Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Monitoring Listener status

595977Jun 13 2008 — edited Jun 13 2008
Hi

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?.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2008
Added on Jun 13 2008
6 comments
932 views