My Oracle Support Banner

EM 13c Fleet: In Case Of Major Upgrades UPDATE_DB Job Fails In Step Pre-Upgrade Tool Checks With Error "Fatal: upgrade.xml does not exist" (Doc ID 2713241.1)

Last updated on SEPTEMBER 17, 2021

Applies to:

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

Symptoms

Enterprise Manager 13.4 Cloud Control
Using Fleet and running the UPDATE_DB with multiple databases, the process fails in pre-upgrade tool checks with the following error:

Command Snippet:

$ emcli db_software_maintenance -performOperation -name="mi" -purpose=UPDATE_DB -target_type=oracle_database -target_list="target1,target2" -normal_credential="UPGRADE_ORACLE:SYSMAN" -privilege_credential="UPGRADE_ROOT:SYSMAN"
Processing target "target1"...
Checking if target is already running from the current version of the
image...
Check Passed.
Checking image subscription...
Check image subscription passed.
Operation 'mi' created successfully.

Patching operation for database target1 can be monitored using:
EMCLI:
emcli get_instance_status -exec=9A25E93D0CA87ECAE053D970400A724B -details
-xml
Browser:
https://<EM Host>:<EM
Port>/em/faces/core-jobs-procedureExecutionTracking?executionGUID=9A25E93D0CA87ECAE053D970400A724B

Processing target "target2"...
Checking if target is already running from the current version of the
image...
Check Passed.
Checking image subscription...
Check image subscription passed.
Operation 'mi' created successfully.

Patching operation for database target2 can be monitored using:
EMCLI:
emcli get_instance_status -exec=9A25E93D0CB57ECAE053D970400A724B -details
-xml
Browser:
https://<EM Host>:<EM
Port>/em/faces/core-jobs-procedureExecutionTracking?executionGUID=9A25E93D0CB57ECAE053D970400A724B

Verb performOperation completed successfully
[oracle@oms bin]$

Job Step Failed Log : Oracle Database Upgrade Check
1:prepareConfig:prepareConfig
Preparing required parameters.
sourceVersion = 12.1.0.2.0.
sourceOracleHome = /u02/sourceupg.
targetSID = target1.
targetVersion = 19.0.0.0.0.
Prepared parameters successfully.
Config data preparation complete.
------------------------------------------------------------
1:prepareConfig:prepareConfig
2:preReq:preReq
Performing pre-requisite checks.
Source Database Checks
Success: Source database upgradable status check
Source database upgradable status check passed.
RDBMS Pre-Upgrade Tool Checks
Fatal: upgrade.xml does not exist
Error in running preupgrd.sql.
/u02/dbbase/cfgtoollogs/dbua/target1/validation1/upgrade.xml not found
Errors were found during pre-requisite checks. 

Changes

 

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
Changes
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.