Forum Stats

  • 3,874,135 Users
  • 2,266,687 Discussions
  • 7,911,732 Comments

Discussions

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

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
Tagged:
This discussion has been closed.