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!

NID-00121 error

jairamDec 6 2012 — edited Dec 6 2012
Hi everyone,

I am having a problem with Oracle 11g NID utility.,

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for HPUX: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production


I am trying to change the DBNAME by using NID.,but it returns the following error.,


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount exclusive;
ORACLE instance started.

Total System Global Area 797523968 bytes
Fixed Size 2185456 bytes
Variable Size 239077136 bytes
Database Buffers 549453824 bytes
Redo Buffers 6807552 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$
$ nid TARGET=SYS/xxxx@test1 DBNAME=test2 SETNAME=YES

DBNEWID: Release 11.2.0.2.0 - Production on Thu Dec 6 11:02:24 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to database test1 (DBID=2323699265)

NID-00121: Database should not be open


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


Anyone please guide me on this issue..,



Regards,
Jai.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2013
Added on Dec 6 2012
4 comments
952 views