ERROR: ORA-01804: failure to initialize timezone information - AUTOCONFIG

 Dear Folks.

Recently we have encountered an issue with auto-config on the database node (19c) that failed with the below error.

ERROR: ORA-01804: failure to initialize timezone information

SP2-0152: ORACLE may not be functioning properly

ERRORCODE = 1 ERRORCODE_END

Fix

==

NONPROD [*******@korladrekbs01 19.3.0]$ unset ORA_TZFILE

Change in below template file to point to correct timezone file and run auto-config.

NONPRD [****@korladrekbs01 zoneinfo]$ diff /u01/app/****/db/tech_st/19.3.0/appsutil/template/ad8idbux.env /u01/app/***/db/tech_st/19.3.0/appsutil/template/ad8idbux.env_old

140c140

<      ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg_32.dat"

---

>      ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"