Remote 12.2 Version Oracle Client - ORA-12637, TNS-12547 During Authentication (Doc ID 2345355.1)

Last updated on SEPTEMBER 08, 2023

Applies to:

Symptoms

Attempting to connect to the database from a 12.2 Oracle client fails.

The following error stack is posted to the alert log at the time of the failure: 

***********************************************************************

Fatal NI connect error 12637, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for Linux: Version 12.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0 - Production
Time: 19-DEC-2017 14:23:17
Tracing not turned on.
Tns error struct:
ns main err code: 12637

TNS-12637: Packet receive failed
ns secondary err code: 12532
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
2017-12-19T14:23:17.205162+08:00
opiodr aborting process unknown ospid (18596) as a result of ORA-609

A level 16 Oracle Net trace shows the failure is occurring during the authentication process and occurs at exactly 1 minute.

The client sends an NTS authentication request here.  Note the timestamp:   16:35:15

(4172) [15-12¤ë-2017 16:35:15:934] nspsend: 00 00 04 00 05 0C 20 01 |........|
(4172) [15-12¤ë-2017 16:35:15:934] nspsend: 00 00 02 00 03 E0 E1 00 |........|
(4172) [15-12¤ë-2017 16:35:15:934] nspsend: 02 00 06 FC FF 00 01 00 |........|
(4172) [15-12¤ë-2017 16:35:15:934] nspsend: 02 01 00 03 00 00 4E 54 |......NT|
(4172) [15-12¤ë-2017 16:35:15:934] nspsend: 53 00 02 00 03 00 00 00 |S.......|

During the read from the server and exactly 1 minute later, the connection faults

4172) [15-12¤ë-2017 16:35:15:934] nsrdr: recving a packet
(4172) [15-12¤ë-2017 16:35:15:934] nsprecv: entry
(4172) [15-12¤ë-2017 16:35:15:934] nsprecv: reading from transport...
(4172) [15-12¤ë-2017 16:35:15:934] nttrd: entry|

60 seconds of delay here and the connection faults:

(4172) [15-12¤ë-2017 16:36:15:938] ntt2err: entry
(4172) [15-12¤ë-2017 16:36:15:938] ntt2err: soc 440 error - operation=5, ntresnt[0]=517, ntresnt[1]=54, ntresnt[2]=0
(4172) [15-12¤ë-2017 16:36:15:938] ntt2err: exit
(4172) [15-12¤ë-2017 16:36:15:938] nttrd: exit
(4172) [15-12¤ë-2017 16:36:15:939] nsprecv: error exit
(4172) [15-12¤ë-2017 16:36:15:939] nserror: entry
(4172) [15-12¤ë-2017 16:36:15:939] nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0

...

(4172) [15-12る-2017 16:36:15:939] nserror: nsres: id=0, op=68, ns=12547, ns2=12532; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(4172) [15-12る-2017 16:36:15:939] nacomrc: received 12637 bytes
(4172) [15-12る-2017 16:36:15:939] nacomrc: failed with error 12637
(4172) [15-12る-2017 16:36:15:939] nacomrc: exit
(4172) [15-12る-2017 16:36:15:939] na_receive_packet: failed with error 12637
(4172) [15-12る-2017 16:36:15:939] na_receive_packet: exit
(4172) [15-12る-2017 16:36:15:939] na_client: failed with error 12637

The client and server are in different network segment. Issue does not happen when

++Connect from 11.2 client

or

++ 12c Server and 12c client are in same network segment

Changes

This is a recent upgrade to 12c database.

Cause

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