# Oracle
URL: https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/dc-oracle.html

# Oracle

There are two data connection types for Oracle Database: Service Name and SID. Use the appropriate parameters for the connection path you use to connect to Oracle Database.

## Supported authentication

- Username/password for both Service Name and SID

## Prerequisites

The following is required before connecting to Oracle in DataRobot:

- Oracle Database account

## Required parameters

### Service Name

The table below lists the minimum required fields to establish a connection with Oracle (Service Name):

| Required field | Description | Documentation |
| --- | --- | --- |
| address | The connection URL that supplies connection information for Oracle. | Oracle documentation |
| serviceName | Specifies name used to connect to an instance. | Oracle documentation |

### SID

The table below lists the minimum required fields to establish a connection with Oracle (SID):

| Required field | Description | Documentation |
| --- | --- | --- |
| address | The connection URL that supplies connection information for Oracle.Example: | Oracle |
| SID | A unique identifier for your database. | Oracle documentation |
| port | A unique identifier for your database. | Oracle documentation |

## Troubleshooting

| Problem | Solution | Instructions |
| --- | --- | --- |
| When attempting to execute an operation in DataRobot, the firewall requests that you clear the IP address each time. | Add all allowed IPs for DataRobot. | See Allowed source IP addresses. If you've already added the allowed IPs, check the existing IPs for completeness. |

---
