Hello Knimers,
After switching to 4.0, I wanted to replace my current Database Connector (legacy) node with the Oracle Connector Node. However unsuccessful so far.
Database Connector (legacy) is working with an oracle db, using ojdbc6 (11.1.0)
I registered the same jar file under Preferences > KNIME > Databases, using the same configuration as in the previous legacy database settings. → jdbc:oracle:thin:@hostname:1521:DBNAME
I also tried:
- jdbc:oracle:thin:@//hostname:1521:DBNAME
- jdbc:oracle:thin:hostname:1521:DBNAME
- jdbc:oracle:thin://hostname:1521:DBNAME
to no avail.
I think I configured the Oracle Connector node correctly in the Connection Settings tab, using Username & password as authentication method. However, it throws me an error:
ERROR Oracle Connector 0:22:0:0:0:1510 Execute failed: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
From stackoverflow I understand that ORA-12514 is an Oracle problem not a Knime problem per se.
The TNS listener is expecting some input that was sent with the legacy node, but is not with the Oracle Connector anymore? Can you help me figuring out what I could be missing to turn the Oracle Connector working, just like it’s legacy counterpart is doing?
Best regards,
Christoph