Sample Header Ad - 728x90

Pentaho Kettle - Unable to connect to virtual Oracle Database

0 votes
2 answers
1565 views
I'm attempting to connect to a virtualized Oracle database but I am receiving the following error: 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: > foohost:1521:foodba Since SIDs are not usable with virtualized databases I need to provide a fully qualified URL (from what I have heard), however I'm not certain how to configure Pentaho to accomplish this.
Asked by Stephen Brewster
Oct 18, 2015, 06:47 PM
Last activity: Jan 31, 2017, 08:41 AM