Oracle XStream setup with RAC

[Aqhil Mohammad]

Hi All,

I have some queries. Hope I expect some clarification.

1) We are trying to setup Oracle Xstream with RAC having SCAN address, can we use "database.url" so we can mention Primary and Standy cluster SCAN address respectively. Could let me know if I can mention like below ?

database.url": "jdbc:oracle:thin:@(DESCRIPTION="

      + "(ADDRESS_LIST="

      + "  (ADDRESS=(PROTOCOL=TCP)(HOST=scan1.grp.net)(PORT=1521))"

      + "  (ADDRESS=(PROTOCOL=TCP)(HOST=scan2.grp.net)(PORT=1521))"

      + ")"

      + "(CONNECT_DATA=(SERVICE_NAME=XSTREAM_SVC)))",

2)  We are using Terraform, can I use this docker image 

https://hub.docker.com/r/debezium/connect. Because latest version is 3.4 on the document but I do not see 3.4 version on docker hub. Can you provide the latest docker image version for oracle connector

3) While using RAC does it handle node failover when DB switches from Node1 to Node2, I hope it does.

Thanks,

Akhil Mohammad.

[Chris Cranford]

Hi -

You can use the `database.url` configuration property; however, when using TNS configuration, if I recall FAILOVER=ON and LOAD_BALANCE=OFF must be set.  

As for images, Debezium has not published images to DockerHub since the end of the 2.x release stream.  All container images are published to quay.io. Please see this blog post [1] for all the details.

Lastly wrt to when the service transitions from Node1 to Node2, it's important to make sure that XStream's RAC configuration is setup with use_rac_service=Y. This should make sure that when the service migrates across nodes, the Oracle JDBC driver will be able to negotiate and resolve to the right SCAN address.

Hope that helps.
-cc

[1]: https://debezium.io/blog/2024/09/18/quay-io-reminder/

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/3471a94c-9686-4bb5-9f1a-0cf99551ef7fn%40googlegroups.com.

[Aqhil Mohammad]

Hello Chris,

Thanks for the update. Yes can see now on  quay.io 

Yes for oracle service we will set  use_rac_service=Y

1) Can you let me know if we can use Debezium oracle xstream for Production or has it been tired by others ?

2) For the connector configuration, I don't see database.service.name which was used in confluent xstream connector. Though it uses same Debezium framework. In that sense I don't see the need to use database.service.name for Debezium xstream isn't ?

[Chris Cranford]

Hi, 

1. Yes you can use it in production.
2. There is no `database.service.name`, you supply that information using either `database.hostname` or `database.url` depending on your needs.

-cc

To view this discussion visit https://groups.google.com/d/msgid/debezium/9c12f395-848c-4f74-a14a-aedd50e7f221n%40googlegroups.com.

[Aqhil Mohammad]

Excellent Chris,

Thanks for the confirmation, will setup and comeback if I'm stuck.

[Aqhil Mohammad]

Hello,

Regarding DB Pre-requisites, can we follow below doc, as it has clear instructions 

https://docs.confluent.io/cloud/current/connectors/cc-oracle-xstream-cdc-source/prereqs-validation.html

Instead of https://debezium.io/documentation/reference/stable/connectors/oracle.html#_preparing_the_database_3

As both follow almost same steps.

[Aqhil Mohammad]

Hello Chris,

Wanted to check, does Debezium provides (Red Hat) provides professional support on xstream connector ?

[Chris Cranford]

Hi,

Yes, support for XStream officially begins early April 2026. So if you're interested, now is a great time to reach out.

-cc

To view this discussion visit https://groups.google.com/d/msgid/debezium/3bdfbe2e-cd3a-4c13-8655-4d205cfac0e1n%40googlegroups.com.

[Aqhil Mohammad]

Hello,

We are trying to set up at the first. Bu eventually would be interested going forward. Can you provide the medium to reach out on the support model.  

[Aqhil Mohammad]

Hello Chris,

Can you provide Price/Quotation for xstream.

[Aqhil Mohammad]

Hello Chris,

Can you let me know the support model, whom to reach out ?

[Chris Cranford]

Hi,

You can contact a Red Hatter here [1] about Red Hat Application Foundations, which includes the Red Hat build of Debezium.

-cc

[1]: https://www.redhat.com/en/products/application-foundations

To view this discussion visit https://groups.google.com/d/msgid/debezium/e0c06826-a77a-4ba5-8fb0-67e82db9c355n%40googlegroups.com.