ORA-01103: database name ‘CMTCTEST’ in control file is not ‘CMTTEST’

ORA-01103: database name ‘CMTCTEST’ in control file is not ‘CMTTEST’

Error means database name is different in control file as mentioned in SPFILE with db name parameter. So, we need to modify the spfile or pfile as we used to start the database as mentioned name in control file.

Error while starting database

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01103: database name 'CMTCTEST' in control file is not 'CMTTEST'

Note: As error database name CMTCTEST is present in control file instead of CMTTEST.

Need to modify the db_name parameter in spfile or pfile

SQL> alter system set db_name='CMTCTEST' scope=spfile;
System altered.

Shutdown the database completed and Start it again:

SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area  855982080 bytes
Fixed Size                  2286032 bytes
Variable Size             549457456 bytes
Database Buffers          297795584 bytes
Redo Buffers                6443008 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Note: Error may occurred when we rename the database with NID utility and forget to change in Pfile or SPfile

Advertisements

One thought on “ORA-01103: database name ‘CMTCTEST’ in control file is not ‘CMTTEST’

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s