Page 3 of 3
Re: check_oracle_health not working for Linux env
Posted: Wed Jul 01, 2020 7:26 am
by Amit_Alone
Thanks for correcting me. I re-run the whole command and observed the time out error. Please find attachment containing the o/p of the cmd.
Re: check_oracle_health not working for Linux env
Posted: Wed Jul 01, 2020 2:18 pm
by tgriep
The timeout error means that the Nagios server cannot connect at all to the Oracle server using the port you specified in the command.
Let's check to see if it is open by running a nmap command.
If needed, install nmap on the nagios server by running the following as root.
Then run this as root to see if port 1525 is OPEN.
You should see something silular to this.
PORT STATE SERVICE
1525/tcp open 1525
If the state says OPEN, then the port is available.
But, you will have to login to the Oracle server to see why it is not responding to the check.
If it says Closed or Filtered, then the Oracle Server is not listening on that port or that there is a firewall blocking the connection.
Re: check_oracle_health not working for Linux env
Posted: Wed Jul 01, 2020 10:51 pm
by Amit_Alone
I run the shared command and I can see connectivity is open.
Code: Select all
[root@avgdlnxvp126 ~]# nmap 10.183.XX.XXX -p 1525
Starting Nmap 6.47 ( http://nmap.org ) at 2020-07-02 03:16 UTC
Nmap scan report for 10.183.XX.XXX
Host is up (0.00038s latency).
PORT STATE SERVICE
1525/tcp open orasrv
Nmap done: 1 IP address (1 host up) scanned in 0.06 seconds
[root@avgdlnxvp126 ~]#
However, do have any troubleshoot document or points to check why Oracle is not responding.
Re: check_oracle_health not working for Linux env
Posted: Thu Jul 02, 2020 11:38 am
by ssax
We see it connect and get the version:
Code: Select all
Wed Jul 1 11:38:47 2020: fetchrow_array: SELECT version FROM v$instance
Wed Jul 1 11:38:47 2020: args: $VAR1 = [];
Wed Jul 1 11:38:47 2020: RESULT:
$VAR1 = [
'12.2.0.1.0'
];
You're running 12.1 client against a 12.2 server, I'm not sure that's an issue though.
Does it work if you do this?
Code: Select all
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 /usr/local/nagios/libexec/check_oracle_health --connect '10.183.XX.XXX:1525/PAAXXX' --username 'nagios' --password 'XXXXXXXXXXX' --mode tablespace-usage --warning 90 --critical 98 -t 300 --method sqlplus -v
Re: check_oracle_health not working for Linux env
Posted: Mon Jul 06, 2020 2:47 am
by Amit_Alone
I tried the shared command and still observed the same time out error.
Is it possible to schedule the remote session.
Re: check_oracle_health not working for Linux env
Posted: Mon Jul 06, 2020 5:13 pm
by benjaminsmith
Hello,
Is it possible to schedule the remote session.
Since this issue is still unresolved, please opens a support ticket and reference this thread, so we can provide a remote session if needed. Thanks, Benjamin
To open a support ticket go to:
https://support.nagios.com/tickets/
Re: check_oracle_health not working for Linux env
Posted: Thu Jul 09, 2020 2:54 am
by Amit_Alone
Hi Benjamin,
As suggested, I have open the ticket
https://support.nagios.com/tickets/tickets.php?id=10173.
Please do let me know in case required any other details.
Thanks & Regards,
Amit Alone
Re: check_oracle_health not working for Linux env
Posted: Thu Jul 09, 2020 7:46 am
by scottwilkerson
Help moving to ticket
Locking thread