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
Last activity: Jan 31, 2017, 08:41 AM