OraFAQ Forum: Networking and Gateways » TNS:Address already in use Urgent please help!!!

Home » RDBMS Server » Networking and Gateways » TNS:Address already in use Urgent please help!!!

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

TNS:Address already in use Urgent please help!!! [message #189061]

Wed, 23 August 2006 01:35

VedPrakash
Messages: 4
Registered: July 2006
Location: India

Junior Member

Hello,
I am getting the following error when i try to connect
./lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 23-AUG-2006 11:53:07

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /opt/oracle/product/9iR2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /opt/oracle/product/9iR2/network/admin/listener.ora
Log messages written to /opt/oracle/product/9iR2/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

Listener failed to start. See the error message(s) above...

Please Somebody help.
Thanks,
Ved

Report message to a moderator

Re: TNS:Address already in use Urgent please help!!! [message #189175 is a reply to message #189061]

Wed, 23 August 2006 08:52

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Try to stop/kill the listener before you restart it.

If that doesn't help, assign a different port number or kill the process that is using your listener's port.

Report message to a moderator

Re: TNS:Address already in use Urgent please help!!! [message #189365 is a reply to message #189175]

Thu, 24 August 2006 04:56

VedPrakash
Messages: 4
Registered: July 2006
Location: India

Junior Member

Thanks Frank, Its worked for me.
I have followed the following process:
1. Stop the listner
2. Reconfigure the Listner for the same port.
3. Restared the server.

Report message to a moderator

Re: TNS:Address already in use Urgent please help!!! [message #357914 is a reply to message #189365]

Fri, 07 November 2008 03:40

oracle_me
Messages: 59
Registered: March 2008

Member

Hi ,
How come changing port number will be a solution to this.
I am a learner DBA, so please explain ....

does Address already in use means port already in use?
thank you experts!!

Report message to a moderator

Previous Topic:	HS ODBC connection to UNIData SQL translation
Next Topic:	ora-12571: tns packet writer failure.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 16:07:36 CST 2024