DBeaver - Create an Oracle Connection

Setting up an Oracle connection for the first time

1. Open DBeaver.

2. It will ask you if you want to create a sample database the first time you open DBeaver, click No. This will not appear in the future.

   Open

   

3. The next window asks you to pick the type of database you want to connect to.
   Select Oracle then Next >

   Open

   

4. In the Oracle Connection Setting window:
   - for Connection Type select the TNS tab
   - Choose the database you want to connect to for the Network Alias. Yours may be different from the example provided below. 
   - Under Authentication, put in your Username and Password 
   - Click Edit Driver Settings
   
   

5. Click Download/Update
   
   

6. In the Drivers Settings window, ensure Force download/overwrite is checked then click Download configuration
   
   

7. In the Preferences (Filtered) window, complete the HTTP Proxy information:
   🗹 Check for new driver versions
   Proxy Host: https://proxy.toronto.ca
   Proxy Port: 8080
   User: Your Windows/Novell login
   Password: Your Windows/Novell password
   
   

8. Click Apply and Close

9. Once back in the Drivers Settings click the Download button. You’ll see a green progress bar as the drivers download
   
   

10. Click OK to close the Oracle Driver window.

11. On the Oracle Connection Settings window, click Test Connection.

If the connection is successful, you’ll see this window.  Click OK and the popup will close.

Click Finish.

Setting up an additional Oracle connection

1. Open DBeaver.

2. Click Database > New Database Connection
   
   

3. The next window asks you to pick your database. Select Oracle then Next >
   
   

4. In the Oracle Connection Setting window:

• for Connection Type select the TNS tab 

• Choose the database you want to connect to for the Network Alias, 

• Under Authentication, put in your Username and Password 

• Click Finish