My Oracle Support Banner

Tnsping Utility Fails: ORA-12547, TNS-12537 - TCP.VALIDNODE_CHECKING is Enabled (Doc ID 2252994.1)

Last updated on MARCH 31, 2022

Applies to:

Oracle Net Services - Version 10.2.0.5 to 12.2 BETA1 [Release 10.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Remote client connections and tnsping is failing to reach the listener.  The listener is running and is working when tnsping and SQL*Plus are launched
locally or on the same server.

The tnsping trace shows this stack:

 SQL*Plus remote connection might fail with:

TNS-12537 TNS: Connection closed
ORA-12547 TNS: Lost Contact

Changes

 This is likely a new installation OR a new implementation of TCP.VALIDNODE_CHECKING.

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


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