Shulou(Shulou.com)06/01 Report--

Today, because the inserted Chinese is garbled, it is found that the character set is not ZHS16GBK, so it is ready to delete and rebuild.

SYS@icsdb >alter database close;

alter database close

*

Error in line 1:

ORA-01093: ALTER DATABASE CLOSE ?????????????

Description also session connection, exit the connection after the deletion operation

SYS@icsdb >alter database close;

The database has changed.

SYS@icsdb >select instance_name,status from v$instance;

INSTANCE_NAME STATUS

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

icsdb MOUNTED

SYS@icsdb >alter system enable restricted session;

The system has changed.

SYS@icsdb >drop database;

Database 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 Open

@ >

You also need to manually delete instance-related configurations:

Delete $ORACLE_BASE/admin/$ORACLE_SID all directories.

2. Delete SID related files and parameter files under $ORACLE_HOME/dbs, including hc_icsdb.dat, lkICSDB

Find can be executed in $ORACLE_HOME. -name icsdb, deletes all files related to the instance.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.