Oracle with Wallet

Pre-requisites for enabling Oracle Wallet

1. TNS_ADMIN windows environmental variable needs to be set. This will be the location of “tnsnames.ora” file. Store tnsnames.ora inside the oracle wallet. Set TNS_ADMIN to oracle wallet.

   
2. tnsnames.ora contains the alias for wallet entry. See image below:

   
3. Wallet can be created using the below commands: mkstore -wrl /path/to/wallet -create

mkstore -wrl /path/to/wallet -createCredential mydb myuser mypassword

mkstore -wrl /path/to/wallet -enableAutoLogin

You need to install Oracle Client 19c to use mkstore. (https://www.oracle.com/in/database/technologies/oracle19c-windows-downloads.html)

1. If you are running the program as a service (service install dbsync), you need to start the program as a system account from services.msc. See image below.

For enabling Oracle Wallet on the Oracle database connector tab, there will be a check box.

On selecting the check box, the user will enable the Oracle wallet

Once Oracle Wallet is enabled user will have to put in the following information

1. Schema - Schema of database

2. TNS Name - The TNS Name (a user-friendly alias for a database connection)

3. Wallet Location- Location of Oracle wallet

4. URL- It will be automatically updated according to the connection parameters passed by the user