如何不使用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

完成！

相关内容