> For the complete documentation index, see [llms.txt](https://docs.mydbsync.com/cloud-replication-main/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mydbsync.com/cloud-replication-main/target-setup/oracle/oracle-with-wallet.md).

# 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="/files/8oRTBHpC5QHMiXaXhZh8" 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;