🔥 connect/connect-cdc-xstream-oracle19-source #7421
Description
🆕💥 New issue !
👍 CP 8.1.1 🕐 2025-12-04 09:52 📄 cdc-xstream-oracle19-blocking-snapshot.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/19921980533/job/57113131357
🔥 CP 8.1.1 🕐 2025-12-04 09:56 📄 cdc-xstream-oracle19-mtls-wallet.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/19921980533/job/57113131357
Logs
09:52:29 ℹ️ 💀 kill all docker containers (disable with 'playground config container-kill-all-before-run false')
09:52:29 ℹ️ 💀 kill all docker containers
09:52:30 ℹ️ 🚀 Running example with flags
09:52:30 ℹ️ ⛳ Flags used are --tag=8.1.1
09:52:31 ℹ️ 🚀 Number of examples ran so far: 10
09:52:31 ℹ️ 🤖CI status: 🟢 ok
🔗test url: https://github.com/vdesabou/kafka-docker-playground/actions/runs/19904250606/job/57056918497
09:52:31 ℹ️ ####################################################
09:52:31 ℹ️ 🚀 Executing cdc-xstream-oracle19-mtls-wallet.sh in dir /home/runner/work/kafka-docker-playground/kafka-docker-playground/connect/connect-cdc-xstream-oracle19-source
09:52:31 ℹ️ ####################################################
09:52:31 ℹ️ 🧰 Checking if Docker image confluentinc/cp-server-connect-base:8.1.1 contains additional tools
09:52:31 ℹ️ ⏳ it can take a while if image is downloaded for the first time
09:52:32 ℹ️ Using sudo to remove /home/runner/work/kafka-docker-playground/kafka-docker-playground/scripts/../confluent-hub
09:52:32 ℹ️ 🎱 Installing connector confluentinc/kafka-connect-oracle-xstream-cdc-source:latest
Downloading component Kafka Connect Oracle XStream Connector 1.3.0, provided by Confluent, Inc. from Confluent Hub and installing into /usr/share/confluent-hub-components
09:52:35 ℹ️ 💫 Using connector:
09:52:35 ℹ️ 🔗 Plugin: confluentinc/kafka-connect-oracle-xstream-cdc-source:1.3.0
09:52:35 ℹ️ 📅 Release date: 2025-10-31
09:52:35 ℹ️ 🌐 Documentation: https://docs.confluent.io/kafka-connectors/oracle-xstream-cdc-source/current
09:52:35 ℹ️ 🎓 To specify different version, check the documentation https://kafka-docker-playground.io/#/how-to-use?id=🔗-for-connectors
09:52:35 ℹ️ 🛰️ Starting up Confluent Platform in Kraft mode as ENABLE_KRAFT environment variable is set
09:52:35 ℹ️ ✨ Using Oracle prebuilt image db-prebuilt-2943665357:19.3.0-ee (oracle version 🔢 19.3.0-ee and 📂 setup folder ../../connect/connect-cdc-oracle19-source/ora-setup-scripts-cdb-table)
09:52:35 ℹ️ 🛑 SQL_DATAGEN is not set
/home/runner/work/kafka-docker-playground/kafka-docker-playground/connect/connect-cdc-xstream-oracle19-source
09:52:35 ℹ️ Starting up oracle container to get generated cert from oracle server wallet
time="2025-12-04T09:52:35Z" level=warning msg="The "flink_connectors" variable is not set. Defaulting to a blank string."
time="2025-12-04T09:52:35Z" level=warning msg="The "flink_connectors" variable is not set. Defaulting to a blank string."
time="2025-12-04T09:52:35Z" level=warning msg="The "flink_connectors" variable is not set. Defaulting to a blank string."
Network plaintext_default Creating
Network plaintext_default Created
Container oracle Creating
Container oracle Created
Container oracle Starting
Container oracle Started
09:52:35 ℹ️ Setting up SSL on oracle server...
09:52:35 ℹ️ Create a wallet for the test CA
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
09:52:38 ℹ️ Create a wallet for the Oracle server
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
09:52:41 ℹ️ You now have the following files under the /tmp/server directory
cert.txt
creq.txt
cwallet.sso
cwallet.sso.lck
ewallet.p12
ewallet.p12.lck
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
{ fingerprint = fe50cdcf0b065400d0de356e4d870872, notBefore = Thu Dec 04 09:52:41 UTC 2025, notAfter = Sun Dec 02 09:52:41 UTC 2035, holder = CN=server,C=US, issuer = CN=root_test,C=US, serialNo = 0, sigAlgOID = SHA256withRSA, key = { modulus = 27153056396525785848288969332650134630042670997015128583720982308052926595260027825038657173632128984214409580501348332716592798433458229323900038941654405368722757456640191254089992533801494262617514320737435963360184646468655625571760416220475606218686999881820089155517943522087111289576707001351215821387567075592845448808551589358429068722714811459310848930418004245255187018895514174615261272442218785136535921039364240288404363358929828249712665139281288211176173935146086265827434504103804618715911145927830839031000319399901524995012336500654256962364592820665264601238938069943875820015444851486666273477399, exponent = 65537 } }
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
{ fingerprint = ab75fc9cc1dcbbf15138d68d193edd44, notBefore = Thu Dec 04 09:52:48 UTC 2025, notAfter = Sun Dec 02 09:52:48 UTC 2035, holder = CN=connect,C=US, issuer = CN=root_test,C=US, serialNo = 0, sigAlgOID = SHA256withRSA, key = { modulus = 21711050234936743226185949891121275536805352240231882885872382560292584623577429987099174490714849728291964257932469311508079434174322325848362165786810734067690622039245425033068898010025533579065565741014992703814044840967345441462400341332414810446790036814583723244363880755783836018487276040862474085650389514136418082863326317557669789440012920956486429292915291710223833624457194233692748380456361903570284510491388528206979131068882819764449561151437301259077376753519734009628645136749036396166819976682280915025593223219411361622427182519160761833847829772246442589144352094369695673157253483774388299517081, exponent = 65537 } }
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
09:52:50 ℹ️ Update listener.ora, sqlnet.ora and tnsnames.ora
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-DEC-2025 09:52:51
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Trace information written to /opt/oracle/diag/tnslsnr/oracle/listener/trace/ora_894_139961248209984.trc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=1532)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
###################################################################
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 04-DEC-2025 09:52:51
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level support
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listener Trace File /opt/oracle/diag/tnslsnr/oracle/listener/trace/ora_894_139961248209984.trc
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=1532)))
The listener supports no services
The command completed successfully
LSNRCTL> 09:52:51 ℹ️ Sleeping 60 seconds
09:53:51 ℹ️ 🛑 zookeeper is disabled
09:53:51 ℹ️ 🛑 control-center is disabled
09:53:51 ℹ️ 🛑 Starting services without Flink
09:53:51 ℹ️ 🛑 ksqldb is disabled
09:53:52 ℹ️ 🛑 REST Proxy is disabled
09:53:52 ℹ️ 🛑 Grafana is disabled
09:53:52 ℹ️ 🛑 kcat is disabled
09:53:52 ℹ️ 🛑 conduktor is disabled
Container oracle Running
Container controller Creating
Container prometheus-c3-v2 Creating
Container prometheus-c3-v2 Created
Container controller Created
Container broker Creating
Container alertmanager-c3-v2 Creating
Container alertmanager-c3-v2 Created
Container broker Created
Container schema-registry Creating
Container schema-registry Created
Container connect Creating
Container connect Created
Container prometheus-c3-v2 Starting
Container controller Starting
Container prometheus-c3-v2 Started
Container alertmanager-c3-v2 Starting
Container controller Started
Container broker Starting
Container alertmanager-c3-v2 Started
Container broker Started
Container schema-registry Starting
Container schema-registry Started
Container connect Starting
Container connect Started
09:53:55 ℹ️ ✨ If you modify a docker-compose file and want to re-create the container(s), run cli command 'playground container recreate'
09:53:55 ℹ️ ⌛ Waiting up to 300 seconds for connect to start
09:54:29 ℹ️ 🚦 containers have started!
09:54:29 ℹ️ 🔏 copy cwallet.sso to connect container
09:54:29 ℹ️ 🪄👑 Executing command as root in container connect with bash
09:54:29 ℹ️ 🪄👑 Executing command as root in container connect with bash
sed: can't read /etc/yum.repos.d/adoptium.repo: No such file or directory
09:54:29 ℹ️ 🪄👑 Executing command as root in container connect with bash
(microdnf:242): librhsm-WARNING **: 09:54:29.916: Found 0 entitlement certificates
(microdnf:242): librhsm-WARNING **: 09:54:29.948: Found 0 entitlement certificates
Downloading metadata...
Downloading metadata...
Downloading metadata...
Package Repository Size
Installing:
libaio-0.3.111-13.el9.x86_64 ubi-9-baseos-rpms 27.1 kB
Transaction Summary:
Installing: 1 packages
Reinstalling: 0 packages
Upgrading: 0 packages
Obsoleting: 0 packages
Removing: 0 packages
Downgrading: 0 packages
Downloading packages...
warning: Unsupported version of key: V6
(microdnf:242): libdnf-WARNING **: 09:54:31.069: failed to parse public key for /etc/pki/rpm-gpg/RPM-GPG-KEY-PQC-redhat-release
Running transaction test...
Installing: libaio;0.3.111-13.el9;x86_64;ubi-9-baseos-rpms
Complete.
09:54:31 ℹ️ 🪄👑 Executing command as root in container connect with bash
(microdnf:304): librhsm-WARNING **: 09:54:31.392: Found 0 entitlement certificates
(microdnf:304): librhsm-WARNING **: 09:54:31.425: Found 0 entitlement certificates
Package Repository Size
Installing:
libnsl2-2.0.0-1.el9.x86_64 ubi-9-appstream-rpms 33.3 kB
libtirpc-1.3.3-9.el9.x86_64 ubi-9-baseos-rpms 98.9 kB
Transaction Summary:
Installing: 2 packages
Reinstalling: 0 packages
Upgrading: 0 packages
Obsoleting: 0 packages
Removing: 0 packages
Downgrading: 0 packages
Downloading packages...
warning: Unsupported version of key: V6
(microdnf:304): libdnf-WARNING **: 09:54:31.555: failed to parse public key for /etc/pki/rpm-gpg/RPM-GPG-KEY-PQC-redhat-release
Running transaction test...
Installing: libtirpc;1.3.3-9.el9;x86_64;ubi-9-baseos-rpms
Installing: libnsl2;2.0.0-1.el9;x86_64;ubi-9-appstream-rpms
Complete.
09:54:31 ℹ️ 🪄👑 Executing command as root in container connect with bash
09:54:31 ℹ️ ⌛ Waiting up to 600 seconds for message DATABASE IS READY TO USE to be present in oracle container logs...
DATABASE IS READY TO USE!
09:54:31 ℹ️ The log is there !
09:54:31 ℹ️ Oracle DB has started!
09:54:31 ℹ️ Enable Oracle XStream
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:32 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL>
System altered.
SQL> SQL>
NAME TYPE VALUE
enable_goldengate_replication boolean TRUE
resource_manage_goldengate boolean FALSE
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:54:33 ℹ️ Configure ARCHIVELOG mode
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:33 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> ORA-01012: not logged on
SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> 09:54:33 ℹ️ Configure supplemental logging
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:33 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL>
Session altered.
SQL>
Database altered.
SQL>
SUPPLEME SUP
IMPLICIT YES
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:34 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> SQL> 2
Tablespace created.
SQL> SQL> SQL> 2
Tablespace created.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:35 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL>
Session altered.
SQL> SQL> SQL> 2
Tablespace created.
SQL> SQL> SQL> 2
Tablespace created.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:54:36 ℹ️ Create a new common user for the XStream administrator
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:36 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> 2 3 4
User created.
SQL> SQL>
Grant succeeded.
SQL> SQL> 2 3 4 5 6 7 8 9
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:54:40 ℹ️ Create a new common user for the XStream connect user
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:40 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> 2 3 4
User created.
SQL> SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL> SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL> SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:54:41 ℹ️ Creating XStream Out
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:41 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:47 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> 2 3 4 5 6
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:54:48 ℹ️ Create CUSTOMERS table and inserting initial data
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:54:48 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> SQL> 2 3 4 5 6 7 8 9 10 11
Table created.
SQL> SQL> 2 3 4 5 6 7 8 9 10
Trigger created.
SQL> SQL>
1 row created.
SQL>
1 row created.
SQL>
1 row created.
SQL>
1 row created.
SQL>
1 row created.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:54:49 ℹ️ Creating Oracle Xstream CDC source connector
09:54:51 ℹ️ 🛠️ Creating 🌎onprem connector cdc-xstream-oracle-source
09:54:51 ℹ️ ✅ 🌎onprem connector cdc-xstream-oracle-source was successfully created
09:54:53 ℹ️ 🔩 list of all available parameters for 🌎onprem connector cdc-xstream-oracle-source (io.confluent.connect.oracle.xstream.cdc.OracleXStreamSourceConnector) and version 1.3.0 (with default value when applicable)
"binary.handling.mode": "bytes",
"column.exclude.list": "",
"column.include.list": "",
"database.dbname": "",
"database.hostname": "",
"database.os.timezone": "Z",
"database.out.server.name": "",
"database.password": "",
"database.pdb.name": "",
"database.port": "1521",
"database.processor.licenses": "",
"database.service.name": "",
"database.tls.mode": "disable",
"database.user": "",
"database.wallet.location": "STRING",
"decimal.handling.mode": "precise",
"field.name.adjustment.mode": "none",
"heartbeat.interval.ms": "0",
"lob.oversize.handling.mode": "fail",
"lob.oversize.threshold": "-1",
"query.fetch.size": "10000",
"schema.history.internal.kafka.bootstrap.servers": "",
"schema.history.internal.kafka.topic": "",
"schema.history.internal.skip.unparseable.ddl": "false",
"schema.history.internal.store.only.captured.tables.ddl": "true",
"schema.name.adjustment.mode": "none",
"signal.data.collection": "",
"signal.enabled.channels": "source",
"signal.kafka.bootstrap.servers": "",
"signal.kafka.topic": "",
"skip.value.placeholder": "__cflt_skipped_value",
"skipped.operations": "t",
"snapshot.database.errors.max.retries": "0",
"snapshot.fetch.size": "",
"snapshot.max.threads": "1",
"snapshot.mode": "initial",
"table.exclude.list": "",
"table.include.list": "",
"time.precision.mode": "adaptive",
"tombstones.on.delete": "true",
"topic.heartbeat.prefix": "__cflt-oracle-heartbeat",
"topic.naming.strategy": "io.confluent.connect.oracle.xstream.cdc.schema.OracleTopicNamingStrategy",
"topic.prefix": "",
"unavailable.value.placeholder": "__cflt_unavailable_value",
09:54:56 ℹ️ 🧩 Displaying status for 🌎onprem connector cdc-xstream-oracle-source
Name Status Tasks Stack Trace
###################################################################
cdc-xstream-oracle-source ✅ RUNNING 🤔 N/A -
###################################################################
09:54:57 ℹ️ 🌐 documentation for 🌎onprem connector kafka-connect-oracle-xstream-cdc-source is available at:
https://docs.confluent.io/kafka-connectors/oracle-xstream-cdc-source/current
09:55:02 ℹ️ Insert 2 customers in CUSTOMERS table
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:55:02 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Thu Dec 04 2025 09:54:56 +00:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
1 row created.
SQL>
1 row created.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:55:03 ℹ️ Update CUSTOMERS with email=[email protected]
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:55:04 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Thu Dec 04 2025 09:55:02 +00:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
1 row updated.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:55:05 ℹ️ Deleting CUSTOMERS with email=[email protected]
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:55:05 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Thu Dec 04 2025 09:55:04 +00:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
1 row deleted.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:55:16 ℹ️ Altering CUSTOMERS table with an optional column
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:55:16 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Thu Dec 04 2025 09:55:08 +00:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
Table altered.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:55:18 ℹ️ Populating CUSTOMERS table after altering the structure
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:55:18 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Thu Dec 04 2025 09:55:16 +00:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
1 row created.
SQL>
1 row updated.
SQL>
1 row updated.
SQL>
1 row updated.
SQL>
Commit complete.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:55:19 ℹ️ Verifying topic cflt.C__CFLTUSER.CUSTOMERS: there should be 14 records
09:56:20 🔥 ❌ overall timeout of 60 seconds exceeded. --min-expected-messages is set with 14 but topic cflt.C__CFLTUSER.CUSTOMERS contains 13 messages
09:56:20 🔥 ####################################################
09:56:20 🔥 🔥 RESULT: FAILURE for cdc-xstream-oracle19-mtls-wallet.sh (took: 3min 49sec - )
09:56:20 🔥 ####################################################
09:56:20 ℹ️ 🧑🚒 you can troubleshoot the issue by running:
playground container display-error-all-containers
09:56:20 ℹ️ 🧑🚒 open full logs with '<playground container logs --open --container ', example:
playground container logs --open --container connect
09:07:47 ℹ️ file /home/runner/work/kafka-docker-playground/kafka-docker-playground/scripts/cli/confluent-hub-plugin-list.txt not found. Generating it now, it may take a while...
09:07:53 ℹ️ 🆕 Listing last updated connector plugins (within 3 days) for confluentinc vendor
🔌 confluentinc/kafka-connect-aws-dynamodb - 🔢 v1.5.2 - 📅 release date: 2025-12-02 (2 days ago) - 🌐 documentation: https://docs.confluent.io/kafka-connect-aws-dynamodb/current/index.html
🔌 confluentinc/kafka-connect-hdfs3 - 🔢 v3.0.5 - 📅 release date: 2025-12-04 (0 days ago) - 🌐 documentation: https://docs.confluent.io/kafka-connect-hdfs3-sink/current/index.html
🔌 confluentinc/kafka-connect-kinesis - 🔢 v2.0.1 - 📅 release date: 2025-12-03 (1 days ago) - 🌐 documentation: https://docs.confluent.io/kafka-connect-kinesis/current/index.html
🔌 confluentinc/kafka-connect-solace-source - 🔢 v1.2.10 - 📅 release date: 2025-12-03 (1 days ago) - 🌐 documentation: https://docs.confluent.io/kafka-connect-solace/current/source/index.html
🔌 confluentinc/kafka-connect-splunk-source - 🔢 v1.1.7 - 📅 release date: 2025-12-02 (2 days ago) - 🌐 documentation: https://docs.confluent.io/kafka-connect-splunk-source/current/index.html
🔌 confluentinc/kafka-connect-sqs - 🔢 v2.0.8 - 📅 release date: 2025-12-03 (1 days ago) - 🌐 documentation: https://docs.confluent.io/kafka-connect-sqs/current/index.html
🔌 confluentinc/kafka-connect-tibco-source - 🔢 v1.2.10 - 📅 release date: 2025-12-03 (1 days ago) - 🌐 documentation: https://docs.confluent.io/kafka-connect-tibco/current/source/index.html
09:56:24 ℹ️ 🎯 Version currently used for confluent platform
8.1.1
09:56:24 ℹ️ 💯 Listing last 5 versions for connector plugin confluentinc/kafka-connect-oracle-xstream-cdc-source
🔢 v1.1.0 - 📅 release date: 2025-06-30 (157 days ago)
🔢 v1.1.1 - 📅 release date: 2025-09-25 (70 days ago)
🔢 v1.2.0 - 📅 release date: 2025-08-28 (98 days ago)
🔢 v1.2.1 - 📅 release date: 2025-09-25 (70 days ago)
🔢 v1.3.0 - 📅 release date: 2025-10-31 (34 days ago)
🌐 documentation: https://docs.confluent.io/kafka-connectors/oracle-xstream-cdc-source/current
09:56:24 ℹ️ 👻 Version currently used for confluentinc/kafka-connect-oracle-xstream-cdc-source is latest
🔢 v1.3.0 - 📅 release date: 2025-10-31
09:56:25 ℹ️ 🧩 Displaying status for 🌎onprem connector cdc-xstream-oracle-source
Name Status Tasks Stack Trace
###################################################################
cdc-xstream-oracle-source ✅ RUNNING 0:🟢 RUNNING[connect] -
###################################################################
09:56:26 ℹ️ 🌐 documentation is available at:
https://docs.confluent.io/kafka-connectors/oracle-xstream-cdc-source/current/overview.html
09:56:27 ℹ️ 🌐 documentation for 🌎onprem connector kafka-connect-oracle-xstream-cdc-source is available at:
https://docs.confluent.io/kafka-connectors/oracle-xstream-cdc-source/current
09:56:27 🔥 💀 The test cdc-xstream-oracle19-mtls-wallet.sh (default_retry) has failed after 1 attempts.
09:56:27 🔥 ####################################################
09:56:27 🔥 🐳 docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
6aca634a1490 confluentinc/cp-server-connect-base:8.1.1 "/etc/confluent/dock…" 2 minutes ago Up 2 minutes 0.0.0.0:5005->5005/tcp, [::]:5005->5005/tcp, 0.0.0.0:8083->8083/tcp, [::]:8083->8083/tcp, 0.0.0.0:10002->10002/tcp, [::]:10002->10002/tcp, 9092/tcp connect
75f6f38821ea confluentinc/cp-schema-registry:8.1.1 "/etc/confluent/dock…" 2 minutes ago Up 2 minutes 0.0.0.0:8081->8081/tcp, [::]:8081->8081/tcp, 0.0.0.0:10001->10001/tcp, [::]:10001->10001/tcp schema-registry
4e1eaf02015d confluentinc/cp-server:8.1.1 "/etc/confluent/dock…" 2 minutes ago Up 2 minutes 0.0.0.0:9092->9092/tcp, [::]:9092->9092/tcp, 0.0.0.0:10000->10000/tcp, [::]:10000->10000/tcp, 0.0.0.0:29092->29092/tcp, [::]:29092->29092/tcp broker
fbe5d0810694 confluentinc/cp-enterprise-alertmanager:2.0.0 "alertmanager-start …" 2 minutes ago Up 2 minutes 9093/tcp alertmanager-c3-v2
a622904b12af confluentinc/cp-server:8.1.1 "/etc/confluent/dock…" 2 minutes ago Up 2 minutes 9092/tcp, 0.0.0.0:10005->10005/tcp, [::]:10005->10005/tcp controller
dfdcd277b43a confluentinc/cp-enterprise-prometheus:2.0.0 "prometheus-start --…" 2 minutes ago Up 2 minutes 9090/tcp prometheus-c3-v2
1c9c66bf93d0 db-prebuilt-2943665357:19.3.0-ee "/bin/sh -c 'exec $O…" 3 minutes ago Up 3 minutes (healthy) 0.0.0.0:1521->1521/tcp, [::]:1521->1521/tcp, 0.0.0.0:1532->1532/tcp, [::]:1532->1532/tcp oracle
09:56:27 🔥 ####################################################
09:56:27 🔥 ####################################################
09:56:27 🔥 connect logs
confluent.client.switchover.disable = false
confluent.lkc.id = null
confluent.metrics.reporter.bootstrap.servers = kafka-0:9071
confluent.proxy.protocol.client.address = null
confluent.proxy.protocol.client.mode = PROXY
confluent.proxy.protocol.client.port = null
confluent.proxy.protocol.client.version = NONE
confluent.selectable.plugin.class = null
connections.max.idle.ms = 300000
default.api.timeout.ms = 60000
enable.metrics.push = false
host.resolver.class = class org.apache.kafka.clients.DefaultHostResolver
metadata.max.age.ms = 300000
metadata.recovery.rebootstrap.trigger.ms = 300000
metadata.recovery.strategy = rebootstrap
metric.reporters = [org.apache.kafka.common.metrics.JmxReporter]
metrics.num.samples = 2
metrics.recording.level = INFO
metrics.sample.window.ms = 30000
receive.buffer.bytes = 65536
reconnect.backoff.max.ms = 1000
reconnect.backoff.ms = 50
request.timeout.ms = 30000
retries = 2147483647
retry.backoff.max.ms = 1000
retry.backoff.ms = 100
sasl.client.callback.handler.class = null
sasl.jaas.config = null
sasl.jaas.config.jndi.allowlist = null
sasl.kerberos.kinit.cmd = /usr/bin/kinit
sasl.kerberos.min.time.before.relogin = 60000
sasl.kerberos.service.name = null
sasl.kerberos.ticket.renew.jitter = 0.05
sasl.kerberos.ticket.renew.window.factor = 0.8
sasl.login.callback.handler.class = null
sasl.login.class = null
sasl.login.connect.timeout.ms = null
sasl.login.read.timeout.ms = null
sasl.login.refresh.buffer.seconds = 300
sasl.login.refresh.min.period.seconds = 60
sasl.login.refresh.window.factor = 0.8
sasl.login.refresh.window.jitter = 0.05
sasl.login.retry.backoff.max.ms = 10000
sasl.login.retry.backoff.ms = 100
sasl.mechanism = GSSAPI
sasl.oauthbearer.assertion.algorithm = RS256
sasl.oauthbearer.assertion.claim.aud = null
sasl.oauthbearer.assertion.claim.exp.minutes = 5
sasl.oauthbearer.assertion.claim.exp.seconds = 300
sasl.oauthbearer.assertion.claim.iss = null
sasl.oauthbearer.assertion.claim.jti.include = false
sasl.oauthbearer.assertion.claim.nbf.include = false
sasl.oauthbearer.assertion.claim.nbf.seconds = 60
sasl.oauthbearer.assertion.claim.sub = null
sasl.oauthbearer.assertion.file = null
sasl.oauthbearer.assertion.private.key.file = null
sasl.oauthbearer.assertion.private.key.passphrase = null
sasl.oauthbearer.assertion.template.file = null
sasl.oauthbearer.client.credentials.client.id = null
sasl.oauthbearer.client.credentials.client.secret = null
sasl.oauthbearer.clock.skew.seconds = 30
sasl.oauthbearer.expected.audience = null
sasl.oauthbearer.expected.issuer = null
sasl.oauthbearer.header.urlencode = false
sasl.oauthbearer.iat.validation.enabled = false
sasl.oauthbearer.jti.validation.enabled = false
sasl.oauthbearer.jwks.endpoint.refresh.ms = 3600000
sasl.oauthbearer.jwks.endpoint.retry.backoff.max.ms = 10000
sasl.oauthbearer.jwks.endpoint.retry.backoff.ms = 100
sasl.oauthbearer.jwks.endpoint.url = null
sasl.oauthbearer.jwt.retriever.class = class org.apache.kafka.common.security.oauthbearer.DefaultJwtRetriever
sasl.oauthbearer.jwt.validator.class = class org.apache.kafka.common.security.oauthbearer.DefaultJwtValidator
sasl.oauthbearer.scope = null
sasl.oauthbearer.scope.claim.name = scope
sasl.oauthbearer.sub.claim.name = sub
sasl.oauthbearer.token.endpoint.url = null
security.protocol = PLAINTEXT
security.providers = null
send.buffer.bytes = 131072
socket.connection.setup.timeout.max.ms = 30000
socket.connection.setup.timeout.ms = 10000
ssl.cipher.suites = null
ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
ssl.endpoint.identification.algorithm = https
ssl.engine.factory.class = null
ssl.key.password = null
ssl.keymanager.algorithm = SunX509
ssl.keystore.certificate.chain = null
ssl.keystore.key = null
ssl.keystore.location = null
ssl.keystore.password = null
ssl.keystore.type = JKS
ssl.protocol = TLSv1.3
ssl.provider = null
ssl.secure.random.implementation = null
ssl.trustmanager.algorithm = PKIX
ssl.truststore.certificates = null
ssl.truststore.location = null
ssl.truststore.password = null
ssl.truststore.type = JKS
(org.apache.kafka.common.config.AbstractConfig:383)
[2025-12-04 09:54:56,927] INFO [cdc-xstream-oracle-source|task-0] These configurations '[enable.idempotence, value.serializer, batch.size, max.in.flight.requests.per.connection, buffer.memory, key.serializer]' were supplied but are not used yet. (org.apache.kafka.common.config.AbstractConfig:394)
[2025-12-04 09:54:56,927] INFO [cdc-xstream-oracle-source|task-0] Kafka version: 8.1.1-ce (org.apache.kafka.common.utils.AppInfoParser:132)
[2025-12-04 09:54:56,927] INFO [cdc-xstream-oracle-source|task-0] Kafka commitId: aeb6069f7c951efa (org.apache.kafka.common.utils.AppInfoParser:133)
[2025-12-04 09:54:56,928] INFO [cdc-xstream-oracle-source|task-0] Kafka startTimeMs: 1764842096927 (org.apache.kafka.common.utils.AppInfoParser:134)
[2025-12-04 09:54:56,973] INFO [cdc-xstream-oracle-source|task-0] Database schema history topic '(name=__orcl-schema-changes.cflt, numPartitions=1, replicationFactor=default, replicasAssignments=null, configs={cleanup.policy=delete, retention.ms=9223372036854775807, retention.bytes=-1})' created (io.debezium.storage.kafka.history.KafkaSchemaHistory:559)
[2025-12-04 09:54:56,974] INFO App info kafka.admin.client for cflt-schemahistory unregistered (org.apache.kafka.common.utils.AppInfoParser:95)
[2025-12-04 09:54:56,980] INFO [cdc-xstream-oracle-source|task-0] No previous offset found (io.confluent.connect.oracle.xstream.cdc.OracleXStreamSourceTask:143)
[2025-12-04 09:54:56,999] INFO [cdc-xstream-oracle-source|task-0] Requested thread factory for component OracleXStreamSourceConnector, id = cflt named = SignalProcessor (io.debezium.util.Threads:270)
[2025-12-04 09:54:57,016] INFO [cdc-xstream-oracle-source|task-0] Requested thread factory for component OracleXStreamSourceConnector, id = cflt named = change-event-source-coordinator (io.debezium.util.Threads:270)
[2025-12-04 09:54:57,017] INFO [cdc-xstream-oracle-source|task-0] Requested thread factory for component OracleXStreamSourceConnector, id = cflt named = blocking-snapshot (io.debezium.util.Threads:270)
[2025-12-04 09:54:57,019] INFO [cdc-xstream-oracle-source|task-0] Creating thread debezium-oraclexstreamsourceconnector-cflt-change-event-source-coordinator (io.debezium.util.Threads:287)
[2025-12-04 09:54:57,019] INFO [cdc-xstream-oracle-source|task-0] WorkerSourceTask{id=cdc-xstream-oracle-source-0} Source task finished initialization and start, task thread id is 119 (org.apache.kafka.connect.runtime.AbstractWorkerSourceTask:302)
[2025-12-04 09:54:57,022] INFO Metrics registered (io.debezium.pipeline.ChangeEventSourceCoordinator:137)
[2025-12-04 09:54:57,025] INFO Context created (io.debezium.pipeline.ChangeEventSourceCoordinator:140)
[2025-12-04 09:54:57,030] INFO According to the connector configuration both schema and data will be snapshot. (io.debezium.relational.RelationalSnapshotChangeEventSource:282)
[2025-12-04 09:54:57,032] INFO Snapshot step 1 - Preparing (io.debezium.relational.RelationalSnapshotChangeEventSource:135)
[2025-12-04 09:54:57,039] INFO Snapshot step 2 - Determining captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource:144)
[2025-12-04 09:55:04,367] INFO Adding table ORCLCDB.C##CFLTUSER.CUSTOMERS to the list of capture schema tables (io.debezium.relational.RelationalSnapshotChangeEventSource:350)
[2025-12-04 09:55:04,370] INFO Created connection pool with 1 threads (io.debezium.relational.RelationalSnapshotChangeEventSource:236)
[2025-12-04 09:55:04,371] INFO Snapshot step 3 - Locking captured tables [ORCLCDB.C##CFLTUSER.CUSTOMERS] (io.debezium.relational.RelationalSnapshotChangeEventSource:153)
[2025-12-04 09:55:04,378] INFO Snapshot step 4 - Determining snapshot offset (io.debezium.relational.RelationalSnapshotChangeEventSource:159)
[2025-12-04 09:55:04,466] INFO Current SCN resolved as 2194446 (io.confluent.connect.oracle.xstream.cdc.snapshot.OracleSnapshotChangeEventSource:179)
[2025-12-04 09:55:04,468] INFO Snapshot step 5 - Reading structure of captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource:162)
[2025-12-04 09:55:04,468] INFO Only captured tables schema should be captured, capturing: [ORCLCDB.C##CFLTUSER.CUSTOMERS] (io.confluent.connect.oracle.xstream.cdc.snapshot.OracleSnapshotChangeEventSource:199)
[2025-12-04 09:55:05,061] INFO Snapshot step 6 - Persisting schema history (io.debezium.relational.RelationalSnapshotChangeEventSource:166)
[2025-12-04 09:55:05,062] INFO Capturing structure of table ORCLCDB.C##CFLTUSER.CUSTOMERS (io.debezium.relational.RelationalSnapshotChangeEventSource:428)
[2025-12-04 09:55:07,336] WARN Topic 'cflt.C##CFLTUSER.CUSTOMERS' name isn't a valid topic name, replacing it with 'cflt.C__CFLTUSER.CUSTOMERS'. (io.debezium.schema.AbstractTopicNamingStrategy:169)
[2025-12-04 09:55:07,365] INFO Already applied 1 database changes (io.debezium.relational.history.SchemaHistoryMetrics:140)
[2025-12-04 09:55:07,367] INFO Snapshot step 7 - Snapshotting data (io.debezium.relational.RelationalSnapshotChangeEventSource:178)
[2025-12-04 09:55:07,367] INFO Creating snapshot worker pool with 1 worker thread(s) (io.debezium.relational.RelationalSnapshotChangeEventSource:480)
[2025-12-04 09:55:07,369] INFO For table 'ORCLCDB.C##CFLTUSER.CUSTOMERS' using select statement: 'SELECT "ID", "FIRST_NAME", "LAST_NAME", "EMAIL", "GENDER", "CLUB_STATUS", "COMMENTS", "CREATE_TS", "UPDATE_TS" FROM "C##CFLTUSER"."CUSTOMERS" AS OF SCN 2194446' (io.debezium.relational.RelationalSnapshotChangeEventSource:489)
[2025-12-04 09:55:07,372] INFO Exporting data from table 'ORCLCDB.C##CFLTUSER.CUSTOMERS' (1 of 1 tables) (io.debezium.relational.RelationalSnapshotChangeEventSource:611)
[2025-12-04 09:55:07,399] INFO Finished exporting 7 records for table 'ORCLCDB.C##CFLTUSER.CUSTOMERS' (1 of 1 tables); total duration '00:00:00.027' (io.debezium.relational.RelationalSnapshotChangeEventSource:663)
[2025-12-04 09:55:07,402] INFO Snapshot - Final stage (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource:108)
[2025-12-04 09:55:07,402] INFO Snapshot completed (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource:112)
[2025-12-04 09:55:07,402] INFO Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=2194446, lcr_position=null]] (io.debezium.pipeline.ChangeEventSourceCoordinator:295)
[2025-12-04 09:55:07,405] INFO Connected metrics set to 'true' (io.debezium.pipeline.ChangeEventSourceCoordinator:502)
[2025-12-04 09:55:07,410] INFO SignalProcessor started. Scheduling it every 5000ms (io.debezium.pipeline.signal.SignalProcessor:105)
[2025-12-04 09:55:07,410] INFO Creating thread debezium-oraclexstreamsourceconnector-cflt-SignalProcessor (io.debezium.util.Threads:287)
[2025-12-04 09:55:07,410] INFO Starting streaming (io.debezium.pipeline.ChangeEventSourceCoordinator:321)
[2025-12-04 09:55:07,549] INFO [cdc-xstream-oracle-source|task-0] 7 records sent during previous 00:00:11.508, last recorded offset of {server=cflt} partition is {snapshot=INITIAL, scn=2194446, snapshot_completed=true} (io.debezium.connector.common.BaseSourceTask:354)
[2025-12-04 09:55:07,872] INFO Capture process 'CAP$_XOUT_1' is enabled and running. (io.confluent.connect.oracle.xstream.cdc.streaming.OracleStreamingChangeEventSource:474)
[2025-12-04 09:55:08,195] WARN [Producer clientId=connect-worker-producer] The metadata response from the cluster reported a recoverable issue with correlation id 3 : {cflt.C__CFLTUSER.CUSTOMERS=UNKNOWN_TOPIC_OR_PARTITION} (org.apache.kafka.clients.NetworkClient:1428)
[2025-12-04 09:55:08,383] INFO Attached to XStream outbound server XOUT (io.confluent.connect.oracle.xstream.cdc.streaming.OracleStreamingChangeEventSource:195)
[2025-12-04 09:55:08,383] INFO Starting data capture from XStream server. (io.confluent.connect.oracle.xstream.cdc.streaming.OracleStreamingChangeEventSource:204)
[2025-12-04 09:55:20,844] INFO [cdc-xstream-oracle-source|task-0] 2 records sent during previous 00:00:13.295, last recorded offset of {server=cflt} partition is {lcr_position=0000000000217c2100000001000000010000000000217c20000000010000000102} (io.debezium.connector.common.BaseSourceTask:354)
[2025-12-04 09:55:23,713] INFO Already applied 2 database changes (io.debezium.relational.history.SchemaHistoryMetrics:140)
[2025-12-04 09:55:56,353] INFO [cdc-xstream-oracle-source|task-0|offsets] WorkerSourceTask{id=cdc-xstream-oracle-source-0} Committing offsets for 13 acknowledged messages (org.apache.kafka.connect.runtime.WorkerSourceTask:241)
[2025-12-04 09:55:56,373] INFO [cdc-xstream-oracle-source|task-0|offsets] Found previous partition offset OraclePartition [sourcePartition={server=cflt}]: {lcr_position=0000000000219f4b00000001000000010000000000219f4a000000050000000102} (io.debezium.connector.common.BaseSourceTask:532)
09:56:27 ❗ ####################################################
09:56:27 🔥 ####################################################
09:56:27 🔥 schema-registry logs
09:56:27 ❗ ####################################################
09:56:27 🔥 ####################################################
09:56:27 🔥 broker logs
[2025-12-04 09:54:05,106] ERROR Unable to submit events without credentials (io.confluent.telemetry.events.exporter.http.HttpExporter)
[2025-12-04 09:54:05,109] ERROR Unable to submit events without credentials (io.confluent.telemetry.events.exporter.http.HttpExporter)
09:56:27 ❗ ####################################################
09:56:27 🔥 ####################################################
09:56:27 🔥 alertmanager-c3-v2 logs
09:56:27 ❗ ####################################################
09:56:27 🔥 ####################################################
09:56:27 🔥 controller logs
[2025-12-04 09:54:03,721] ERROR Unable to submit events without credentials (io.confluent.telemetry.events.exporter.http.HttpExporter)
[2025-12-04 09:54:03,929] ERROR Uncaught exception in SBK_DataBalanceEngine-0: (io.confluent.databalancer.ConfluentDataBalanceEngine)
09:56:27 ❗ ####################################################
09:56:27 🔥 ####################################################
09:56:27 🔥 prometheus-c3-v2 logs
09:56:27 ❗ ####################################################
09:56:27 🔥 ####################################################
09:56:27 🔥 oracle logs
09:56:27 ❗ ####################################################
🔥 CP 8.1.1 🕐 2025-12-04 10:00 📄 cdc-xstream-oracle19-ssl-wallet.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/19921980533/job/57113131357
Logs
09:56:48 ℹ️ 💀 kill all docker containers (disable with 'playground config container-kill-all-before-run false')
09:56:48 ℹ️ 💀 kill all docker containers
09:56:49 ℹ️ 🚀 Running example with flags
09:56:49 ℹ️ ⛳ Flags used are --tag=8.1.1
09:56:50 ℹ️ 🚀 Number of examples ran so far: 11
09:56:50 ℹ️ 🤖CI status: 🟢 ok
🔗test url: https://github.com/vdesabou/kafka-docker-playground/actions/runs/19904250606/job/57056918497
09:56:50 ℹ️ ####################################################
09:56:50 ℹ️ 🚀 Executing cdc-xstream-oracle19-ssl-wallet.sh in dir /home/runner/work/kafka-docker-playground/kafka-docker-playground/connect/connect-cdc-xstream-oracle19-source
09:56:50 ℹ️ ####################################################
09:56:50 ℹ️ 🧰 Checking if Docker image confluentinc/cp-server-connect-base:8.1.1 contains additional tools
09:56:50 ℹ️ ⏳ it can take a while if image is downloaded for the first time
09:56:50 ℹ️ Using sudo to remove /home/runner/work/kafka-docker-playground/kafka-docker-playground/scripts/../confluent-hub
09:56:50 ℹ️ 🎱 Installing connector confluentinc/kafka-connect-oracle-xstream-cdc-source:latest
Downloading component Kafka Connect Oracle XStream Connector 1.3.0, provided by Confluent, Inc. from Confluent Hub and installing into /usr/share/confluent-hub-components
09:56:53 ℹ️ 💫 Using connector:
09:56:53 ℹ️ 🔗 Plugin: confluentinc/kafka-connect-oracle-xstream-cdc-source:1.3.0
09:56:53 ℹ️ 📅 Release date: 2025-10-31
09:56:53 ℹ️ 🌐 Documentation: https://docs.confluent.io/kafka-connectors/oracle-xstream-cdc-source/current
09:56:53 ℹ️ 🎓 To specify different version, check the documentation https://kafka-docker-playground.io/#/how-to-use?id=🔗-for-connectors
09:56:53 ℹ️ 🛰️ Starting up Confluent Platform in Kraft mode as ENABLE_KRAFT environment variable is set
09:56:53 ℹ️ ✨ Using Oracle prebuilt image db-prebuilt-2943665357:19.3.0-ee (oracle version 🔢 19.3.0-ee and 📂 setup folder ../../connect/connect-cdc-oracle19-source/ora-setup-scripts-cdb-table)
09:56:53 ℹ️ 🛑 SQL_DATAGEN is not set
/home/runner/work/kafka-docker-playground/kafka-docker-playground/connect/connect-cdc-xstream-oracle19-source
09:56:53 ℹ️ Starting up oracle container to get generated cert from oracle server wallet
time="2025-12-04T09:56:53Z" level=warning msg="The "flink_connectors" variable is not set. Defaulting to a blank string."
time="2025-12-04T09:56:53Z" level=warning msg="The "flink_connectors" variable is not set. Defaulting to a blank string."
time="2025-12-04T09:56:53Z" level=warning msg="The "flink_connectors" variable is not set. Defaulting to a blank string."
Network plaintext_default Creating
Network plaintext_default Created
Container oracle Creating
Container oracle Created
Container oracle Starting
Container oracle Started
09:56:54 ℹ️ Setting up SSL on oracle server...
09:56:54 ℹ️ Create a wallet for the test CA
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
09:56:56 ℹ️ Create a wallet for the Oracle server
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
09:57:00 ℹ️ You now have the following files under the /tmp/server directory
cert.txt
creq.txt
cwallet.sso
cwallet.sso.lck
ewallet.p12
ewallet.p12.lck
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
{ fingerprint = 7073c57ae226ac03591ce65d3969a6ae, notBefore = Thu Dec 04 09:56:59 UTC 2025, notAfter = Sun Dec 02 09:56:59 UTC 2035, holder = CN=server,C=US, issuer = CN=root_test,C=US, serialNo = 0, sigAlgOID = SHA256withRSA, key = { modulus = 19565161481663854534772930465387240983813056469592409871637112590066935524860640426005172514623810384017448580631728547871903821368993043821511208742349663228308049188751794523250191231466409270211727899357780577755570405026740659080344278686332557278622763170767334810700947826346837731100918269710508132934338364819521534843922794355083518711058694193788158170318666906537453902052479635560248395073660180517875873337306933391713344480712586881158871276634825114897064685245019544870580790078669104980580401538536758967038636988323099174978851917590219872035178169201120443758441178334181451840911778732688137615609, exponent = 65537 } }
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
Oracle PKI Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.
Operation is successfully completed.
09:57:01 ℹ️ Update listener.ora, sqlnet.ora and tnsnames.ora
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-DEC-2025 09:57:02
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=1532)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
###################################################################
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 04-DEC-2025 09:57:02
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=1532)))
The listener supports no services
The command completed successfully
LSNRCTL> 09:57:02 ℹ️ Sleeping 60 seconds
09:58:02 ℹ️ 🛑 zookeeper is disabled
09:58:02 ℹ️ 🛑 control-center is disabled
09:58:02 ℹ️ 🛑 Starting services without Flink
09:58:02 ℹ️ 🛑 ksqldb is disabled
09:58:02 ℹ️ 🛑 REST Proxy is disabled
09:58:02 ℹ️ 🛑 Grafana is disabled
09:58:02 ℹ️ 🛑 kcat is disabled
09:58:03 ℹ️ 🛑 conduktor is disabled
Container controller Creating
Container prometheus-c3-v2 Creating
Container oracle Running
Container prometheus-c3-v2 Created
Container alertmanager-c3-v2 Creating
Container controller Created
Container broker Creating
Container alertmanager-c3-v2 Created
Container broker Created
Container schema-registry Creating
Container schema-registry Created
Container connect Creating
Container connect Created
Container prometheus-c3-v2 Starting
Container controller Starting
Container prometheus-c3-v2 Started
Container alertmanager-c3-v2 Starting
Container controller Started
Container broker Starting
Container alertmanager-c3-v2 Started
Container broker Started
Container schema-registry Starting
Container schema-registry Started
Container connect Starting
Container connect Started
09:58:05 ℹ️ ✨ If you modify a docker-compose file and want to re-create the container(s), run cli command 'playground container recreate'
09:58:05 ℹ️ ⌛ Waiting up to 300 seconds for connect to start
09:58:37 ℹ️ 🚦 containers have started!
09:58:37 ℹ️ 🔏 copy cwallet.sso to connect container
09:58:37 ℹ️ 🪄👑 Executing command as root in container connect with bash
09:58:38 ℹ️ 🪄👑 Executing command as root in container connect with bash
sed: can't read /etc/yum.repos.d/adoptium.repo: No such file or directory
09:58:38 ℹ️ 🪄👑 Executing command as root in container connect with bash
(microdnf:239): librhsm-WARNING **: 09:58:38.750: Found 0 entitlement certificates
(microdnf:239): librhsm-WARNING **: 09:58:38.789: Found 0 entitlement certificates
Downloading metadata...
Downloading metadata...
Downloading metadata...
Package Repository Size
Installing:
libaio-0.3.111-13.el9.x86_64 ubi-9-baseos-rpms 27.1 kB
Transaction Summary:
Installing: 1 packages
Reinstalling: 0 packages
Upgrading: 0 packages
Obsoleting: 0 packages
Removing: 0 packages
Downgrading: 0 packages
Downloading packages...
warning: Unsupported version of key: V6
(microdnf:239): libdnf-WARNING **: 09:58:39.832: failed to parse public key for /etc/pki/rpm-gpg/RPM-GPG-KEY-PQC-redhat-release
Running transaction test...
Installing: libaio;0.3.111-13.el9;x86_64;ubi-9-baseos-rpms
Complete.
09:58:40 ℹ️ 🪄👑 Executing command as root in container connect with bash
(microdnf:301): librhsm-WARNING **: 09:58:40.142: Found 0 entitlement certificates
(microdnf:301): librhsm-WARNING **: 09:58:40.175: Found 0 entitlement certificates
Package Repository Size
Installing:
libnsl2-2.0.0-1.el9.x86_64 ubi-9-appstream-rpms 33.3 kB
libtirpc-1.3.3-9.el9.x86_64 ubi-9-baseos-rpms 98.9 kB
Transaction Summary:
Installing: 2 packages
Reinstalling: 0 packages
Upgrading: 0 packages
Obsoleting: 0 packages
Removing: 0 packages
Downgrading: 0 packages
Downloading packages...
warning: Unsupported version of key: V6
(microdnf:301): libdnf-WARNING **: 09:58:40.341: failed to parse public key for /etc/pki/rpm-gpg/RPM-GPG-KEY-PQC-redhat-release
Running transaction test...
Installing: libtirpc;1.3.3-9.el9;x86_64;ubi-9-baseos-rpms
Installing: libnsl2;2.0.0-1.el9;x86_64;ubi-9-appstream-rpms
Complete.
09:58:40 ℹ️ 🪄👑 Executing command as root in container connect with bash
09:58:40 ℹ️ ⌛ Waiting up to 600 seconds for message DATABASE IS READY TO USE to be present in oracle container logs...
DATABASE IS READY TO USE!
09:58:40 ℹ️ The log is there !
09:58:40 ℹ️ Oracle DB has started!
09:58:40 ℹ️ Enable Oracle XStream
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:40 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL>
System altered.
SQL> SQL>
NAME TYPE VALUE
enable_goldengate_replication boolean TRUE
resource_manage_goldengate boolean FALSE
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:58:41 ℹ️ Configure ARCHIVELOG mode
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:41 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> ORA-01012: not logged on
SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> SP2-0640: Not connected
SQL> 09:58:41 ℹ️ Configure supplemental logging
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:42 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL>
Session altered.
SQL>
Database altered.
SQL>
SUPPLEME SUP
IMPLICIT YES
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:43 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> SQL> 2
Tablespace created.
SQL> SQL> SQL> 2
Tablespace created.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:44 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL>
Session altered.
SQL> SQL> SQL> 2
Tablespace created.
SQL> SQL> SQL> 2
Tablespace created.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:58:45 ℹ️ Create a new common user for the XStream administrator
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:45 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> 2 3 4
User created.
SQL> SQL>
Grant succeeded.
SQL> SQL> 2 3 4 5 6 7 8 9
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:58:49 ℹ️ Create a new common user for the XStream connect user
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:49 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> 2 3 4
User created.
SQL> SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL> SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL> SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:58:50 ℹ️ Creating XStream Out
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:50 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:55 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
SQL> Connected.
SQL> 2 3 4 5 6
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:58:56 ℹ️ Create CUSTOMERS table and inserting initial data
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 4 09:58:56 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> SQL> 2 3 4 5 6 7 8 9 10 11
Table created.
SQL> SQL> 2 3 4 5 6 7 8 9 10
Trigger created.
SQL> SQL>
1 row created.
SQL>
1 row created.
SQL>
1 row created.
SQL>
1 row created.
SQL>
1 row created.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
09:58:57 ℹ️ Creating Oracle Xstream CDC source connector
09:58:58 ℹ️ 🛠️ Creating 🌎onprem connector cdc-xstream-oracle-source
09:58:59 ℹ️ ✅ 🌎onprem connector cdc-xstream-oracle-source was successfully created
09:59:01 ℹ️ 🔩 list of all available parameters for 🌎onprem connector cdc-xstream-oracle-source (io.confluent.connect.oracle.xstream.cdc.OracleXStreamSourceConnector) and version 1.3.0 (with default value when applicable)
"binary.handling.mode": "bytes",
"column.exclude.list": "",
"column.include.list": "",
"database.dbname": "",
"database.hostname": "",
"database.os.timezone": "Z",
"database.out.server.name": "",
"database.password": "",
"database.pdb.name": "",
"database.port": "1521",
"database.processor.licenses": "",
"database.service.name": "",
"database.tls.mode": "disable",
"database.user": "",
"database.wallet.location": "STRING",
"decimal.handling.mode": "precise",
"field.name.adjustment.mode": "none",
"heartbeat.interval.ms": "0",
"lob.oversize.handling.mode": "fail",
"lob.oversize.threshold": "-1",
"query.fetch.size": "10000",
"schema.history.internal.kafka.bootstrap.servers": "",
"schema.history.internal.kafka.topic": "",
"schema.history.internal.skip.unparseable.ddl": "false",
"schema.history.internal.store.only.captured.tables.ddl": "true",
"schema.name.adjustment.mod