How to setup DataGrip to connect to Oracle DB using sqlnet.ora
Completed
I have an Oracle database I need to connect to that requires a unique sqlnet.ora file and tns file.
I am able to connect using SQL Developer by referencing a separate Oracle Instant Client with the sqlnet.ora and tnsnames.ora file in the Instant Client's ./network/admin folder. If I am able to somehow reference this Instant Client from DataGrip that might work too but I am lost as to how to accomplish this.
Please sign in to leave a comment.
@Caseymilller,
You can specify TNS Admin folder via:
@vasily-chernov that works for the TNS file but I am still unable to connect to the database in question. Will this method also pick up the sqlnet.ora file? Maybe the better question is how to switch use an Oracle driver in DataGrip that references an Oracle Instant Client installation?
@Caseymiller,
From https://intellij-support.jetbrains.com/hc/en-us/community/posts/203526830/comments/360000524200
@vasily-chernov
Okay I was able to get it to connect by adding all of the .jars in the instant client to the drivers section of the Instant Client based driver connection and then selecting OCI driver from the Server screen.
Thank you so much for your help!
-- Casey
Additionally, we've included help topic for OCI connections https://www.jetbrains.com/help/datagrip/how-to-connect-to-oracle-with-oci.html#creating-the-oracle-oci-connection
Thank you for your kind explanation for this problem.
However, I still have problem with establishing connection between DataGrip and Oracle Cloud ATP.
Here, I made two attempts.
1. Set the Connection type: SID
I don't know what to fill in 'Name', 'Host', 'SID', 'User', 'Password'. I filled in possible things in those blanks a couple of times and clicked 'TEST CONNECTION' button, but it all failed and the result was like above.
In Advanced tab, I made blank on the server as you explained above feed, but I don't know what to fill in the database.
Also, I don't know what to fill in VM options, so I left it in blank.
2. Set the Connection type: TNS
I don't know what to fill in 'Name', 'TNSADMIN', 'TNS Name', 'User', 'Password'. I filled in possible things in those blanks a couple of times and clicked 'TEST CONNECTION' button, but it all failed and the result was like above.
Either way, I failed the connection, and I don't know what is the reason of this problem.
I need more detailed explanation about what to fill in each blanks. I think there are more things that I should do to establish connection, especially filling in the VM options in Advanced tab.
I'm in urgent situation. Could you help me with filling in those blanks and establishing connection?
Could you send me email?
ant1102@naver.com
13109378,
Here is IDE step by step guidance https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html#connect-to-oracle-database
vasily chernov,
I referenced the site you linked, but it doesn't really help me that much.
I'm still struggling with it.
Could you provide me with more information in detail?
So, you're trying to connect to Oracle Cloud ATP (Autonomous Transaction Processing), but DataGrip works only with Oracle Database.
You can try to follow instructions provided by Oracle itself https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/connect-using-client-application.html#GUID-5F661631-39FA-49BA-82D6-7C089D567A1F
Dod this ever get resolved? I am also trying to connect datagrip to an Oracle ATP. Its just a oracle database running in the cloud so dont'w quite understand why its not supported? Also why does intellij still only include jdbc driver up to version 12?
K Bines1,
>Oracle ATP
There is a feature request https://youtrack.jetbrains.com/issue/DBE-11669 you can follow.
>Also why does intellij still only include jdbc driver up to version 12?
We're working on it. As a workaround you can add jars yourself.