# Oracle

The Oracle connector is available as a [Connector Service](/release-information/connector-services.md) as of Flow 6.14.

For documentation about how to connect to Oracle using the Database Connector bundled with Flow Server, [click here](/connectors/areas/business-systems/database.md).

### Introduction

The Oracle Connector Service is used to integrate with Oracle with version number 10 and upwards. Oracle changed its version numbering system from version 12, to reflect the year of release instead. After versions 12c, 18c and 19c were released. The letter ‘c’ stands for Oracle Cloud.

### Configuration

| Setting                               | Description                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| ------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Hostname**                          | IP address or host name.                                                                                                                                                                                                                                                                                                                                                                                                                    |
| **Port**                              | Port number. The standard port is 1521.                                                                                                                                                                                                                                                                                                                                                                                                     |
| **Username/Password**                 | The user credentials for the (global) database user.                                                                                                                                                                                                                                                                                                                                                                                        |
| **Service Name or SID Type Selector** | <p>Choose which type of name is given</p><p><strong>Service Name</strong>: Service name is the TNS alias that you give when you remotely connect to your database and this Service name is recorded in Tnsnames</p><p><strong>SID</strong>: Oracle SID is the unique name that uniquely identifies your instance/database. </p>                                                                                                             |
| **Initialization Command**            | Optional command to execute immediately after successful login.                                                                                                                                                                                                                                                                                                                                                                             |
| **Cleanup Command**                   | An optional command to execute on the database after the operation has been completed.                                                                                                                                                                                                                                                                                                                                                      |
| **Command Timeout**                   | Command timeout, in seconds, to use when executing a script or a query. If not set, the default value will be used (usually 30 seconds). Please note that this is the timeout between Flow Server and database. The communication between Flow Client and Flow server may timeout before the command timeout. If the client experiences timeout, but the database command does not, the database command will still be executed completely. |
| **Connection Timeout**                | The timeout, in seconds, for establishing a connection to the Oracle Server.                                                                                                                                                                                                                                                                                                                                                                |
| **Connection Pooling**                | Sets whether connection pooling should be used.                                                                                                                                                                                                                                                                                                                                                                                             |
| **Override Connection String**        | If a connection string is specified here, it will be used instead of the one generated from the settings above.                                                                                                                                                                                                                                                                                                                             |


---

# 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://help.novacuraflow.com/connectors/areas/business-systems/database/oracle.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.