Pentaho Kettle – Unable to connect to virtual Oracle Database

oraclepentaho

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.

Best Answer

So the trick was to go into the Options tab in the Edit Connection dialogue and create a database parameter to define the connection string.

Related Solutions

How to change the connection descriptor used by Oracle Enterprise Manager

I'm guessing because you haven't specified what version of OEM you're using.

If you're using OEM 12C, go to the DB home then click on "Oracle Database", "Target Setup", "Monitoring Configuration". You can change the SID there.

ORA : 12519 No appropriate Service Handler

http://docs.oracle.com/cd/E18283_01/network.112/e10836/concepts.htm

sales=
 (DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)) 
  (CONNECT_DATA= 
     (SID=sales)
     (SERVICE_NAME=sales.us.example.com)
     (INSTANCE_NAME=sales)))

It looks like you haven't put the SID in your TNSNAMES.ORA.

Best Answer

Related Solutions

How to change the connection descriptor used by Oracle Enterprise Manager

ORA : 12519 No appropriate Service Handler

Related Question