一、问题描述
使用oracle自带的sql developer登录sys是没有问题的:
但是,使用sys登录kettle确实是有问题的,
错误连接数据库 [oracle] : 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-28009: connection as SYS should be as SYSDBA or SYSOPER
org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
二、解决办法
使用管理员登录,用户名后面添加 as sysdba即可。
测试成功