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 and later
Information in this document applies to any platform.


Running EM 13.2 OMS and agent with db plugin 13.2.2 to attempt to patch using fleet maintenance on a 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


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