Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OEM and monitoring clustered databases
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.
HTH
Tony Aponte
-----Original Message-----
From: Chuck Hamilton [mailto:chuckh_at_softhome.net]
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: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: chuckh_at_softhome.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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
![]() |
![]() |