Updating the Oracle Home Path of an Upgraded a RAC cluster Target in Enterprise Manager Cloud Control Alters only One Instance of the Cluster (Doc ID 1959635.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 12.1.0.7.0 [Release 12.1]
Enterprise Manager Base Platform - Version 12.1.0.5.0 to 12.1.0.5.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

You have recently upgraded a RAC database, which changed the Oracle Home file paths.
You want to reflect the change for this target in Enterprise Manager (EM) 12c Cloud Control.
When you change the Oracle Home Path in the Cluster Database homepage, it only seems to change the Cluster Database Target and one Database Instance - controlled by the master agent:

Cluster Database Homepage -> Target Setup -> Monitoring Configuration

Change "Oracle home path" to new value, click next -> click ok / Submit

 

To check the update fails on the "Other" instances

Go to The Monitoring Configuration again:

Cluster Database Homepage -> Target Setup -> Monitoring Configuration
scroll down the page to the instances section

Highlight each Instance "in turn" and click edit

 

You will see one instance with the new ORACLE HOME path and the other instances show the old ORACLE HOME path.

You can also check the targets.xml files on the agent in  <AGENT HOME>/agent_inst/sysman/emd/targets.xml

The Instance Target will have the old ORACLE HOME value.

This can result in Metric Collection/Metric Evaluation Errors for example:

Internal Event Name:RAC_DATABASE_CONFIG

Event Type: Metric Evaluation Error

Message:  /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl config database -d ORCL -S 1 did not run successfully. Refer agent's perl log files for details. em_error=/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl config database -d ORCL -S 1 did not run successfully. Refer agent's perl log files for details. 

 

 

Changes

 

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