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:
(ADDRESS = (PROTOCOL = TCP)(HOST = tobago)(PORT = 1521))
(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
Best of luck!!