My Oracle Support Banner

OEM 13c: FLEET UPDATE_DB Fails In Step Apply PSU With Error "ORA-01804: failure to initialize timezone information" (Doc ID 2708055.1)

Last updated on MAY 13, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.2.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control, Fleet Update DB Fails in Apply PSU with below error.

Command Snippet :

$ emcli db_software_maintenance -performOperation -name="Update" -purpose=UPDATE_DB -target_type=oracle_database -target_list="<target_name>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN" -database_credential="DB_CREDENTIAL:SYS

Job Step Log : Apply PSU

final command is /bin/sh -x /u01/app/oracle/12.1.0.2.200714/OPatch/datapatch+ /u01/app/oracle/12.1.0.2.200714/sqlpatch/sqlpatch
SQL Patching tool version 12.1.0.2.0 Production on Thu Sep 3 12:13:51 2020
Copyright (c) 2012, 2017, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_25765_2020_09_03_12_13_51/sqlpatch_invocation.log
Connecting to database...OK

Bootstrapping registry and package to current versions...done
Error in bootstrap log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_25765_2020_09_03_12_13_51/bootstrap1_DB.log:
Error at line 13: ORA-01804: failure to initialize timezone information
Error in bootstrap log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_25765_2020_09_03_12_13_51/bootstrap1_DB.log:
Error at line 13: ORA-01804: failure to initialize timezone information
Prereq check failed, exiting without installing any patches. 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.