IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “NID-00120: Database should be mounted exclusively ” error.
Details of error are as follows.
NID-00120: Database should be mounted exclusivelyCause: The database was started in parallel mode. To change the DBID, the database must be mounted exclusively.
Action: Shut down the database and start it in exclusive mode.
NID–00120: Database should be mounted exclusively
Change of database name failed during validation – database is intact.
DBNEWID – Completed with validation errors.
This error is related with the cluster_database parameter, When this parameter’s value is TRUE, you can get this error.
SQL> show parameter cluster NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cluster_database boolean TRUE
Set this parameter to False, then restart database.
ALTER SYSTEM SET CLUSTER_DATABASE=FALSE scope=spfile sid='*';
shutdown immediate; startup mount;
Run nid tool again using 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/
