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.

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

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: