Page 1 of 1

Oracle Agent issues

Posted: Fri Apr 29, 2016 3:14 am
by 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)

Re: Oracle Agent issues

Posted: Fri Apr 29, 2016 9:54 am
by 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

Re: Oracle Agent issues

Posted: Thu Jun 23, 2016 10:41 am
by raamardhani7
bwallace wrote: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.

Re: Oracle Agent issues

Posted: Thu Jun 23, 2016 10:44 am
by mcapra
Is it ok if we lock this thread and mark the issue as resolved?

Re: Oracle Agent issues

Posted: Wed Jun 29, 2016 12:59 am
by raamardhani7
mcapra wrote:Is it ok if we lock this thread and mark the issue as resolved?
Yes please close this. thanks.