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

[lmiltchev]

In the "tnsnames.ora" file you have:

Code: Select all

SERVICE_NAME=KCTCQA.konecranes.com

but in your command you use:

Code: Select all

--connect '10.x.x.237:1521/KCTCQA'

The service name needs to match... Try using:

Code: Select all

--connect '10.x.x.237:1521/KCTCQA.konecranes.com'

[dlukinski]

In the "tnsnames.ora" file you have:

Code: Select all

SERVICE_NAME=KCTCQA.konecranes.com

but in your command you use:

Code: Select all

--connect '10.x.x.237:1521/KCTCQA'

The service name needs to match... Try using:

Code: Select all

--connect '10.x.x.237:1521/KCTCQA.konecranes.com'

Same host unreachable (thank you for the finding) :-\

Asking Oracle Admin to re-confirm credentials and access

[lmiltchev]

Hm-m, have you tried connecting to another Oracle host? Let us know what the Oracle Admin had to say. We will keep the thread open.

[dlukinski]

Hm-m, have you tried connecting to another Oracle host? Let us know what the Oracle Admin had to say. We will keep the thread open.

Re-confirmed some things and was able to read Oracle server connection time: WARNING - 1.24 seconds to connect as nagiosxi

HOWEVER, no other checks are working (please take a look at screenshot attached)
- hope you've seen similar in the past and wonder if this has to do with Oracle permissions (?)

[lmiltchev]

You will need to check with your Oracle admin to make sure that the user has sufficient privileges. I found some examples of how to set up a user with specific privileges, required for collecting the information from the database.

Code: Select all

create user nagios identified by oradbmon;
grant create session to nagios;
grant select any dictionary to nagios;
grant select on V_$SYSSTAT to nagios;
grant select on V_$INSTANCE to nagios;
grant select on V_$LOG to nagios;
grant select on SYS.DBA_DATA_FILES to nagios;
grant select on SYS.DBA_FREE_SPACE to nagios;

-- if somebody still uses Oracle 8.1.7...

Code: Select all

grant select on sys.dba_tablespaces to nagios;
grant select on dba_temp_files to nagios;
grant select on sys.v_$Temp_extent_pool to nagios;
grant select on sys.v_$TEMP_SPACE_HEADER  to nagios;
grant select on sys.v_$session to nagios;

Hope this helps.

[dlukinski]

You will need to check with your Oracle admin to make sure that the user has sufficient privileges. I found some examples of how to set up a user with specific privileges, required for collecting the information from the database.

Code: Select all

create user nagios identified by oradbmon;
grant create session to nagios;
grant select any dictionary to nagios;
grant select on V_$SYSSTAT to nagios;
grant select on V_$INSTANCE to nagios;
grant select on V_$LOG to nagios;
grant select on SYS.DBA_DATA_FILES to nagios;
grant select on SYS.DBA_FREE_SPACE to nagios;

-- if somebody still uses Oracle 8.1.7...

Code: Select all

grant select on sys.dba_tablespaces to nagios;
grant select on dba_temp_files to nagios;
grant select on sys.v_$Temp_extent_pool to nagios;
grant select on sys.v_$TEMP_SPACE_HEADER  to nagios;
grant select on sys.v_$session to nagios;

Hope this helps.

This worked after also:
grant select any dictionary to nagios

works on another Nagios XI I moved configurations to.

Thank you for your help.
Wasn't easy to resolve.

[lmiltchev]

I am glad I could help!