Connect to Oracle by using Kerberos (JDBC Thin Driver)

Run kinit in the command prompt

1. In the command prompt or in the terminal, run the following command:

   kinit oraclekrb

   Instead of oraclekrb, use your username.

2. Enter a password for the username.

   

Create a data source

1. Open data source properties. You can open data source properties by using one of the following options:

   • Navigate to File | Data Sources.

   • Press Ctrl+Alt+Shift+S.

   • In the Database Explorer ( View | Tool Windows | Database Explorer), click the Data Source Properties icon .

2. In the Data Sources and Drivers dialog, click the Add icon () and select Oracle.

3. From the Connection type list, select SID.

   

4. In the Host field, type the host address of your database.

5. In the SID field, enter the instance name. You can ask your database administrator for the instance name or try running the following query in the command prompt when connected to the instance with your user:

   SELECT sys_context('userenv','instance_name') FROM dual;

6. From the Driver list, select Thin.

   

7. From the Authentication list, select Kerberos.

   

8. On the General tab, click Test Connection to ensure that the connection is successful.

   

Check an authentication method

• Run the following query from the data editor:

  SELECT sys_context('userenv', 'authentication_method') FROM dual;