# Oracle ## Establishing a Connection ### 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](https://docs.appstrategy.com/apprules-r-documentation/appendix/miscellaneous/editing-environment-variables) ### 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. ![](https://1923141441-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MFjmFrZ8sef1J7qkr6H%2F-MIONFBnzlk-D6Zy7bfO%2F-MIOSkrXg70sA6scKmIa%2Fimage.png?alt=media\&token=d9bf581f-a975-43b0-b7fc-4604861cc4a4) ***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](https://docs.appstrategy.com/apprules-r-documentation/appendix/miscellaneous/connection-common-properties)