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 in Oracle 11 without using the DBCA Database Configuration assistant.

1-SID of the imported database, if not defined

 
 

  
  
export ORACLE_SID=database
 
 

2-connect to the database with OS Authentication

 
 

  
  
[oracle@Oracle11 ~]$ sqlplus / as sysdba
  
  
 
  
  
SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014
  
  
Copyright (c) 1982, 2009, Oracle. All rights reserved.
  
  
Connected to an idle instance.
 
 

3-start a database instance

 
 

  
  
SQL> startup
  
  
 
  
  
ORACLE instance started.
  
  
Total System Global Area 3340451840 bytes
  
  
Fixed Size 2217952 bytes
  
  
Variable Size 1828718624 bytes
  
  
Database Buffers 1493172224 bytes
  
  
Redo Buffers 16343040 bytes
  
  
Database mounted.
  
  
Database opened.
 
 

4-Shut down the database

 
 

  
  
SQL> shutdown immediate;
  
  
 
  
  
Database closed.
  
  
Database dismounted.
  
  
ORACLE instance shut down.
 
 

5-enable exclusive mode

 
 

  
  
SQL> startup mount exclusive restrict
  
  
 
  
  
ORACLE instance started.
  
  
 
  
  
Total System Global Area 3340451840 bytes
  
  
Fixed Size 2217952 bytes
  
  
Variable Size 1828718624 bytes
  
  
Database Buffers 1493172224 bytes
  
  
Redo Buffers 16343040 bytes
  
  
Database mounted.
 
 

6-delete a database

 
 

  
  
SQL> drop database;
  
  
<br>Database dropped.
  
  
 
  
  
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  
  
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
 

Done!

Via: http://www.unixmen.com/drop-database-oracle-11-without-using-dcba/

Author: M. el Khamlichi Translator: VicYu/Vic020 Proofreader: wxy