本文主要是介绍Kettle 错误:Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) ORA-28040: No,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
一、问题描述
使用kettle8.0连接oracle12c,发现将oracle安装目录下与ojdbc相关的jar包都拷贝到kettle的相关目录Program Files\kettle\data-integration\lib下。配置连接
但是,运行测试连接oracle还是报错:
[oracle_local] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the databaseError connecting to database: (using class oracle.jdbc.driver.OracleDriver)
ORA-28040: No matching authentication protocolorg.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the databaseError connecting to database: (using class oracle.jdbc.driver.OracleDriver)
ORA-28040: No matching authentication protocolat org.pentaho.di.core.database.Database.normalConnect(Database.java:472)at org.pentaho.di.core.database.Database.connect(Database.java:370)at org.pentaho.di.core.database.Database.connect(Database.java:341)at org.pentaho.di.core.database.Database.connect(Database.java:331)at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:83)at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestResults(DatabaseFactory.java:112)at org.pentaho.di.core.database.DatabaseMeta.testConnectionSuccess(DatabaseMeta.java:2811)at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:621)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)
二、问题原因
尽管把oracle数据库中的相关oracle拷贝,但是,没有删除原有的ojdbc14-10.2.0.1.0.jar。所以kettle默认使用14包,导致报错。
三、解决
删除原有的ojdbc14-10.2.0.1.0.jar。
这篇关于Kettle 错误:Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) ORA-28040: No的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!