DBUA or preupgrade.jar execution failed with error :"ORA-01804: Failure to Initialize Timezone Information" (Doc ID 2161428.1)

Last updated on DECEMBER 18, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Generic UNIX

Symptoms

Symptom 1:

DBUA Upgrade to 12c Fails with below Error Message:

trace.log :

[AWT-EventQueue-0] [ 2016-06-23 19:11:27.890 IST ] [SelectDatabasePage.populateVersionAndStatusFromLocalInstance:2149] Error when obtaining db info ORA-01804: failure to initialize timezone information.

Symptom 2:

preupgrade.jar execution or manual execution of ultppkg.sql failed with below error on 12.1.0.2 database prior to upgrade of the database to 19.x

$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/preupgrade.jar TERMINAL TEXT DIR <directory location>
|
|

@?/rdbms/admin/utluppkg.sql

Package created.

Warning: Package Body created with compilation errors.

SYS>show error
Errors for PACKAGE BODY DBMS_PREUP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-01804: failure to initialize timezone information