Re: Slow connections with 12.2 client

I have found this trace tool to work quite well:

http://www.howzatt.demon.co.uk/NtTrace/

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill

On Tue, May 29, 2018 at 9:25 AM, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:

> Not a windows guy at all, but have you tried tracing it?
> https://stackoverflow.com/questions/3847745/systrace-for-windows
>
> Might show you the syscall it's hanging on which would confirm if it's
> indeed some sort of lookup that hangs.
>
> Stefan
>
>
>
> On Tue, May 29, 2018 at 9:11 PM, Niall Litchfield <
> niall.litchfield_at_gmail.com> wrote:
>
>> Hi
>>
>> Has anybody else observed initial connectivity with the 12.2
>> windows client to be significantly slower than in 12.1 (or 11.2). My setup
>> has ldap and TNS_ADMIN involved.
>>
>> 12.1
>> ORACLE_HOME: C:\APP\ORACLE\INSTANTCLIENT_12_1
>> TNS_ADMIN: C:\APP\TNS
>>
>> 12.2
>> ORACLE_HOME: C:\APP\ORACLE\INSTANTCLIENT_12_2
>> TNS_ADMIN: C:\APP\TNS
>>
>> Extract from an admin level sqlnet trace in 12.1
>>
>> (12180) [29-MAY-2018 14:53:56:171] nnflgetnlpactx: NLPA context
>> successfuly initialized
>> (12180) [29-MAY-2018 14:53:56:172] nnflgetnlpactx: exit
>> (12180) [29-MAY-2018 14:53:56:517] nnfloidinfocache: entry
>> (12180) [29-MAY-2018 14:53:56:517] nnfloidinfocache: Info: Inserted
>> value DIRECTORY_SERVER_TYPE=OID at index 0 into NLPA_CACHE
>>
>> and from 12.2
>>
>> (9712) [29-MAY-2018 14:47:01:777] nnflgetnlpactx: NLPA context
>> successfuly initialized
>> (9712) [29-MAY-2018 14:47:01:777] nnflgetnlpactx: exit
>> (9712) [29-MAY-2018 14:47:38:195] nnfloidinfocache: entry
>> (9712) [29-MAY-2018 14:47:38:195] nnfloidinfocache: Info: Inserted value
>> DIRECTORY_SERVER_TYPE=OID at index 0 into NLPA_CACHE
>>
>> Note the extra 30 secs between exit from the nnflgetnlpactx function and
>> entry to the OID related function nnfloidinfocache
>>
>> I have a ticket with Oracle Support but wondered if anyone else has seen
>> this.
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>>
>
>
>
> --
> //
> zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
> Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/
>

--
http://www.freelists.org/webpage/oracle-l