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.

SHUTDOWN IMMEDIATE
STARTUP MOUNT

DBID Only:

nid TARGET=sys/password@PROD

DBNAME Only:

nid TARGET=sys/password@PROD DBNAME=TEST SETNAME=YES

BOTH DBNAME and DATABASE:

nid TARGET=sys/password@PROD DBNAME=TEST