Changing DBID by NID

Changing DBID by NID

the Oracle utility NID uses to change DBID of a database.

List available options

the available options are shown below:

$ nid

Keyword     Description                    (Default)
----------------------------------------------------
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO

Start up database in mount state

In order to change DBID,  the database should be restarted in mount state

SQL> shutdown immediate;
SQL> startup mount;
SQL> alter system register;

Change DBID by NID

$> nid sys/iamsys@db10gr2

$ nid

DBNEWID: Release 10.2.0.5.0 – Production on Fri May 6 11:24:19 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Keyword     Description                    (Default)
—————————————————-
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO

Advertisements

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: