Data synchronization problem of oracle19c cdc integrated with debezium #22990
Unanswered
ChaoY000000
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Whether or not database.dbname can only configure CDB connection information for Oracle 19c cdc configuration;
Problem 1: If the CDB connection information is configured, the data changes of the schemas and tables under the PDB cannot be monitored. How to monitor the data changes of some schemas and tables under a PDB?
Problem 2: If you configure PDB information, you will get an error with the following message:
2024-07-01T02:03:53,064+0000 [public/default/oracle-1-pulsar_job-0] ERROR org.apache.pulsar.functions.instance.JavaInstanceRunnable - Encountered exception in source read
org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42) ~[debezium-core-1.7.2.Final.jar:1.7.2.Final]
at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:182) ~[debezium-connector-oracle-1.7.2.Final.jar:1.7.2.Final]
at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58) ~[debezium-connector-oracle-1.7.2.Final.jar:1.7.2.Final]
at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166) ~[debezium-core-1.7.2.Final.jar:1.7.2.Final]
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127) ~[debezium-core-1.7.2.Final.jar:1.7.2.Final]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: java.sql.SQLException: ORA-65040: operation not allowed from within a pluggable database
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8132
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 5161
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 5381
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 7983
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8146
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8302
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 61
ORA-06512: at line 1
Beta Was this translation helpful? Give feedback.
All reactions