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 OCTOBER 26, 2021
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 primary 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: <ORACLE HOME>/bin/srvctl config database -d<SID> -S 1 did not run successfully. Refer agent's perl log files for details. em_error=<ORACLE HOME>/bin/srvctl config database -d <SID> -S 1 did not run successfully. Refer agent's perl log files for details.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |