I am getting a TNS error when trying to create a new Oracle database connection:
TNS: listener does not currently know of SID given in connect descriptor
Pentaho: pdi-ee 5.0.2
Using Oracle 10g
Native (JDBC)
Entered SID in the Database Name field.
From the Database Connection/Feature list window:
Driver class: oracle.jdbc.driver.OracleDriver
URL: jdbcracle:thin@server_ip:1521:my_SID
I have copied the ojdbc14.jar file into data-integration/lib, which I believe is the correct version for Oracle 10g.
Please advise,
thanks,
-John