Skip to content
Menu
nix.engineering
  • Start
  • Info
  • Link Collection
  • Site Notice
nix.engineering

ORA-01103: database name ‘DB1’ in control file is not ‘DB2’

Posted on March 28, 2018May 20, 2019

This error often occurs in the context of duplicating a database. The reason is the control file still containing the old name. You can solve this by restoring a correct control file or change your database name. Usually the original control file ist lost, therefore the second solution is described below:

Shutdown Database:

SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.

 
Startup in nomount mode & alter the parameter DB_NAME:

SQL> startup nomount;
ORACLE instance started.
Total System Global Area 66666666 bytes
Fixed Size               666666 bytes
Variable Size            666666 bytes
Database Buffers         66666666 bytes
Redo Buffers             666666 bytes
SQL> alter system set DB_NAME=DB1 scope=SPFILE;
System altered.

 
Restart Database:

SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.

SQL> startup;
ORACLE instance started.
Total System Global Area 66666666 bytes
Fixed Size               666666 bytes
Variable Size            666666 bytes
Database Buffers         66666666 bytes
Redo Buffers             666666 bytes
Database mounted.
Database opened.

 

Reference:
https://support.oracle.com/knowledge/Oracle%20Database%20Products/2151821_1.html

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • ntp – what time it is?
  • Remove service from services.msc
  • Oracle DBNEWID Utility for new DBID and DBNAME
  • ORA-01103: database name ‘DB1’ in control file is not ‘DB2’
  • SQL1041N: The maximum number of concurrent databases have already been started. SQLSTATE=57032

Categories

  • Database
  • DB2
  • Exploit
  • Misc
  • Oracle
  • Security

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2023 nix.engineering | WordPress Theme by Superb WordPress Themes