NID-00121 error
jairamDec 6 2012 — edited Dec 6 2012Hi 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.