是:Listener不能启动-TNS;12537,TNS-12560, TNS-00507
提示oracle不能启动。检查listener状态,执行listener start,提示:
----------------------
The listener fails to start with the following errors:
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
解决方法:
第一步:编辑tnsname.ora,listen.ora修改其中的IP地址。
第二步:/etc/hosts文件中缺少了127.0.0.1 localhost的信息,加上以后,关闭oracle,再重新启动就可以了。
127.0.0.1 localhost.localdomain localhost
ORACLE的FAQ:
The information in this document applies to:
Oracle Net Services - Version: 10.1.0.3
This problem can occur on any platform.
Symptoms
The listener fails to start with the following errors:
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
Generic to Unix platforms.
Cause
Wrong syntax in hosts file and also due to the the tnslsnr process was enhanced in
10.1.0.3 to support FAN(Fast Application Notification) via
ONS (Oracle Notification Services). This new code opens a socket open on localhost. Therefore
"localhost" should be defined on the system.
This new code opens a socket open on localhost. Therefore "localhost" should be defined on the
system.
Fix
Change /etc/hosts file to include
127.0.0.1 localhost.localdomain localhost