Nagios Support Forum

In the "tnsnames.ora" file you have: but in your command you use: The service name needs to match... Try using:

lmiltchev wrote: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

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.

lmiltchev wrote: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 (?)

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. -- if somebody still uses Oracle 8.1.7... Hope this helps.

lmiltchev wrote: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.

I am glad I could help!