Skip to Main Content

Enterprise Manager

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-12578: TNS:wallet open failed

1406869Jul 17 2019 — edited Jul 17 2019

Hi,

We have setup Oracle wallet for our DB and this was working fine.

Recently we had an our server patched, since then we have been facing wallet opening issues. Below is my wallet config

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

WALLET_LOCATION=

     (SOURCE = (METHOD=FILE)

     (METHOD_DATA=(DIRECTORY = F:\wallet))

     )

SQLNET.WALLET_OVERRIDE = TRUE

Using this wallet I'm able to login in the server with no issues, but when i use a tool to do stuff it gives me below error.

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 16 14:33:49 2019

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:

ORA-12578: TNS:wallet open failed

Enter user-name: SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

And when i change SQLNET.WALLET_OVERRIDE = FALSE, it gives invalid Credentials errors even if the credentials are correct.

We have an antivirus in place, could this be the issues can someone help and guide us.

Thanks All in advance.

Comments

Processing

Post Details

Added on Jul 17 2019
0 comments
1,293 views