Dbfleet: Deploy Oracle Home Failed With Error Error In Oracle Home Details. Check OMS Logs For More

(Doc ID 2346150.1)

Last updated on JANUARY 14, 2018

Applies to:

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

Symptoms

Running EM 13.2 OMS and agent with db plugin 13.2.2 to attempt to patch using fleet maintenance on a 12.1.0.2 db target.

Use-case to reproduce the issue:
--------------------------------

1. Create a Gold image.
emcli db_software_maintenance -createSoftwareImage -input_file="<>"

2. Subscribe the Image to the target
emcli db_software_maintenance -subscribeTarget -target_name="orcldp.us.oracle.com" -target_type=oracle_database -image_id=5CFB

3. Stage and deploy the s/w
emcli db_software_maintenance -performOperation -name=sysman -purpose=DEPLOY_DB_SOFTWARE
-- This will create new OH(oracle home) and insert the successor guid in db_gi_oh_lineage table.

4. Delete the new Oracle home target from EM console. (i.e. go to target page and delete it)

During target delete the db_gi_oh_lineage data not cleared from the target.

5. Again submitted "stage and deploy s/w" and got the same error in emoms.trc

2017-11-06 20:42:02,086 [emcli-work-manager:emcli-request] ERROR gis.FleetOperationExecuter logp.251 - Error in oracle home details.
ORA-01403: no data found
ORA-06512: at "SYSMAN.EM_GOLD_IMAGE", line 2585
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms