urgent: getting (Return code of 9 is out of bounds)

[aels]

Hi,
Urgent question, I had to update the oracle instant client being used and now I am getting: (Return code of 9 is out of bounds) for all my oracle checks.
I can run the plugin script manually using root or nagios and it works perfect, but from the application it is just gives the (Return code of 9 is out of bounds).
This is urgent any ideas??

I downgraded the oracle client, backed out changes etc no change.
I tried to update the perl DBD::Oracle module to 1.28 it was at 1.24, but now no matter which one I use, I still get the (Return code of 9 is out of bounds)

Using : 2009R1.4B

thank you
Anton

[aels]

I added the following environment variables to the /etc/init.d/nagios and /etc/init.d/nagiosxi scripts, restart and now all works again.
I have updated the DBD::Oracle driver and the client and all is working.....

export ORACLE_BASE=.....
export ORACLE_HOME=....
export LD_LIBRARY_PATH=....

Cheers
Anton

[rdedon]

Excellent! I was a bit stumped on this but glad you figured it out