Page 2 of 2
Re: Nagios check_oracle_health - ORA-12154 ERROR
Posted: Wed Oct 10, 2018 9:20 am
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.
Re: Nagios check_oracle_health - ORA-12154 ERROR
Posted: Wed Oct 10, 2018 2:38 pm
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.
Re: Nagios check_oracle_health - ORA-12154 ERROR
Posted: Thu Oct 11, 2018 2:23 am
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
Re: Nagios check_oracle_health - ORA-12154 ERROR
Posted: Thu Oct 11, 2018 8:53 am
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.