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

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

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

SQL> alter system set db_name=’CMTCTEST’ scope=spfile;

System altered.

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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s