Home » RDBMS Server » Networking and Gateways » TNS-12542: TNS:address already in use
TNS-12542: TNS:address already in use [message #66977] Wed, 07 May 2003 10:29 Go to next message
drl
Messages: 1
Registered: May 2003
Junior Member
We have users who randomly disconnect off any of our three Oracle 8 databases.

When I simultaneously and continuously TCP/IP ping and TNSping any one of the databases, the TCP pings are 100% clean but anywhere from immediate to within a few minutes the TNSping will result in the following error:

TNS-12542: TNS:address already in use

Has anyone run into this or have any suggestions?
Thanks
Re: TNS-12542: TNS:address already in use [message #66978 is a reply to message #66977] Thu, 08 May 2003 06:22 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what is the OS ?
If windows then
create a registry value under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE
name it USE_SHARED_SOCKET and set it equal to TRUE.
Previous Topic: Dead Connection Detection
Next Topic: listener unresponsive
Goto Forum:
  


Current Time: Sun Nov 24 11:28:43 CST 2024