Hi to everybody,
I’m Andrea from Italy, newbie of Knime. It is the first post on this forum, so change the category if I was wrong.
I have to connect to an Oracle Database 11g, and I use the Database Connector node: in order to do it, I have downloaded the JDBC driver (11g, 12c and 18c) from the following url [http://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html](Oracle Database 18c (18.3) JDBC driver and Older Releases - 12.2,12.1, and 11.2 JDBC drivers), and I use oracle.jdbc.driver.OracleDriver.
When I try to connect to the DB using credential input, I successfully do it: I connect to a test schema, so it is not the real Operational DB.
The Operational DB is atteinable through external authentication (using PL/SQL Developer I select the DB and blank username and password: the program automatically select the Windows credentials). If I try to access to the Operational DB I have some problem.
I use two different methods with two different errors:
-
jdbc:oracle:thin:@< host>:< port>/< database_name> -->
ERROR Database Connector 0:12 Execute failed: Could not create connection to database: ORA-01017: invalid username/password; connection refused
-
jdbc:oracle:oci:@< host>:< port>/< database_name> -->
ERROR Database Connector 0:16 Execute failed: Could not create connection to database: no ocijdbc12 in java.library.path
I’m not able to solve this problem, using external authentication (I have also tried to insert the Windows credential without any result), someone can help me?
Thanks a lot,
Andrea