My Oracle Support Banner

Fleet Maintenance Target Already On The Latest Version. (Doc ID 2482750.1)

Last updated on JANUARY 18, 2023

Applies to:

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

Symptoms

Trying to patch a database using Fleet maintenance is failing with:

emcli db_software_maintenance -performOperation -name="ORCLPatch" -purpose=UPDATE_DB -target_type=oracle_database -target_list="ORCL" -normal_credential=NC_HOST_ORACLE:SYSMAN -privilege_credential=NC_HOST_PRIV:SYSMAN -input_file="data:/home/oracle/patch_details.txt"
Processing target "ORCL"...
Checking if target is already running from the current version of the image...
Check Passed.
Checking image subscription...
Check image subscription passed.
Error in oracle home details. Check OMS logs for more details.
Already running on the same Oracle Home.

ERROR: Operation could not be completed

OMS logs are showing these errors:

2018-11-23 11:33:47,415 [emcli-work-manager:emcli-request] ERROR gis.FleetOperationExecuter logp.251 - Unable to retreive destination home location: ORA-01436: CONNECT BY loop in user data

2018-11-23 11:33:47,416 [emcli-work-manager:emcli-request] ERROR gis.FleetOperationExecuter logp.251 - Error in oracle home details.Unable to retreive destination home location: ORA-01436: CONNECT BY loop in user data

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


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