Skip to content

SYSTEM Cited by 1 source

Oracle Database

Oracle Database is a commercial, widely-deployed relational database management system (RDBMS) from Oracle Corporation. It is the archetypal "crown-jewel OLTP" system in many enterprises — often running for decades, holding mission- critical transactional data, and sitting at the centre of the corporate data landscape.

Stub page — this page exists primarily as the canonical wiki home for Oracle-specific substrate concepts that Redpanda's 2026- 04-09 Oracle CDC launch post canonicalises (LogMiner, Oracle Wallet, ALL_TAB_COLUMNS, NUMBER type, auto-login wallet formats). Expand on future Oracle-internals sources.

Editions relevant to CDC

  • Oracle Enterprise Edition — ships LogMiner and other advanced features. LogMiner is the substrate that CDC ecosystems (Debezium Oracle connector, Redpanda Connect oracledb_cdc, GoldenGate, others) consume.
  • Oracle Standard Edition — does not include LogMiner; CDC via redo-log mining is not possible without upgrading to Enterprise.

CDC substrate surface

Oracle exposes several change-capture surfaces that downstream CDC ecosystems compose on:

  • LogMiner — Enterprise Edition utility for reconstructing row-level change events from the redo log. The substrate behind Debezium Oracle connector, Redpanda Connect Oracle CDC, and others.
  • Oracle GoldenGate — Oracle's own commercial replication product (separate licensing).
  • Triggers + shadow tables — the pre-LogMiner classical approach (invasive, performance-impacting).

For CDC-ecosystem framing see CDC driver ecosystem.

Data-dictionary views relevant to CDC

  • ALL_TAB_COLUMNS — data-dictionary view exposing full column metadata (name, data type, precision, scale, nullability, default value) for all tables accessible to the current user. Named by the Redpanda Connect Oracle CDC post as the schema-tracking source feeding downstream Avro/Schema Registry integration, with precision-aware NUMBER → typed- value mapping.

Auth substrates

  • Plain-text user/password in connection string — dev default, fails compliance review.
  • Oracle Wallet — file-based credential store. Two formats: cwallet.sso auto-login (no password) and ewallet.p12 PKCS#12 (password-protected). Canonical compliance substrate for regulated environments.

Seen in

  • sources/2026-04-09-redpanda-oracle-cdc-now-available-in-redpanda-connect — canonical first wiki disclosure of Oracle as a Redpanda Connect CDC source database (sixth engine in the family). Names LogMiner as the underlying change-capture substrate, ALL_TAB_COLUMNS as the schema-tracking view, and Oracle Wallet as the file-based credential-store substrate for regulated environments. Competitive framing against Kafka-Connect-hosted Debezium on the single-binary vs JVM-+-Kafka-Connect-cluster axis.
Last updated · 470 distilled / 1,213 read