Monday, June 10, 2013

Oracle Home Property Missing for 12c Agent

1. Check that the Oracle home exist in the $AGENT_INST/sysman/emd/targets.xml
2. Check that the Oracle home exist in the oraInventory

Here is the resolution:

Missing home in oraInventory

1. Attach home to oraInventory
$cd $AGENT_HOME
$AGENT_HOME/oui/bin/runInstaller -silent -attachHome -invPtrLoc $AGENT_HOME/oraInst.loc ORACLE_HOME_NAME="agent1_home" oracle_home="$AGENT_HOME" "cluster_nodes={}"

2. Run emctl collection
$cd $AGENT_HOME
 $./emctl control agent runCollection <TARGET_ORACLE_HOME_NAME>:oracle_home oracle_home_config

Missing Home in Targets.xml

1. Run emctl collection
 $cd $AGENT_HOME

$./emctl control agent runCollection <TARGET_ORACLE_HOME_NAME>:oracle_home oracle_home_config

6 comments:

  1. This is very informative post. i loved to read this.
    Real Estate India

    ReplyDelete
  2. I am glad to locate your recognized method for composing the post. Presently you make it simple for me to comprehend and execute the idea. Much obliged to you for the post. HOA Management Solutions

    ReplyDelete
  3. Javier! My man! How do you determine when the value is missing from the targets.xml file? I tried guessing what it should be and got this error:

    EMD runCollection error:no target collection

    ReplyDelete
    Replies
    1. sorry it looks like the string got stripped. How do you determine the "TARGET_ORACLE_HOME_NAME"?

      Delete
    2. Hay David how's it going. The target Oracle home name would be found in OEM.


      You also check if the patch for that home exist in the Oracle inventory file.

      Delete

About Me

My photo

Senior DBA with over 16 years experience, specializing in "Database Performance Tuning" and High Availability (RAC, Data Guard & Oracle Golden Gate).