# 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;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-replication-main/target-setup/oracle/oracle-with-wallet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.