TNS Linux Error: 29: Illegal seek

[DB_HOME]@:/home/oracle$ lsnrctl start

LSNRCTL for Linux: Version 10.1.0.4.2 – Production on 24-JUN-2010 16:46:42

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

Starting /home/oracle/product/infra/

bin/tnslsnr: please wait…

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

Oracle Net Services – Version: 10.1.0.0 to 10.2.0.2
This problem can occur on any platform.

I tried setting tcp.validnode_checking = no in sqlnet.ora

There was no output for : netstat -an | grep 1521

I checked /etc/hosts file for the entry 127.0.0.1 localhost.localdomain localhost

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 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. Explicitly disable the 10g TNS Listener’s subscrition 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

2. Start the TNS Listener from a new LSNRCTL prompt:

lsnrctl <return>

LSNRCTL> start

References :
Note:315720.1
Note 284602.1

Advertisements

About mpoojari
Oracle Database/Applications Administrator

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: