logo
社区首页 / 全域数据集成平台 / 问题详情
标题
CDC实时数据监听启动失败
0
用户头像
楼主:王朋飞
主题:1     回复:1     获赞:0 注册日期:2023-08-07

数据库是oracle19c,实例是pdb1 数据库开启归档日志后,启动实时数据监听失败,控制台日志报如下错误:

当前日志文件:/usr/tomcat/webapps/ROOT/log/etl01/20230808/20230808134921.log ETL01:admin at 08/08 13:49:21 traceId:64d1d76106c50a2445395288 =&gt手动启动监听器=&gtoracle-175 ETL01:08/08 13:49:22=&gtjava.lang.Class - 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:50) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:222) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:60) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: java.sql.SQLException: ORA-65040: operation not allowed from within a pluggable database ORA-06512: at "SYS.DBMS_LOGMNR", line 82 ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081) at io.debezium.connector.oracle.logminer.LogMinerHelper.executeCallableStatement(LogMinerHelper.java:217) at io.debezium.connector.oracle.logminer.LogMinerHelper.setLogFilesForMining(LogMinerHelper.java:87) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.initializeRedoLogsForMining(LogMinerStreamingChangeEventSource.java:335) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:155) ... 9 more Caused by: Error : 65040, Position : 0, Sql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =&gt 'C:\ARCHIVELOG\ARC0000012265_1074874228.0001', OPTIONS =&gt DBMS_LOGMNR.ADDFILE);END;, OriginalSql = BEGIN sys.dbms_logmnr.add_logfile(LOGFILENAME =&gt 'C:\ARCHIVELOG\ARC0000012265_1074874228.0001', OPTIONS =&gt DBMS_LOGMNR.ADDFILE);END;, Error Msg = ORA-65040: operation not allowed from within a pluggable database ORA-06512: at "SYS.DBMS_LOGMNR", line 82 ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ... 27 mor

---------------------------------------------------
签名:
共3回答
0
用户头像
回答者: lingpengliang
获赞:20 注册于:2023-04-10 回答于 2023-08-08 14:16:03 #1

用户权限不够

---------------------------------------------------
签名:
0
用户头像
回答者: 王朋飞
获赞:0 注册于:2023-08-07 回答于 2023-08-08 14:18:00 #2

需要什么权限?

---------------------------------------------------
签名:
0
用户头像
回答者: lingpengliang
获赞:20 注册于:2023-04-10 回答于 2023-08-08 14:42:44 #3

读写表空间权限,cdc捕获修改数据权限等,还有问题可以扫下方二维码加社区群方便交流

---------------------------------------------------
签名: