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

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

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

TNS-12542 TNS:Address already in use Urgent please help!!! [message #66519]

Mon, 15 July 2002 10:33

emme
Messages: 13
Registered: July 2002

Junior Member

Hello,
I am getting the following error when i try to connect LSNRCTL>START
Attempted to listen on:(description=(connect_timeout=10)(address=(protocol=tcp)(host=my_host)(port=1526)))
TNS-12542:TNS:Address already in use
TNS-12560:TNS:protocol adopter error
TNS-00512:TNS:Address already in use
32 bit windows error:48:Unknown system error.

Please Somebody help.

Report message to a moderator

Re: TNS-12542 TNS:Address already in use Urgent please help!!! [message #66520 is a reply to message #66519]

Mon, 15 July 2002 10:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Try the following:
On your Windows NT machine, create a registry value under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE called
USE_SHARED_SOCKET and set it equal to TRUE.

Ensure that you have the latest service pack 6 installed.

Report message to a moderator

Re: TNS-12542 TNS:Address already in use Urgent please help!!! [message #66640 is a reply to message #66519]

Thu, 26 September 2002 06:54

mazhar
Messages: 4
Registered: September 2002

Junior Member

hi

i am really in troublbe please solve it. my problrm is when i am trying to connect the data base with my home machine it is giving me erroe massage
protocol adopter error
thanks

Report message to a moderator

Re: TNS-12542 TNS:Address already in use Urgent please help!!! [message #66962 is a reply to message #66640]

Fri, 25 April 2003 13:41

Rob Green
Messages: 1
Registered: April 2003

Junior Member

This *may* help. First run netstat to see if there are 100's of TIME_WAIT sockets. If so, this is what I did.

Add a Windows 2000 registry entry (see links at the end of the email):
In HKEY_LOCAL_MACHINESystemCurrectControlSetServicesTcpipParameters
Add the key: TcpTimedWaitDelay REG_DWORD 0x0000003c (60)

The cause of the TNS-12542, "Address Already In Use", means just that, that all connections are in use. The reason they are all in use (in the issue on my system) was due to the behavior of tcp/ip connections.

In the lifecycle of a socket, you get in TIME_WAIT as the sequence when you close the connection. It is put in that state to allow missing packets to come in and get discarded. I reduced the time from 4 minutes to 1 minute (240 to 60 in the registry since it is units of seconds). By reducing it to 1 minute the sockets from previous SQLPlus executions becomes available sooner and thus connections are available.

Here are 2 links, the first even says you can only get 200 connection per second.
http://www.winguides.com/registry/display.php/878/
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/isa/proddocs/isadocs/CMT_RegKey.asp

Report message to a moderator

Re: TNS-12542 TNS:Address already in use Urgent please help! [message #67347 is a reply to message #66962]

Thu, 27 May 2004 00:55

DANISH
Messages: 5
Registered: March 2002

Junior Member

TNS-12542 TNS:Address already in use Urgent please help!!!

Report message to a moderator

Previous Topic:	ora_sid_autostart
Next Topic:	9i DB and Oracle7 client - will it work?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 14:21:13 CDT 2025