Nagios Support Forum

I changed the oracle home and LD_LIBRARY_PATH for the commands check_xi_oraclequery, serverspace and tablespace in CCM.
Now is able to load libraries, but i am still getting a error

CRITICAL - cannot connect to sfpariapp30k-prd-001.cisco.com:1521XE. ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)

Any ideas on how to resolve this

Try using a double backslash or enclosing in double quotes, the host name, that is.

COMMAND: /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 /usr/local/nagios/libexec/check_oracle_health --connect "<hostname>:1521\\XE" --username system --password "<password>" --mode connection-time --warning 2 --critical 5

OUTPUT: CRITICAL - cannot connect to <hostname>:1521\XE. ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)


I am using double quotes for host name, i have posted the command and the output, can you check and let me know if i have to change any thing.

Thanks a lot for the help.
Its working now