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

1,814 views
Skip to first unread message

Ehasnul Khan

unread,
May 8, 2019, 3:27:03 AM5/8/19
to debezium
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

unread,
May 9, 2019, 2:12:44 AM5/9/19
to debezium

Ehasnul Khan

unread,
May 9, 2019, 4:05:45 AM5/9/19
to debezium
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

unread,
May 9, 2019, 6:42:48 AM5/9/19
to debezium
The path should point to a directory where libocijdbc12.so file resides.

J.
Message has been deleted
Message has been deleted
Message has been deleted
Message has been deleted

Jiri Pechanec

unread,
May 13, 2019, 3:02:30 AM5/13/19
to debezium
Hi,

is the Debezium running on MacOS?

J.

Ehsanul Khan

unread,
May 14, 2019, 2:57:49 AM5/14/19
to debe...@googlegroups.com
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.


--
Reply all
Reply to author
Forward
0 new messages