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

Error means the database name in the control file does not match the name in the SPFILE. We need to update the SPFILE or PFILE to match the database name in the 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: An error may occur if we rename the database using the NID utility and forget to update the Pfile or SPfile.