Link to home
Start Free TrialLog in
Avatar of sventhan
sventhanFlag for United States of America

asked on

ORA-12537: TNS: Connection closed

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
SOLUTION
Avatar of Peter Chan
Peter Chan
Flag of Hong Kong image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sventhan

ASKER

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.
thanks.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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...