Monitoring Listener status
595977Jun 13 2008 — edited Jun 13 2008Hi
Some few weeks back,the listeners were not running in one of the test server. I understand "lsnrctl status" command can be used to check the status.
Apart from this,is there anyway to look for some error/exception codes in Logs path "/dboracle/product/10.2.0.2/network/log" so that the error text can be configured in monitoring utility?.I could observe some error codes like
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
in the <listener>.lod.old.<Date> file under the path /dboracle/product/10.2.0.2/network/log. Whether this was reflected when the listener goes down?.
Basically I want to raise a trap alert mail when listeners goes down. Are there any shell/perl scripts available for this?.