-----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-----