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 (Doc ID 1562424.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jul-2016***

Symptoms

Database startup fails with

 with often also an ORA-600 [qcisSetPlsqlCtx:tzi init]

Changes

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms