[Nagios-users] tools to monitor oracle 9i and 10g

[Joe Lin]

All,

Does anyone have any good tools to monitor the healthiness of oracle 9i or
10g?

Particularly I want to be able to query opmn or the Oracle Enterprise
manager and get a status if they are up or not.

Thanks
Joe

[Tom Brown]

Post by Joe Lin
All,
Does anyone have any good tools to monitor the healthiness of oracle 9i or
10g?
Particularly I want to be able to query opmn or the Oracle Enterprise
manager and get a status if they are up or not.

i monitor the state of my 9i db's using a shell script that invokes a
JDBC connection that is able to execute queries on the db to get info
about rows in tables / verify an instance is up etc

[Trevor Warren]

Hello dear,

I had worked with DB2 and WebSphere at one of my customers
datacenter. You should first see if any CLI tools are available to
pull this info out. Very simply for DB2 i could issue a "db2 get
dbm_cfg......." like a simple SQL statement and display the out put of
the same via nagios.

Most params for oracle performance/status can be achieved using a
simple query. For Oracle Apps i aint too sure but there has to be a
way of obtaining the same.

Thanks and take care. HTH.

Trevor

[j***@comcast.net]

Can I see your sample code that you have created for nagios?

Post by Tom Brown

Post by Joe Lin
All,
Does anyone have any good tools to monitor the healthiness of oracle 9i or
10g?
Particularly I want to be able to query opmn or the Oracle Enterprise
manager and get a status if they are up or not.

i monitor the state of my 9i db's using a shell script that invokes a
JDBC connection that is able to execute queries on the db to get info
about rows in tables / verify an instance is up etc

[j***@comcast.net]

Is it possible to see sample code you used for DB2 and websphere?

I know i can issue opmn status, and it will return status for all the components, but I am unsure what is the proper thing to pass them back into nagios...

Thanks!!
Joe

Post by Trevor Warren
Hello dear,
I had worked with DB2 and WebSphere at one of my customers
datacenter. You should first see if any CLI tools are available to
pull this info out. Very simply for DB2 i could issue a "db2 get
dbm_cfg......." like a simple SQL statement and display the out put of
the same via nagios.
Most params for oracle performance/status can be achieved using a
simple query. For Oracle Apps i aint too sure but there has to be a
way of obtaining the same.
Thanks and take care. HTH.
Trevor
--
___________________________________
( >- / Scaling FreeSoftware & OpenSource \ -< )
/~\ / In the Enterprise \ /~\
| \) \ | www.fsf.org | www.opensource.org | / (/ |
|_|_ \____________________________________/ _|_|

[Kreig DuBose]

The "proper" thing to pass back to Nagios can be whatever you want
to monitor.



For example



[ "$TEMP" -gt "$CRITHITEMP" ]

then

echo "CRITICALLY hot at $TEMP degrees F"

exit 2 #EXIT WITH CRITICAL



Nagios looks for your exit status and in this case passed the contents
within " " back to the UI.



Hope this helps.

...[write your message here]...





- Kreig DuBose (covtwin)



-----------------------

This thread is located in the archive at this URL:

http://www.nagiosexchange.org/nagios-users.34.0.html?&tx_maillisttofaq_pi
1[showUid]=6668

[Trevor Warren]

Thanks for writing in dear,

The code i have written is at me client site and can send it across
only next week. I might have also sent it to the mailing list, but am
not too sure. Can you pls check the achives.

Do drop me an email pls next week incase me forgets. Take care and
have a great weekend dear.

Trevor

[Joe Lin]

Trevor,

I searched the archives as well as the nagios-plugins CVS tree.

I did not see the code.

Can you post next week on here please :)

Thanks
Joe


-----Original Message-----
From: Trevor Warren [mailto:***@gmail.com]
Sent: Saturday, May 21, 2005 6:36 AM
To: ***@comcast.net
Cc: nagios-***@lists.sourceforge.net
Subject: Re: [Nagios-users] tools to monitor oracle 9i and 10g

Thanks for writing in dear,

The code i have written is at me client site and can send it across
only next week. I might have also sent it to the mailing list, but am
not too sure. Can you pls check the achives.

Do drop me an email pls next week incase me forgets. Take care and
have a great weekend dear.

Trevor