Nagios check_oracle_health - ORA-12154 ERROR

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
admincauce
Posts: 34
Joined: Wed Sep 19, 2018 3:20 am

Re: Nagios check_oracle_health - ORA-12154 ERROR

Post by admincauce »

Ok.

It's correct. My tnsname.ora is located in the path /u01/app/oracle/product/12c/dbhome_1/network/admin in my Oracle Server.

And it's correct that I have in $ORACLE_HOME a path to lib and path to bin files.
User avatar
tgriep
Madmin
Posts: 9177
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios check_oracle_health - ORA-12154 ERROR

Post by tgriep »

The command I use does not require the tnsnames.ora file. I specify all of the information required to connect on the command line.
One thing I found to check is that the $ORACLE_HOME/network/admin/tnsnames.ora is world readable.
Be sure to check out our Knowledgebase for helpful articles and solutions!
admincauce
Posts: 34
Joined: Wed Sep 19, 2018 3:20 am

Re: Nagios check_oracle_health - ORA-12154 ERROR

Post by admincauce »

Hi

Finally I came up with the solution to the problem, and that's what you just answered me in the last comment. The file "tnsname.ora" did not have enough permissions to be read. Changing the permissions, the checkup works perfectly.

In the end these problems are silly but it is hard to reach them.

Thank you very much anyway for your help.

Regards
User avatar
tgriep
Madmin
Posts: 9177
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios check_oracle_health - ORA-12154 ERROR

Post by tgriep »

Your Welcome. Glad it is working now.
I'll lock up the post for you but feel free to post any questions in the future.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked