Page 2 of 2
Re: Unable to install DBD::Oracle
Posted: Tue Apr 29, 2014 4:46 am
by jstoddart
Using the info in that link I managed to get it installed, am now getting
ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)
Am having a look now, appears to be a listner/connection issue
Re: Unable to install DBD::Oracle
Posted: Tue Apr 29, 2014 8:51 am
by jstoddart
Have had no luck resolving this, any posts I have seen refer to having a tnsnames.ora which I do not have but have followed all the install steps in the XI guide?
Re: Unable to install DBD::Oracle
Posted: Tue Apr 29, 2014 1:28 pm
by slansing
What is the exact command you are using? The TNS listener is located on the oracle server, you will need to get with your oracle DBA and make sure they set you up with a listener service that has permissions to see everything you intend to monitor with the wizards.
Re: Unable to install DBD::Oracle
Posted: Tue Apr 29, 2014 5:44 pm
by jstoddart
Any of the Core ones imported via the Wizard for Oracle checks:
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 $USER1$/check_oracle_health $ARG1$
--connect '<ip>:1521/BGRSPRD' --username 'sys' --password '****' --mode connection-time --warning 1 --critical 5
Is there some config required on the listener to allow us to connect?
Re: Unable to install DBD::Oracle
Posted: Wed Apr 30, 2014 10:07 am
by slansing
Well it is absolutely imperative that you have a TNS listener listening for your connection, you can run the following on the oracle server to see what listeners are available but anything beyond what has already been covered i.e. "anything on your oracle server" is beyond the scope of Nagios support:
Can you run your entire check command manually from the CLI and show the output?
Re: Unable to install DBD::Oracle
Posted: Thu May 29, 2014 2:39 am
by jstoddart
Apologies, I have been of sick for a few weeks and just getting back to this, will run the check from the command line as requested.
Re: Unable to install DBD::Oracle
Posted: Thu May 29, 2014 5:28 am
by jstoddart
./check_oracle_health --connect <host>:1521/KANADB' --username 'sys' --password '****' --mode tablespace-usage --warning 90 --critical 98
CRITICAL - cannot connect to <host>:1521/KANADB. ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)
[NagiosX1:main.linux64 libexec]#
lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-MAY-2014 05:26:28
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 27-APR-2014 22:57:30
Uptime 31 days 6 hr. 28 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/kcibdb02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kcibdb02)(PORT=1521)))
Services Summary...
Service "KANADB" has 1 instance(s).
Instance "KANADB", status READY, has 1 handler(s) for this service...
The command completed successfully
Re: Unable to install DBD::Oracle
Posted: Thu May 29, 2014 1:08 pm
by slansing
NagiosX1:main.linux64 libexec
You didn't run the status command on the nagios server did you? If you did, looks like you have some strange hybrid oracle going on there. It needs to be ran on the oracle server, if you did run it there, great! As far as that TNS listener service, did your DBA tell you whether it had permissions on what you are trying to check, and that it is actually listening? It's likely your XI server's ADDRESS is not defined for it.