Pricey All,
On this submit i’m sharing step-by-step course of to drop Oracle 19C RAC database.
Word : these steps just for demo function solely****
srvctl standing database -d prod
[oracle@prodnode1 bin]$ srvctl cease database -d prod
[oracle@prodnode1 bin]$ sqlplus / as sysdba
SQL*Plus: Launch 19.0.0.0.0 – Manufacturing on Tue Apr 15 17:11:31 2025
Model 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Related to an idle occasion.
SQL> startup mount unique prohibit;
ORACLE occasion began.
Complete System International Space 2533358728 bytes
Fastened Measurement 8899720 bytes
Variable Measurement 637534208 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database have to be mounted EXCLUSIVE and never open for this operation
SQL> shut abort
ORACLE occasion shut down.
SQL> startup mount prohibit prohibit;
SP2-0714: invalid mixture of STARTUP choices
SQL> startup mount prohibit;
ORACLE occasion began.
Complete System International Space 2533358728 bytes
Fastened Measurement 8899720 bytes
Variable Measurement 637534208 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database have to be mounted EXCLUSIVE and never open for this operation
SQL> shut abort
ORACLE occasion shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Version Launch 19.0.0.0.0 – Manufacturing
Model 19.3.0.0.0
[oracle@prodnode1 bin]$ sqlplus / as sysdba
SQL*Plus: Launch 19.0.0.0.0 – Manufacturing on Tue Apr 15 17:15:00 2025
Model 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Related to an idle occasion.
SQL> STARTUP NOMOUNT RESTRICT;
alter database mount;
ORACLE occasion began.
Complete System International Space 2533358728 bytes
Fastened Measurement 8899720 bytes
Variable Measurement 637534208 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7876608 bytes
SQL>
Database altered.
SQL> SQL>
SQL>
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database have to be mounted EXCLUSIVE and never open for this operation
SQL> shut abort
ORACLE occasion shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Version Launch 19.0.0.0.0 – Manufacturing
Model 19.3.0.0.0
[oracle@prodnode1 bin]$ sqlplus / as sysdba
SQL*Plus: Launch 19.0.0.0.0 – Manufacturing on Tue Apr 15 17:17:01 2025
Model 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Related to an idle occasion.
SQL> startup mount prohibit;
ORACLE occasion began.
Complete System International Space 2533358728 bytes
Fastened Measurement 8899720 bytes
Variable Measurement 637534208 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database have to be mounted EXCLUSIVE and never open for this operation
SQL> shut abort
ORACLE occasion shut down.
SQL> startup mount prohibit unique;
ORACLE occasion began.
Complete System International Space 2533358728 bytes
Fastened Measurement 8899720 bytes
Variable Measurement 637534208 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 19c Enterprise Version Launch 19.0.0.0.0 – Manufacturing
Model 19.3.0.0.0
SQL>
Thanks,
Srini
