lsnr报错解决

 

今天做实验，报了个错：
[oracle@oel4 admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2011 09:26:02

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2/db/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
 TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed
   Linux Error: 29: Illegal seek

 

查了一下：

这个时候vi /etc/hosts，查看hosts文件。

 

　　在127.0.0.1对应的主机名后面添加一个“localhost”了！这么做的具体原因不详，欢迎高手来指点！

 

lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2011 09:27:13

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2/db/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2/db/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel4)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel4)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                23-APR-2011 09:27:13
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2/db/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2/db/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel4)(PORT=1521)))
Services Summary...
Service "liu" has 1 instance(s).
  Instance "liu", status UNKNOWN, has 1 handler(s) for this service...
Service "liust" has 1 instance(s).
  Instance "liust", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

 

 

最近又看了以前写的这篇文章，查了一下ID 315720.1

TNS Listener Fails To Start With Errors: TNS-12537...Error: 29: Illegal seek [ID 315720.1]
		修改时间 30-JUN-2010     类型 PROBLEM     状态 PUBLISHED

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

---

Applies to:

Oracle Net Services - Version: 10.1.0.2.0 to 11.1.0.7 - Release: 10.1 to 11.1
Information in this document applies to any platform.

Symptoms

Unable to start an Oracle10g R1 or later Listener on Unix:

For example:

$ lsnrctl start

    LSNRCTL for HPUX: Version 10.1.0.4.0 - Production on 01-JUL-2005 10:16:59
    Copyright (c) 1991, 2004, Oracle.  All rights reserved.
    Starting /db02/product/10.1/bin/tnslsnr: please wait...
    TNS-12537: TNS:connection closed
     TNS-12560: TNS:proto    adapter error
      TNS-00507: Connection closed
       HPUX Error: 29: Illegal seek

On Linux, the error stack may look like this:

    TNS-12547: TNS:lost contact
      TNS-12560: TNS:proto adapter error
        TNS-00517: Lost contact
          Linux IA64 Error: 104: Connection reset by peer

Changes

This is likely a new installation or the /etc/hosts file has been modified. 

Cause

TNS Listener fails while attempting to initiate subscription to ONS node down event.

Level 16 TNS Listener trace shows the last action:

...
[01-JUL-2005 10:16:59:727] nsglonsinit: Initiated subscription for node down event
...

Same symptoms and corrective action found in Unpublished Bug 4227455 OCS_MAIN_SOLARIS_050304 - UNABLE TO START THE SECOND LISTENER of if OS User is unable to read the /etc/hosts file.

Solution

To implement the solution, please execute the following steps:

1)  Verify the user attempting to start the TNS Listener process has read permissions on the /etc/hosts file, and that the /etc/hosts file contains the localhost entry in the following form:


127.0.0.1 localhost.localdomain localhost
12.123.123.12 myhost.us.oracle.com myhost


2) 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_<listener_name>=OFF

       where <listener_name> 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

The subscription to ONS should NOT be disabled in a RAC environment.

3) Start the TNS Listener from a new LSNRCTL prompt:

lsnrctl <return>

LSNRCTL> set current_listener <listener_name>

LSNRCTL>start

References

NOTE:284602.1 - 10g Listener: High CPU Utilization - Listener May Hang

相关内容 产品 Oracle Database Products > Oracle Database > Net Services > Oracle Net Services 关键字 LISTENER.ORA; NOTIFICATION SERVICES; START LISTENER 错误 TNS-12547; TNS-517; TNS-12560; TNS-12537; TNS-507; 64 ERROR