ODI安装代理验证数据库失败

最新推荐文章于 2022-12-20 23:14:28 发布

IT小学徒qwer

最新推荐文章于 2022-12-20 23:14:28 发布

阅读量1.1k

点赞数

本文链接：https://blog.csdn.net/qq_40877166/article/details/82804138

版权

我在数据库验证的时候，报错
Error message: com.oracle.cie.rcu.external.ComponentSchemaInfoException: SQLException thrown
at com.oracle.cie.rcu.external.ComponentSchemaInfoFactory.getComponentSchemaInfos(ComponentSchemaInfoFactory.java:48)
at com.oracle.cie.domain.gui.jdbc.ShadowTableConfigurationPanel$BindThread.run(ShadowTableConfigurationPanel.java:915)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
   at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:727)
   at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
   at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)
   at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
   at com.oracle.cie.rcu.external.ComponentSchemaInfoFactory.getComponentSchemaInfos(ComponentSchemaInfoFactory.java:28)
   ... 1 more
Caused by: Error : 942, Position : 14, Sql = select * from COMPONENT_SCHEMA_INFO, OriginalSql = select * from COMPONENT_SCHEMA_INFO, Error Msg = ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 14 more
.这怎么解决啊