debezium / debezium/dbz

Clarify the connection string settings for XStream/TCPS [DBZ-6168]

Open
#775 0 comments 0 reactions 0 assignees View on GitHub
component/documentation component/oracle-connector migrated-from-jira type/task
Dominant language
HTML
Stars
6
Forks
9
Avg merge
2d 19h
Merged PRs (30d)
1

Description

Migrated from [DBZ-6168](https://issues.redhat.com/browse/DBZ-6168)

In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.
h1. Bug report

For bug reports, provide this information, please:
h2. What Debezium connector do you use and what version?

Oracle Connector v1.9
h2. What is the connector configuration?

debezium.name = oracle-engine

offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore

offset.storage.file.filename = /offsets/oracle4.txt

offset.flush.interval.ms = 60000

database.history = io.debezium.relational.history.FileDatabaseHistory

database.url = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=db-host)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=servicename)))

database.user = xxxxxxx

database.password = xxxxxx

database.history.file.filename = /offsets/dbhistory.txt

database.server.name = oracle-connector

database.out.server.name = dbzxout

database.pdb.name = xxxxpdb

database.connection.adapter = xstream

 

Also I have included the following Java environment properties when running Debezium

-Djavax.net.ssl.trustStore="xxx.jks"

-Djavax.net.ssl.trustStorePassword="xxxxxx"

-Djavax.net.ssl.trustStoreType="JKS"
h2. What is the captured database version and mode of deployment?

On-premise Oracle 19c RAC CDB Installation with Multiple PDBs with TCPS enabled and only server certificate validation
h2. What behaviour do you expect?

Debezium is able to successfully connect to XStream outbound server via TCPS 
h2. What behaviour do you see?

java.lang.RuntimeException: Failed to resolve Oracle database version

io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:161)

...

Contributor guide

Open the contributing guide

Research direction

Start at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:161) and review the supplied XStream/TCPS configuration for Oracle 19c. Reproduce the connection attempt with the listed Java trust-store properties; done means the connector resolves the Oracle version and connects to the XStream outbound server without the reported RuntimeException.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases, security
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.