NID Utility in Oracle – RENAME DATABASE
DBNEWID (NID) utility was introduced in Oracle 10g, Which can change the database identifier (DBID) and the database name (DBNAME).
NID utility allows us to change
- Only DBID
- Only DBNAME
- Both DBNAME and DBID of a database
Before performing below changes, Database should be in MOUNT status.
nid TARGET=sys/password@PROD DBNAME=TEST SETNAME=YES
BOTH DBNAME and DATABASE:
nid TARGET=sys/password@PROD DBNAME=TEST