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

Last updated on JULY 20, 2024

Applies to:

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

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