Kettle 连接失败 Oracle 数据库报 ora-12505 的解决方法（转）
用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;
