Saturday, May 26, 2018

AutoConfig Encounters ORA- errors in a fresh physical standby database for EBS 12.2.7

For the past few days, i was making my hands dirty on setting up a physical standby database for EBS 12.2.7. Once i had created the context file in the physical standby database and cleaned up the FND nodes, it was time for me to run autoconfig for the first time.

The first error encountered was

Encounters A ORA-1804 Error: Failure To Initialize Timezone Information

This issue was caused by the current AutoConfig template file that points to the wrong file. Issue was resolved by editing the template ad8idbux.env in location .../oracle/db/tech_st/11.2.0/appsutil/template changing:

From:
set ORA_TZFILE=%s_db_oh%\oracore\zoneinfo\timezlrg.dat

To:
set ORA_TZFILE=%s_db_oh%\oracore\zoneinfo\timezlrg_18.dat


Again i ran autoconfig and encountered the next error which was ORA-12705: Cannot Access NLS Data Files Or Invalid Environment Specified.

The solution is to run perl $ORACLE_HOME/nls/data/old/cr9idata.pl 

So at the end of the day, we should always stick on following the Oracle supported docs line by line. Hope this will help someone.

No comments:

Post a Comment