JDBC Oracle driver not working on Server (Linux)

database
#1

we are using the oracle 12 jdbc driver on the Knime workstion (on Windows) now I tried to get the workflow (which is running on the workstation) to work on the knime server 4.9 (on Linux)
The workflow allways runs into a timeout.

-----Preferences on the server-----
file_export_version=3.0
!/=
/instance/org.knime.workbench.core/database_drivers=/app/driver/ojdbc8.jar;/app/driver
/instance/org.knime.workbench.core/database_timeout=60
/instance/org.knime.workbench.core/logging.logfile.location=true
/instance/org.knime.database/drivers/Oracle\ 8/database_type=oracle
/instance/org.knime.database/drivers/Oracle\ 8/driver_class=oracle.jdbc.OracleDriver
/instance/org.knime.database/drivers/Oracle\ 8/paths/0=/app/driver/ojdbc8.jar
/instance/org.knime.database/drivers/Oracle\ 8/url_template=://:/<database_name>
/instance/org.knime.database/drivers/Oracle\ 8/version=12.2.0

Screenshot from the configuration

0 Likes

#2

Hello WMoser,
these seems to be a problem with the service settings in your Oracle DB indicated by the ORA-12514 error code in the screenshot and the java.io.IOException: Socket read timed out in the log file.
Bye
Tobias

1 Like

#3

yes it was the oracle service, we operate a oracle cluster and on the firewall there were some adresses missing.
Thanks for support!

2 Likes

closed #4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

0 Likes