如何不使用DBCA在Oracle 11中删除数据库

本文简短的教程，将会向你展示如何不使用DBCA（数据库配置助手）在Oracle 11中删除数据库。

1- 导入数据库的SID，如果没有定义的话

1. export ORACLE_SID=database

2- 以操作系统认证连接数据库

1. [oracle@Oracle11 ~]$ sqlplus /as sysdba
2.  
3. SQL*Plus:Release11.2.0.1.0Production on MonDec117:38:022014
4. Copyright(c)1982,2009,Oracle.All rights reserved.
5. Connected to an idle instance.

3- 启动数据库实例

1. SQL> startup
2.  
3. ORACLE instance started.
4. TotalSystemGlobalArea3340451840 bytes
5. FixedSize2217952 bytes
6. VariableSize1828718624 bytes
7. DatabaseBuffers1493172224 bytes
8. RedoBuffers16343040 bytes
9. Database mounted.
10. Database opened.

4- 关闭数据库

1. SQL> shutdown immediate;
2.  
3. Database closed.
4. Database dismounted.
5. ORACLE instance shut down.

5- 启动独占模式

1. SQL> startup mount exclusive restrict
2.  
3. ORACLE instance started.
4.  
5. TotalSystemGlobalArea3340451840 bytes
6. FixedSize2217952 bytes
7. VariableSize1828718624 bytes
8. DatabaseBuffers1493172224 bytes
9. RedoBuffers16343040 bytes
10. Database mounted.

6- 删除数据库

1. SQL> drop database;
2. Database dropped. 
3. DisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
4. With the Partitioning, OLAP,DataMiningandRealApplicationTesting options

完成！