Search found 6 matches

by ghostzy
Fri Apr 29, 2016 3:15 am
Forum: Nagios XI
Topic: error"TNS:listener was not given the SERVICE_NAME"
Replies: 5
Views: 12017

Re: error"TNS:listener was not given the SERVICE_NAME"

Hi Tgriep, i've replaced on pourpose the name, it's ORCL, here is the input and output: sqlplus "USER/PASSWORD@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=SERVERIP)(Port=1521))(CONNECT_DATA=(SID=ORCL)))" SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 29 10:56:52 2016 Copyright (c) 1982, ...
by ghostzy
Thu Apr 28, 2016 4:03 am
Forum: Nagios XI
Topic: error"TNS:listener was not given the SERVICE_NAME"
Replies: 5
Views: 12017

Re: error"TNS:listener was not given the SERVICE_NAME"

Hi Guys, thank for looking after this and sorry for the other post, i was not sure if they are both monitored. So my checks are like this: this is one of the checks - Oracle Query - Test Query check_xi_oraclequery!--connect 'SERVERIP:1521/ORCL' --username 'USER' --password 'PASSWORD' --mode sql --na...
by ghostzy
Wed Apr 27, 2016 7:41 am
Forum: Nagios XI
Topic: oracle monitoring error
Replies: 18
Views: 7393

Re: oracle monitoring error

Hi Guys, i've read the thread, an unfortunately i'm in the same place as kranthi6, i'm getting : CRITICAL - cannot connect to IP:1521/ORCL. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach) I've read the instructions from lmiltche...
by ghostzy
Wed Apr 27, 2016 7:03 am
Forum: Nagios XI
Topic: Setting up Oracle database Monitoring - facing issue
Replies: 25
Views: 11338

Re: Setting up Oracle database Monitoring - facing issue

IT worked for me by setting the following exports:

Code: Select all

export ORACLE_HOME=/usr/lib/oracle/12.1/client64/lib
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/
export PATH=$PATH:/usr/lib/oracle/12.1/client64/bin
After that i could run the CPAN installation oK.
Cheers.
by ghostzy
Wed Apr 27, 2016 6:58 am
Forum: Nagios XI
Topic: error"TNS:listener was not given the SERVICE_NAME"
Replies: 5
Views: 12017

error"TNS:listener was not given the SERVICE_NAME"

Moderator Edit: This thread has been split from another - https://support.nagios.com/forum/viewtopic.php?f=6&t=9482 In the future, please create a new thread and link to the old one instead of adding on. Hi Guys, sorry to write on this old thread but i'm having the same issue: CRITICAL - cannot...
by ghostzy
Thu Apr 14, 2016 10:39 am
Forum: Nagios XI
Topic: Setting up Oracle database Monitoring - facing issue
Replies: 25
Views: 11338

Re: Setting up Oracle database Monitoring - facing issue

Hi Guys, i've just installed today the plugin for oracle and i'm getting the same error: CRITICAL - cannot connect to <IP>:1521/ORCL. install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/nagios/libexec /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/p...