# 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.<br>

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdPQQbsrJiPQGBsmfzZkYh6G4MggeFwIICbQcZRgU00ewUeD2lxnUtGOiTX8pZYaLKNqbkRnMtYXAgGlj4tdBMjufSP5_glD9L6VZocIIGYe_X4lPnftkjgppi_4VKQbB4k7yo-PA?key=zSxzIyxjJppN7v8R0r7Ck0_8" alt=""><figcaption></figcaption></figure>
2. tnsnames.ora contains the alias for wallet entry. See image below:\ <br>

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeA4K2sCLWasm4C7vq36Nh2TolbLEJyWKJV59gO5rKO4GN7zpO6UQVWDfgFBQ5n57_qCEqyAGTRCmfwjYpH3yVDViHRIqwfhgRkS91oUeKdcU8PeeukYVFcjgLx-4bq5yeM3H3zTw?key=zSxzIyxjJppN7v8R0r7Ck0_8" alt=""><figcaption></figcaption></figure>
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>)

\ <br>

4. 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.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXd8A-Qkf2BbMcHqbH4jGnVKwepHQ3_xEuYWnrMnrK6ExndGBf6fLb4ksgluFy33kapzL1yelLrdtcXOnqmnBGyOyZh02bt4T-G9Ih2QjJglOPbRrOslrzj3o2hyL9dW0gezK3eXXg?key=zSxzIyxjJppN7v8R0r7Ck0_8" alt=""><figcaption></figcaption></figure>

<br>

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

<figure><img src="https://1807783010-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrJ01SyijpwGkw5NZTFOA%2Fuploads%2FwKS04wdIXBpH4MvyjmL2%2FWallet%20enabledtns.jpg?alt=media&#x26;token=731e4340-8ba6-469f-a226-a9863e1817e7" alt=""><figcaption></figcaption></figure>

Once Oracle Wallet is enabled user will have to put in the following information&#x20;

1. Schema - Schema of database&#x20;
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&#x20;