1 Reply Latest reply on Sep 24, 2017 8:13 AM by Vlad Visan-Oracle

    SSL error - ORA-28864: SSL connection closed gracefully

    user12840908

      Hi,

       

      We are trying to enable SSL handshake between client and server.

       

      Server: 12.2.0.1  (OEL)  Client: 12.2.0.1 (Windows 10)

       

      All the configuration done as per Oracle document and https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-and-tls-for-database-connections

       

      But while connecting we face:

       

      C:\>sqlplus scott/tiger@lon_ssl
      
      SQL*Plus: Release 12.2.0.1.0 Production on Sun Sep 24 01:39:13 2017
      
      Copyright (c) 1982, 2016, Oracle.  All rights reserved.
      
      ERROR:
      ORA-28864: SSL connection closed gracefully
      

       

      Can someone please help identify the issue?  Please note we tried and checked all wallet permissions it is fine.ORA-28864: SSL connection closed gracefully

       

      After enabling trace we see the following log:

       

      Trace file E:\app\client\diag\clients\user_osuser\host_312470070_107\trace\ora_14132_16192.trc
      2017-09-24 01:39:13.362 : nlstddt_do_alter_trace:--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
      2017-09-24 01:39:13.385 : nlstddt_do_alter_trace:New trace stream is E:\app\client\diag\clients\user_osuser\host_312470070_107\trace\ora_14132_16192.trc
      2017-09-24 01:39:13.385 : nlstddt_do_alter_trace:New trace level is 16
      2017-09-24 01:39:13.385 : nlstddt_do_alter_trace:--- TRACE CONFIGURATION INFORMATION ENDS ---
      2017-09-24 01:39:13.385 : nlstdtp_trace_pfile:--- PARAMETER SOURCE INFORMATION FOLLOWS ---
      2017-09-24 01:39:13.385 : nlstdts_trace_source:Attempted load of system pfile source E:\app\client\product\12.2.0\client_1\network\admin\sqlnet.ora
      2017-09-24 01:39:13.385 : nlstdts_trace_source:Parameter source loaded successfully
      2017-09-24 01:39:13.385 : nlstdts_trace_source:
      2017-09-24 01:39:13.385 : nlstdts_trace_source:Attempted load of local pfile source C:\WINDOWS\system32\sqlnet.ora
      2017-09-24 01:39:13.385 : nlstdts_trace_source:Parameter source was not loaded
      2017-09-24 01:39:13.385 : nlstdts_trace_source:
      2017-09-24 01:39:13.385 : nlstdtp_trace_pfile: -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
      2017-09-24 01:39:13.385 : nlstdtp_trace_pfile:Successful parameter table load
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable: -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  trace_fileno_client = 2
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  trace_filelen_client = 100
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA)
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  trace_level_client = 16
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = E:\app\oracle\wallet)))
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  log_file_client = cli
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  log_directory_client = E:\app\client\trace1
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  tnsping.trace_level = admin
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  tnsping.trace_directory = c:\trace\trace
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  trace_directory_client = E:\app\client\trace
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS)
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  trace_timestamp_client = on
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  trace_file_client = cli
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  trace_unique_client = on
      2017-09-24 01:39:13.385 : nlstddp_dump_ptable:  SSL_CLIENT_AUTHENTICATION = FALSE
      2017-09-24 01:39:13.385 : nlstdtp_trace_pfile:--- PARAMETER SOURCE INFORMATION ENDS ---
      2017-09-24 01:39:13.385 : nlstddl_do_alter_log:--- LOG CONFIGURATION INFORMATION FOLLOWS ---
      2017-09-24 01:39:13.385 : nlstddl_do_alter_log:Log stream will be "E:\app\client\diag\clients\user_osuser\host_312470070_107\alert\log.xml"
      2017-09-24 01:39:13.385 : nlstddl_do_alter_log:Log stream validation not requested
      2017-09-24 01:39:13.385 : nlstddl_do_alter_log:--- LOG CONFIGURATION INFORMATION ENDS ---
      
      
      2017-09-24 01:39:13.385 : nlstdipi:entry
      2017-09-24 01:39:13.385 : nlstdipi:exit
      2017-09-24 01:39:13.386 : nigini:entry
      2017-09-24 01:39:13.386 : nigini:Count in the NL global area is now 1
      2017-09-24 01:39:13.386 : nigini:Count in NI gbl area now: 1
      2017-09-24 01:39:13.386 : nrigbi:entry
      2017-09-24 01:39:13.386 : nrigbni:entry
      2017-09-24 01:39:13.386 : nrigbni:Unable to get data from navigation file tnsnav.ora
      2017-09-24 01:39:13.386 : nrigbni:exit
      2017-09-24 01:39:13.386 : nrigbi:exit
      2017-09-24 01:39:13.386 : nigini:exit
      2017-09-24 01:39:13.390 : nigsui:entry
      2017-09-24 01:39:13.390 : nigsui:exit (-1)
      2017-09-24 01:39:13.393 : nigini:entry
      2017-09-24 01:39:13.393 : nigini:Count in the NL global area is now 2
      2017-09-24 01:39:13.393 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:39:13.393 : nigini:exit
      2017-09-24 01:39:13.393 : niqname:Using nnfsn2a() to build connect descriptor for (possibly remote) database.
      2017-09-24 01:39:13.393 : nnfgiinit:entry
      2017-09-24 01:39:13.393 : nncpcin_maybe_init:default name server domain is [root]
      2017-09-24 01:39:13.393 : nnfgiinit:Installing read path
      2017-09-24 01:39:13.393 : nnfgsrsp:entry
      2017-09-24 01:39:13.393 : nnfgsrsp:Obtaining path parameter from names.directory_path or native_names.directory_path
      2017-09-24 01:39:13.393 : nnfgsrdp:entry
      2017-09-24 01:39:13.393 : nnfgsrdp:Setting path:
      2017-09-24 01:39:13.393 : nnfgsrdp:checking element TNSNAMES
      2017-09-24 01:39:13.393 : nnfgsrdp:checking element EZCONNECT
      2017-09-24 01:39:13.393 : nnfgsrdp:Path set
      2017-09-24 01:39:13.393 : nnfun2a:entry
      2017-09-24 01:39:13.393 : nlolgobj:entry
      2017-09-24 01:39:13.393 : nnfgrne:entry
      2017-09-24 01:39:13.393 : nnfgrne:Going though read path adapters
      2017-09-24 01:39:13.393 : nnfgrne:Switching to TNSNAMES adapter
      2017-09-24 01:39:13.393 : nnftboot:entry
      2017-09-24 01:39:13.393 : nlpaxini:entry
      2017-09-24 01:39:13.393 : nlpaxini:exit
      2017-09-24 01:39:13.393 : nnftmlf_make_local_addrfile:entry
      2017-09-24 01:39:13.394 : nnftmlf_make_local_addrfile:construction of local names file failed
      2017-09-24 01:39:13.394 : nnftmlf_make_local_addrfile:exit
      2017-09-24 01:39:13.394 : nlpaxini:entry
      2017-09-24 01:39:13.394 : nlpaxini:exit
      2017-09-24 01:39:13.394 : nnftmlf_make_system_addrfile:entry
      2017-09-24 01:39:13.394 : nnftmlf_make_system_addrfile:system names file is E:\app\client\product\12.2.0\client_1\network\admin\tnsnames.ora
      2017-09-24 01:39:13.394 : nnftmlf_make_system_addrfile:exit
      2017-09-24 01:39:13.394 : nnftboot:exit
      2017-09-24 01:39:13.394 : nnftrne:entry
      2017-09-24 01:39:13.394 : nnftrne:Original name: lon_ssl
      2017-09-24 01:39:13.394 : nnfttran:entry
      2017-09-24 01:39:13.395 : nnfttran:exit
      2017-09-24 01:39:13.395 : nnftrne:Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = sample.localdomain)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = lon))) for name lon_ssl
      2017-09-24 01:39:13.395 : nnftrne:exit
      2017-09-24 01:39:13.395 : nnfgrne:exit
      2017-09-24 01:39:13.395 : nlolgserv:entry
      2017-09-24 01:39:13.395 : nnfggav:entry
      2017-09-24 01:39:13.395 : nnftgav:entry
      2017-09-24 01:39:13.395 : nnftgav:exit
      2017-09-24 01:39:13.395 : nnfgfrm:entry
      2017-09-24 01:39:13.395 : nnftfrm:entry
      2017-09-24 01:39:13.395 : nnftfrm:exit
      2017-09-24 01:39:13.395 : nnfgfrm:exit
      2017-09-24 01:39:13.395 : nlolgserv:exit
      2017-09-24 01:39:13.395 : nlolgobj:exit
      2017-09-24 01:39:13.395 : nlolfmem:entry
      2017-09-24 01:39:13.395 : nlolfmem:exit
      2017-09-24 01:39:13.395 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:39:13.395 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:39:13.395 : nigini:entry
      2017-09-24 01:39:13.395 : nigini:Count in the NL global area is now 2
      2017-09-24 01:39:13.395 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:39:13.395 : nigini:exit
      2017-09-24 01:39:13.395 : niqname:Using nnfsn2a() to build connect descriptor for (possibly remote) database.
      2017-09-24 01:39:13.395 : nnfun2a:entry
      2017-09-24 01:39:13.395 : nlolgobj:entry
      2017-09-24 01:39:13.395 : nnfgrne:entry
      2017-09-24 01:39:13.395 : nnfgrne:Going though read path adapters
      2017-09-24 01:39:13.395 : nnfgrne:Switching to TNSNAMES adapter
      2017-09-24 01:39:13.395 : nnftrne:entry
      2017-09-24 01:39:13.395 : nnftrne:Original name: lon_ssl
      2017-09-24 01:39:13.395 : nnfttran:entry
      2017-09-24 01:39:13.395 : nnfttran:exit
      2017-09-24 01:39:13.395 : nnftrne:Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = sample.localdomain)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = lon))) for name lon_ssl
      2017-09-24 01:39:13.395 : nnftrne:exit
      2017-09-24 01:39:13.395 : nnfgrne:exit
      2017-09-24 01:39:13.395 : nlolgserv:entry
      2017-09-24 01:39:13.395 : nnfggav:entry
      2017-09-24 01:39:13.395 : nnftgav:entry
      2017-09-24 01:39:13.395 : nnftgav:exit
      2017-09-24 01:39:13.395 : nnfgfrm:entry
      2017-09-24 01:39:13.396 : nnftfrm:entry
      2017-09-24 01:39:13.396 : nnftfrm:exit
      2017-09-24 01:39:13.396 : nnfgfrm:exit
      2017-09-24 01:39:13.396 : nlolgserv:exit
      2017-09-24 01:39:13.396 : nlolgobj:exit
      2017-09-24 01:39:13.396 : nlolfmem:entry
      2017-09-24 01:39:13.396 : nlolfmem:exit
      2017-09-24 01:39:13.396 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:39:13.396 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:39:13.396 : nigini:entry
      2017-09-24 01:39:13.396 : nigini:Count in the NL global area is now 2
      2017-09-24 01:39:13.396 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:39:13.396 : nigini:exit
      2017-09-24 01:39:13.396 : niqname:Hst is already an NVstring.
      2017-09-24 01:39:13.396 : niqname:Inserting CID.
      2017-09-24 01:39:13.396 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:39:13.396 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:39:13.396 : nigini:entry
      2017-09-24 01:39:13.396 : nigini:Count in the NL global area is now 2
      2017-09-24 01:39:13.396 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:39:13.396 : nigini:exit
      2017-09-24 01:39:13.396 : niqname:Hst is already an NVstring.
      2017-09-24 01:39:13.396 : niqname:Inserting CID.
      2017-09-24 01:39:13.397 : niotns:entry
      2017-09-24 01:39:13.397 : snsbitini_ts:entry
      2017-09-24 01:39:13.397 : snsbitini_ts:normal exit
      2017-09-24 01:39:13.397 : snsbitini_ts:entry
      2017-09-24 01:39:13.397 : snsbitini_ts:normal exit
      2017-09-24 01:39:13.397 : niotns:Not trying to enable dead connection detection.
      2017-09-24 01:39:13.397 : niotns:Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=sample.localdomain)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=lon)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:39:13.397 : nsgettrans_bystring:entry
      2017-09-24 01:39:13.397 : nsgettrans_bystring:exit
      2017-09-24 01:39:13.397 : nscall:entry
      2017-09-24 01:39:13.397 : nsmal:entry
      2017-09-24 01:39:13.397 : nsmal:304 bytes at 0x7f47ee50
      2017-09-24 01:39:13.397 : nsmal:normal exit
      2017-09-24 01:39:13.397 : nscall:connecting...
      2017-09-24 01:39:13.397 : nlad_expand_hst:Expanding sample.localdomain
      2017-09-24 01:39:13.397 : snlinGetAddrInfo:entry
      2017-09-24 01:39:13.400 : snlinGetAddrInfo:exit
      2017-09-24 01:39:13.400 : snlinGetNameInfo:entry
      2017-09-24 01:39:13.400 : snlinGetNameInfo:exit
      2017-09-24 01:39:13.400 : nlad_expand_hst:Adding IP 192.168.2.11
      2017-09-24 01:39:13.400 : snlinFreeAddrInfo:entry
      2017-09-24 01:39:13.400 : snlinFreeAddrInfo:exit
      2017-09-24 01:39:13.400 : nlad_expand_hst:Result: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=192.168.2.11)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=lon)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:39:13.400 : nlad_pr:entry
      2017-09-24 01:39:13.400 : nlad_pr:description processing
      2017-09-24 01:39:13.400 : nlad_pr:entry
      2017-09-24 01:39:13.400 : snlinGetAddrInfo:entry
      2017-09-24 01:39:13.400 : snlinGetAddrInfo:exit
      2017-09-24 01:39:13.400 : nlad_pr:hostname 192.168.2.11
      2017-09-24 01:39:13.400 : snlinFreeAddrInfo:entry
      2017-09-24 01:39:13.400 : snlinFreeAddrInfo:exit
      2017-09-24 01:39:13.400 : nlad_pr:Result: (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=192.168.2.11)(PORT=2484)))
      2017-09-24 01:39:13.400 : nlad_pr:entry
      2017-09-24 01:39:13.400 : nlad_pr:Result: (CONNECT_DATA=(SERVICE_NAME=lon)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser)))
      2017-09-24 01:39:13.400 : nlad_aand:entry
      2017-09-24 01:39:13.400 : nlad_ind:entry
      2017-09-24 01:39:13.400 : snlinGetAddrInfo:entry
      2017-09-24 01:39:13.400 : snlinGetAddrInfo:exit
      2017-09-24 01:39:13.400 : nlad_ind:hostname 192.168.2.11
      2017-09-24 01:39:13.400 : snlinFreeAddrInfo:entry
      2017-09-24 01:39:13.401 : snlinFreeAddrInfo:exit
      2017-09-24 01:39:13.401 : nlad_ind:exit
      2017-09-24 01:39:13.401 : nlad_aand:entry
      2017-09-24 01:39:13.401 : nlad_pr:Result: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=192.168.2.11)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=lon)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:39:13.401 : nladini:entry
      2017-09-24 01:39:13.401 : nladini:exit
      2017-09-24 01:39:13.401 : nladget:entry
      2017-09-24 01:39:13.401 : nladget:exit
      2017-09-24 01:39:13.401 : nsmal:entry
      2017-09-24 01:39:13.401 : nsmal:206 bytes at 0x7f472f60
      2017-09-24 01:39:13.401 : nsmal:normal exit
      2017-09-24 01:39:13.401 : nsc2addr:entry
      2017-09-24 01:39:13.401 : nsc2addr:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=192.168.2.11)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=lon)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:39:13.417 : ntzini:entry
      2017-09-24 01:39:13.417 : ntzSetupConnection:entry
      2017-09-24 01:39:13.417 : ntzgbhapip:entry
      2017-09-24 01:39:13.417 : ntzgbhapip:no value for bhapi parameter specified - using default value: "TRUE"
      2017-09-24 01:39:13.417 : ntzgbhapip:exit
      2017-09-24 01:39:13.418 : nztysgs_genseed:entry
      2017-09-24 01:39:13.419 : nztysgs_genseed:exit
      2017-09-24 01:39:13.506 : nzosr_DefaultConfig:entry
      2017-09-24 01:39:13.506 : nzsuppgp_get_parameter:entry
      2017-09-24 01:39:13.506 : nzsuppgp_get_parameter:parameter "ssl.renegotiate" does not exist.
      2017-09-24 01:39:13.506 : nzsuppgp_get_parameter:exit
      2017-09-24 01:39:13.506 : nzosr_DefaultConfig:Renegotiation parameter undefined. Will use default value
      2017-09-24 01:39:13.506 : nzosr_DefaultConfig:Renegotiation parameter ssl.renegotiate = 
      2017-09-24 01:39:13.506 : nzosr_DefaultConfig:exit
      2017-09-24 01:39:13.506 : nzos_Initialize:nz initialize status 0
      2017-09-24 01:39:13.506 : ntzSetupConnection:exit
      2017-09-24 01:39:13.506 : ntzSetupConnection:entry
      2017-09-24 01:39:13.506 : ntzgbhapip:entry
      2017-09-24 01:39:13.506 : ntzgbhapip:no value for bhapi parameter specified - using default value: "TRUE"
      2017-09-24 01:39:13.506 : ntzgbhapip:exit
      2017-09-24 01:39:13.506 : nztysgs_genseed:entry
      2017-09-24 01:39:13.508 : nztysgs_genseed:exit
      2017-09-24 01:39:13.582 : nzosr_DefaultConfig:entry
      2017-09-24 01:39:13.582 : nzsuppgp_get_parameter:entry
      2017-09-24 01:39:13.582 : nzsuppgp_get_parameter:parameter "ssl.renegotiate" does not exist.
      2017-09-24 01:39:13.582 : nzsuppgp_get_parameter:exit
      2017-09-24 01:39:13.582 : nzosr_DefaultConfig:Renegotiation parameter undefined. Will use default value
      2017-09-24 01:39:13.582 : nzosr_DefaultConfig:Renegotiation parameter ssl.renegotiate = 
      2017-09-24 01:39:13.582 : nzosr_DefaultConfig:exit
      2017-09-24 01:39:13.582 : nzos_Initialize:nz initialize status 0
      2017-09-24 01:39:13.582 : ntzSetupConnection:exit
      2017-09-24 01:39:13.582 : ntzcsgtab:entry
      2017-09-24 01:39:13.582 : ntzcsgtab:exit
      2017-09-24 01:39:13.582 : ntzini:exit
      2017-09-24 01:39:13.582 : nttbnd2addr:entry
      2017-09-24 01:39:13.582 : snlinGetAddrInfo:entry
      2017-09-24 01:39:13.582 : snlinGetAddrInfo:exit
      2017-09-24 01:39:13.582 : nttbnd2addr:using host IP address: 192.168.2.11
      2017-09-24 01:39:13.582 : snlinFreeAddrInfo:entry
      2017-09-24 01:39:13.582 : snlinFreeAddrInfo:exit
      2017-09-24 01:39:13.582 : nttbnd2addr:exit
      2017-09-24 01:39:13.582 : nsc2addr:normal exit
      2017-09-24 01:39:13.582 : nsopen:entry
      2017-09-24 01:39:13.582 : nsmal:entry
      2017-09-24 01:39:13.582 : nsmal:1880 bytes at 0x7fc02330
      2017-09-24 01:39:13.582 : nsmal:normal exit
      2017-09-24 01:39:13.582 : nsopenmplx:entry
      2017-09-24 01:39:13.582 : nsmal:entry
      2017-09-24 01:39:13.582 : nsmal:3536 bytes at 0x7fc02a90
      2017-09-24 01:39:13.582 : nsmal:normal exit
      2017-09-24 01:39:13.582 : snsbitini_ts:entry
      2017-09-24 01:39:13.582 : snsbitini_ts:normal exit
      2017-09-24 01:39:13.582 : nsiorini:entry
      2017-09-24 01:39:13.582 : nsbal:entry
      2017-09-24 01:39:13.582 : nsbgetfl:entry
      2017-09-24 01:39:13.582 : nsbgetfl:normal exit
      2017-09-24 01:39:13.582 : nsmal:entry
      2017-09-24 01:39:13.582 : nsmal:168 bytes at 0x7fb1de10
      2017-09-24 01:39:13.582 : nsmal:normal exit
      2017-09-24 01:39:13.582 : nsbal:normal exit
      2017-09-24 01:39:13.582 : nsiorini:exit (0)
      2017-09-24 01:39:13.582 : nscpxget:entry
      2017-09-24 01:39:13.582 : snsbitts_ts:entry
      2017-09-24 01:39:13.582 : snsbitts_ts:acquired the bit
      2017-09-24 01:39:13.582 : snsbitts_ts:normal exit
      2017-09-24 01:39:13.582 : snsbitcl_ts:entry
      2017-09-24 01:39:13.582 : snsbitcl_ts:normal exit
      2017-09-24 01:39:13.582 : nscpxget:normal exit
      2017-09-24 01:39:13.583 : nsopenalloc_nsntx:nlhthput on mplx_ht_nsgbu:ctx=7fc02330, nsntx=7fc02a90
      2017-09-24 01:39:13.583 : nsopenmplx:normal exit
      2017-09-24 01:39:13.583 : nsopen:opening transport...
      2017-09-24 01:39:13.583 : ntzconnect:entry
      2017-09-24 01:39:13.583 : ntzCreateConnection:entry
      2017-09-24 01:39:13.583 : nttcon:entry
      2017-09-24 01:39:13.583 : nttcon:toc = 1
      2017-09-24 01:39:13.583 : nttcnp:entry
      2017-09-24 01:39:13.583 : nttcnp:creating a socket.
      2017-09-24 01:39:13.583 : nttcnp:exit
      2017-09-24 01:39:13.583 : nttcni:entry
      2017-09-24 01:39:13.583 : nttcni:Tcp conn timeout = 60000 (ms)
      2017-09-24 01:39:13.583 : nttcni:TCP Connect TO enabled. Switching to NB
      2017-09-24 01:39:13.583 : nttctl:entry
      2017-09-24 01:39:13.583 : nttctl:Setting connection into non-blocking mode
      2017-09-24 01:39:13.583 : nttcni:trying to connect to socket 860.
      2017-09-24 01:39:13.583 : ntt2err:entry
      2017-09-24 01:39:13.583 : ntt2err:exit
      2017-09-24 01:39:13.583 : ntctst:size of NTTEST list is 1 - not calling poll
      2017-09-24 01:39:13.583 : sntseltst:Testing for WRITE on socket 860
      2017-09-24 01:39:13.583 : sntseltst:FOUND: write request on socket 860
      2017-09-24 01:39:13.583 : nttctl:entry
      2017-09-24 01:39:13.583 : nttctl:Clearing non-blocking mode
      2017-09-24 01:39:13.583 : snlinGetNameInfo:entry
      2017-09-24 01:39:13.583 : snlinGetNameInfo:exit
      2017-09-24 01:39:13.583 : nttcni:connected on source ipaddr 192.168.2.7 port 60200
      2017-09-24 01:39:13.583 : nttcni:exit
      2017-09-24 01:39:13.583 : nttctl:entry
      2017-09-24 01:39:13.583 : nttctl:Setting connection into nodelay mode
      2017-09-24 01:39:13.584 : nttctl:set TCP_NODELAY on 860
      2017-09-24 01:39:13.584 : nttcon:exit
      2017-09-24 01:39:13.584 : ntzAllocate:entry
      2017-09-24 01:39:13.584 : ntzAllocate:allocating 304 bytes of memory.
      2017-09-24 01:39:13.584 : ntzAllocate:exit
      2017-09-24 01:39:13.584 : ntzAllocate:entry
      2017-09-24 01:39:13.584 : ntzAllocate:allocating 2097152 bytes of memory.
      2017-09-24 01:39:13.584 : ntzAllocate:exit
      2017-09-24 01:39:13.584 : ntzAllocate:entry
      2017-09-24 01:39:13.584 : ntzAllocate:allocating 2097152 bytes of memory.
      2017-09-24 01:39:13.584 : ntzAllocate:exit
      2017-09-24 01:39:13.584 : ntzConfigure:entry
      2017-09-24 01:39:13.584 : ntzgsvp:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : ntzgsvp:no SSL version specified - using default version 0
      2017-09-24 01:39:13.584 : ntzgsvp:exit
      2017-09-24 01:39:13.584 : ntzgcpp:entry
      2017-09-24 01:39:13.584 : ntzAllocate:entry
      2017-09-24 01:39:13.584 : ntzAllocate:allocating 32 bytes of memory.
      2017-09-24 01:39:13.584 : ntzAllocate:exit
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:found value for "ssl_cipher_suites" configuration parameter: "SSL_RSA_WITH_AES_256_CBC_SHA"
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:found value for "ssl_cipher_suites" configuration parameter: "SSL_RSA_WITH_3DES_EDE_CBC_SHA"
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : ntzgcpp:exit
      2017-09-24 01:39:13.584 : ntzCreateCipherSpec:entry
      2017-09-24 01:39:13.584 : ntzCreateCipherSpec:exit
      2017-09-24 01:39:13.584 : ntzgcap:entry
      2017-09-24 01:39:13.584 : ntzgcap:retrieved value "FALSE" for client authentication parameter
      2017-09-24 01:39:13.584 : ntzgcap:exit
      2017-09-24 01:39:13.584 : ntzgwrl:entry
      2017-09-24 01:39:13.584 : ntzgwrlFromFile:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:found value for "wallet_location" configuration parameter: "SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = E:\app\oracle\wallet))"
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : ntzAllocate:entry
      2017-09-24 01:39:13.584 : ntzAllocate:allocating 78 bytes of memory.
      2017-09-24 01:39:13.584 : ntzAllocate:exit
      2017-09-24 01:39:13.584 : ntzAllocate:entry
      2017-09-24 01:39:13.584 : ntzAllocate:allocating 29 bytes of memory.
      2017-09-24 01:39:13.584 : ntzAllocate:exit
      2017-09-24 01:39:13.584 : ntzgwrlFromFile:exit
      2017-09-24 01:39:13.584 : ntzgwrl:exit
      2017-09-24 01:39:13.584 : ntzscr:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : ntzscr:exit
      2017-09-24 01:39:13.584 : ntzlogin:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:entry
      2017-09-24 01:39:13.584 : ntzGetStringParameter:exit
      2017-09-24 01:39:13.584 : nztwOpenWallet:entry
      2017-09-24 01:39:13.584 : nzosReadConfFile:entry
      2017-09-24 01:39:13.584 : nzosReadCertParams:entry
      2017-09-24 01:39:13.584 : nzosReadCertParams:sslconf.ora location is..
      2017-09-24 01:39:13.584 : nzosReadCertParams:E:\app\client\product\12.2.0\client_1\ldap\admin\sslconf.ora
      2017-09-24 01:39:13.584 : nzosReadConfFile:sslconf.ora file could not be opened. Continuing.
      
      
      2017-09-24 01:39:13.584 : nzosReadConfFile:exit
      2017-09-24 01:39:13.584 : nzupawp_apply_wrl_policy:entry
      2017-09-24 01:39:13.584 : nzupgew_get_environ_wrl:entry
      2017-09-24 01:39:13.584 : nzupgew_get_environ_wrl:Environment Variable not found or empty value. 
      2017-09-24 01:39:13.584 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument .. 
      2017-09-24 01:39:13.584 : nzdcpgfd_get_file_data:entry
      2017-09-24 01:39:13.584 : nzdcpaf_assemble_filename:entry
      2017-09-24 01:39:13.584 : snzdafn_assemble_filename:entry
      2017-09-24 01:39:13.585 : nzupawp_apply_wrl_policy:entry
      2017-09-24 01:39:13.585 : nzupgew_get_environ_wrl:entry
      2017-09-24 01:39:13.585 : nzupgew_get_environ_wrl:Environment Variable not found or empty value. 
      2017-09-24 01:39:13.585 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument .. 
      2017-09-24 01:39:13.585 : nzdtrsr_store_certreq:entry
      2017-09-24 01:39:13.585 : nzupawp_apply_wrl_policy:entry
      2017-09-24 01:39:13.585 : nzupgew_get_environ_wrl:entry
      2017-09-24 01:39:13.585 : nzupgew_get_environ_wrl:Environment Variable not found or empty value. 
      2017-09-24 01:39:13.585 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument .. 
      2017-09-24 01:39:13.585 : nzdcpgfd_get_file_data:entry
      2017-09-24 01:39:13.585 : nzdcpaf_assemble_filename:entry
      2017-09-24 01:39:13.585 : snzdafn_assemble_filename:entry
      2017-09-24 01:39:13.585 : nzupawp_apply_wrl_policy:entry
      2017-09-24 01:39:13.585 : nzupgew_get_environ_wrl:entry
      2017-09-24 01:39:13.585 : nzupgew_get_environ_wrl:Environment Variable not found or empty value. 
      2017-09-24 01:39:13.585 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument .. 
      2017-09-24 01:39:13.585 : nzdcpgfd_get_file_data:entry
      2017-09-24 01:39:13.585 : nzdcpaf_assemble_filename:entry
      2017-09-24 01:39:13.585 : snzdafn_assemble_filename:entry
      2017-09-24 01:39:13.585 : nziropen:entry
      2017-09-24 01:39:13.585 : nzdfo_open:entry
      2017-09-24 01:39:13.585 : snzdfo_open_file:entry
      2017-09-24 01:39:13.585 : snzdfo_open_file:Opening file E:\app\oracle\wallet\ewallet.p12 with READ ONLY permissions
      2017-09-24 01:39:13.585 : nziropen:entry
      2017-09-24 01:39:13.585 : nzdfo_open:entry
      2017-09-24 01:39:13.585 : snzdfo_open_file:entry
      2017-09-24 01:39:13.585 : snzdfo_open_file:Opening file E:\app\oracle\wallet\cwallet.sso with READ ONLY permissions
      2017-09-24 01:39:13.585 : nzirretrieve:entry
      2017-09-24 01:39:13.585 : nzdfr_reset:entry
      2017-09-24 01:39:13.585 : nzdfr_reset:exit
      2017-09-24 01:39:13.585 : nzdfr_reset:entry
      2017-09-24 01:39:13.585 : nzdfr_reset:exit
      2017-09-24 01:39:13.585 : nzdfwe_read_entry:entry
      2017-09-24 01:39:13.585 : nzdfwe_read_entry:File read error: paramsizemismatch
      2017-09-24 01:39:13.585 : nzdfr_reset:entry
      2017-09-24 01:39:13.585 : nzdfr_reset:exit
      2017-09-24 01:39:13.585 : nzirclose:entry
      2017-09-24 01:39:13.585 : nzdfc_close:entry
      2017-09-24 01:39:13.585 : nzdfc_close:exit
      2017-09-24 01:39:13.585 : nzirclose:entry
      2017-09-24 01:39:13.585 : nzdfc_close:entry
      2017-09-24 01:39:13.585 : nzdfc_close:exit
      2017-09-24 01:39:13.587 : nzupgu_get_username:entry
      2017-09-24 01:39:13.588 : nzhewencPkcs12wlttoWallet:entry
      2017-09-24 01:39:13.590 : nzbc_certreq_import:entry
      2017-09-24 01:39:13.590 : nzbc_certreq_import:entry
      2017-09-24 01:39:13.590 : nzxMKEOU_MapKeyExtToOrclUsg:entry
      2017-09-24 01:39:13.591 : nzxMKEOU_MapKeyExtToOrclUsg:exit
      2017-09-24 01:39:13.591 : nzxMKEOU_MapKeyExtToOrclUsg:entry
      2017-09-24 01:39:13.591 : nzxMKEOU_MapKeyExtToOrclUsg:exit
      2017-09-24 01:39:13.591 : nzxMKEOU_MapKeyExtToOrclUsg:entry
      2017-09-24 01:39:13.591 : nzxMKEOU_MapKeyExtToOrclUsg:exit
      2017-09-24 01:39:13.591 : nzbdc2uko_dercert_to_publickeyobj:entry
      2017-09-24 01:39:13.591 : nzdkcks_compare_keys:entry
      2017-09-24 01:39:13.591 : nzupgu_get_username:entry
      2017-09-24 01:39:13.591 : nzhewencPkcs12wlttoWallet:entry
      2017-09-24 01:39:13.593 : nzbc_certreq_import:entry
      2017-09-24 01:39:13.593 : nzbc_certreq_import:entry
      2017-09-24 01:39:13.593 : nzxMKEOU_MapKeyExtToOrclUsg:entry
      2017-09-24 01:39:13.593 : nzxMKEOU_MapKeyExtToOrclUsg:exit
      2017-09-24 01:39:13.593 : nzxMKEOU_MapKeyExtToOrclUsg:entry
      2017-09-24 01:39:13.593 : nzxMKEOU_MapKeyExtToOrclUsg:exit
      2017-09-24 01:39:13.594 : nzxMKEOU_MapKeyExtToOrclUsg:entry
      2017-09-24 01:39:13.594 : nzxMKEOU_MapKeyExtToOrclUsg:exit
      2017-09-24 01:39:13.594 : nzbdc2uko_dercert_to_publickeyobj:entry
      2017-09-24 01:39:13.594 : nzdkcks_compare_keys:entry
      2017-09-24 01:39:13.594 : nztwOpenWallet:exit
      2017-09-24 01:39:13.594 : ntzlogin:exit
      2017-09-24 01:39:13.594 : ntzConfigure:exit
      2017-09-24 01:39:13.594 : ntzdosecneg:entry
      2017-09-24 01:39:13.594 : nzosSetCredential:entry
      2017-09-24 01:39:13.594 : nzosSetCipherSuite:entry
      2017-09-24 01:39:13.594 : nzosSetCipherSuite:Setting ciphers to AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA256:AES128-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-RSA-DES-CBC3-SHA:ECDHE-RSA-AES128-SHA:ECDHE-RSA-RC4-SHA:ECDH-RSA-AES256-SHA:ECDH-RSA-DES-CBC3-SHA:ECDH-RSA-AES128-SHA:ECDH-RSA-RC4-SHA:ECDH-ECDSA-AES256-SHA:ECDH-ECDSA-DES-CBC3-SHA:ECDH-ECDSA-AES128-SHA:ECDH-ECDSA-RC4-SHA:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-ECDSA-RC4-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:RC4-SHA:RC4-MD5
      2017-09-24 01:39:13.594 : nzosSetCipherSuite:exit
      2017-09-24 01:39:13.594 : nzos_SetPersona:entry
      2017-09-24 01:39:13.594 : nzosAddCertChain:entry
      2017-09-24 01:39:13.594 : nzosAddCertChain:exit
      2017-09-24 01:39:13.594 : nzos_SetPersona:exit
      2017-09-24 01:39:13.594 : nzosSetCredential:exit
      2017-09-24 01:39:13.594 : nzos_Create_Ctx:nz ctx create status: 0
      2017-09-24 01:39:13.594 : nzosSetCredential:entry
      2017-09-24 01:39:13.594 : nzosSetCipherSuite:entry
      2017-09-24 01:39:13.594 : nzosSetCipherSuite:Setting ciphers to AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA256:AES128-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-RSA-DES-CBC3-SHA:ECDHE-RSA-AES128-SHA:ECDHE-RSA-RC4-SHA:ECDH-RSA-AES256-SHA:ECDH-RSA-DES-CBC3-SHA:ECDH-RSA-AES128-SHA:ECDH-RSA-RC4-SHA:ECDH-ECDSA-AES256-SHA:ECDH-ECDSA-DES-CBC3-SHA:ECDH-ECDSA-AES128-SHA:ECDH-ECDSA-RC4-SHA:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-ECDSA-RC4-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:RC4-SHA:RC4-MD5
      2017-09-24 01:39:13.595 : nzosSetCipherSuite:exit
      2017-09-24 01:39:13.595 : nzos_SetPersona:entry
      2017-09-24 01:39:13.595 : nzosAddCertChain:entry
      2017-09-24 01:39:13.595 : nzosAddCertChain:exit
      2017-09-24 01:39:13.595 : nzos_SetPersona:exit
      2017-09-24 01:39:13.595 : nzosSetCredential:exit
      2017-09-24 01:39:13.595 : ntzSetUserDefinedCiphers:entry
      2017-09-24 01:39:13.595 : nzos_ModifyCipherSuites:Setting ciphers to AES256-SHA:DES-CBC3-SHA
      2017-09-24 01:39:13.595 : ntzSetUserDefinedCiphers:exit
      2017-09-24 01:39:13.595 : nzos_Handshake:entry
      2017-09-24 01:39:13.595 : SSL_Info:Handshake before/connect initialization (TLSv12 protocol)
      2017-09-24 01:39:13.595 : nttwr:entry
      2017-09-24 01:39:13.595 : nttwr:socket 860 had bytes written=134
      2017-09-24 01:39:13.595 : nttwr:exit
      2017-09-24 01:39:13.595 : nzosp_bio_write:processed=134, ret=0
      2017-09-24 01:39:13.595 : nzbiowrite:  write 134/134 bytes
      2017-09-24 01:39:13.595 :      0: 16030300 81010000 7d030359 c6bf6974       |........}..Y..it|
          16: eb4d9fc3 76acffff 95309176 9f18ec10       |.M..v....0.v....|
          32: 27e4b7a4 710ceda5 854acb00 00060035       |'...q....J.....5|
          48: 000a00ff 0100004e 000a0020 001e0017       |.......N... ....|
          64: 0019000d 000e0018 000b000c 0009000a       |................|
          80: 00150006 00070013 00010003 000b0002       |................|
          96: 0100000d 0020001e 02010301 04010501       |..... ..........|
         112: 06010202 03020402 05020602 02030303       |................|
         128: 04030503 0603---- -------- --------       |......          |
      
      
      2017-09-24 01:39:13.595 : SSL_Info:SSLv2/v3 write client hello A (TLSv12 protocol)
      2017-09-24 01:39:13.595 : nttrd:entry
      2017-09-24 01:39:13.597 : nttrd:exit
      2017-09-24 01:39:13.597 : ntt2err:entry
      2017-09-24 01:39:13.597 : ntt2err:Read unexpected EOF ERROR on 860
      2017-09-24 01:39:13.597 : ntt2err:exit
      2017-09-24 01:39:13.597 : nzospRead:I/O channel closed - closing connection (-6990)
      2017-09-24 01:39:13.597 : SSL_Info:error in SSLv3 read server hello A
      2017-09-24 01:39:13.597 : nzos_Handshake:exit
      2017-09-24 01:39:13.597 : ntzdosecneg:SSL handshake failed with error 28864.
      2017-09-24 01:39:13.597 : ntzdosecneg:exit
      2017-09-24 01:39:13.597 : ntzsopts:entry
      2017-09-24 01:39:13.597 : nttctl:entry
      2017-09-24 01:39:13.597 : nttctl:Setting connection into non-blocking mode
      2017-09-24 01:39:13.597 : ntzsopts:exit
      2017-09-24 01:39:13.597 : ntzCreateConnection:returning NZ error 28864 in result structure
      2017-09-24 01:39:13.597 : ntzCreateConnection:failed with error 542
      2017-09-24 01:39:13.597 : ntzCreateConnection:exit
      2017-09-24 01:39:13.597 : ntzdisconnect:entry
      2017-09-24 01:39:13.597 : ntzFreeNTZData:entry
      2017-09-24 01:39:13.597 : nzos_DestroyCtx:entry
      2017-09-24 01:39:13.597 : nzos_DestroyCtx:exit
      2017-09-24 01:39:13.597 : ntzFreeNTZData:exit
      2017-09-24 01:39:13.597 : nttdisc:entry
      2017-09-24 01:39:13.597 : nttdisc:Closed socket 860
      2017-09-24 01:39:13.597 : nttdisc:exit
      2017-09-24 01:39:13.597 : ntzdisconnect:exit
      2017-09-24 01:39:13.597 : ntzconnect:failed with error 542
      2017-09-24 01:39:13.597 : ntzconnect:exit
      2017-09-24 01:39:13.597 : nserror:entry
      2017-09-24 01:39:13.597 : nserror:nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=542, nt[1]=28864, nt[2]=0; ora[0]=28864, ora[1]=0, ora[2]=0
      2017-09-24 01:39:13.597 : nsopen:unable to open transport
      2017-09-24 01:39:13.597 : snsbitts_ts:entry
      2017-09-24 01:39:13.597 : snsbitts_ts:acquired the bit
      2017-09-24 01:39:13.597 : snsbitts_ts:normal exit
      2017-09-24 01:39:13.597 : snsbitcl_ts:entry
      2017-09-24 01:39:13.597 : snsbitcl_ts:normal exit
      2017-09-24 01:39:13.597 : nsiocancel:entry
      2017-09-24 01:39:13.597 : nsiofrrg:entry
      2017-09-24 01:39:13.597 : nsiofrrg:cur = 7fc03a30
      2017-09-24 01:39:13.597 : nsbfr:entry
      2017-09-24 01:39:13.597 : nsbaddfl:entry
      2017-09-24 01:39:13.597 : nsbaddfl:normal exit
      2017-09-24 01:39:13.597 : nsbfr:normal exit
      2017-09-24 01:39:13.597 : nsiofrrg:exit
      2017-09-24 01:39:13.597 : nsiocancel:exit
      2017-09-24 01:39:13.597 : nsvntx_dei:entry
      2017-09-24 01:39:13.597 : nsvntx_dei:exit
      2017-09-24 01:39:13.598 : nsopenfree_nsntx:nlhthdel from mplx_ht_nsgbu, ctx=7fc02330 nsntx=7fc02a90
      2017-09-24 01:39:13.598 : nsiocancel:entry
      2017-09-24 01:39:13.598 : nsiofrrg:entry
      2017-09-24 01:39:13.598 : nsiofrrg:exit
      2017-09-24 01:39:13.598 : nsiocancel:exit
      2017-09-24 01:39:13.598 : snsbittrm_ts:entry
      2017-09-24 01:39:13.598 : snsbittrm_ts:normal exit
      2017-09-24 01:39:13.598 : snsbitts_ts:entry
      2017-09-24 01:39:13.598 : snsbitts_ts:acquired the bit
      2017-09-24 01:39:13.598 : snsbitts_ts:normal exit
      2017-09-24 01:39:13.598 : snsbitcl_ts:entry
      2017-09-24 01:39:13.598 : snsbitcl_ts:normal exit
      2017-09-24 01:39:13.598 : nsmfr:entry
      2017-09-24 01:39:13.598 : nsmfr:3536 bytes at 0x7fc02a90
      2017-09-24 01:39:13.598 : nsmfr:normal exit
      2017-09-24 01:39:13.598 : nsmfr:entry
      2017-09-24 01:39:13.598 : nsmfr:1880 bytes at 0x7fc02330
      2017-09-24 01:39:13.598 : nsmfr:normal exit
      2017-09-24 01:39:13.598 : nsopen:error exit
      2017-09-24 01:39:13.598 : nsclose:entry
      2017-09-24 01:39:13.598 : nsclose:normal exit
      2017-09-24 01:39:13.598 : nladget:entry
      2017-09-24 01:39:13.598 : nladget:exit
      2017-09-24 01:39:13.598 : nsmfr:entry
      2017-09-24 01:39:13.598 : nsmfr:206 bytes at 0x7f472f60
      2017-09-24 01:39:13.598 : nsmfr:normal exit
      2017-09-24 01:39:13.598 : nsmfr:entry
      2017-09-24 01:39:13.598 : nsmfr:304 bytes at 0x7f47ee50
      2017-09-24 01:39:13.598 : nsmfr:normal exit
      2017-09-24 01:39:13.598 : nladtrm:entry
      2017-09-24 01:39:13.598 : nladtrm:exit
      2017-09-24 01:39:13.598 : nscall:error exit
      2017-09-24 01:39:13.598 : nioqper: error from nscall
      2017-09-24 01:39:13.598 : nioqper:   ns main err code: 12560
      2017-09-24 01:39:13.598 : nioqper:   ns (2)  err code: 0
      2017-09-24 01:39:13.598 : nioqper:   nt main err code: 542
      2017-09-24 01:39:13.598 : nioqper:   nt (2)  err code: 28864
      2017-09-24 01:39:13.598 : nioqper:   nt OS   err code: 0
      2017-09-24 01:39:13.598 : niomapnserror:entry
      2017-09-24 01:39:13.598 : niqme:entry
      2017-09-24 01:39:13.598 : niqme:reporting ORA-28864 error
      2017-09-24 01:39:13.598 : niqme:exit
      2017-09-24 01:39:13.598 : niomapnserror:exit
      2017-09-24 01:39:13.598 : niotns:Couldn't connect, returning 28864
      2017-09-24 01:39:13.605 : niotns:exit
      2017-09-24 01:39:13.605 : snsbittrm_ts:entry
      2017-09-24 01:39:13.605 : snsbittrm_ts:normal exit
      2017-09-24 01:39:13.605 : snsbittrm_ts:entry
      2017-09-24 01:39:13.605 : snsbittrm_ts:normal exit
      2017-09-24 01:39:13.605 : nsbfrfl:entry
      2017-09-24 01:39:13.605 : nsbrfr:entry
      2017-09-24 01:39:13.605 : nsbrfr:nsbfs at 0x7fb1de10, data at 0x7fc03ab0.
      2017-09-24 01:39:13.605 : nsbrfr:normal exit
      2017-09-24 01:39:13.605 : nsbfrfl:normal exit
      2017-09-24 01:39:13.605 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:39:13.605 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:51:24.170 : nigini:entry
      2017-09-24 01:51:24.171 : nigini:Count in the NL global area is now 2
      2017-09-24 01:51:24.171 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:51:24.171 : nigini:exit
      2017-09-24 01:51:24.171 : niqname:Hst is already an NVstring.
      2017-09-24 01:51:24.171 : niqname:Inserting CID.
      2017-09-24 01:51:24.171 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:51:24.171 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:51:24.171 : nigini:entry
      2017-09-24 01:51:24.171 : nigini:Count in the NL global area is now 2
      2017-09-24 01:51:24.171 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:51:24.171 : nigini:exit
      2017-09-24 01:51:24.171 : niqname:Hst is already an NVstring.
      2017-09-24 01:51:24.171 : niqname:Inserting CID.
      2017-09-24 01:51:24.171 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:51:24.171 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:51:24.171 : nigini:entry
      2017-09-24 01:51:24.171 : nigini:Count in the NL global area is now 2
      2017-09-24 01:51:24.171 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:51:24.171 : nigini:exit
      2017-09-24 01:51:24.171 : niqname:Hst is already an NVstring.
      2017-09-24 01:51:24.171 : niqname:Inserting CID.
      2017-09-24 01:51:24.172 : niotns:entry
      2017-09-24 01:51:24.172 : snsbitini_ts:entry
      2017-09-24 01:51:24.172 : snsbitini_ts:normal exit
      2017-09-24 01:51:24.172 : snsbitini_ts:entry
      2017-09-24 01:51:24.172 : snsbitini_ts:normal exit
      2017-09-24 01:51:24.172 : niotns:Not trying to enable dead connection detection.
      2017-09-24 01:51:24.172 : niotns:Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.172 : nsgettrans_bystring:entry
      2017-09-24 01:51:24.194 : nlpcaini:entry
      2017-09-24 01:51:24.194 : nlpcaini:prg = oracle
      2017-09-24 01:51:24.195 : nlpcaini:arg[0] = oracleORCL
      2017-09-24 01:51:24.195 : nlpcaini:arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
      2017-09-24 01:51:24.195 : nlpcaini:env[0] = =C:=C:\Windows\System32
      2017-09-24 01:51:24.195 : nlpcaini:exit
      2017-09-24 01:51:24.195 : ntgettrans:entry
      2017-09-24 01:51:24.195 : ntgettrans:exit
      2017-09-24 01:51:24.195 : nsgettrans_bystring:exit
      2017-09-24 01:51:24.195 : nscall:entry
      2017-09-24 01:51:24.195 : nsmal:entry
      2017-09-24 01:51:24.195 : nsmal:304 bytes at 0x7fcd1ba0
      2017-09-24 01:51:24.195 : nsmal:normal exit
      2017-09-24 01:51:24.195 : nscall:connecting...
      2017-09-24 01:51:24.195 : nlad_expand_hst:Result: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.195 : nlad_pr:entry
      2017-09-24 01:51:24.195 : nlad_pr:description processing
      2017-09-24 01:51:24.195 : nlad_pr:entry
      2017-09-24 01:51:24.195 : nlad_pr:Result: (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
      2017-09-24 01:51:24.195 : nlad_pr:entry
      2017-09-24 01:51:24.195 : nlad_pr:Result: (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser)))
      2017-09-24 01:51:24.195 : nlad_aand:entry
      2017-09-24 01:51:24.195 : nlad_ind:entry
      2017-09-24 01:51:24.195 : nlad_ind:exit
      2017-09-24 01:51:24.195 : nlad_aand:entry
      2017-09-24 01:51:24.195 : nlad_pr:Result: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.195 : nladini:entry
      2017-09-24 01:51:24.195 : nladini:exit
      2017-09-24 01:51:24.195 : nladget:entry
      2017-09-24 01:51:24.195 : nladget:exit
      2017-09-24 01:51:24.195 : nsmal:entry
      2017-09-24 01:51:24.195 : nsmal:259 bytes at 0x7fb0a560
      2017-09-24 01:51:24.195 : nsmal:normal exit
      2017-09-24 01:51:24.195 : nsc2addr:entry
      2017-09-24 01:51:24.195 : nsc2addr:(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.195 : nlpcaini:entry
      2017-09-24 01:51:24.195 : nlpcaini:prg = oracle
      2017-09-24 01:51:24.195 : nlpcaini:arg[0] = oracleORCL
      2017-09-24 01:51:24.195 : nlpcaini:arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
      2017-09-24 01:51:24.195 : nlpcaini:env[0] = =C:=C:\Windows\System32
      2017-09-24 01:51:24.195 : nlpcaini:exit
      2017-09-24 01:51:24.195 : nsc2addr:normal exit
      2017-09-24 01:51:24.195 : nsopen:entry
      2017-09-24 01:51:24.195 : nsmal:entry
      2017-09-24 01:51:24.195 : nsmal:1880 bytes at 0x7fb05dd0
      2017-09-24 01:51:24.195 : nsmal:normal exit
      2017-09-24 01:51:24.195 : nsopenmplx:entry
      2017-09-24 01:51:24.195 : nsmal:entry
      2017-09-24 01:51:24.195 : nsmal:3536 bytes at 0x7fcf5f60
      2017-09-24 01:51:24.195 : nsmal:normal exit
      2017-09-24 01:51:24.195 : snsbitini_ts:entry
      2017-09-24 01:51:24.195 : snsbitini_ts:normal exit
      2017-09-24 01:51:24.195 : nsiorini:entry
      2017-09-24 01:51:24.195 : nsbal:entry
      2017-09-24 01:51:24.195 : nsbgetfl:entry
      2017-09-24 01:51:24.195 : nsbgetfl:normal exit
      2017-09-24 01:51:24.195 : nsmal:entry
      2017-09-24 01:51:24.195 : nsmal:168 bytes at 0x7fcd5e20
      2017-09-24 01:51:24.195 : nsmal:normal exit
      2017-09-24 01:51:24.195 : nsbal:normal exit
      2017-09-24 01:51:24.195 : nsiorini:exit (0)
      2017-09-24 01:51:24.195 : nscpxget:entry
      2017-09-24 01:51:24.195 : snsbitts_ts:entry
      2017-09-24 01:51:24.195 : snsbitts_ts:acquired the bit
      2017-09-24 01:51:24.195 : snsbitts_ts:normal exit
      2017-09-24 01:51:24.196 : snsbitcl_ts:entry
      2017-09-24 01:51:24.196 : snsbitcl_ts:normal exit
      2017-09-24 01:51:24.196 : nscpxget:normal exit
      2017-09-24 01:51:24.196 : nsopenalloc_nsntx:nlhthput on mplx_ht_nsgbu:ctx=7fb05dd0, nsntx=7fcf5f60
      2017-09-24 01:51:24.196 : nsopenmplx:normal exit
      2017-09-24 01:51:24.196 : nsopen:opening transport...
      2017-09-24 01:51:24.196 : ntpcon:entry
      2017-09-24 01:51:24.196 : ntpcon:toc = 1
      2017-09-24 01:51:24.196 : sntpcall:entry
      2017-09-24 01:51:24.196 : sntpcall:waiting for OS to spawn process ..
      2017-09-24 01:51:24.196 : snlpcss:entry
      2017-09-24 01:51:24.197 : snlpcss:Failed to load ORASPAWN.DLL, err = 126
      2017-09-24 01:51:24.197 : sntpcall:exit
      2017-09-24 01:51:24.197 : ntpcon:exit
      2017-09-24 01:51:24.197 : nserror:entry
      2017-09-24 01:51:24.197 : nserror:nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=126, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
      2017-09-24 01:51:24.197 : nsopen:unable to open transport
      2017-09-24 01:51:24.197 : nstoClearTimeout:entry
      2017-09-24 01:51:24.197 : nstoClearTimeout:ATO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.197 : nstoClearTimeout:STO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.197 : nstoClearTimeout:RTO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.197 : nstoClearTimeout:PITO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.197 : nstoUpdateActive:entry
      2017-09-24 01:51:24.197 : nstoUpdateActive:Active timeout is -1 (see nstotyp)
      2017-09-24 01:51:24.197 : snsbitts_ts:entry
      2017-09-24 01:51:24.197 : snsbitts_ts:acquired the bit
      2017-09-24 01:51:24.197 : snsbitts_ts:normal exit
      2017-09-24 01:51:24.197 : snsbitcl_ts:entry
      2017-09-24 01:51:24.197 : snsbitcl_ts:normal exit
      2017-09-24 01:51:24.197 : nsiocancel:entry
      2017-09-24 01:51:24.197 : nsiofrrg:entry
      2017-09-24 01:51:24.197 : nsiofrrg:cur = 7f386470
      2017-09-24 01:51:24.197 : nsbfr:entry
      2017-09-24 01:51:24.197 : nsbaddfl:entry
      2017-09-24 01:51:24.197 : nsbaddfl:normal exit
      2017-09-24 01:51:24.197 : nsbfr:normal exit
      2017-09-24 01:51:24.197 : nsiofrrg:exit
      2017-09-24 01:51:24.197 : nsiocancel:exit
      2017-09-24 01:51:24.197 : nsvntx_dei:entry
      2017-09-24 01:51:24.197 : nsvntx_dei:exit
      2017-09-24 01:51:24.197 : nsopenfree_nsntx:nlhthdel from mplx_ht_nsgbu, ctx=7fb05dd0 nsntx=7fcf5f60
      2017-09-24 01:51:24.197 : nsiocancel:entry
      2017-09-24 01:51:24.197 : nsiofrrg:entry
      2017-09-24 01:51:24.197 : nsiofrrg:exit
      2017-09-24 01:51:24.197 : nsiocancel:exit
      2017-09-24 01:51:24.197 : snsbittrm_ts:entry
      2017-09-24 01:51:24.197 : snsbittrm_ts:normal exit
      2017-09-24 01:51:24.197 : snsbitts_ts:entry
      2017-09-24 01:51:24.197 : snsbitts_ts:acquired the bit
      2017-09-24 01:51:24.197 : snsbitts_ts:normal exit
      2017-09-24 01:51:24.197 : snsbitcl_ts:entry
      2017-09-24 01:51:24.197 : snsbitcl_ts:normal exit
      2017-09-24 01:51:24.197 : nsmfr:entry
      2017-09-24 01:51:24.197 : nsmfr:3536 bytes at 0x7fcf5f60
      2017-09-24 01:51:24.197 : nsmfr:normal exit
      2017-09-24 01:51:24.197 : nsmfr:entry
      2017-09-24 01:51:24.197 : nsmfr:1880 bytes at 0x7fb05dd0
      2017-09-24 01:51:24.197 : nsmfr:normal exit
      2017-09-24 01:51:24.198 : nsopen:error exit
      2017-09-24 01:51:24.198 : nsclose:entry
      2017-09-24 01:51:24.198 : nsclose:normal exit
      2017-09-24 01:51:24.198 : nladget:entry
      2017-09-24 01:51:24.198 : nladget:exit
      2017-09-24 01:51:24.198 : nsmfr:entry
      2017-09-24 01:51:24.198 : nsmfr:259 bytes at 0x7fb0a560
      2017-09-24 01:51:24.198 : nsmfr:normal exit
      2017-09-24 01:51:24.198 : nsmfr:entry
      2017-09-24 01:51:24.198 : nsmfr:304 bytes at 0x7fcd1ba0
      2017-09-24 01:51:24.198 : nsmfr:normal exit
      2017-09-24 01:51:24.198 : nladtrm:entry
      2017-09-24 01:51:24.198 : nladtrm:exit
      2017-09-24 01:51:24.198 : nscall:error exit
      2017-09-24 01:51:24.198 : nioqper: error from nscall
      2017-09-24 01:51:24.198 : nioqper:   ns main err code: 12560
      2017-09-24 01:51:24.198 : nioqper:   ns (2)  err code: 0
      2017-09-24 01:51:24.198 : nioqper:   nt main err code: 530
      2017-09-24 01:51:24.198 : nioqper:   nt (2)  err code: 126
      2017-09-24 01:51:24.198 : nioqper:   nt OS   err code: 0
      2017-09-24 01:51:24.198 : niomapnserror:entry
      2017-09-24 01:51:24.198 : niqme:entry
      2017-09-24 01:51:24.198 : niqme:reporting NS-12560 error as ORA-12560
      2017-09-24 01:51:24.198 : niqme:exit
      2017-09-24 01:51:24.198 : niomapnserror:exit
      2017-09-24 01:51:24.198 : niotns:Couldn't connect, returning 12560
      2017-09-24 01:51:24.205 : niotns:exit
      2017-09-24 01:51:24.205 : snsbittrm_ts:entry
      2017-09-24 01:51:24.205 : snsbittrm_ts:normal exit
      2017-09-24 01:51:24.205 : snsbittrm_ts:entry
      2017-09-24 01:51:24.205 : snsbittrm_ts:normal exit
      2017-09-24 01:51:24.205 : nsbfrfl:entry
      2017-09-24 01:51:24.205 : nsbrfr:entry
      2017-09-24 01:51:24.205 : nsbrfr:nsbfs at 0x7fcd5e20, data at 0x7fcf6d40.
      2017-09-24 01:51:24.205 : nsbrfr:normal exit
      2017-09-24 01:51:24.205 : nsbfrfl:normal exit
      2017-09-24 01:51:24.205 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:51:24.205 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:51:24.344 : nigini:entry
      2017-09-24 01:51:24.344 : nigini:Count in the NL global area is now 2
      2017-09-24 01:51:24.344 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:51:24.344 : nigini:exit
      2017-09-24 01:51:24.344 : niqname:Hst is already an NVstring.
      2017-09-24 01:51:24.344 : niqname:Inserting CID.
      2017-09-24 01:51:24.344 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:51:24.344 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:51:24.344 : nigini:entry
      2017-09-24 01:51:24.344 : nigini:Count in the NL global area is now 2
      2017-09-24 01:51:24.344 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:51:24.344 : nigini:exit
      2017-09-24 01:51:24.344 : niqname:Hst is already an NVstring.
      2017-09-24 01:51:24.345 : niqname:Inserting CID.
      2017-09-24 01:51:24.345 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:51:24.345 : nigtrm:Count in the NL global area is now 1
      2017-09-24 01:51:24.345 : nigini:entry
      2017-09-24 01:51:24.345 : nigini:Count in the NL global area is now 2
      2017-09-24 01:51:24.345 : nigini:Count in NI gbl area now: 2
      2017-09-24 01:51:24.345 : nigini:exit
      2017-09-24 01:51:24.345 : niqname:Hst is already an NVstring.
      2017-09-24 01:51:24.345 : niqname:Inserting CID.
      2017-09-24 01:51:24.345 : niotns:entry
      2017-09-24 01:51:24.345 : snsbitini_ts:entry
      2017-09-24 01:51:24.345 : snsbitini_ts:normal exit
      2017-09-24 01:51:24.345 : snsbitini_ts:entry
      2017-09-24 01:51:24.345 : snsbitini_ts:normal exit
      2017-09-24 01:51:24.345 : niotns:Not trying to enable dead connection detection.
      2017-09-24 01:51:24.345 : niotns:Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.345 : nsgettrans_bystring:entry
      2017-09-24 01:51:24.345 : nlpcaini:entry
      2017-09-24 01:51:24.345 : nlpcaini:prg = oracle
      2017-09-24 01:51:24.345 : nlpcaini:arg[0] = oracleORCL
      2017-09-24 01:51:24.345 : nlpcaini:arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
      2017-09-24 01:51:24.345 : nlpcaini:env[0] = =C:=C:\Windows\System32
      2017-09-24 01:51:24.345 : nlpcaini:exit
      2017-09-24 01:51:24.345 : ntgettrans:entry
      2017-09-24 01:51:24.345 : ntgettrans:exit
      2017-09-24 01:51:24.345 : nsgettrans_bystring:exit
      2017-09-24 01:51:24.345 : nscall:entry
      2017-09-24 01:51:24.345 : nsmal:entry
      2017-09-24 01:51:24.345 : nsmal:304 bytes at 0x7fcd1ba0
      2017-09-24 01:51:24.345 : nsmal:normal exit
      2017-09-24 01:51:24.345 : nscall:connecting...
      2017-09-24 01:51:24.345 : nlad_expand_hst:Result: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.345 : nlad_pr:entry
      2017-09-24 01:51:24.345 : nlad_pr:description processing
      2017-09-24 01:51:24.345 : nlad_pr:entry
      2017-09-24 01:51:24.345 : nlad_pr:Result: (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
      2017-09-24 01:51:24.345 : nlad_pr:entry
      2017-09-24 01:51:24.345 : nlad_pr:Result: (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser)))
      2017-09-24 01:51:24.345 : nlad_aand:entry
      2017-09-24 01:51:24.345 : nlad_ind:entry
      2017-09-24 01:51:24.345 : nlad_ind:exit
      2017-09-24 01:51:24.345 : nlad_aand:entry
      2017-09-24 01:51:24.346 : nlad_pr:Result: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.346 : nladini:entry
      2017-09-24 01:51:24.346 : nladini:exit
      2017-09-24 01:51:24.346 : nladget:entry
      2017-09-24 01:51:24.346 : nladget:exit
      2017-09-24 01:51:24.346 : nsmal:entry
      2017-09-24 01:51:24.346 : nsmal:259 bytes at 0x7fb0b550
      2017-09-24 01:51:24.346 : nsmal:normal exit
      2017-09-24 01:51:24.346 : nsc2addr:entry
      2017-09-24 01:51:24.346 : nsc2addr:(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\app\client\product\12.2.0\client_1\bin\sqlplus.exe)(HOST=DESKTOP-7451ANL)(USER=osuser))))
      2017-09-24 01:51:24.346 : nlpcaini:entry
      2017-09-24 01:51:24.346 : nlpcaini:prg = oracle
      2017-09-24 01:51:24.346 : nlpcaini:arg[0] = oracleORCL
      2017-09-24 01:51:24.346 : nlpcaini:arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
      2017-09-24 01:51:24.346 : nlpcaini:env[0] = =C:=C:\Windows\System32
      2017-09-24 01:51:24.346 : nlpcaini:exit
      2017-09-24 01:51:24.346 : nsc2addr:normal exit
      2017-09-24 01:51:24.346 : nsopen:entry
      2017-09-24 01:51:24.346 : nsmal:entry
      2017-09-24 01:51:24.346 : nsmal:1880 bytes at 0x7fb05dd0
      2017-09-24 01:51:24.346 : nsmal:normal exit
      2017-09-24 01:51:24.346 : nsopenmplx:entry
      2017-09-24 01:51:24.346 : nsmal:entry
      2017-09-24 01:51:24.346 : nsmal:3536 bytes at 0x7fcf6fc0
      2017-09-24 01:51:24.346 : nsmal:normal exit
      2017-09-24 01:51:24.346 : snsbitini_ts:entry
      2017-09-24 01:51:24.346 : snsbitini_ts:normal exit
      2017-09-24 01:51:24.346 : nsiorini:entry
      2017-09-24 01:51:24.346 : nsbal:entry
      2017-09-24 01:51:24.346 : nsbgetfl:entry
      2017-09-24 01:51:24.346 : nsbgetfl:normal exit
      2017-09-24 01:51:24.346 : nsmal:entry
      2017-09-24 01:51:24.346 : nsmal:168 bytes at 0x7fcd60e0
      2017-09-24 01:51:24.346 : nsmal:normal exit
      2017-09-24 01:51:24.346 : nsbal:normal exit
      2017-09-24 01:51:24.346 : nsiorini:exit (0)
      2017-09-24 01:51:24.346 : nscpxget:entry
      2017-09-24 01:51:24.346 : snsbitts_ts:entry
      2017-09-24 01:51:24.346 : snsbitts_ts:acquired the bit
      2017-09-24 01:51:24.346 : snsbitts_ts:normal exit
      2017-09-24 01:51:24.346 : snsbitcl_ts:entry
      2017-09-24 01:51:24.346 : snsbitcl_ts:normal exit
      2017-09-24 01:51:24.346 : nscpxget:normal exit
      2017-09-24 01:51:24.346 : nsopenalloc_nsntx:nlhthput on mplx_ht_nsgbu:ctx=7fb05dd0, nsntx=7fcf6fc0
      2017-09-24 01:51:24.346 : nsopenmplx:normal exit
      2017-09-24 01:51:24.346 : nsopen:opening transport...
      2017-09-24 01:51:24.346 : ntpcon:entry
      2017-09-24 01:51:24.346 : ntpcon:toc = 1
      2017-09-24 01:51:24.346 : sntpcall:entry
      2017-09-24 01:51:24.346 : sntpcall:waiting for OS to spawn process ..
      2017-09-24 01:51:24.346 : snlpcss:entry
      2017-09-24 01:51:24.348 : snlpcss:Failed to load ORASPAWN.DLL, err = 126
      2017-09-24 01:51:24.348 : sntpcall:exit
      2017-09-24 01:51:24.348 : ntpcon:exit
      2017-09-24 01:51:24.348 : nserror:entry
      2017-09-24 01:51:24.348 : nserror:nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=126, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
      2017-09-24 01:51:24.348 : nsopen:unable to open transport
      2017-09-24 01:51:24.348 : nstoClearTimeout:entry
      2017-09-24 01:51:24.348 : nstoClearTimeout:ATO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.348 : nstoClearTimeout:STO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.348 : nstoClearTimeout:RTO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.348 : nstoClearTimeout:PITO disabled for ctx=0x000001767FB05DD0
      2017-09-24 01:51:24.348 : nstoUpdateActive:entry
      2017-09-24 01:51:24.348 : nstoUpdateActive:Active timeout is -1 (see nstotyp)
      2017-09-24 01:51:24.348 : snsbitts_ts:entry
      2017-09-24 01:51:24.348 : snsbitts_ts:acquired the bit
      2017-09-24 01:51:24.348 : snsbitts_ts:normal exit
      2017-09-24 01:51:24.348 : snsbitcl_ts:entry
      2017-09-24 01:51:24.348 : snsbitcl_ts:normal exit
      2017-09-24 01:51:24.348 : nsiocancel:entry
      2017-09-24 01:51:24.348 : nsiofrrg:entry
      2017-09-24 01:51:24.348 : nsiofrrg:cur = 7f386470
      2017-09-24 01:51:24.348 : nsbfr:entry
      2017-09-24 01:51:24.348 : nsbaddfl:entry
      2017-09-24 01:51:24.348 : nsbaddfl:normal exit
      2017-09-24 01:51:24.348 : nsbfr:normal exit
      2017-09-24 01:51:24.348 : nsiofrrg:exit
      2017-09-24 01:51:24.348 : nsiocancel:exit
      2017-09-24 01:51:24.348 : nsvntx_dei:entry
      2017-09-24 01:51:24.348 : nsvntx_dei:exit
      2017-09-24 01:51:24.348 : nsopenfree_nsntx:nlhthdel from mplx_ht_nsgbu, ctx=7fb05dd0 nsntx=7fcf6fc0
      2017-09-24 01:51:24.348 : nsiocancel:entry
      2017-09-24 01:51:24.348 : nsiofrrg:entry
      2017-09-24 01:51:24.348 : nsiofrrg:exit
      2017-09-24 01:51:24.348 : nsiocancel:exit
      2017-09-24 01:51:24.348 : snsbittrm_ts:entry
      2017-09-24 01:51:24.348 : snsbittrm_ts:normal exit
      2017-09-24 01:51:24.348 : snsbitts_ts:entry
      2017-09-24 01:51:24.348 : snsbitts_ts:acquired the bit
      2017-09-24 01:51:24.348 : snsbitts_ts:normal exit
      2017-09-24 01:51:24.348 : snsbitcl_ts:entry
      2017-09-24 01:51:24.348 : snsbitcl_ts:normal exit
      2017-09-24 01:51:24.348 : nsmfr:entry
      2017-09-24 01:51:24.348 : nsmfr:3536 bytes at 0x7fcf6fc0
      2017-09-24 01:51:24.348 : nsmfr:normal exit
      2017-09-24 01:51:24.348 : nsmfr:entry
      2017-09-24 01:51:24.348 : nsmfr:1880 bytes at 0x7fb05dd0
      2017-09-24 01:51:24.348 : nsmfr:normal exit
      2017-09-24 01:51:24.348 : nsopen:error exit
      2017-09-24 01:51:24.348 : nsclose:entry
      2017-09-24 01:51:24.348 : nsclose:normal exit
      2017-09-24 01:51:24.348 : nladget:entry
      2017-09-24 01:51:24.348 : nladget:exit
      2017-09-24 01:51:24.348 : nsmfr:entry
      2017-09-24 01:51:24.348 : nsmfr:259 bytes at 0x7fb0b550
      2017-09-24 01:51:24.349 : nsmfr:normal exit
      2017-09-24 01:51:24.349 : nsmfr:entry
      2017-09-24 01:51:24.349 : nsmfr:304 bytes at 0x7fcd1ba0
      2017-09-24 01:51:24.349 : nsmfr:normal exit
      2017-09-24 01:51:24.349 : nladtrm:entry
      2017-09-24 01:51:24.349 : nladtrm:exit
      2017-09-24 01:51:24.349 : nscall:error exit
      2017-09-24 01:51:24.349 : nioqper: error from nscall
      2017-09-24 01:51:24.349 : nioqper:   ns main err code: 12560
      2017-09-24 01:51:24.349 : nioqper:   ns (2)  err code: 0
      2017-09-24 01:51:24.349 : nioqper:   nt main err code: 530
      2017-09-24 01:51:24.349 : nioqper:   nt (2)  err code: 126
      2017-09-24 01:51:24.349 : nioqper:   nt OS   err code: 0
      2017-09-24 01:51:24.349 : niomapnserror:entry
      2017-09-24 01:51:24.349 : niqme:entry
      2017-09-24 01:51:24.349 : niqme:reporting NS-12560 error as ORA-12560
      2017-09-24 01:51:24.349 : niqme:exit
      2017-09-24 01:51:24.349 : niomapnserror:exit
      2017-09-24 01:51:24.349 : niotns:Couldn't connect, returning 12560
      2017-09-24 01:51:24.355 : niotns:exit
      2017-09-24 01:51:24.355 : snsbittrm_ts:entry
      2017-09-24 01:51:24.355 : snsbittrm_ts:normal exit
      2017-09-24 01:51:24.355 : snsbittrm_ts:entry
      2017-09-24 01:51:24.355 : snsbittrm_ts:normal exit
      2017-09-24 01:51:24.355 : nsbfrfl:entry
      2017-09-24 01:51:24.355 : nsbrfr:entry
      2017-09-24 01:51:24.355 : nsbrfr:nsbfs at 0x7fcd60e0, data at 0x7fcf7da0.
      2017-09-24 01:51:24.355 : nsbrfr:normal exit
      2017-09-24 01:51:24.355 : nsbfrfl:normal exit
      2017-09-24 01:51:24.355 : nigtrm:Count in the NI global area is now 1
      2017-09-24 01:51:24.355 : nigtrm:Count in the NL global area is now 1
      
        • 1. Re: SSL error - ORA-28864: SSL connection closed gracefully
          Vlad Visan-Oracle

          1) they create the certificates without specifying the signature algorithm and by default orapki creates certificates signed in MD5 algorithm which does not work anymore in 12c

           

          So you will need to remove the wallets are recreate them. Then the certificates should be created by adding " -sign_alg sha256 " parameter.

           

          2) They create the auto login wallet as LOCAL ( -auto_login_local ), this can create some issues on Windows. At least on the Windows client create the auto login wallet with -auto_login option.

           

          Make sure you restart the listener and instance once you recreate the wallet on the server side.