Oracle Source Connector
Source connector
Oracle Source Connector
Oracle replication uses the Debezium Oracle connector. The most important Oracle-specific decisions are the database service/PDB name and the LogMiner-related settings.
Connector Class
io.debezium.connector.oracle.OracleConnector
Parameters
| Category | Parameter | Required | Recommended / Default | Description |
|---|---|---|---|---|
| Basic | name | Yes | User-defined | Unique connector name. GIFROST derives topic.prefix as <name>-server. |
| Basic | tasks.max | Yes | 1 | Keep one task for ordered log mining. |
| Database Connection | database.hostname | Yes | From Database Store | Oracle host. |
| Database Connection | database.port | Yes | 1521 | Oracle listener port. |
| Database Connection | database.user | Yes | From Database Store | User with required LogMiner privileges. |
| Database Connection | database.password | Yes | Hidden | Password or secret reference. |
| Database Connection | database.dbname | Yes | From Database Store | Oracle database or service identifier. |
| Database Connection | database.pdb.name | Conditional | From Database Store | Pluggable database name for CDB/PDB deployments. |
| Database Settings | log.mining.strategy | No | Deployment-specific | Controls how LogMiner reads redo data. |
| Database Settings | log.mining.batch.size.min / max | No | Defaults | Batch sizing for LogMiner. |
| Database Wizard | schema.include.list / schema.exclude.list | No | Generated | Schema filters. |
| Database Wizard | table.include.list / table.exclude.list | No | Generated | Table filters. |
| Database Wizard | column.include.list / column.exclude.list | No | Generated | Column filters. |
| Database Wizard | message.key.columns | Conditional | Generated | Custom keys for tables without primary keys. |
| Snapshot | snapshot.mode | No | initial | Initial loading behavior. |
| Signal | signal.data.collection | Conditional | <schemaName>.<tableName> | Signal table. |
| Events | decimal.handling.mode | No | Defaults | Controls Oracle number representation. |
| Events | lob.enabled | No | Deployment-specific | Enables LOB capture when required. |
Oracle Notes
Oracle connectors are sensitive to database privileges, archive log availability, and LogMiner configuration. Keep Database Settings unchanged unless the DBA and replication design require a different LogMiner strategy.