-
Bug
-
Resolution: Done
-
Major
-
1.4.0.Final
-
None
-
False
-
False
-
Undefined
-
DB:
docker pull store/oracle/database-enterprise:12.2.0.1
Install instant client with scripts
https://github.com/debezium/debezium-examples/tree/master/tutorial:
set DEBEZIUM_VERSION=1.4 docker-compose -f docker-compose-oracle.yaml up --build
Add network:
docker network connect --alias ODB tutorial_default ODB
The following exception is caught in the logs:
connect_1 | 2021-01-15 16:07:46,037 ERROR || Producer failure [io.debezium.pipeline.ErrorHandler] connect_1 | java.lang.RuntimeException: java.sql.SQLException: ORA-08181: specified number is not a valid system change number connect_1 | ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1 connect_1 | ... 6 more connect_1 | Caused by: Error : 8181, Position : 25, Sql = SELECT 1 FROM DUAL WHERE SCN_TO_TIMESTAMP(0) = SCN_TO_TIMESTAMP(3143773), OriginalSql = SELECT 1 FROM DUAL WHERE SCN_TO_TIMESTAMP(0) = SCN_TO_TIMESTAMP(3143773), Error Msg = ORA-08181: specified number is not a valid system change number connect_1 | ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1 connect_1 | connect_1 | at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1145) connect_1 | ... 16 more