Oracle test without oracle client

[Hari Sekhon]

"if" you could compile....

Yes yes I know, in fact Oracle sucks in few ways, I'm still a bit 
surprised that they rate themselves so well, there have been so many 
problems with them, they have many bugs etc and of course you don't have 
the source to try compiling it on another arch, you're stuck with what 
they give you.

but x86 boxes are so cheap, you could just buy one...

I'm not sure why people would not have some x86 boxes since everything 
works on them, it's practically _the_ standard.

Even if you run other arches for some specific app, it doesn't mean you 
can have a cheap x86 box somewhere.

But anyway, I digress...

To end, there is check_oracle and a few plugins in the contrib dir of 
the standard plugins distribution. As well as a few on nagios exchange 
if I am not mistaken...

-h

Hari Sekhon



admir.trakic at nordea.com wrote:
> Recompile InstantClient? -where is the source? .... ;-) 
> Anyways, some of us are not sitting on x86 boxes, 
> /admir
>
> -----Original Message-----
> From: Hari Sekhon [mailto:hpsekhon at googlemail.com] 
> Sent: 24 September 2007 12:21
> To: Trakic, Admir
> Cc: Nagios Users mailinglist
> Subject: Re: [Nagios-users] Oracle test without oracle client
>
> Yes this is a limitation of the instant client then, not the plugin per
> se, if you could compile the instant client on those other architectures
> then you could run the plugin there.
>
> I agree it's not ideal, when I first saw this I wondered why nobody has
> done a proper plugin in C or something, but then, who's going to do it? 
> It's not easy and it's hard to find the time for something like this
> when there is already a (mainly) working solution.
>
> I, probably like everyone else, figured the check_oracle script was
> worth a try, and just good enough. I have used it for a year and a half
> and it's done great by me so far. But then I am not running exotic
> architectures...
>
> If worst came to worst, you could just have the plugin and instant
> client on an x86 box and run it via a remote check like nrpe...
>
> -h
>
> Hari Sekhon
>
>
>
> admir.trakic at nordea.com wrote:
>   
>> Ehm, oracle_client is havily dependent on instannt client, therefore 
>> cannot be used under arm,ppc,etc,...
>>
>> $ uname -m
>> armv5tel
>>
>> Br,AdmirTrakic
>>
>> -----Original Message-----
>> From: Hari Sekhon [mailto:hpsekhon at googlemail.com]
>> Sent: 24 September 2007 12:08
>> To: Trakic, Admir
>> Cc: Nagios Users mailinglist
>> Subject: Re: [Nagios-users] Oracle test without oracle client
>>
>> admir.trakic at nordea.com wrote:
>>   
>>     
>>> I agree with you, but again it was just a dirty hack (if no 
>>> $ORACLE_HOME)...
>>>
>>> Additionally I would also comment on your "usable" pointer: 
>>> - take a good look on your tablespace checks, since the check_oracle 
>>> script does not taking any account on that, for more info se:
>>> http://www.oracleutilities.com/autoextend.html
>>>   
>>>     
>>>       
>> True, it's not 100% cos your tablespaces could be out of space, there 
>> are a couple of oracle scripts in contrib that are supposed to check 
>> tablespaces but I don't use them personally at this time. I just make 
>> sure the oracle databases are up and accessible
>>
>> it's still a good start though, it will tell you if the listener is up
>>     
>
>   
>> and if so then if the instance is up or not.
>>
>>
>> -h
>>
>>   
>>     
>
>   

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
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