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

# Oracle Database Connector

> Connect Oracle Database as a source or destination in Zwiron, including LogMiner CDC.

Zwiron supports Oracle Database 12c+ as a source and destination, with CDC via Oracle LogMiner.

***

## Connection details

| Field        | Description                           |
| ------------ | ------------------------------------- |
| Host         | Hostname or IP of the Oracle server   |
| Port         | Default: `1521`                       |
| Service name | Oracle service name (e.g. `ORCLPDB1`) |
| Username     | Oracle user for Zwiron                |
| Password     | User's password                       |

***

## Permissions

### Source

```sql theme={null}
CREATE USER zwiron IDENTIFIED BY your_password;
GRANT CREATE SESSION TO zwiron;
GRANT SELECT ANY TABLE TO zwiron;
GRANT SELECT ANY DICTIONARY TO zwiron;
```

### CDC (LogMiner)

```sql theme={null}
GRANT EXECUTE ON DBMS_LOGMNR TO zwiron;
GRANT EXECUTE ON DBMS_LOGMNR_D TO zwiron;
GRANT SELECT ON V_$LOG TO zwiron;
GRANT SELECT ON V_$LOG_HISTORY TO zwiron;
GRANT SELECT ON V_$LOGMNR_LOGS TO zwiron;
GRANT SELECT ON V_$LOGMNR_CONTENTS TO zwiron;
GRANT LOGMINING TO zwiron;
```

Enable supplemental logging on the database:

```sql theme={null}
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
```

**Supported sync modes:** Full Refresh ✅ | Incremental ✅ | CDC ✅