Dbfleet: Deploy Oracle Home Failed With Error Error In Oracle Home Details. Check OMS Logs For More
Last updated on JANUARY 14, 2018
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.0 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 220.127.116.11 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