Monitor oracle resources

[Kent Saunders]

Can you post that script?  Looks interesting.

Livio Zanol Puppim wrote:
> 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
>>
>>     
>
>
>
>   


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