check_oracle_health not working for Linux env

[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.

[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.

Code: Select all

yum install nmap -y

Then run this as root to see if port 1525 is OPEN.

Code: Select all

nmap 10.183.XX.XXX -p 1525

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.

[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.

[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

[Amit_Alone]

I tried the shared command and still observed the same time out error.

Is it possible to schedule the remote session.

[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/

[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

[scottwilkerson]

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

Help moving to ticket

Locking thread