kettle创建oracle连接

《kettle创建oracle连接》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Kettle创建oracle连接，在test的时候报错的解决方案1、先点Cancel进入kettle主界［ifORepositoryConnection1SSRepository:JKettleRespUserName:adminPassword:0

2、EF:ToolsKettle4.4data-integrationPath%KETTLEJ40ME%首先找到Kettle的主程序启动方式:运行data-integrationSpoon.bat。Kettle默认不带Oracle驰动。于是我把Oracle的JDBC驱动ojdbcld.jar/ojdbclzl_g/ojdbcl4dms/ojdbcl4dms_g.jar放到了Kettle的R录data-integrationlibextJDBC(JDatabaseConnection22GeneralAdvancedOpt

3、ionsPoolingClusteringConnectionName:orclConnectionType:IntersystemsCacheKingbaseESLucidDBMSAccessMSSQLServerMSSQLServer(Native)MaxDB(SAPDB)MonetDBMySQLNeoviewNetezzaOracleSettingsHostName:john-PCDatabaseName:orclceforDataTablespaceforIndicesPortNumber:OracleRDBPaloMO

4、LAPServerAccess:Test持征列表1521UserName:Password:浏览OKCancel我遇到的连接错误：错误连接数据库[orcl]:org.pentaho.di.core,exception.KeltIcDatabaseException:ErroroccuredwhiletryingtoconnecttothedatabaseErrorconnectingtodatabase:(usingclassoracle,jdbe.driver.OracleDriver)lo异常：TheNetworkAdapt

5、ercouldnotestablishtheconnectionorg.pentaho.di.core,exception.KettleDatabaseException:ErroroccuredwhiletryingtoconnecttothedatabaseErrorconnectingtodatabase:(usingclassoracle,jdbe.driver.OracleDriver)Io异常：TheNetworkAdaptercouldnotestablishtheconnection3、原因：—1、connect

6、ionname:orcl【这个是我的数据库名，连接时我也用这个名字，DB名字也是这个】-2、Host-name：说实话，我重装系统之后还真没注意主机名是什么，我是在E:oracleproduct10.2.0db1etworkADMIN中的tnsnames.ora中查到的，ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=john-PC)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICENAME=orcl)))端U号写1

7、521Username和password就是我连接oracle的用户名和密码，点击test按钮，终于连接成功了！