error in ora log monitoring

[wiproltdwiv]

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!

[slansing]

If you were to log into the oracle server with that exact same username and password and manually run that query, how long does it take?