Trace file created
KEN CHAN, February 23, 2021 - 10:47 pm UTC
Hi, Thanks for your comment. It is very useful. I did the trace, the log file containing lots of information. But I do notice there are two periods nothing report in the trace file (1 min and 10 seconds). Please see below
-- 1 min
(11028) [24-FEB-2021 09:34:30:732] nau_fad: searching for "NTS" adapter
(11028) [24-FEB-2021 09:34:30:732] nau_fad: supported adapter: "KERBEROS5"
(11028) [24-FEB-2021 09:34:30:732] nau_fad: supported adapter: "NTS"
(11028) [24-FEB-2021 09:34:30:732] nau_fad: exit
(11028) [24-FEB-2021 09:34:30:732] naunts: entry
(11028) [24-FEB-2021 09:34:30:732] naunts5: entry
(11028) [24-FEB-2021 09:34:30:732] naunts5: no_ntlm is 0
(11028) [24-FEB-2021 09:35:36:027] naunts5: Using old logic to determine package.
(11028) [24-FEB-2021 09:35:36:027] naunts5: exit
(11028) [24-FEB-2021 09:35:36:027] naunts: exit
(11028) [24-FEB-2021 09:35:36:027] nauninit: entry
(11028) [24-FEB-2021 09:35:36:027] naun5init: entry
(11028) [24-FEB-2021 09:35:36:027] naun5init: Connection type is: 0
(11028) [24-FEB-2021 09:35:36:027] naun5init: exit
(11028) [24-FEB-2021 09:35:36:027] nauninit: exit
-- 10 seconds
(11028) [24-FEB-2021 09:35:36:073] nsbrfr: normal exit
(11028) [24-FEB-2021 09:35:36:073] nsbrfr: entry
(11028) [24-FEB-2021 09:35:36:073] nsbrfr: nsbfs at 0x2cea4f8, data at 0x688d540.
(11028) [24-FEB-2021 09:35:36:073] nsbrfr: normal exit
(11028) [24-FEB-2021 09:35:36:073] nsbfrfl: normal exit
(11028) [24-FEB-2021 09:35:36:073] nigtrm: Count in the NL global area is now 1
(11028) [24-FEB-2021 09:35:47:607] nigini: entry
(11028) [24-FEB-2021 09:35:47:607] nigini: Count in the NL global area is now 2
(11028) [24-FEB-2021 09:35:47:607] nigini: Count in NI gbl area now: 2
(11028) [24-FEB-2021 09:35:47:607] nigini: exit
Can you see any problem.
February 25, 2021 - 5:45 am UTC
Seeing as it looks related to NTS, perhaps try
SQLNET.AUTHENTICATION_SERVICES= (NONE)
in sqlnet.ora
authentication methods
KEN CHAN, February 25, 2021 - 6:22 am UTC
Thanks. It does work. Is it mean there is something wrong with Windows NT native authentication?
February 26, 2021 - 3:49 am UTC
It means something is going wrong between Oracle and OS
(I use NTS here on my local machine and its instant)
I think you'd need to speak to Support to get full network layer expertise on that