分类: Oracle
2011-05-25 17:54:57
报错:
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问题解决。
127.0.0.1 db.e-trade.com db localhost
注:db.e-trade.com 与localhost并列的关系
方法二:
在listner.ora文件上添加如下语句:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_
To implement the solution, please execute the following steps:
1. Explicitly disable the TNS Listener's subscription to ONS by editing the listener.ora file and add the parameter below:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_
where
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