Connecting to Oracle

KNIME Analytics Platform
1

Hi ,

I’m trying to connect to Oracle 11g vi Database connector, but it fails.

I added ojdbc14. jar and also ojdbc6.jar under preferences--Knime-- db and also preferences—data management-- driver definition but none of them works.

Please find my configuration below: 

Database Driver:  oracle.jdbc.driver.OracleDriver ( also i tried it with oracle.jdbc.OracleDriver and still no luck)

Database URL:
jdbc:oracle:thin:@eaidbprd.gov.calgary.ab.ca:1527/pdeai
User Name:  XXX
Database Type:  oracle

with the above configuration I’m getting the following errors.

​ERROR Database Connector   0:229      Execute failed: Could not create connection to database: Connection refused: connect

And if i changed the port to 1521 then ill get 

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Could you please help me what did i miss?

Thanks,

2

The error message comes from the database therefore you have to search for and fix the problem there. A quick Google search retrieves quite a few pages about your error message, e.g. http://stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-d

3

Hi Thor,

I`ve read in the forum the the port should be 1527 and not 1521, Could you please confirm?

Also I have doubt if there is any issues with DB, as we are using the same config for spagoBI.

Ojdbc14 or Ojdbc6 should i use? did you see anything wrong on my settings?

Thanks,
Sanaz

4

The default port for Oracle it 1521 but in the end it depends on your database configuration. If you are getting a message from the database then it seems that 1521 is also the correct port in your setup.

Internally we are using ojdbc6.jar without any problems. As I said the error message you get is definitly a server-side problem which you need to fix in your configuration. Please check in your database that the service "pdeai" indeed has a TNS listener at port 1521.

5

Hi Thor,

You were right,  i configured it wrong in one step, Thanks alot for your help.