Site icon IT Tutorial

NID-00120: Database should be mounted exclusively

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 exclusively
Cause: 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.
NID00120: 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.

Oracle Database Name Change Using NID

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 890 views last month,  1 views today

Exit mobile version