ORA-01103: database name 'TEST' in control file is not 'CDB'

_____________________________________________________________________________________________________________________


Problem Description:
Alter database mount failed with following error after the dbname change using DBNEWID – NID utility.
SQL> startup mount

ORACLE instance started.

Total System Global Area  838858176 bytes
Fixed Size              8902080 bytes
Variable Size         515899392 bytes
Database Buffers      310378496 bytes
Redo Buffers            3678208 bytes
ORA-01103: database name 'TEST' in control file is not 'CDB'

Solution Description:
Change the db_name in spfile using below command and mount the database.
Then shutdown the database and mount it again.

SQL> alter system set db_name='TEST' scope=spfile;

System altered.

SQL> shut immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  838858176 bytes
Fixed Size              8902080 bytes
Variable Size         515899392 bytes
Database Buffers      310378496 bytes
Redo Buffers            3678208 bytes
Database mounted.

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-19 All Rights Reserved | Site Map | Contact | Disclaimer | Google