Autoconfig is failing in new primary database server after switchover

[Raja]

Hi Erman

As per note:Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1), section 6:Performing Role Transitions
subsection:6.1.6 Complete the database configuration

Autoocnfig is getting failed in the new primary database with errors
 afdbprf.sh              INSTE8_PRF         1
  adcrobj.sh              INSTE8_APPLY       1

The error mesage says that "database shutdown in progress"


Any idea where i am doing wrong. My new primary Database sid-PROD, DB unique name-PRODDR, listener-PROD Global db name-PRODDR

[ErmanArslansOracleBlog]

You did the switchover and your standby is runnin in read/write mode right?
If so, please check the  TNS definitions as stated in that document -> As the ORACLE user on both the primary and standby database servers, change the host name in the standby service definitions to point to the new standby server in both the <CONTEXT_NAME>_ifile.ora and <STNDBY_CONTEXT>_ifile.ora (which are located in the <TNS_ADMIN> directory)

Also * ensure that you restart the db after the switchover as stated;

SQL>shutdown immediate
SQL>startup pfile=$ORACLE_HOME/dbs/init<SID>.ora  (or startup with spfile)

In short, follow the document by understanding and doing everything that is documented there.

[Raja]

Hi Erman

Yes new primary(which was standby earlier) is running in read/write mode.
I have a doubt here. My initial primary -PROD with DB unique name-PROD was running in host rac2.localdomain and standby was running in host dr.localdomain with Global name-PROD and Db unique name PRODDR.

DG Config at primary were=(PROD,PRODDR)


Now after the switchover,

Global name-PROD and Db unique name PRODDR becomes the primary with dg config details as (PRODDR,PROD) in host dr.localdomain and now new Global db name-PROD with DB unique name-PROD in host rac2.localdomain becomes the new standby.

So i couldn't understand what changes i need to make it in the context_ifile.ora under $TNS_ADMIN? Also, Archives are getting applied from primary to new standby(which is now in mount mode).


THanks

[Raja]

This is now resolved. Thanks

[ErmanArslansOracleBlog]

Ok.
Please share the resolution. Maybe someone can get benefit from it.

[Raja]

Hi Erman

As suggested by you, I had to change the host names in primary context ifile and standby context ifile.


Thanks
Raja

[ErmanArslansOracleBlog]

So, now it is okay?

[Raja]

Yes. All working fine now.