2.5.3 Verify the Connectivity of the Wallet

This section describes how to verify the connectivity of the Wallet.

To verify the connectivity of the wallet.
  1. Create a sqlnet.ora file in the wallet directory using the following content:
    WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY =
    <Wallet_Location>)) )
    SQLNET.WALLET_OVERRIDE=TRUE
    SSL_CLIENT_AUTHENTICATION=FALSE
  2. Test the connectivity using the following command:

    Note:

    The ORACLE_HOME used with the wallet must be the same version or higher than the wallet created.
    $ export WALLET_LOCATION=<wallet_location>
    $ export TNS_ADMIN=<tnsnames.ora_location>. If you have created a new
    tnsnames.ora file, provide the location of the new file.
    $ sqlplus /@<alias_name>
    The output is similar to:
    SQL*Plus: Release 11
    Connected to:
    Oracle Database 12c
    To verify if you are connected to the correct user:
    SQL> show user
    The output is similar to:
    USER is "<database-user-name>"