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'

advertisements
 


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.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

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