OraFAQ Forum: Backup & Recovery » NID- utility giving ora-01103 error

Z:\>set oracle_sid=kalyani

Z:\>nid

DBNEWID: Release 10.2.0.1.0 - Production on Mon Oct 12 11:11:43 2009

Keyword Description (Default)
----------------------------------------------------
TARGET Username/Password (NONE)
DBNAME New database name (NONE)
LOGFILE Output Log (NONE)
REVERT Revert failed change NO
SETNAME Set a new database name only NO
APPEND Append to output log NO
HELP Displays these messages NO

Z:\>sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 12 11:12:36 2009

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

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

Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> select name from v$database;

NAME
---------
KALYANI

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
kalyani

SQL> host nid target=sys/tejajun20 dbname=mallik

DBNEWID: Release 10.2.0.1.0 - Production on Mon Oct 12 11:16:08 2009

Connected to database KALYANI (DBID=4102920684)

Connected to server version 10.2.0

Control Files in database:
C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL01.CTL
C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL02.CTL
C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL03.CTL

Change database ID and database name KALYANI to MALLIK? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 4102920684 to 1121083962
Changing database name from KALYANI to MALLIK
Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL01.CTL - modified
Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL02.CTL - modified
Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL03.CTL - modified
Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\SYSTEM01.DBF - dbid changed, wrote new name
Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\UNDOTBS01.DBF - dbid changed, wrote new name
Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\SYSAUX01.DBF - dbid changed, wrote new name
Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\USERS01.DBF - dbid changed, wrote new name
Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\EXAMPLE01.DBF - dbid changed, wrote new name
Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\TEMP01.DBF - dbid changed, wrote new name
Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL01.CTL - dbid changed, wrote new name
Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL02.CTL - dbid changed, wrote new name
Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL03.CTL - dbid changed, wrote new name
Instance shut down

Database name changed to MALLIK.
Modify parameter file and generate a new password file before restarting.
Database ID for database MALLIK changed to 1121083962.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.

SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> conn sys / as sysdba
Enter password:
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 83887484 bytes
Database Buffers 75497472 bytes
Redo Buffers 7139328 bytes
ORA-01103: database name 'MALLIK' in control file is not 'KALYANI'

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted

SQL>