Home » RDBMS Server » Networking and Gateways » ORA-12537: TNS:connection closed
ORA-12537: TNS:connection closed [message #6495] Mon, 21 April 2003 14:02 Go to next message
Naren
Messages: 8
Registered: October 2001
Junior Member
Hi,

Last week I upgraded an old 8.1.6 db to 8.1.7 on Windows NT. I created a new instance on the upgraded db. I can connect to the instance, the users that I created on it, access tables etc. using sql*plus on that machine but when I try to connect it from any other machine, I get the error "ORA-12537: TNS:connection closed". Also, if I use Oracle db studio on the same NT machine, I get the same error message.

Any help and guidance is appreciated.

Thanks
Naren
Re: ORA-12537: TNS:connection closed [message #6497 is a reply to message #6495] Mon, 21 April 2003 15:20 Go to previous messageGo to next message
Anand
Messages: 161
Registered: August 1999
Senior Member
Possible Solution:

1. Delete TNS_ADMIN:PROTOCOL.ORA. If you use TNS_ADMIN:PROTOCOL.ORA, review it for problems. If you do NOT use this file, delete it.

2. Stop and start the listener.

GL
Re: ORA-12537: TNS:connection closed [message #6538 is a reply to message #6495] Wed, 23 April 2003 18:57 Go to previous message
liuxnp
Messages: 3
Registered: April 2003
Junior Member
Did u use SERVERMA,E to connect to any other mechine?
Then u use SID to connect to other mechine!
Previous Topic: Net8 Client on Linux
Next Topic: Access oracle via dial up
Goto Forum:
  


Current Time: Fri Apr 26 07:41:11 CDT 2024