Connection error when trying to create Oracle connector

[Rafael Galina]

I'm trying to use Debezium 1.6 on Oracle 19c on AWS RDS (SIngle instance).

I made all the settings as per the documentation for use with logminer,  but I keep getting this generic connection error when trying to create a connector.

{

"error_code": 400,

 "message": "Connector configuration is invalid and contains the following 1 error(s):\nUnable to connect: Failed to resolve Oracle database version\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`"

}

I put on github as is my Dockerfile and the connector I'm trying to create

https://github.com/rafaelgalina/debezium-kafka-connect

Please what am I doing wrong?

[Chris Cranford]

Hi Rafael -

As the error indicates, the connector is unable to connect to the Oracle database. 
Can you please confirm that the port & host are accessible from the machine that is hosting Kafka connect?
Also, is there a reason why you need to use `database.url` over specifying the `database.hostname` and `database.port` options?

Chris

--
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 on the web visit https://groups.google.com/d/msgid/debezium/99e8234e-947f-4747-86b6-7a5c2a8d72f6n%40googlegroups.com.

[Andrei S.]

Hi, guys!

I have had that problem.

Try to check that servise_name or sid do not contain "-" in names.

среда, 23 июня 2021 г. в 10:31:20 UTC+3, Chris Cranford:

[Rafael Galina]

Hi Chris, thanks for your answer!

I'm sure the database allows the connection from my kafka connect cluster. I have another app on the same cluster that uses this database. I also have other MySQL CDC connectors  that are on this cluster and connect to MySQL databases in this same RDS account (although they are different security groups, I checked and they have the same inbound and outbound rules).

I ran some connectivity tests from my cluster machine to the database, and those tests returned success.

No reason to use "database.url", i was just trying different configurtion. Using "database.port" and "database.hostname" the error still the same.

[Rafael Galina]

Hey guys, i solved by changing the odjc10.jar to ojdbc8.jar and copying to the lib folder
COPY java/kafka-connect-jdbc/ojdbc8.jar /usr/share/confluent-hub-components/confluentinc-kafka-connect-jdbc/lib/

Thanks for the support

[Chris Cranford]

Hi Rafael -

I'm glad you found the culprit.  We have not officially tested with ojdbc10 so there could be some problems with it, I'll log an issue so that we do test it and see what limitations exist if any.  Fwiw, I also checked the Instant Client 21.1 and it too uses ojdbc8.jar.

Happy CDCing!
Chris

To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/7debfcd8-de8e-481e-86cf-857a18b1d394n%40googlegroups.com.