NID Utility



Last updated on November 23rd, 2015 at 01:55 pm

The NID Utility is a new utility introduced with Oracle 9.2. The NID
utility allows you to change only the DBNAME, or only the DBID or both
DBNAME and DBID in the same command.

Change Only the DBID
1. Backup Database
2. shutdown immediate
3. startup mount
4. Open one session and run NID with sysdba privileges
nid TARGET=SYS/password@exptest
5. shutdown immediate
6. Set the DB_NAME initialization parameter in the initialization parameter
file to the new database name
7. Create a new password file
8. Startup of the database with open resetlogs

Change Only the DBNAME

1. Backup Database
2. shutdown immediate
3. startup mount
4. Open one session and run NID with sysdba privileges
nid TARGET=SYS/password@test_db DBNAME=exptest_db2 SETNAME=Y
– the value of DBNAME is the new dbname of the database
– SETNAME must be set to Y. The default is N and causes the
DBID to be changed also.
5. shutdown immediate
6. Set the DB_NAME initialization parameter in the initialization parameter
file to the new database name
7. Create a new password file.
8. Startup of the database(without resetlogs)

Change Both DBID and DBNAME

1. Backup Database
2. shutdown immediate
3. startup mount
4. Open one session and run NID with sysdba privileges
nid TARGET=SYS/password@test_db DBNAME=exptest_db2
– the value of DBNAME is the new dbname of the database
5. After DBNEWID successfully changes the DBID,shutdown immediate
6. Set the DB_NAME initialization parameter in the
initialization parameter file to the new database name.
7. Create a new password file.
8. Startup of the database with open resetlogs


Leave a Reply