Home » RDBMS Server » Networking and Gateways » Listener (Oracle 10 G Linux Redhat 5)
Listener [message #605211] Wed, 08 January 2014 01:54 Go to next message
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
Re: Listener [message #605217 is a reply to message #605211] Wed, 08 January 2014 02:33 Go to previous messageGo to next message
John Watson
Messages: 8922
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
Re: Listener [message #605224 is a reply to message #605217] Wed, 08 January 2014 03:19 Go to previous messageGo to next message
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))
)
)
Re: Listener [message #605232 is a reply to message #605217] Wed, 08 January 2014 04:02 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Listener [message #605241 is a reply to message #605224] Wed, 08 January 2014 04:23 Go to previous messageGo to next message
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
]
Re: Listener [message #605257 is a reply to message #605211] Wed, 08 January 2014 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Listener [message #605260 is a reply to message #605241] Wed, 08 January 2014 05:07 Go to previous message
John Watson
Messages: 8922
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.
Previous Topic: DB LINK USING INTERNET
Next Topic: ORA-28500 : While selecting SQL Server data in Oracle [HSODBC]
Goto Forum:
  


Current Time: Thu Mar 28 18:39:34 CDT 2024