Oracle plugin error

[GldRush98]

Is this indicating there is something wrong with the installed Oracle libraries, or is this showing the plugin and libraries are working but it just can't connect to the Oracle server?
Sorry if this is obvious, but I don't know anything about oracle and the error isn't completely clear on what isn't working:

Capture.png

[cdienger]

Nagios may have been given an incorrect SID to connect to the database. Double check the command. The error indicates the there is a connection but service isn't available on the Oracle side. https://docs.oracle.com/cd/B19306_01/se ... t12500.htm has some more information as well as actions to take to help troubleshoot.

[GldRush98]

Thank you for the information! I believe it is indeed the SID. I'll go back to our DB side, thanks!

[cdienger]

Sounds good. Let me know if you have any additional questions for us after you check this!

[GldRush98]

Ok, so this is odd.
I ended up getting the correct SID and getting everything working with these... left work, came in the next day, and they had stopped working.
This is the error I am seeing now:

Capture.png

I'm not sure why it's complaining of the env variables, they're still set in the commands just like the instructions say and how they were when I got them working.
The Oracle guy claims nothing has changed on the db server, so they keep pushing back on me saying it is something with the plugin. Any tips or way I can prove what it is, either way?

[dwhitfield]

Do you get the same output if you run the plugin from the command line on the nagios server?

Also, can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

UPDATE: profile received and shared with techs

[GldRush98]

Yes, I get the same output when ran from a command line.

I have PM'ed you the system profile.

[tgriep]

When that plugin is ran, it keeps a state file for temporary information. If you ran the command manually as root, the state file will only be writeable as root so when the XI server runs it as the nagios user, it would fail.
Try removing the following file from the Nagios server and see if that fixes the issue.

Code: Select all

/var/tmp/check_oracle_health

Other than that, you may want to look at the Oracle server to see if the account is still active and has the correct permissions.

[GldRush98]

The check was not ran as root at any point. I double checked the state file and I don't see it, so I don't think it is stuck there. Is the message about the env variables not relevant then? I only has because they keep harping on that bit of the error, even thought I've told them the variables are set literally every time the check runs...

[tgriep]

Verify that the path in the command is correct. If the command cannot find the Oracle Instant client, it may give the error you are having.
Make sure the paths in the command are correct, If not, update them and see if that resolves the error.

Code: Select all

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 $USER1$/check_oracle_health $ARG1$

If the path is correct, try reinstalling the Oracle Instant Client.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf