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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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-20 All Rights Reserved | Site Map | Contact | Disclaimer