How to Rename Oracle Database Using NID command Line Utility

_____________________________________________________________________________________________________________________

Requirement is rename the database name from SOURCE to TARGET

Steps:

1. Create the initTARGET.ora file with necessary parameters. Db_name parameter value must be TARGET.
2. Shutdown the SOURCE database

export ORACLE_SID=SOURCE

SQL> shutdown immediate;

3. Startup mount the TARGET database using initTARGET.ora parameter file.
4. Run the nid command in the command prompt.

nid TARGET=SYS/syspassword  DBNAME=TARGET SETNAME=YES

_____________________________________________________________________________________________________________________

Website Stats