Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Change of database name failed during validation - database is intact.

NanubalusAug 12 2012
While running below step it is throwing error
Details:
nid TARGET=SYS/**** DBNAME=r1oltp SETNAME=YES

NID-00111: Oracle error reported from target database while executing
begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchged, :nmchged); end;
ORA-01000: maximum open cursors exceeded

Change of database name failed.
Must finish change or REVERT changes before attempting any database operation.
DBNEWID - Completed with errors.

cursor count is 1000 and later we tried to hit one more time but no luck and now its strikingly odd error,

dttmps11u:r1oltp>nid TARGET=SYS/mymanager DBNAME=r1oltp SETNAME=YES

DBNEWID: Release 10.2.0.4.0 - Production on Sun Aug 12 11:48:35 2012

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

Connected to database RIO2FPT (DBID=2561827962)

NID-00135: There are 1 active threads


Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.

Reference:

http://docs.oracle.com/cd/B10501_01/server.920/a96525/nidus.htm
NID-00135 There are number active threads
Cause: There are active threads in the database. The most likely cause is that the database crashed the last time it was shut down.
Action: Ensure that all threads are closed before retrying the operation. Start and open the database to perform crash recovery, then shut down with the NORMAL or IMMEDIATE options to close it cleanly. Finally, try running the utility again.

Please share the details if any one having an idea on this, thanks very much in advance.

Thanks,
nanubalu

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 9 2012
Added on Aug 12 2012
0 comments
3,211 views