OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Listener (Oracle 10 G Linux Redhat 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Listener [message #605211]

Wed, 08 January 2014 01:54

aliawan41
Messages: 10
Registered: December 2013
Location: lahore

Junior Member

Hi ALL
I have an issue while starting listener. i have reconfigured listener by deleting and recreating. but the issue remains the same.

Errors are mentioned below

Starting /u01/app/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

Report message to a moderator

Re: Listener [message #605217 is a reply to message #605211]

Wed, 08 January 2014 02:33

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Please post your listener.ora file. Do not forget to format the post with [code] tags, How to use [code] tags and make your code easier to read

Report message to a moderator

Re: Listener [message #605224 is a reply to message #605217]

Wed, 08 January 2014 03:19

aliawan41
Messages: 10
Registered: December 2013
Location: lahore

Junior Member

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ***.**.*.105)(PORT = 1521))
)
)

Report message to a moderator

Re: Listener [message #605232 is a reply to message #605217]

Wed, 08 January 2014 04:02

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

You have ignored my request to use [code] tags.
You have also obfuscated what could be important information: the IP address. Please post the complete lisstener.ora file and also the sqlnet.ora file and also the /etc/hosts file.

Report message to a moderator

Re: Listener [message #605241 is a reply to message #605224]

Wed, 08 January 2014 04:23

aliawan41
Messages: 10
Registered: December 2013
Location: lahore

Junior Member

well
listener .ora file is like this
[
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Awan01.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

]

sqlnet.ora is like this
[
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tcp.validnode_checking=no
]

etc/hosts
[
127.0.0.1 Awan01.localdomain Awan01
::1 Awan01 Awan01.localdomain Awan01
]

Report message to a moderator

Re: Listener [message #605257 is a reply to message #605211]

Wed, 08 January 2014 04:57

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You first have to search for "Linux Error: 29: Illegal seek " on the web.
The OS raises this error, why?
This is the first step to investigate.
Until you know the reason of the error you cannot do anything from Oracle.
Oracle here is the victim NOT the culprit.

Report message to a moderator

Re: Listener [message #605260 is a reply to message #605241]

Wed, 08 January 2014 05:07

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Could be your OS config. I would adjust the hosts file to this

127.0.0.1 localhost.localdomain localhost Awan01.localdomain Awan01

The other suggestion I have is to use [code] tags when you post, as I have.

Report message to a moderator

Previous Topic:	DB LINK USING INTERNET
Next Topic:	ORA-28500 : While selecting SQL Server data in Oracle [HSODBC]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 18 21:35:29 CST 2025