Oracle Agent issues

[raamardhani7]

Hi Team,

We have installed Oracle agent couple of months back, it was working fine and suddenly I am facing the below issue.

[root@lussvpnagiosxi00 ~]# /bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health -t 60 --connect '172.30.248.10:1521/JDAEPPRD' --username 'nagios' --password 'nagios' --mode tablespace-free --warning 5: --critical 2:
CRITICAL - connection could not be established within 60 seconds

[root@lussvpnagiosxi00 ~]# /bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '172.30.248.10:1521/JDAEPPRD' --username 'nagios' --password 'nagios' --mode tablespace-free --warning 5: --critical 2: --timeout 300
CRITICAL - cannot connect to 172.30.248.10:1521/JDAEPPRD. ORA-12170: TNS:Connect timeout occurred (DBD ERROR: OCIServerAttach)

[bwallace]

I was about to suggest increasing the timeout, but I see you jacked it all the way up to 300 in the second example. Since it is still timing out at 5 minutes!, I'm inclined to say the problem lies with the network, a firewall, security settings on the Oracle server, etc, as discussed in this Oracle thread https://community.oracle.com/thread/1077772?tstart=0

[raamardhani7]

I was about to suggest increasing the timeout, but I see you jacked it all the way up to 300 in the second example. Since it is still timing out at 5 minutes!, I'm inclined to say the problem lies with the network, a firewall, security settings on the Oracle server, etc, as discussed in this Oracle thread https://community.oracle.com/thread/1077772?tstart=0

Thanks a lot for your help. sorry for the delay in responses. Issue is with the permissions with check_oracle_health.pl script. Sorted it now. URL mentioned in this helped me to get other required parameters.

[mcapra]

Is it ok if we lock this thread and mark the issue as resolved?

[raamardhani7]

Is it ok if we lock this thread and mark the issue as resolved?

Yes please close this. thanks.