Nagios Support Forum

Posted: **Mon Oct 26, 2020 8:18 am**

Hi Team,

We are monitoring Oracle RAC database. While monitoring the services, we are getting below error:

CRITICAL - ORA-12154: TNS:could not resolve the connect identifier specified

CRITICAL - cannot connect to RAPRD1. ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)

I am attaching the ORACLE_PATH details and config details here.

Kindly, help us on the same.

Posted: **Mon Oct 26, 2020 5:22 pm**

Do you have this file?

Code: Select all

/usr/local/nagiosxi/etc/configwizards/oracle/oracle

If not, run these commands:

Code: Select all

mkdir -p /usr/local/nagiosxi/etc/configwizards/oracle
touch /usr/local/nagiosxi/etc/configwizards/oracle/oracle
chown -R nagios.nagios /usr/local/nagiosxi/etc/configwizards
chmod 2755 /usr/local/nagiosxi/etc/configwizards/oracle
chmod 0664 /usr/local/nagiosxi/etc/configwizards/oracle/oracle

Then add these lines to it:

Code: Select all

export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/client_1/lib
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1

Then go to Configure > Core Config Manager > Commands:
- Edit the check_oracle_tablespace command
- Change the command line to:

Code: Select all

. /usr/local/nagiosxi/etc/configwizards/oracle/oracle && $USER1$/check_oracle --tablespace $ARG1$ $ARG2$ $ARG3$ $ARG4$ $ARG5$ $ARG6$

- Save
- Apply Configuration and force a check

Nagios Support Forum

CRITICAL - ORA-12154: TNS:could not resolve the connect iden

CRITICAL - ORA-12154: TNS:could not resolve the connect iden

Re: CRITICAL - ORA-12154: TNS:could not resolve the connect