Table of contents

• Configuration types
  • Basic connections
  • TNS
  • Custom URL
• Authentication
  • Database
  • OS authentication
• Oracle Cloud connections
  • Plain URL connection
  • Oracle Wallet connection

There are several ways to configure a database connection and several ways to perform an authentication.

Configuration types

Basic connections

Host/port based configuration

Parameter	Description	Example
Host	Server host name	192.168.1.25
Post number	Server listener port	1521 (default)
Database	Service or SID name	ORCL
Service/SID	It depends on the server configuration. SID must be selected for some servers and the Service Name for others	SID

TNS

TNS configuration is the simplest, but it requires you to have the tnsnames.ora file somewhere on your disk. tnsnames.ora contains information about all accessible Oracle server connections. DBeaver can determine the default location of this file, but sometimes you will need to manually specify it.

Parameter	Description	Example
Network Alias	Name of configuration from tnsnames.ora	ORCL1
TNS names path	Path to tnsnames.ora file. By default, it is got from the TNS_ADMIN environment variable or from Windows' registry	c:\oracle\network\admin

Custom URL

For a more sophisticated configuration, you can specify the full JDBC URL manually ( see Data Sources and URLs).

Sample URL (Oracle Cloud):
jdbc:oracle:thin:@(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=xxxxxxxxxxxxxxxxx_high.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com, OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))

Authentication

Database

Parameter	Description	Example
User name	Database user name	SYS
Password	Database user password
Role	Role for connection. Roles SYSDBA and SYSOPER are needed for some administrative operations	Normal
Save password	Saves the user/password information in the local DBeaver configuration	SID

OS authentication

The Oracle driver gets user information from the current OS user.
You do not need to explicitly specify any credentials.

Oracle Cloud connections

DBeaver supports Oracle Cloud Autonomous databases connectivity.
There are two ways to authenticate:

Plain URL connection

• To use a plain URL connection you must enable the Access control list for the Oracle autonomous database.
• Then add your IP address to the IP list.
• Use the Custom connection configuration (URL). You can copy the URL from the Oracle Cloud database page (link "DB Connection").

Oracle Wallet connection

It is the default authentication type for the Oracle Cloud.

• Download Wallet from the Oracle Cloud website
• Expand the wallet archive to a folder
• Set TNS configuration type
• Set the TNS path to the wallet location directory
• Choose the proper Network Alias from the drop-down menu
• Set Authentication to the Oracle Wallet
• Set the database username and password (you can get them from the Oracle Cloud database information page)
• Set the Wallet location to the wallet location directory