Skip to main content

Posts

Showing posts from October, 2012

Drop Oracle Instance

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 ...