error in ora log monitoring
Posted: Thu Aug 21, 2014 1:22 am
Dear Team,
I have to monitor oracle any ora-xxx logs, for this i am trying to use check_ora_db, but i am getting timeout error. same plugin in working fine when i check listener status, but for rest services its giving time out error. please check below. same user and password we are using for check_oracle_health and which r working fine.
[root@localhost libexec]# ./check_ora_db --action=lsnrstatus --service=xyz --oh=$ORACLE_HOME --lsnrports=xx.xx.xx.xx:1543
[OK] Listener status (Host:Port xx.xx.xx.xx:1543 - OK)
[root@localhost libexec]# ./check_ora_db --action=dbstatus --service=xyz --oh=$ORACLE_HOME --dbuser=user1--dbpass=user1--port=1543 --host=xx.xx.xx.xx --timeout=120
[CRITICAL] Time out (120 seconds) while executing SQL statement!
I have to monitor oracle any ora-xxx logs, for this i am trying to use check_ora_db, but i am getting timeout error. same plugin in working fine when i check listener status, but for rest services its giving time out error. please check below. same user and password we are using for check_oracle_health and which r working fine.
[root@localhost libexec]# ./check_ora_db --action=lsnrstatus --service=xyz --oh=$ORACLE_HOME --lsnrports=xx.xx.xx.xx:1543
[OK] Listener status (Host:Port xx.xx.xx.xx:1543 - OK)
[root@localhost libexec]# ./check_ora_db --action=dbstatus --service=xyz --oh=$ORACLE_HOME --dbuser=user1--dbpass=user1--port=1543 --host=xx.xx.xx.xx --timeout=120
[CRITICAL] Time out (120 seconds) while executing SQL statement!