Experience: Monitoring Oracle via Xymon?
Hi,
Does anyone have any experience in monitoring Oracle via Xymon (tablespaces/instaces/listener/export/rman-backups) - any help would be welcomed.
Regards,
Carl Melgaard
http://sourceforge.net/projects/hobbit-perl-cl/
There's a database check script in there. Doesn't monitor rman backups and exp's, but it catches the rest.
Needs the thick client, and perl dbi.
Steve Anderson
From: xymon-bounces at xymon.com [mailto:xymon-bounces at xymon.com] On Behalf Of Carl Melgaard Sent: 09 May 2011 11:37 To: 'xymon at xymon.com' Subject: [Xymon] Experience: Monitoring Oracle via Xymon?
Hi,
Does anyone have any experience in monitoring Oracle via Xymon (tablespaces/instaces/listener/export/rman-backups) - any help would be welcomed.
Regards,
Carl Melgaard
This email has been scanned by Netintelligence http://www.netintelligence.com/email
BiP Solutions Limited is a company registered in Scotland with Company Number SC086146 and VAT number 383030966 and having its registered office at Medius, 60 Pacific Quay, Glasgow, G51 1DZ.
This e-mail (and any attachment) is intended only for the attention of the addressee(s). Its unauthorised use, disclosure, storage or copying is not permitted. If you are not the intended recipient, please destroy all copies and inform the sender by return e-mail. This e-mail (whether you are the sender or the recipient) may be monitored, recorded and retained by BiP Solutions Ltd. E-mail monitoring/ blocking software may be used, and e-mail content may be read at any time.You have a responsibility to ensure laws are not broken when composing or forwarding e-mails and their contents.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
There is also more than one script, if I'm not mistaken, on Deadcat.net for Big Brother (which I can tell you works fine with Xymon).
Here is a sample of the output:
Mon May 9 13:07:59 EDT 2011 Oracle test on "MYPROD": OK
=============== Oracle Instance Check ================
green Instances specified in ORACLE_SIDS (MYPROD) match those found in /var/opt/oracle/oratab
=================== Oracle Listener ===================
green Listener UP
=================== Oracle Listener Info ===================
LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 09-MAY-2011 13:07:57
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS Message 1408 not found; No message file for product=network, facility=TNS Message 1411 not found; No message file for product=network, facility=TNS Message 1408 not found; No message file for product=network, facility=TNS Message 1052 not found; No message file for product=network, facility=TNS
TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 09-MAY-2011 13:07:57
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS
=================== MYPROD Check =================== green Paranoid test: Database MYPROD is up. Oracle Users in MYPROD: 36
============= MYPROD Tablespace Check ================ green Tablespace MYPROD:UPORTAL totals 500.0Mb and is 28% used. green Tablespace MYPROD:UNDO_RBS totals 500.0Mb and is 28% used. green Tablespace MYPROD:SYSTEM totals 500.0Mb and is 47% used. green Tablespace MYPROD:SYSAUX totals 500.0Mb and is 42% used. green Tablespace MYPROD:LUMINIS totals 500.0Mb and is 10% used.
============= MYPROD Extent Check ================ green No objects are exceeding 60%. Extent test ok.
============== Oracle Shadow Processes ===============
green Database MYPROD does not have shadow entries clear LDAP Monitor tests disabled clear LDAP Process tests disabled clear LDAP Port tests disabled
On 05/09/2011 07:09 AM, Steve Anderson wrote:
http://sourceforge.net/projects/hobbit-perl-cl/
There?s a database check script in there. Doesn?t monitor rman backups and exp?s, but it catches the rest.
Needs the thick client, and perl dbi.
Steve Anderson
*From:*xymon-bounces at xymon.com [mailto:xymon-bounces at xymon.com] *On Behalf Of *Carl Melgaard *Sent:* 09 May 2011 11:37 *To:* 'xymon at xymon.com' *Subject:* [Xymon] Experience: Monitoring Oracle via Xymon?
Hi,
Does anyone have any experience in monitoring Oracle via Xymon (tablespaces/instaces/listener/export/rman-backups) ? any help would be welcomed.
Regards,
Carl Melgaard
This email has been scanned by Netintelligence http://www.netintelligence.com/email
BiP Solutions Limited is a company registered in Scotland with Company Number SC086146 and VAT number 383030966 and having its registered office at Medius, 60 Pacific Quay, Glasgow, G51 1DZ.
This e-mail (and any attachment) is intended only for the attention of the addressee(s). Its unauthorised use, disclosure, storage or copying is not permitted. If you are not the intended recipient, please destroy all copies and inform the sender by return e-mail. This e-mail (whether you are the sender or the recipient) may be monitored, recorded and retained by BiP Solutions Ltd. E-mail monitoring/ blocking software may be used, and e-mail content may be read at any time.You have a responsibility to ensure laws are not broken when composing or forwarding e-mails and their contents.
Xymon mailing list Xymon at xymon.com http://lists.xymon.com/mailman/listinfo/xymon
- ---- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Sr. Systems Programmer |$&| |__| | | |__/ | \| _| |novosirj at umdnj.edu - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/CST-Academic Svcs. - ADMC 450, Newark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk3IH9wACgkQmb+gadEcsb7/UQCeL3hO5/s/m/WwSHxcU4qrEatL TkYAoKnmII6vcAvUfKsqpvkidIkXEiuY =6vn1 -----END PGP SIGNATURE-----
Hi, I have written a couple of scripts which check various things. They are designed to run from a single server with oracle client installed (in our case the Xymon server). I have a oracle xymon user on each database with minimal permissions so that it can get the data it needs.
If you like what you see I can post the scripts and configs. :-)
This is what the pages show. In this case it's a database under Data Guard soapro is the service on both databases. soapro1 is currently the primary (ora_dbrole = green). soapro2 is currently the failover (ora_dbrole = clear). It will go yellow for 5 minutes on a change of roles.
SOA Production
info<http://xymon/xymon-cgi/hobbitcolumn.sh?info>
ora_backups<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_backups>
ora_checks<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_checks>
ora_dbrole<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_dbrole>
ora_ping<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ping>
ora_size<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_size>
ora_ts<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ts>
trends<http://xymon/xymon-cgi/hobbitcolumn.sh?trends>
soapro
[info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=info>
[ora_backups:green:8d14h12m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_backups>
[ora_checks:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_checks>
[ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_dbrole>
[ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ping>
[ora_size:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_size>
[ora_ts:green:20d02h38m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ts>
[trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=trends>
soapro1 (soapro)
[info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=info>
[ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_dbrole>
[ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_ping>
[trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=trends>
soapro2 (soapro)
[info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=info>
[ora_dbrole:clear:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_dbrole>
[ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_ping>
[trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=trends>
attached are samples of what I produce :-)
From: xymon-bounces at xymon.com [mailto:xymon-bounces at xymon.com] On Behalf Of Carl Melgaard Sent: Monday, 9 May 2011 8:37 PM To: 'xymon at xymon.com' Subject: [Xymon] Experience: Monitoring Oracle via Xymon?
Hi,
Does anyone have any experience in monitoring Oracle via Xymon (tablespaces/instaces/listener/export/rman-backups) - any help would be welcomed.
Regards,
Carl Melgaard
This email (including all attachments) may contain personal information and is intended solely for the named addressee. It is confidential and may be subject to legal or other professional privilege and any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. This email is also subject to copyright. No part of it should be reproduced, adapted or communicated without the written consent of the copyright owner. Any personal Information in this email must be handled in accordance with the Privacy Act 1988 (Cth). If you have received it in error, please let Stanwell Corporation Limited know by reply email, delete it from your system and destroy any copies. Stanwell is not responsible for any changes made to a document other than those made by Stanwell. Stanwell accepts no liability for any damage caused by this email or its attachments due to viruses, interference, interception, corruption or unauthorised access. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. If this is a commercial electronic message within the meaning of the Spam Act 2003 (Cth), you may indicate that you do not wish to receive any further commercial electronic messages from Stanwell by emailing mailto:privacy at stanwell.com...
There was also bb-roracle, which I found on deadcat. It worked OK for me, but that was many years ago. Not sure how it will shape up to the newer versions of Oracle. I also spotted a bb-moracle on the xymonton page. I haven't looked at it, but it might be worth investigating.
Regards Vernon
On Tue, May 10, 2011 at 9:27 AM, FORD Alan <Alan.FORD at stanwell.com> wrote:
Hi,
I have written a couple of scripts which check various things.
They are designed to run from a single server with oracle client installed (in our case the Xymon server).
I have a oracle xymon user on each database with minimal permissions so that it can get the data it needs.
If you like what you see I can post the scripts and configs. :-)
This is what the pages show. In this case it's a database under Data Guard *soapro* is the service on both databases.
*soapro1* is currently the primary (ora_dbrole = green).
*soapro2* is currently the failover (ora_dbrole = clear).
It will go yellow for 5 minutes on a change of roles.
*SOA Production*
*info* <http://xymon/xymon-cgi/hobbitcolumn.sh?info>
*ora_backups* <http://xymon/xymon-cgi/hobbitcolumn.sh?ora_backups>
*ora_checks* <http://xymon/xymon-cgi/hobbitcolumn.sh?ora_checks>
*ora_dbrole* <http://xymon/xymon-cgi/hobbitcolumn.sh?ora_dbrole>
*ora_ping* <http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ping>
*ora_size* <http://xymon/xymon-cgi/hobbitcolumn.sh?ora_size>
*ora_ts* <http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ts>
*trends* <http://xymon/xymon-cgi/hobbitcolumn.sh?trends>
soapro
[image: info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=info>
[image: ora_backups:green:8d14h12m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_backups>
[image: ora_checks:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_checks>
[image: ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_dbrole>
[image: ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ping>
[image: ora_size:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_size>
[image: ora_ts:green:20d02h38m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ts>
[image: trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=trends>
soapro1 (soapro)
[image: info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=info>
[image: ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_dbrole>
[image: ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_ping>
[image: trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=trends>
soapro2 (soapro)
[image: info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=info>
[image: ora_dbrole:clear:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_dbrole>
[image: ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_ping>
[image: trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=trends>
attached are samples of what I produce :-)
*From:* xymon-bounces at xymon.com [mailto:xymon-bounces at xymon.com] *On Behalf Of *Carl Melgaard *Sent:* Monday, 9 May 2011 8:37 PM
*To:* 'xymon at xymon.com' *Subject:* [Xymon] Experience: Monitoring Oracle via Xymon?
Hi,
Does anyone have any experience in monitoring Oracle via Xymon (tablespaces/instaces/listener/export/rman-backups) – any help would be welcomed.
Regards,
Carl Melgaard
This email (including all attachments) may contain personal information and is intended solely for the named addressee. It is confidential and may be subject to legal or other professional privilege and any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. This email is also subject to copyright. No part of it should be reproduced, adapted or communicated without the written consent of the copyright owner. Any personal Information in this email must be handled in accordance with the Privacy Act 1988 (Cth). If you have received it in error, please let Stanwell Corporation Limited know by reply email, delete it from your system and destroy any copies. Stanwell is not responsible for any changes made to a document other than those made by Stanwell. Stanwell accepts no liability for any damage caused by this email or its attachments due to viruses, interference, interception, corruption or unauthorised access. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. If this is a commercial electronic message within the meaning of the Spam Act 2003 (Cth), you may indicate that you do not wish to receive any further commercial electronic messages from Stanwell by emailing mailto:privacy at stanwell.com...
Xymon mailing list Xymon at xymon.com http://lists.xymon.com/mailman/listinfo/xymon
participants (5)
-
Alan.FORD@stanwell.com
-
Carl.Melgaard@STAB.RM.DK
-
everett.vernon@gmail.com
-
novosirj@umdnj.edu
-
steve.anderson@bipsolutions.com