Wednesday, November 04, 2020

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

Issue #4:

 

Autoconfig failed on DB:

 

ERROR:
ORA-01804: failure to initialize timezone information

 

Solution:

AutoConfig Encounters A ORA-1804 Error: Failure To Initialize Timezone Information (Doc ID 1917923.1)

 

1.       This is 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_14.dat

2. Running AutoConfig after this change means the environment file is created with the ORA_TZFILE value as timezlrg_14.dat and AutoConfig completes successfully.

 

No comments:

Post a Comment