My Oracle Support Banner

Remote or SQL*Net Connections Fail With TNS-12537 Error (Doc ID 333158.1)

Last updated on JANUARY 13, 2020

Applies to:

Oracle Net Services - Version 8.1.7.4.0 to 12.2.1.3.0 [Release 8.1.7 to 12.2]
Information in this document applies to any platform.
This problem can occur on any platform.
Some or all remote client connections to the database.

Symptoms

Tnsping Net Service Name fails with TNS-12537: TNS:connection closed
SQL*Plus connections via the listener may thrown an error TNS-12537.

Connection to the Database locally using the bequeath protocol or a TNS connect string will likely be successful.

The problem documented here would be occurring consistently, not intermittently, for remote client connections. 

A level 16 listener trace may reveal the following:

Changes

This is likely a new installation and possibly a new Applications installation.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.