Flink CDC Issue Import created FLINK-34862: ----------------------------------------------
Summary: [Bug] oracle-cdc ORA-01371: Complete LogMiner dictionary not found Key: FLINK-34862 URL: https://issues.apache.org/jira/browse/FLINK-34862 Project: Flink Issue Type: Bug Components: Flink CDC Reporter: Flink CDC Issue Import ### Search before asking - [X] I searched in the [issues|https://github.com/ververica/flink-cdc-connectors/issues) and found nothing similar. ### Flink version flink-1.15.2 ### Flink CDC version flink-connector-oracle-cdc-2.4.2 ### Database and its version oracle 12c cdb ### Minimal reproduce step **Translation: There is no problem running the following code segment individually:** Properties prop = new Properties(); prop.setProperty("log.mining.strategy", "redo_log_catalog"); prop.setProperty("log.mining.continuous.mine", "true"); prop.setProperty("decimal.handling.mode", "string"); prop.setProperty("interval.handling.mode", "string"); prop.setProperty("database.tablename.case.insensitive", "false"); prop.setProperty("snapshot.locking.mode", "none"); prop.setProperty("lob.enabled", "true"); prop.setProperty("database.history.store.only.captured.tables.ddl", "true"); prop.setProperty("database.dbname", "ORCL"); prop.setProperty("database.pdb.name", "ORCLPDB"); SourceFunction<String> sourceFunction = OracleSource.<String>builder() .url("jdbc:oracle:thin:@//192.168.xxx.xxx:1521/ORCL") .hostname("192.168.xxx.xxx") .port(1521) .database("ORCL") .schemaList("C##DBZUSER") .tableList("C##DBZUSER.TEST_TABLE_02") .username("c##dbzuser") .password("dbz") .startupOptions(StartupOptions.initial()) .debeziumProperties(prop) .deserializer(new JsonDebeziumDeserializationSchema()) // converts SourceRecord to JSON String .build(); **Run the following code simultaneously, an error is reported:** Properties prop = new Properties(); prop.setProperty("log.mining.strategy", "redo_log_catalog"); prop.setProperty("log.mining.continuous.mine", "true"); prop.setProperty("decimal.handling.mode", "string"); prop.setProperty("interval.handling.mode", "string"); prop.setProperty("database.tablename.case.insensitive", "false"); prop.setProperty("snapshot.locking.mode", "none"); prop.setProperty("lob.enabled", "true"); prop.setProperty("database.history.store.only.captured.tables.ddl", "true"); prop.setProperty("database.dbname", "ORCL"); prop.setProperty("database.pdb.name", "ORCLPDB"); SourceFunction<String> sourceFunction = OracleSource.<String>builder() .url("jdbc:oracle:thin:@//192.168.xxx.xxx:1521/ORCL") .hostname("192.168.xxx.xxx") .port(1521) .database("ORCL") .schemaList("C##DBZUSER") .tableList("C##DBZUSER.TEST_TABLE_01") .username("c##dbzuser") .password("dbz") .startupOptions(StartupOptions.initial()) .debeziumProperties(prop) .deserializer(new JsonDebeziumDeserializationSchema()) // converts SourceRecord to JSON String .build(]; error info: java.sql.SQLException: ORA-01371: Complete LogMiner dictionary not found ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 ### What did you expect to see? able to run multiple Oracle CDC instances simultaneously. ### What did you see instead? Error occurred when running multiple oracle-cdc instances. ### Anything else? _No response_ ### Are you willing to submit a PR? - [X] I'm willing to submit a PR! ---------------- Imported from GitHub ---------------- Url: https://github.com/apache/flink-cdc/issues/2998 Created by: [Toroidals|https://github.com/Toroidals] Labels: bug, Created at: Mon Jan 15 09:56:17 CST 2024 State: open -- This message was sent by Atlassian Jira (v8.20.10#820010)