Monitor oracle resources

Livio Zanol Puppim livio.zanol.puppim at gmail.com
Tue Jul 8 17:28:05 CEST 2008


Here we have made an shell script that returns the stats of all
cluster services, and made it apeend the results to an OID using
NET-SNMP snmpd...

On the Nagios server host, we've created an shell script to make an
walk and verify if the services are working properly... I think it's
better then using NRPE...

snmpwalk example output(I know that the format is not the ideal yet...):

# snmpwalk -v1 -c public 127.0.1 .1.3.6.1.4.1.2021.51
UCD-SNMP-MIB::ucdavis.51.1.1 = INTEGER: 1
UCD-SNMP-MIB::ucdavis.51.2.1 = STRING: "oracle"
UCD-SNMP-MIB::ucdavis.51.3.1 = STRING: "/usr/local/bin/snmp_test.sh"
UCD-SNMP-MIB::ucdavis.51.100.1 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.51.101.1 = STRING: "ora.server0.ASM1.asm ONLINE
   ONLINE on server0"
UCD-SNMP-MIB::ucdavis.51.101.2 = STRING:
"ora.server0.LISTENER_server0.lsnr ONLINE     ONLINE on server0"
UCD-SNMP-MIB::ucdavis.51.101.3 = STRING: "ora.server0.gsd ONLINE
ONLINE on server0"
UCD-SNMP-MIB::ucdavis.51.101.4 = STRING: "ora.server0.ons ONLINE
ONLINE on server0"
UCD-SNMP-MIB::ucdavis.51.101.5 = STRING: "ora.server0.vip ONLINE
ONLINE on server0"
UCD-SNMP-MIB::ucdavis.51.101.6 = STRING: "ora.server1.ASM2.asm ONLINE
   ONLINE on server1"
UCD-SNMP-MIB::ucdavis.51.101.7 = STRING:
"ora.server1.LISTENER_server1.lsnr ONLINE     ONLINE on server1"
UCD-SNMP-MIB::ucdavis.51.101.8 = STRING: "ora.server1.gsd ONLINE
ONLINE on server1"
UCD-SNMP-MIB::ucdavis.51.101.9 = STRING: "ora.server1.ons ONLINE
ONLINE on server1"
UCD-SNMP-MIB::ucdavis.51.101.10 = STRING: "ora.server1.vip ONLINE
ONLINE on server1"
UCD-SNMP-MIB::ucdavis.51.101.11 = STRING: "ora.oracle.db ONLINE
ONLINE on server0"
UCD-SNMP-MIB::ucdavis.51.101.12 = STRING: "ora.oracle.oracle.cs ONLINE
    ONLINE on server1"
UCD-SNMP-MIB::ucdavis.51.101.13 = STRING:
"ora.oracle.oracle.oracle1.srv ONLINE     ONLINE on server0"
UCD-SNMP-MIB::ucdavis.51.101.14 = STRING: "ora.oracle.oracle.oracle2.srv"
UCD-SNMP-MIB::ucdavis.51.102.1 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.51.103.1 = ""

