Home » RDBMS Server » Networking and Gateways » TNS:Address already in use Urgent please help!!!
TNS:Address already in use Urgent please help!!! [message #189061] Wed, 23 August 2006 01:35 Go to next message
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
Re: TNS:Address already in use Urgent please help!!! [message #189175 is a reply to message #189061] Wed, 23 August 2006 08:52 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: TNS:Address already in use Urgent please help!!! [message #189365 is a reply to message #189175] Thu, 24 August 2006 04:56 Go to previous messageGo to next message
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.


Re: TNS:Address already in use Urgent please help!!! [message #357914 is a reply to message #189365] Fri, 07 November 2008 03:40 Go to previous message
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!!
Previous Topic: HS ODBC connection to UNIData SQL translation
Next Topic: ora-12571: tns packet writer failure.
Goto Forum:
  


Current Time: Wed Dec 07 06:44:37 CST 2016

Total time taken to generate the page: 0.09972 seconds