My Oracle Support Banner

12.1.0.1 client kerberos connections failing after db upgrade to 18c (Doc ID 2782039.1)

Last updated on AUGUST 17, 2021

Applies to:

Advanced Networking Option - Version 18.12.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading the database to 18c(18.12.0.0.201020 (31730250)) kerberos connections with sqlplus client 12.1.0.1.0 to the database that previously worked ok are now failing with error ORA-28547.

 

 


Database alert log shows error ORA-609

Database sqlnet.log shows :-
Fatal NI connect error 12631, connecting to:
(DESCRIPTION=(LOCAL=NO)(SDU=32768))
VERSION INFORMATION:
TNS for Linux: Version 18.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 18.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 18.0.0.0.0 - Production
Version 18.12.0.0.0
Time: 19-MAY-2021 17:00:52
Tracing not turned on.
Tns error struct:
ns main err code: 12631
TNS-12631: Username retrieval failed


Client trace shows :-
(9172) [17-MAY-2021 16:31:30:309] nsprecv: reading from transport...
(9172) [17-MAY-2021 16:31:30:309] nttrd: entry
(9172) [17-MAY-2021 16:31:30:309] ntt2err: entry
(9172) [17-MAY-2021 16:31:30:309] ntt2err: soc 764 error - operation=5, ntresnt[0]=530, ntresnt[1]=53, ntresnt[2]=0
(9172) [17-MAY-2021 16:31:30:309] ntt2err: exit
(9172) [17-MAY-2021 16:31:30:309] nttrd: exit
(9172) [17-MAY-2021 16:31:30:309] nsprecv: error exit
(9172) [17-MAY-2021 16:31:30:309] nserror: entry
(9172) [17-MAY-2021 16:31:30:309] nserror: nsres: id=0, op=68, ns=12570, ns2=12560; nt[0]=530, nt[1]=53, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0

Changes

 Database upgrade

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.