> For the complete documentation index, see [llms.txt](https://ai2sql.gitbook.io/ai2sql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ai2sql.gitbook.io/ai2sql/9.-database-connectors/9.2.1.-ai2sql-oracle-cloud-connector.md).

# 9.2.1. AI2sql Oracle Cloud Connector

A Comprehensive Setup Guide'. This guide provides straightforward instructions for integrating AI2sql with Oracle Cloud. It covers installation, configuration, firewall setup, and troubleshooting to ensure a smooth and secure connection between AI2sql and your Oracle Cloud database.

* **Select Oracle Cloud Connector**: In AI2sql, locate and select the option for connecting to an Oracle Cloud database.

<figure><img src="/files/vdGMRROJcz1yAEC43Kkd" alt=""><figcaption></figcaption></figure>

* **Connection Details**:
  * Enter the **Connection Name**: A unique identifier for this connection.
  * Specify the **DSN (Data Source Name)**: The DSN corresponding to your Oracle Cloud database.
  * Provide the **Owner Name**: The owner's name of the Oracle Cloud database.
  * Input **User**: The username for accessing the Oracle Cloud database.
  * Set the **Password**: The password associated with your database user.

<figure><img src="/files/gMrKuHOiRfqkIQT5lQ7E" alt=""><figcaption></figcaption></figure>

* **Test Connection**: After entering all details, use the test feature in AI2sql to ensure that the connection is correctly set up and functioning.
* **Save and Use**: Once the connection is successfully tested, save the settings and start using the connector for your data operations.
* **Configure Firewall for AI2sql Access**:
  * **Access Firewall Settings**: Open the firewall settings on the system or network that hosts the Oracle Cloud database.
  * **Add Rules/Exceptions**: Create rules or exceptions to allow traffic from AI2sql to Oracle Cloud. This typically involves specifying the IP addresses or domain names used by AI2sql, and opening the relevant ports used for database communication.
* **Finalize and Test**:
  * After configuring the firewall, retest the connection in AI2sql to ensure that the Oracle Cloud database is accessible with the new firewall settings in place.

For the most specific and detailed instructions, please consult the official documentation of AI2sql, as the actual process might have unique steps or additional requirements based on the software version and specific Oracle Cloud configurations.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://ai2sql.gitbook.io/ai2sql/9.-database-connectors/9.2.1.-ai2sql-oracle-cloud-connector.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.