How might I associate with an Oracle Autonomous Data Warehouse with an outsider IDE (DataGrip)?


I'm attempting to interface with an Oracle Autonomous Data Warehouse information base with Jetbrains DataGrip. Prophet gives me a wallet document (a compress), with contains tnsnames.ora, a keystore,, and some different records.

I'm experiencing a great deal of difficulty utilizing this data to associate with the information base utilizing DataGrip. I found a string on the DataGrip uphold gatherings, however I'm not having any karma with that all things considered.


What I did:

1. Made the 'TNS_ADMIN' climate variable and set it to:

C:\\Users\\xxx\\Documents\\[folder with wallet files]

2. Added the Oracle JDBC driver documents (ojdbc8.jar, osdt_cert.jar, oraclepki.jar, osdt_core.jar) to the standard Oracle driver in DataGrip

3. altered the 'sqlnet.ora' document to incorporate the way to the wallet records

4. Added the accompanying to the Data Source VM Options:

-\\Users\\xxx\\Documents\\[folder with wallet files]







Set association type to URL as it were

Attempted diverse association strings in the URL field:

jdbc:oracle:thin:@//\\Users\\xxx\\Documents\\[folder with wallet files]\\Users\\xxx\\Documents\\[folder with wallet files]



Association with ADW1 fizzled.

[08006][17002] IO Error: Got short one from a read call, associate slip by 32 ms.,

Verification pass 0 ms.

I have additionally taken a stab at utilizing the 'Administration name' and 'TNS' association types and filled in the data from tnsnames.ora. No dice, same mistake.

Additionally attempted explicitely setting the 'tcp.validnode_checking' boundary to invalid.

(The association turns out great with sqldeveloper)

What's the legitimate method to do this?

1 comment
Comment actions Permalink

We are working on solution in this task, please follow and vote.


Please sign in to leave a comment.