| 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.
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
