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!

SSL - wallet creation without auto_login giving "ORA-28759: failure to open file"

NRAJJun 19 2017 — edited Jul 31 2017

Hello,

I have created wallet without auto_login and sqlplus and lsnrctl failing with "ORA-28759: failure to open file".  ( wallet creation with -auto_login has NO issues)

wallet location :/oracle/product/xx.xx.xx/server_wallet

-rw------- 1 oracle dba 6240 Jun 19 13:59 ewallet.p12

It has created with oracle user and have read permission for oracle user. Password is correct. SQLNET.ora has proper wallet path entry. I have opened the wallet using OWM but still getting error.

SQLNET.ora

SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS)

SSL_VERSION = 1.0

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SSL_CLIENT_AUTHENTICATION = FALSE

WALLET_LOCATION =

  (SOURCE =

    (METHOD = FILE)

    (METHOD_DATA =

      (DIRECTORY = /oracle/product/xx.xx.xx/server_wallet)

    )

  )

LSNRCTL STATUS

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=xxxxx)(PORT=1xx1)))

ORA-28759: failure to open file

TNS-12560: TNS:protocol adapter error

  TNS-00540: SSL protocol adapter failure

sqlplus connection:

Enter password:

ERROR:

ORA-28759: failure to open file

Anyone encountered such issue? If so please help me to resolve it.

Thanks,

Raj

This post has been answered by Vlad Visan-Oracle on Jun 20 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2017
Added on Jun 19 2017
4 comments
3,031 views