Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: OEM and monitoring clustered databases

RE: OEM and monitoring clustered databases

From: Aponte, Tony <>
Date: Fri, 21 Mar 2003 15:06:59 -0500
Message-Id: <>

We got around it by dropping the natural and failover nodes from OEM, modifying the oratab files to contain only the databases active the node, bounce the dbsnmp agents, rediscover the nodes and change the oratab files back to their original. The trick is in the discovery of the services on that node, the agents look through the oratab file for that info. We have to do this every time a database fails or is switched over manually.

Tony Aponte

-----Original Message-----
From: Chuck Hamilton [] Sent: Wednesday, March 05, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L Subject: OEM and monitoring clustered databases

I've had problems trying to use OEM (9.0.1) to monitor clustered databases.
The problem is that each database is set up in it's own resource group, therefore each has it's own virtual hostname. Even though I may have several
databases all running on the same physical host, they all have different virtual hostnames that move with the database when it fails over to another
node in the cluster. When you discover a node, it picks up all of the databases on the node and registers them with the OMS as being on that node.
Once one of them fails over it's no longer on that node and can't be monitored from OEM anymore. I'm sure others on this list are using this type
of failover for high availability. How did you get around it?


Please see the official ORACLE-L FAQ:

Author: Chuck Hamilton

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 21 2003 - 14:06:59 CST

Original text of this message