asked on
Can TNSPing, but not connect to Oracle 8.1.7 database
Hi experts,
We have a serious problem on one of our production database servers. When we try to connect to the databases running on that server, we get the following error: ORA-12537: TNS:connection closed
When we do a tnsping to a database (i.e. tnsping pop) it comes back OK, but when we connect using sqlplus we get the error above. This also happens on the server !?!
The server is running Windows 2000.
This is the TNSNAMES section for one of the databases:
POPT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tobago)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = POPT)
)
)
When we examine the log-files the connection is established on port 1521 and than continues on another, apparently random, port before it is disconnected. We've had the same problem on two other servers with a firewall in between, but this server is on the same network as all the clients. We have created the registry value USE_SHARED_SOCKET and set it to TRUE, but to no avail.
I hope anyone can help
We have a serious problem on one of our production database servers. When we try to connect to the databases running on that server, we get the following error: ORA-12537: TNS:connection closed
When we do a tnsping to a database (i.e. tnsping pop) it comes back OK, but when we connect using sqlplus we get the error above. This also happens on the server !?!
The server is running Windows 2000.
This is the TNSNAMES section for one of the databases:
POPT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tobago)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = POPT)
)
)
When we examine the log-files the connection is established on port 1521 and than continues on another, apparently random, port before it is disconnected. We've had the same problem on two other servers with a firewall in between, but this server is on the same network as all the clients. We have created the registry value USE_SHARED_SOCKET and set it to TRUE, but to no avail.
I hope anyone can help
Databases
Last Comment
PAQ_Man
Excerpts from Oracle,
oerr tns 12537
12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has
disconnected.
// *Action: None needed; this is an information message.
oerr tns 12537
12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has
disconnected.
// *Action: None needed; this is an information message.
ASKER
Sujit,
thanx for your replies. We've managed to solve the problem by setting the USE_SHARED_SOCKET registry value to FALSE.
I haven't got a clue why this value could disrupt the entire connection process, but I'll find out !!
Thanks again.
Jeroen
thanx for your replies. We've managed to solve the problem by setting the USE_SHARED_SOCKET registry value to FALSE.
I haven't got a clue why this value could disrupt the entire connection process, but I'll find out !!
Thanks again.
Jeroen
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Best of luck!!
Sujit