Page 2 of 3
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Thu Jan 28, 2016 4:26 pm
by dlukinski
tgriep wrote:There are issues with the Oracle 12.1 client that are causing the issue. The newer client doesn't have some of the required modules needed.
Remove the 12.1 Oracle Client and use the Oracle Client 11.2. That should fix the issue you are having.
went down to 11.2.0.4.0
Now getting this error:
CRITICAL - cannot connect to fihp-oradev06.konecranes.com :1532. ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Thu Jan 28, 2016 4:42 pm
by lmiltchev
Can you show us the "tnsnames.ora" file?
Similar issue is described here:
http://www.perlmonks.org/?node_id=809180
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Mon Feb 01, 2016 5:00 pm
by dlukinski
No such file in XI / get one from Oracle DB server?
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Mon Feb 01, 2016 5:51 pm
by lmiltchev
No such file in XI / get one from Oracle DB server?
Yes, it is located on the Oracle DB server.
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Tue Feb 09, 2016 1:34 pm
by dlukinski
lmiltchev wrote:No such file in XI / get one from Oracle DB server?
Yes, it is located on the Oracle DB server.
Please keep this one open - still trying to obtain the file in question
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Tue Feb 09, 2016 1:54 pm
by hsmith
Sure.
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Wed Feb 10, 2016 3:12 pm
by dlukinski
hsmith wrote:Sure.
Here is the file (finally have one)
Thank you
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Thu Feb 11, 2016 9:47 am
by lmiltchev
Can you show us the exact command that you are running from the command line along with the output of it? What is the instance name that you are using in the command that is failing? (see below - the name is colored in red)
Example:
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '10.102.33.221:1521/
aprd' --username '<username>' --password '<password>' --mode connection-time --warning 1 --critical 5
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Thu Feb 11, 2016 1:38 pm
by dlukinski
lmiltchev wrote:Can you show us the exact command that you are running from the command line along with the output of it? What is the instance name that you are using in the command that is failing? (see below - the name is colored in red)
Example:
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '10.102.33.221:1521/
aprd' --username '<username>' --password '<password>' --mode connection-time --warning 1 --critical 5
[root@cakc-nagxitest01 conf.d]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '10.x.x.237:1521/KCTCQA' --username 'nagiosxi' --password 'xxxxxxxx' --mode connection-time --warning 1 --critical 5
CRITICAL - cannot connect to 10.102.36.237:1521/KCTCQA. ORA-12543: TNS:destination host unreachable (DBD ERROR: OCIServerAttach)
Re: ORACLE - (Return code of 127 is out of bounds - plugin m
Posted: Thu Feb 11, 2016 1:53 pm
by hsmith
Code: Select all
cannot connect to 10.102.36.237:1521/KCTCQA. ORA-12543
Can you try to telnet to this host:port?