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
:v
LikeLike
Thanks that was helpful for me
LikeLiked by 1 person