Starting Listener Gives TNS-12547

早上发现一套Rac的node2的Listener down掉，重新start时候报以下错误

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 11-JAN-2006 08:09:29

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /u01/product/oracle/bin/tnslsnr: please wait...

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe

在Metalink上查找发现Oracle在Linux上Listener的log大小有2G的限制,目前Oracle也没有提供Patch修复此问题。我们采取cronjob定期去purge这个文件(cat /dev/null > listener.log)。

ldp2-node2$ll
total 2099208
-rw-r--r-- 1 oracle dba 0 Jan 11 08:12 listener.log
-rw-r--r-- 1 oracle dba 2147483647 Jan 11 06:18 listener.log.old
-rw-r--r-- 1 oracle dba 608 Oct 8 05:34 sqlnet.log

Cause
~~~~~~~

OS has the limitation of 2GB file system.
Listener.log was going above 2GB

Fix
~~~~

rename the listener.log to listener.old and restart the listener

References
~~~~~~~~~~~

Metalink:Note:237737.1-Starting Listener Gives TNS-12547

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/87949/viewspace-813126/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/87949/viewspace-813126/