Cannot determine ORACLE_HOME for sid

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.
Locked
Pratapa
Posts: 150
Joined: Tue Oct 01, 2019 1:33 am

Cannot determine ORACLE_HOME for sid

Post by Pratapa »

We are getting error while executing the following. check_oracle is the plugin and step is the ORACLE_SID

[[email protected]]# /usr/bin/env LD_LIBRARY_PATH=/opt/oracle/product/12.2.0/db_2/lib ORACLE_HOME=/opt/oracle/product/12.2.0/db_2 /opt/nagios/libexec/check_oracle --login step
Cannot determine ORACLE_HOME for sid step


Please help me in fixing this.
gormank
Posts: 1114
Joined: Tue Dec 02, 2014 12:00 pm

Re: Cannot determine ORACLE_HOME for sid

Post by gormank »

I think env just echos environment variables so I'm not sure what it's purpose is.
Maybe try
expoert LD_LIBRARY_PATH=/opt/oracle/product/12.2.0/db_2/lib; export ORACLE_HOME=/opt/oracle/product/12.2.0/db_2; /opt/nagios/libexec/check_oracle --login step
Or that and set ORACLE_ADMIN at the same time to point to tnsnames.ora as well.
Locked