STEP 1. Set up the environment
[oracle@oracle database]$ . oraenv
ORACLE_SID = [oracle] ? mydb
The Oracle base for ORACLE_HOME=/data/oracle/app/oracle/product/11.2.0/dbhome_2 is /data/oracle/app/oracle
[oracle@oracle database]$
[oracle@oracle database]$
2
Section 2
[oracle@oracle database]$
STEP 2. Connect to sqlplus utility
[oracle@oracle database]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 15 15:47:17 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
3
Section 3
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
STEP 3. Shutdown database
SQL> shu immediate;
Database closed.
Database dismounted.
4
Section 4
ORACLE instance shut down.
STEP 4. Start database in mount stage with restricted mode.
SQL> startup mount restrict
ORACLE instance started.
Total System Global Area 830930944 bytes
Fixed Size 2217912 bytes
5
Section 5
Variable Size 629147720 bytes
Database Buffers 197132288 bytes
Redo Buffers 2433024 bytes
Database mounted.
STEP 5. Drop the database finally.
SQL> drop database;
6
Section 6
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.