Santosh Kangane

Simple steps to remove Oracle instance…. 1) Login to the server machine with Oracle user 2) Set ORACLE_HOME, ORACLE_SID 3) Open SQL Plus [oracle$] sqlplus / as sysdba SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount EXCLUSIVE ORACLE instance started. Total System Global Area 3.2068E+10 bytes Fixed Size                  2214736 bytes Variable Size            1.5838E+10 bytes Database Buffers         1.6106E+10 bytes Redo Buffers              122404864 bytes Database mounted. SQL> alter system enable restricted session; System altered. SQL> drop database; 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 SQL>