troubleshooting Question

Can TNSPing, but not connect to Oracle 8.1.7 database

Avatar of JeroenH
JeroenH asked on
Databases
4 Comments1 Solution1081 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
PAQ_Man

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros