Hi,
I got ” ORA-01586: database must be mounted EXCLUSIVE and not open for this operation ” error during drop database.
Details of error are as follows. When I try to drop database in mount mode, i got the following error.
SQL> startup mount restrict; ORACLE instance started. Database mounted. SQL> drop database; drop database * ERROR at line 1: ORA-01586: database must be mounted EXCLUSIVE and not open for this operation
This error is related with the Cluster Database ( Oracle RAC ).
To solve this error you should change the cluster_database to false from true as follows.
SQL> alter system set cluster_database=FALSE scope=spfile;
Then shutdown database and mount it in restricted mode again as follows.
SQL> shutdown immediate; SQL>startup mount restrict; ORACLE instance started. Database mounted.
Now you can drop database as follows.
SQL>Drop Database; Database dropped.
You can read the following post.
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/