Database startup fails with ORA-01804: failure to initialize timezone information and Failed to find timezone data file # -here an number- (DST_4) Daylight Saving Time feature is disabled is seen in the alert.log
Last updated on MARCH 19, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jul-2016***
Database startup fails with
with often also an ORA-600 [qcisSetPlsqlCtx:tzi init]
This is mostly seen when restoring a database and opening it in a new $ORACLE_HOME.
The -number- in the error indicates what missing DST patch needed for opening the database , for example:
"Failed to find timezone data file # 14 (DST_4)" error means the database cannot find the RDBMS DSTv14 patch applied (normally installed by default) in order to open properly.
"Failed to find timezone data file # 17 (DST_4)" error means the database n cannot find the RDBMS DSTv17 patch in the home in order to open properly.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms