Oracle Manual Delete Library

Today because the insertion of Chinese is garbled, found that the character set is not ZHS16GBK, so ready to delete the re-built

[Email protected] >alter database close;

ALTER DATABASE Close

*

An error occurred on line 1th:

Ora-01093:alter DATABASE CLOSE?????????????

Description also to session connection, after exiting the connection in the delete operation

[Email protected] >alter database close;

The database has changed.

[Email protected] >select instance_name,status from V$instance;

instance_name STATUS

------------------------------------------------ ------------------------------------

Icsdb Mounted

[Email protected] >alter system enable restricted session;

The system has changed.

[Email protected] >drop database;

The database has been deleted.

From Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the partitioning, OLAP, Data Mining and Real application testing options Disconnect

@ >

You also need to manually delete the instance-related configuration:

1, delete $oracle_base/admin/$ORACLE _sid all directories.

2. Delete $oracle_home/dbs and SID-related file and parameter files, including HC_ICSDB.DAT,LKICSDB

3. You can execute find in $oracle_home. -name icsdb, delete all files associated with the instance.

This article is from the "record a bit of learning life" blog, please make sure to keep this source http://laobaiv1.blog.51cto.com/2893832/1922067

Oracle Manual Delete Library