-----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-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: novosirj.vcf
Type: text/x-vcard
Size: 301 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20110509/3db372a6/attachment.vcf>