How To Update OEM Targets Oracle Home Configuration After Out of Place Patching without using Enterprise Manager Cloud Control (Doc ID 2451994.1)

How To Update OEM Targets Oracle Home Configuration After Out of Place Patching without using Enterprise Manager Cloud Control (Doc ID 2451994.1)

To Bottom

---

In this Document Goal Solution APPLIES TO: Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later Information in this document applies to any platform. GOAL  How to update Oracle Home target property on multiple targets after manually upgrading database or using out of place patching? SOLUTION The only method that can be used to bulk update this property currently is emcli: emcli modify_target -type='<target_type>' -name='<target_name>' -properties='OracleHome:<oracle_home_path>' -on_agent In order to generate the emcli command for multiple targets you can use below sql code for example on OMS repository database (replace the regex expressions and replace parameters as per your requirements): select      target_name    , target_type    , 'emcli modify_target -type=' ||chr(39) || target_type || chr(39) || ' -name=' || chr(39) || target_name || chr(39) || ' -properties=' || chr(39) || property_name||':'||replace(property_value,'12.2.0.1','18.0.0.0') || chr(39) as cmdA    , 'emcli modify_target -type=' ||chr(39) || target_type || chr(39) || ' -name=' || chr(39) || target_name || chr(39) || ' -properties=' || chr(39) || property_name||':'||replace(property_value,'12.2.0.1','18.0.0.0') || chr(39)|| ' -on_agent' as cmdB from    sysman.mgmt$target_properties where    target_type in    (        'osm_cluster'    ,   'oracle_listener'    ,   'has'    ,   'oracle_home'    ,   'cluster'    ,   'osm_proxy'    ,   'osm_instance' )    and property_name='OracleHome'    and property_value='/u01/app/oracle/product/11.2.0.4/dbhome_1'    and (        regexp_like(target_name,'celem','i') or            (                regexp_like(target_name,'LISTENER_SCAN[[:digit:]]{1}_','i')            and regexp_like(target_name,'celem$','i')            )        ) order by      target_type    , target_name    ;