Using the Tricky NID Utility

Never did like the Metalink (My Oracle Support) document that described how to use NID. This is a very powerful utility and can be hard for someone who hasn’t attempted to use it before.

I personally like to keep the ORACLE_SID uppercase…on both UNIX and Windows, it seems to make it more distinct and noticeable above all other TEXT. So in this case I would change test1by to TEST1BY, see what I mean?

It doesn’t seem to get as lost among other mixed case words in a command.

Subject: How to Change the DBID and the DBNAME by using NID Doc ID: 224266.1

Most of the instructions are correct and spot on…there is a critical point that they assume that you are running on Windows….It is after Step 4 of the second example of changing both the database ID and database name. Located near the bottom of the page.

4. Shutdown immediate of the database

***********At this point..if you are on Unix, logout completely of your session. Log back in and execute oraenv for the new DBNAME. In this example it is the ORACLE_SID test1by