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.
Nagios check_oracle_health - ORA-12154 ERROR
-
- Posts: 34
- Joined: Wed Sep 19, 2018 3:20 am
Re: Nagios check_oracle_health - ORA-12154 ERROR
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.
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!
-
- Posts: 34
- Joined: Wed Sep 19, 2018 3:20 am
Re: Nagios check_oracle_health - ORA-12154 ERROR
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
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
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.
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!