0 Replies Latest reply on Jul 17, 2019 9:53 AM by 1406869

    ORA-12578: TNS:wallet open failed

    1406869
    1406869 Jul 17, 2019 9:53 AM

      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.