My Oracle Support Banner

Fleet: During Major UPDATE_RACDB From 12.2 To 19c Does Not Upgrade DST Timezone At Pluggable Database Level (Doc ID 2687893.1)

Last updated on JULY 07, 2020

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 Cloud Control Enterprise Manager using Fleet, UPDATE_RACDB from 12.2 to 19c completed successfuly but failed to upgrade DST timezone at pluggable database level

Command Snippet :
$ emcli db_software_maintenance -performOperation -name="Update RAC DB" -purpose=UPDATE_RACDB -target_type=rac_database -target_list="<TARGET_NAME>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN"
Processing target "<TARGET_NAME>"...
Checking if target is already running from the current version of the image...
Check Passed.
Checking image subscription...
Check image subscription passed.
Operation 'Update RAC DB' created successfully.
Patching operation for RAC database <TARGET_NAME> can be monitored using:
EMCLI:
emcli get_instance_status -exec=72DC7B5959500CBDE053BC3A410A3CD1 -details -xml
Browser:
https://<EM Host>:<EM Port>/em/faces/core-jobs-procedureExecutionTracking?executionGUID=72DC7B5959500CBDE053BC3A410A3CD1
Verb performOperation completed successfully

Job Step Log:

Job Steps Log for Job :Upgrade RAC Database Instance
Pre Upgrade Step started at Tue Jun 23 14:39:44 GMT 2020
Configure Database in 19.0.0.0.0 Oracle Home started at Tue Jun 23 14:53:11 GMT 2020
Database Components Upgrade started at Tue Jun 23 14:54:19 GMT 2020
Recompile Invalid Objects started at Tue Jun 23 16:36:28 GMT 2020
Timezone Upgrade started at Tue Jun 23 16:37:36 GMT 2020
CDB Root Post Upgrade Step started at Tue Jun 23 16:40:55 GMT 2020
Enterprise manager configuration step started at Tue Jun 23 16:43:01 GMT 2020
PDBS Components Upgrade started at Tue Jun 23 16:43:11 GMT 2020
[catupgrdpdb_seed0.log]
ORA-02002: error while writing to audit trail
[catupgrdpdb_seed0.log]
ORA-02002: error while writing to audit trail
Upgrade operation has failed. Check the log files for the upgrade operation located at: /opt/oracle/db/cfgtoollogs/dbua/upgrade2020-06-23_02-24-46PM/PCD7004
PDBS Recompile Invalid Objects started at Tue Jun 23 18:25:27 GMT 2020
Recompilation of invalid objects has failed. To continue upgrade, ignore this error. Recompilation of invalid objects can be done manually by executing rdbms/admin/utlprp.sql after DBUA execution.
PDBS Timezone Upgrade started at Tue Jun 23 18:25:42 GMT 2020
Exception raised during Timezone upgrade. Check the documentation to complete Timezone upgrade manually.
PDBS Enable Services started at Tue Jun 23 18:25:57 GMT 2020
Generate Summary started at Tue Jun 23 18:26:13 GMT 2020
100% complete
Operation Succeeded.

 

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.