Monday, October 20, 2008

ORA-01103: database name 'PRIMARY' in controlfile is not 'STANDBY'

At the time of Creating Standby Database many DBA's receive ORA-01103 Error. 

There is a possibility that we can receive this error becuse of DB_NAME Parameter. 

When you receive ORA-01103 Error please make sure that DB_NAME PARAMETER is having same value on Primary as well as Standby Database.


2 comments:

  1. I haven't done many of these and I forgot this parameter this time! Thanks for posting!

    ReplyDelete
  2. I use to change that in the initSID.ora when i clone a DB with other SID, for standby can't be change for another! Thanks!

    ReplyDelete