2008/7/8 Hart, Harry M. CTR USJFCOM SUPPORT.SUPPORT JTC-I
<harry.hart.ctr at jfcom.mil>:
> Looks like!
>
>
> Harry M. Hart Systems integrator
> (757) 203-7422
> DSN 668-7422
> Harry.Hart at intel.jwfc.jfcom.smil.mil
> Harry.Hart at jwfc.ic.gov
>
> -----Original Message-----
> From: Christian Schneemann [mailto:cschneemann at suse.de]
> Sent: Tuesday, July 08, 2008 7:38 AM
> To: Hart, Harry M. CTR USJFCOM SUPPORT.SUPPORT JTC-I
> Cc: nagios-users at lists.sourceforge.net
> Subject: Re: [Nagios-users] Monitor oracle resources
>
> On Tuesday July 8 2008 01:33:03 pm Hart, Harry M. CTR USJFCOM SUPPORT.SUPPORT JTC-I wrote:
> Hi,
> so your text files are the needed plugins?
>
>
>        Christian
>
>> I downloaded files from a web page that are txt files but they don't
>> explain what I need to do to make them useful for my requirement. I took
>> off the .txt extension and I seem to be making some progress. I can get the
>> check_oracle_cluster one to at least read the crs_stat parameters. I just
>> need to play with them a little bit more.
>>
>> Thanks again
>>
>>
>> Harry M. Hart Systems integrator
>> (757) 203-7422
>> DSN 668-7422
>> Harry.Hart at intel.jwfc.jfcom.smil.mil
>> Harry.Hart at jwfc.ic.gov
>>
>> -----Original Message-----
>> From: Christian Schneemann [mailto:cschneemann at suse.de]
>> Sent: Tuesday, July 08, 2008 7:28 AM
>> To: nagios-users at lists.sourceforge.net
>> Cc: Hart, Harry M. CTR USJFCOM SUPPORT.SUPPORT JTC-I
>> Subject: Re: [Nagios-users] Monitor oracle resources
>>
>> On Tuesday July 8 2008 01:21:14 pm Hart, Harry M. CTR USJFCOM
> SUPPORT.SUPPORT JTC-I wrote:
>> > I know that part. I don't know how to get the txt files to work. As I
>> > said, I'm not a programmer.
>>
>> Hm, maybe you should show us what txt file you mean? Why not simple search
>> on nagiosexchange.net for a plugin that fits your needs?
>>
>> Sorry, I don't understand what you mean with txt files? Why are you
>> handling with textfiles? Is there a discription in how to set up a test for
>> nagios?
>>
>>
>> Christian
>>
>> > Thanks anyway
>> >
>> >
>> > Harry M. Hart Systems integrator
>> > (757) 203-7422
>> > DSN 668-7422
>> > Harry.Hart at intel.jwfc.jfcom.smil.mil
>> > Harry.Hart at jwfc.ic.gov
>> >
>> > -----Original Message-----
>> > From: Christian Schneemann [mailto:cschneemann at suse.de]
>> > Sent: Tuesday, July 08, 2008 7:17 AM
>> > To: nagios-users at lists.sourceforge.net
>> > Cc: Hart, Harry M. CTR USJFCOM SUPPORT.SUPPORT JTC-I
>> > Subject: Re: [Nagios-users] Monitor oracle resources
>> >
>> > On Tuesday July 8 2008 12:59:23 pm Hart, Harry M. CTR USJFCOM
>>
>> SUPPORT.SUPPORT JTC-I wrote:
>> > > Hello all
>> >
>> > Hi,
>> >
>> > > I want to monitor oracle resources on remote servers. I found a couple
>> > > text files (one written by Ricardo Alves dos Reis) that looks like
>> > > they might do it on the local machine but I am not a programmer and
>> > > don't know how to get them to monitor remote crs services. Does anyone
>> > > know how I can do this?
>> >
>> > You can do local tests on a remote machine with nrpe, nagios remote
>> > plugin executor.
>> >
>> > Greetings,
>> >     Christian
>> >
>> > > TIA
>> > > Harry
>> > >
>> > > Harry M. Hart Systems integrator
>> > > SAIC
>> > > USJFCOM JIOC DCGS-A
>> > > (757) 203-7422
>> > > DSN 668-7422
>> > > Harry.Hart at intel.jwfc.jfcom.smil.mil
>> > > Harry.Hart at jwfc.ic.gov
>> > >
>> > >
>> > >
>> > > ----------------------------------------------------------------------
>> > > --- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
>> > > Studies have shown that voting for your favorite open source project,
>> > > along with a healthy diet, reduces your potential for chronic lameness
>> > > and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>> > > _______________________________________________
>> > > Nagios-users mailing list
>> > > Nagios-users at lists.sourceforge.net
>> > > https://lists.sourceforge.net/lists/listinfo/nagios-users
>> > >
>> > > ::: Please include Nagios version, plugin version (-v) and OS when
>> > > ::: reporting any issue. Messages without supporting info will risk
>> > >
>> > > being
>> > >
>> > > ::: sent to /dev/null
>> >
>> > --
>> > Christian Schneemann
>> >
>> > -------------------------------------
>> > SUSE LINUX Products GmbH,
>> > Maxfeldstr. 5, D - 90409 Nürnberg
>> >
>> > Phone:  +49 (0)911 - 740 53 0
>> > e-mail: cschneemann at suse.de
>> > -------------------------------------
>> > SUSE LINUX Products GmbH, GF: Markus Rex HRB 16746 (AG Nürnberg)
>> >
>> > -------------------------------------------------------------------------
>> > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
>> > Studies have shown that voting for your favorite open source project,
>> > along with a healthy diet, reduces your potential for chronic lameness
>> > and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>> > _______________________________________________
>> > Nagios-users mailing list
>> > Nagios-users at lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/nagios-users
>> >
>> > ::: Please include Nagios version, plugin version (-v) and OS when
>> > ::: reporting any issue. Messages without supporting info will risk being
>> > ::: sent to /dev/null
>
>
>
> --
> Christian Schneemann
>
> -------------------------------------
> SUSE LINUX Products GmbH,
> Maxfeldstr. 5, D - 90409 Nürnberg
>
> Phone:  +49 (0)911 - 740 53 0
> e-mail: cschneemann at suse.de
> -------------------------------------
> SUSE LINUX Products GmbH, GF: Markus Rex
> HRB 16746 (AG Nürnberg)
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>



-- 
[]'s

Lívio Zanol Puppim

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list