4.5.2 Verify the Connectivity of the Wallet

To verify the connectivity of the wallet, follow these steps:

  1. 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>"