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 ...
Thinking Through Technology.... To design any system put your Business Standard and Technology together keeping them rightly disjoin....