ERROR Producer failure (io.debezium.pipeline.ErrorHandler:36) java.lang.RuntimeException: java.lang.

[Ehasnul Khan]

Hi All,

When I started Dbz Oracle connector, I get the following error message. Here is my config curl command looks like. I also put tnsnames.ora in the directory: /Users/ekhan/Oracle/tns_admin/tnsnames.ora ( this is the latest one from the server machine- but is not working). 

Please advise!

Thanks!

-Ehsan

curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" localhost:8083/connectors/ -d '{ "name": "oracle-source-connector", "config": { "connector.class" : "io.debezium.connector.oracle.OracleConnector", "tasks.max" : "1", "database.server.name" : "E1Local", "database.hostname" : "VAIO", "database.port" : "1521", "database.user" : "xstmrep", "database.password" : "Xstrmrep01+", "database.dbname" : "E1Local", "table.whitelist" : "XSTRMADMIN.customers",  "database.out.server.name" : "dbzxout", "database.history.kafka.bootstrap.servers" : "localhost:9092", "database.history.kafka.topic": "schema-changes.customer" } }'

ERROR Producer failure (io.debezium.pipeline.ErrorHandler:36)

java.lang.RuntimeException: java.lang.UnsatisfiedLinkError: no ocijdbc12 in java.library.path

[Jiri Pechanec]

Hi,

please check https://debezium.io/docs/connectors/oracle/#deploying-a-connector

J.

[Ehasnul Khan]

HI Jiri,

I have everything accordingly but unable to solve the issue. In the error message it mentions "no ocijdbc12 in java.library.path ". However, in the debezium link below, there is no mention of "ocijdbc12" library. Does this mean that I need to add that file in the plugin.path=connectors? I have also set up env variable: export LD_LIBRARY_PATH=/Users/ekhan/Oracle/instantclient_12_1

Not sure what I am still missing.

Thanks,

-ek

[Jiri Pechanec]

The path should point to a directory where libocijdbc12.so file resides.

J.

[Jiri Pechanec]

Hi,

is the Debezium running on MacOS?

J.

[Ehsanul Khan]

Hi Jiri,

Yes, it is. I have resolved this issue by adding libocijdbc (12.2 version) and looks like it is now trying to get data from the source database. I now need to go back and make sure the configuration on xstream, etc. are all configured properly. 

I know I should use docker but I wanted to do this on my Mac first as this has been a good learning experience from various issues I am getting (would be nice if I could solve these issues faster though :-) )

Thanks for your help!

-Ehsan

--
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 post to this group, send email to debe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/13097ec3-6d7e-4de2-83f1-2ce23a50946d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ehsanul Khan
ehsanul...@gmail.com
Phone: 612-310-6594