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> alter database open resetlogs;


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