Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

open wallet failed when use ssl to connect oracle 18c xe

3776300Apr 15 2019 — edited Apr 15 2019

this is the trace log

2019-04-15 14:54:02.963 : ntzgsvp:no SSL version specified - using default version 0

2019-04-15 14:54:02.963 : ntzgcpp:no SSL cipher suites specified

2019-04-15 14:54:02.963 : ntzgcap:retrieved value "FALSE" for client authentication parameter

2019-04-15 14:54:02.963 : ntzGetStringParameter:found value for "wallet_location" configuration parameter: "SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = C:\app\sd))"

2019-04-15 14:54:02.963 : ntzAllocate:allocating 67 bytes of memory.

2019-04-15 14:54:02.963 : ntzAllocate:allocating 18 bytes of memory.

2019-04-15 14:54:02.963 : ntzGetWRLFromDatabaseCallback:SERVICE_NAME available and WRL type is NZTTWRL_FILE, checking to see if per-PDB wallet for TLS is available.

2019-04-15 14:54:02.963 : nzosReadCertParams:sslconf.ora location is..

2019-04-15 14:54:02.963 : nzosReadCertParams:C:\app\myuser\product\18.0.0\dbhomeXE\ldap\admin\sslconf.ora

2019-04-15 14:54:02.963 : nzosReadConfFile:sslconf.ora file could not be opened. Continuing.

2019-04-15 14:54:02.963 : nzupgew_get_environ_wrl:Environment Variable not found or empty value.

2019-04-15 14:54:02.963 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument ..

2019-04-15 14:54:02.964 : nzupgew_get_environ_wrl:Environment Variable not found or empty value.

2019-04-15 14:54:02.964 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument ..

2019-04-15 14:54:02.964 : nzupgew_get_environ_wrl:Environment Variable not found or empty value.

2019-04-15 14:54:02.964 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument ..

2019-04-15 14:54:02.964 : nzupgew_get_environ_wrl:Environment Variable not found or empty value.

2019-04-15 14:54:02.964 : nzupawp_apply_wrl_policy:Using wallet locator from caller argument ..

2019-04-15 14:54:02.964 : snzdfo_open_file:Opening file C:\app\sd\ewallet.p12 with READ ONLY permissions

2019-04-15 14:54:02.964 : snzdfo_open_file:Opening file C:\app\sd\cwallet.sso with READ ONLY permissions

2019-04-15 14:54:02.964 : snzdfo_open_file:File Open/Close error

2019-04-15 14:54:02.964 : nzdfo_open:File Open/Close error

2019-04-15 14:54:02.965 : nziropen:rio open failed with error 28759

2019-04-15 14:54:02.965 : nzdtrsr_store_certreq:nziropen() returned error 28759

2019-04-15 14:54:02.965 : nzswFRFileRetrieve:Call to unlock file (UnlockFileEx) failed.

2019-04-15 14:54:02.965 : nztwOpenWallet:Could not open wallet from file:C:\app\sd: NZ error 28759

2019-04-15 14:54:02.965 : ntzlogin:Wallet open failed with error 28759

2019-04-15 14:54:02.965 : ntzlogin:returning NZ error 28759 in result structure

2019-04-15 14:54:02.965 : ntzlogin:failed with error 540

2019-04-15 14:54:02.965 : ntzConfigure:failed with error 540

2019-04-15 14:54:02.965 : ntzCreateConnection:failed with error 540

2019-04-15 14:54:02.993 : ntzconnect:failed with error 540

2019-04-15 14:54:02.993 : nserror:nsres: id=3, op=65, ns=12560, ns2=0; nt[0]=540, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0

2019-04-15 14:54:02.993 : nsopen:unable to open transport

2019-04-15 14:54:02.993 : nstoClearTimeout:ATO disabled for ctx=0x0000000001F27C80

2019-04-15 14:54:02.993 : nstoClearTimeout:STO disabled for ctx=0x0000000001F27C80

2019-04-15 14:54:02.993 : nstoClearTimeout:RTO disabled for ctx=0x0000000001F27C80

2019-04-15 14:54:02.993 : nstoClearTimeout:PITO disabled for ctx=0x0000000001F27C80

2019-04-15 14:54:02.993 : nstoUpdateActive:Active timeout is -1 (see nstotyp)

2019-04-15 14:54:02.993 : nsglhc:nsanswer error 12560

2019-04-15 14:54:02.993 : nsglhc:Deallocating cxd 0x1f284c0.

listener:

# listener.ora Network Configuration File: C:\app\myuser\product\18.0.0\dbhomeXE\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = xe)

      (ORACLE_HOME = C:\app\myuser\product\18.0.0\dbhomeXE)

      (SID_NAME = xe)

    )

  )

SSL_CLIENT_AUTHENTICATION = FALSE

WALLET_LOCATION =

  (SOURCE =

    (METHOD = FILE)

    (METHOD_DATA =

      (DIRECTORY = C:\app\sd)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.177.79.234)(PORT = 1521))

    )

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCPS)(HOST = 10.177.79.234)(PORT = 2484))

    )

  )

ADR_BASE_LISTENER = C:\app\myuser\product\18.0.0\dbhomeXE\log

SAVE_CONFIG_ON_STOP_LISTENER = TRUE

TRACE_LEVEL_LISTENER = USER

Comments
Post Details
Added on Apr 15 2019
0 comments
864 views