304792747 opened a new issue, #9429: URL: https://github.com/apache/seatunnel/issues/9429
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened 环境数据库使用oracle 11g 根据官网的配置后，进行oracle 配置 还是会有一些表和视图不存在。希望官网能补充上相关文档信息 https://seatunnel.apache.org/zh-CN/docs/2.3.11/connector-v2/source/Oracle-CDC 解决方式：添加授权 GRANT SELECT ON V_$STATNAME TO logminer_user; GRANT SELECT ON V_$MYSTAT TO logminer_user; ### SeaTunnel Version SeaTunne 2.3.11 ### SeaTunnel Config ```conf 无 ``` ### Running Command ```shell ./bin/seatunnel.sh --config ./config/test1.config -m local ``` ### Error Exception ```log Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:628) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:562) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1145) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:726) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:108) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:887) at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1158) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1093) at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1402) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1285) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1687) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394) at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:641) at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:510) at io.debezium.connector.oracle.OracleConnection.getSessionStatisticByName(OracleConnection.java:372) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.captureSessionMemoryStatistics(LogMinerStreamingChangeEventSource.java:346) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:258) ... 8 more Caused by: Error : 942, Position : 32, Sql = SELECT VALUE FROM v$statname n, v$mystat m WHERE n.name='session uga memory' AND n.statistic#=m.statistic#, OriginalSql = SELECT VALUE FROM v$statname n, v$mystat m WHERE n.name='session uga memory' AND n.statistic#=m.statistic#, Error Msg = ORA-00942: 表或视图不存在 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:632) ... 26 more ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version _No response_ ### Screenshots <!-- Failed to upload "QQ20250611-103218.png" --> ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
