用kettle新建DB连接的时候总是报错，可是用plsql连接是可以连上，错误信息大致如下：

错误连接数据库 [MIS] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
10.9.202.67:1521:ORCL



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

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
10.9.202.67:1521:ORCL



主机名       : 10.9.202.67
端口           : 1521
数据库名:ORCL

查找资料得知：

jdbc连接数据库的时候，需要使用数据库的sid_name，而不是数据库的services_name
而使用plsql连接数据库的时候，只需要数据库的services_name即可，所以修改连接字符串中的services_name （即连接参数中的database name）为sid_name

PS：查看数据库的sid_name语句：

select INSTANCE_NAME from v$instance;