How to delete a database in Oracle 11 without using DBCA

How to delete a database in Oracle 11 without using DBCA

This short tutorial will show you how to delete a database from Oracle 11 without using DBCA (Database Configuration Assistant.

1-SID of the imported database, if not defined

1. Export ORACLE_SID = database

2-connect to the database with OS Authentication

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-start a database instance

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-Shut down the database

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

5-enable exclusive mode

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-delete a database

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

Done!