[Nagiosplug-devel] Check_oracle

[Ton Voon]

On 22 Mar 2006, at 10:05, sean finney wrote:

> hi ali,
>
> On Wed, Mar 22, 2006 at 09:31:14AM -0000, Khan, Ali wrote:
>> Hello Sean, same problem, its only if i remove the $ sign does the
>> correct name get resolved.
>
> okay, then at least i know.  not having an oracle installation myself,
> i can only make guesses at what's going on.  could you send me the
> output of the command?  in the meantime i'll remove the extra $ from
> the grep expression but it would be good for me to see what's being
> grepped so i can understand perhaps why it got there in the first  
> place.

What is the oracle sid? What is the output from a

ps -ef | grep -v grep | grep -c "ora_pmon_"

The $ was put in because otherwise a sid of "ABC" would match if  
there was another database called ABCD.

Personally, I use the --login option instead. This does a dummy login  
to the oracle database and checks that the result is a "userid  
incorrect". Any other error would be flagged up. This checks from the  
plugin to the database itself - much more reliable than just checking  
a process is running.

Ton


http://www.altinity.com
T: +44 (0)870 787 9243
F: +44 (0)845 280 1725
Skype: tonvoon