ORACLE - (Return code of 127 is out of bounds - plugin may b

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post 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)
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post by lmiltchev »

Can you show us the "tnsnames.ora" file?

Similar issue is described here:

http://www.perlmonks.org/?node_id=809180
Be sure to check out our Knowledgebase for helpful articles and solutions!
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post by dlukinski »

lmiltchev wrote:Can you show us the "tnsnames.ora" file?

Similar issue is described here:

http://www.perlmonks.org/?node_id=809180
No such file in XI / get one from Oracle DB server?
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post by lmiltchev »

No such file in XI / get one from Oracle DB server?
Yes, it is located on the Oracle DB server.
Be sure to check out our Knowledgebase for helpful articles and solutions!
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post 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
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post by hsmith »

Sure.
Former Nagios Employee.
me.
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post by dlukinski »

hsmith wrote:Sure.
Here is the file (finally have one)

Thank you
You do not have the required permissions to view the files attached to this post.
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post 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
Be sure to check out our Knowledgebase for helpful articles and solutions!
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post 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)
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: ORACLE - (Return code of 127 is out of bounds - plugin m

Post 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?
Former Nagios Employee.
me.
Locked