Login to Oracle server using windows credentials using data grip
已回答
I am moving to Data grip from SQL Developer but I am unable to figure out how to connect to my oracle server with my windows credentials using Datagrip. In SQL Developer it works without having to enter any credentials. So I am guessing it is taking my windows credentials in that case(without checking in the OS Authentication and Kerberos authentication checkboxes). How can I achieve similar functionatily using Data grip? I am totally blocked here.
请先登录再写评论。
Hello, here is instruction:
1. Open Data Sources & Drivers, go to Oracle driver, right-click on it and select Duplicate.
2. Remove the entry from Driver files, and add here ojdbc7.jar & orai18n.jar files from your Oracle Client, so it should look like this:
3. Go to Advanced tab and to VM Environment LD_LIBRARY_PATH=path_to_oracle_home\bin
4. Create Data Source using this new driver.
5. You need to use TNS connection and specify path to tnsnames.ora file
6. Done