Can't create connection to Oracle database

KNIME Analytics Platform
1

Try to make connection with the Database Connector to our Oracle Database.
First downloaded and installed the Orcale Driver
Then tried to connect

image

Get this error message:
ERROR Database Connector 4:27 Execute failed: Could not create connection to database: Maximum number of retries to get a valid connection reached. JDBC URL: jdbc:oracle:thin:@//vivlp01.viv.olsp:1521/vivdp01.viv.olsp

also tried it with the SID
ERROR Database Connector 4:27 Execute failed: Could not create connection to database: Maximum number of retries to get a valid connection reached. JDBC URL: jdbc:oracle:thin:@//vivlp01.viv.olsp:1521/vivdp01

Anyone an idea?

Thanks,

Ron

2

Hi Ron!

Not sure but maybe it is up to the DB URL format. Try with this one:

jdbc:oracle:thin:@vivlp01.viv.olsp:1521/...

Br,
Ivan

3

Hi ipazin,

tried it but get this error message

Execute failed: Could not create connection to database: Maximum number of retries to get a valid connection reached.
Any idea how i can reset this.
Tried a new Database node, but get right away the same error

Thanks,

Ron

4

Hi ipazin,

Have connection to the database.

After all these errormessages I finaly restarted KNIME.
Started a new workflow and added again a DatabaseConnection Node. Set it up the same and now it does the job and get the connection with the database and can see the tables

Cheers,

Ron

1 Like
5

Hi Ron!

Glad it works now. So only restart was needed? Which URL did you use in the end?

Br,
Ivan

6

Hi ipazin,

jdbc:oracle:thin:@vivlp01.viv.olsp:1521/VIVDP01

Thanks,

Ron

1 Like