Andrew_Garland_7890

Oracle Error 01804 - Failure to initialize timezone - Common solutions

Discussion created by Andrew_Garland_7890 on Aug 31, 2016
Latest reply on Feb 9, 2018 by Andreas_Sprosec_7439
Hello Automic Community!

I recently ran across an interesting error message in Oracle that I wanted to share. This issue occured when attempting to start up WPs after an installation/upgrade to the Automation Engine. The error message is written below:

ORA - 01804: failure to initialize timezone information

This is a generic error message from the Oracle Database indicating that the timezone information file was not properly read. Below are the most common solutions:


1) Your oracle client may be missing some timezone related files in its$ORACLE_HOMEdirectory. You can try simply copying those files from another instance of oracle client. 

2) Binary may not have permission to access the OCCI library. Please ensure permissions are in correctly in place. 

3) Check to make sure the following paths are set correctly in your environment: 
LD_LIBRARY_PATH 
ORACLE_HOME 
NLS_LANG

I hope this is helpful!

Outcomes