# Oracle

## Establishing a Connection <a href="#default" id="default"></a>

### Before you Connect

To connect to Oracle, you'll first need to update the appropriate environment variable and ensure it contains a folder location that includes the Oracle OCI Library assemblies.

If appRules is already installed on your computer, a windows PATH variable to \[Installation Folder]/appStrategy/appRules/bin/x64 must have been created by the Installer.

If not, create it manually : [see here](/apprules-r-documentation/appendix/miscellaneous/editing-environment-variables.md)&#x20;

### Connecting to Oracle OCI

The following are the properties for connecting to Oracle. The required properties are identified using the \*\*\* characters.

If a connection property value has special characters such as semicolons, single quotes, spaces, etc., then you must quote the value using either single or double quotes.

![](/files/-MIOSkrXg70sA6scKmIa)

***Server\*\*\****

The host name or IP of the server hosting the Oracle database.

***Port\*\*\****\
The port used to connect to the server hosting the Oracle database.

***Service Name\*\*\****\
The service name of the Oracle database.

***User\*\*\****

The Oracle OCI user account used to authenticate.

***Password\*\*\****

The password used to authenticate the user.

***Browsable Schemas\*\*\****

Comma-separated list of schemas to restrict browse-able database object tree.

***Datasource***\
Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect.

| **Connection Life Time** | The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. |
| ------------------------ | -------------------------------------------------------------------------------------------------------------- |

| Max Lob Size | The volume in numbers of bytes or UTF-8 chars which is allowed to query by non-parameterized SELECT query. |
| ------------ | ---------------------------------------------------------------------------------------------------------- |

| Pool Idle Timeout | The allowed idle time for a connection before it is closed. |
| ----------------- | ----------------------------------------------------------- |
| Pool Max Size     | The maximum connections in the pool.                        |
| Pool Min Size     | The minimum number of connections in the pool.              |
| Pool Wait Time    | The max seconds to wait for an available connection.        |

Other properties (Proxy...) are detailed in section [common properties](/apprules-r-documentation/appendix/miscellaneous/connection-common-properties.md)


---

# 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.appstrategy.com/apprules-r-documentation/platform/platform-features/system-settings/data-sources/connection-settings/databases/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.