Oracle JDBC driver 23.x throws ORA-18716 - not in any time zone

[Mukesh Venaram Choudhary]

Hi Chris,

We are using debezium version 1.9 for capturing CDC events from Oracle and we are getting the ORA-18716 error. We have tried with ojdbc 12.x, 19.x and 21.x?

Any way to resolve this error other than upgrading debezium to 2.2 and above?

Thanks

[Chris Cranford]

Hi -

The Oracle 23 JDBC driver is not something we supported on Debezium 1.9. This was fixed in DBZ-6502 [1], which was applied in Debezium 2.2 and 2.3.  As Debezium 1.9 is no longer supported, you will need to move to a later version to obtain the fix.

Thanks,
Chris

[1]: https://issues.redhat.com/browse/DBZ-6502

--
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/39e7d72a-dadb-47fd-ad68-734717a7693fn%40googlegroups.com.

[Mukesh Venaram Choudhary]

Any chance it can work with older Oracle JDBC drivers? 12.x, 19.x and 21.x?

Thanks,

[Chris Cranford]

Hi -

It should be compatible with 12/19/21, as those were what we tested with Debezium 1.9 [1]:

Thanks,
Chris

[1]: https://debezium.io/releases/1.9/

To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/310a4df7-9d0b-4b51-8533-ecfe0b448d8cn%40googlegroups.com.

[Mukesh Venaram Choudhary]

Our setup is on Debezium 1.9 with ojdbc 19/21. We are getting the same error. By any chance was the fix applied for ORA-18716 in the lower versions?

Thanks,

Mukesh Choudhary

[Chris Cranford]

Perhaps the version of 19/21 drivers contain a backport of some changes made to the 23 driver.
What explicit versions of the 19 and 21 drivers are you using?

Chris

To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/4714e143-bed6-4799-b943-c55e8d6951d4n%40googlegroups.com.