Oracle - bobbyiliev/dbeaver GitHub Wiki

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

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 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

For more a 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")))

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

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

Note: This functionality is available in Enterprise, Ultimate and Team editions only.

A more secure way to connect is to use the Oracle Wallet. Wallet is a directory with security keys and some other optional connection information. Wallets are usually distributed as ZIP archives. You need to extract the ZIP archive to a folder on a disk and specify this folder in the Wallet location field.

Wallet may contain information about a database user. This, however, is optional. You will sometimes need to specify the user too.

Wallet may also contain a TNS configuration. If it does, you can use the TNS connection configuration easily by setting the TNS path to the same value as the Wallet location.

Parameter	Description	Example
User name, Password, Role	See Database authentication
Wallet location	Oracle wallet directory	C:\oracle\network\wallet\example
Wallet password	Optional. Some wallets are password-protected

Note: This functionality is available in Enterprise, Ultimate and Team editions only.

Kerberos is the most complicated authentication in Oracle.

Parameter	Description	Example
Username	Database user name	c##testuser
Kerberos user	Kerberos / Active directory user name	testuser@THE-REALM
Realm	Kerberos realm	THE-REALM
KDC server	KDC server address	krb5.your-domain.com
Password	Kerberos user password

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

• 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").

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 user name and password (you can get them from the Oracle Cloud database information page)
• Set the Wallet location to the wallet location directory