Follow below steps for changing the oracle database name using nid utility. We will change the database name from P2PRMD2 to P1D2ST.

1. Mount the database

2. Run the NID utility

SYNTAX – nid sys/password@CURRENT_DBNAME DBNAME=NEW_DBNAME

 

3. change the db_name parameter in the parameter file.

4. Rename the spfile to new db name

cp spfileP2PRMD2.ora spfileP1D2ST.ora