Drop Oracle single instance Database Manually
Hostname : lovetech
OS : Red Hat Enterprise Linux Server release 7.9 (Maipo)
DB Name : DBADEV
Version : 11.2.0.1
Filesystem : Normal
Database type : Single Instance
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Set env to DBADEV database
[oracle@lovetech ~]$ . oraenv
ORACLE_SID = [dbadev] ? dbadev
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@lovetech ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 6 00:37:21 2021
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
check the status of the database
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
DBADEV READ WRITE
Shutdown the database
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Startup and mount the database in restricted mode
SQL> startup mount restrict;
ORACLE instance started.
Total System Global Area 367439872 bytes
Fixed Size 2213456 bytes
Variable Size 276826544 bytes
Database Buffers 83886080 bytes
Redo Buffers 4513792 bytes
Database mounted.
Issue the drop command
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> exit
Remove entries in the oratab file as the drop command will not perform this action
Note: The use of any materials on this website is at your own risk. It is provided for educational purposes only. It has been tested internally, but we do not guarantee that it will work for you. We recommend you test in your test environment before using.
Recent Comments