Linux Error: 29: Illegal seek

    今天不知道是谁碰了机房里面的网线，害的我ping不通那台服务器。后来把网线插上以后，listener起不来了，郁闷，重新netca也不行，奇怪，为什么listener起不来呢？

报错：

Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... 
TNS-12537: TNS:connection closed
 TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed
  Linux Error: 29: Illegal seek

上网查了一下原因：
方法一：
修改 /etc/hosts  加 127.0.0.1 localhost问题解决。
方法二：
To implement the solution, please execute the following steps:
1. Explicitly disable the 10g TNS Listener's subscription to ONS by editing the listener.ora file and add the parameter below:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFF
       where would be replaced with the actual listener name configured in the listener.ora file.
For example, if the listener name is LISTENER (default), the parameter would be:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
       - Save the listener.ora file
2. Start the TNS Listener from a new LSNRCTL prompt:
lsnrctl
LSNRCTL> start

From metalink:

Note:294730.1
Note:315720.1

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

转载于:http://blog.itpub.net/9252210/viewspace-567113/