> ## Documentation Index
> Fetch the complete documentation index at: https://docs.alumio.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle

> Database connection for Oracle

export const FormField = ({property, label, required = false, diType, uiPatterns, children}) => {
  const patterns = Array.isArray(uiPatterns) ? uiPatterns : uiPatterns ? [uiPatterns] : [];
  return <div style={{
    margin: '1.5rem 0'
  }}>
      <div style={{
    display: 'flex',
    alignItems: 'baseline',
    flexWrap: 'wrap',
    gap: '0.5rem',
    marginBottom: '0.25rem'
  }}>
        <strong>{label}</strong>
        <span style={{
    fontSize: '0.7rem',
    fontWeight: 600,
    textTransform: 'uppercase',
    letterSpacing: '0.04em',
    color: required ? '#6241f5' : '#6b7280'
  }}>
          {required ? 'Required' : 'Optional'}
        </span>
      </div>

      <div>{children}</div>

      {diType || patterns.length > 0 ? <p style={{
    fontSize: '0.85rem',
    color: '#6b7280',
    marginBottom: 0
  }}>
          {diType ? <>
              See the <a href={`/references/${diType}`}>{diType}</a> reference.{' '}
            </> : null}
          {patterns.length > 0 ? <>
              Accepts a <a href={`/documentation/placeholders-and-patterns/patterns#${patterns[0]}`}>pattern</a>.
            </> : null}
        </p> : null}
    </div>;
};

Use this to connect Alumio to an Oracle database server. Once it is set up, the connection can be reused by other features that read from or write to your Oracle database. Oracle servers can be reached in two ways, by service name or by SID, and this connection lets you pick whichever your server uses.

This documentation describes: [Schema](/schemas/database-connection/oci-v2)

## Fields

<FormField property="host" label="Server host" required>
  The address of the Oracle server, for example `db.example.com`. This can be a domain name or an IP address.
</FormField>

<FormField property="port" label="Server port">
  The network port the server listens on. If you leave this empty it defaults to `1521`, the standard Oracle port. Change it only if your server uses a different port.
</FormField>

<FormField property="connectionType" label="Connection type">
  How Alumio should identify the database on the server. Choose **Service name** for modern or cloud Oracle servers, or **SID** for legacy servers and certain administrative tasks. If you leave it empty it behaves as Service name. The value you enter in the Database name field is interpreted according to this choice.
</FormField>

<FormField property="databaseName" label="Database name" required>
  The Oracle service name or SID to connect to, matching the connection type you selected above.
</FormField>

<FormField property="charset" label="Character set" required>
  The character set used when reading and sending data, for example `UTF8` (the default). Leave it as the default unless your database expects a specific encoding.
</FormField>

<FormField property="username" label="Username">
  The username used to sign in to the database server. Leave it empty to connect anonymously.
</FormField>

<FormField property="password" label="Password">
  The password used to sign in to the database server.
</FormField>

## Sample data

A typical Oracle connection using a service name:

| Field           | Value                      |
| --------------- | -------------------------- |
| Server host     | `your-db-host.example.com` |
| Server port     | `1521`                     |
| Connection type | `serviceName`              |
| Database name   | `ORCLPDB1`                 |
| Character set   | `UTF8`                     |
| Username        | `integration_user`         |
| Password        | `your-password`            |

```json theme={null}
{
    "host": "your-db-host.example.com",
    "port": "1521",
    "connectionType": "serviceName",
    "databaseName": "ORCLPDB1",
    "charset": "UTF8",
    "username": "integration_user",
    "password": "your-password"
}
```

Connection credentials are shown here as placeholders. See [Placeholders](/references/placeholders) for how to reference an environment variable instead of typing a secret directly.

```json Configuration theme={null}
{
  "prototype": "oci-v2",
  "parameters": {
    "host": "your-db-host.example.com",
    "port": "1521",
    "connectionType": "serviceName",
    "databaseName": "ORCLPDB1",
    "charset": "UTF8",
    "username": "integration_user",
    "password": "your-password"
  }
}
```