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 database

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
ORA-28040: No matching authentication protocol



org.pentaho.di.core.exception.KettleDatabaseException: 
Error occurred while trying to connect to the database

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
ORA-28040: No matching authentication protocol



	at 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。