This is one of a series of posts where I document software configurations for personal reference. This post documents the configurations for Datagrip.
Datagrip is available as a snap package on Ubuntu, which can be installed using the following command:
sudo snap install datagrip
Follow these steps:
- Download this configuration file.
- Open Datagrip and click “File” -> “Import Settings”.
- Choose the downloaded file.
- Select components to import (select all by default).
Here is a short tutorial on how to connect to an Oracle 11g database using TNS:
- Open the “Data Sources and Drivers” window.
- Download the oracle database driver.
- Add an Oracle data source.
- In the “General” -> “URL” section, choose “TNS” from the drop box.
- Specify the TNS file (see below for an example) path in the “TNSADMIN” section, and other necessary information below.
Here is a made-up TNS file:
mydb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 220.127.116.11)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 18.104.22.168)(PORT = 1521)) (LOAD_BALANCE = no) (FAILOVER = ON) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = newods1) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) ) ) )
mydb is a TNS name.