ORA-12537: TNS: Connection closed

sventhan
sventhan used Ask the Experts™
on
Experts -

We're getting intermittent connection issues with the databases.

The error we're getting is "ORA-12537: TNS: Connection closed"

This server is running 13 databases with their own oracle homes.

Where should I start looking to fix this issue?

Thanks,
Stanley
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solutions Only
HuaMin ChenProblem resolver
Commented:
Try to ping the server's IP to see if it is fine.

Check also if the database is up or not.
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
I hate to post blind links but it appears there can be many things that might cause this error.

I would probably open an SR with Oracle Support so they can set up the proper tracing to make sure you find the correct cause.

That said, check out:
http://www.dba-oracle.com/t_ora_12537_tns_error.htm
sventhan

Author

Commented:
Thanks Experts.

We did make some changes on the memory settings that help to resolve this error on few databases. Still working with Oracle support on this.
sventhan

Author

Commented:
thanks.
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
If you didn't get an answer I suggest you delete the question.

That is better than accepting answers that didn't help locate a solution, like ping the servers and make sure the database is up...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial