NID CHANGE DATABASE NAME SESSION HANGS
(Doc ID 1202355.1)
Last updated on JULY 07, 2021
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2] Information in this document applies to any platform.
***Checked for relevance on 30-Mar-2012***
When executing NID utility from SQLPLUS prompt to rename the instance the session hangs.
SQL> host nid TARGET=sys/<PASSWORD> DBNAME=<DB_NAME>
Hangs with the below message:
Control File /<PATH>/<FILE_NAME>.ctl - dbid changed, wrote new name Control File /<PATH>/<FILE_NAME>.ctl - dbid changed, wrote new name Control File /<PATH>/<FILE_NAME>.ctl - dbid changed, wrote new name
Enter ctrl C
NID-00600: Internal Error -     . . Change of database name and ID failed during validation - database is intact. DBNEWID - Completed with validation errors.
From the alert.log:
Wed Jul 21 11:52:54 2010
MMNL started with pid=16, OS id=8947
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /<PATH>
Wed Jul 21 11:52:55 2010
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 870223319
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Jul 21 11:53:59 2010
*** DBNEWID utility started ***
DBID will be changed from nnnnnnnnnn to new DBID of nnnnnnnnn for database
DBNAME will be changed from <DB_NAME> to new DBNAME of <DB_NAME>
Database name changed to <DB_NAME>.
Database ID for database <DB_NAME> changed to nnnnnnnnn.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open with RESETLOGS option.
Successfully changed database name and ID.
*** DBNEWID utility finished successfully ***
Wed Jul 21 13:04:22 2010
SHUTDOWN: Active processes prevent shutdown operation
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!