B2. Setting Up the Database Driver for Oracle

General Description

The Oracle Database (or Oracle DBMS) is an object-relational DBMS. Oracle may be used as an external DB for Dr.Web Enterprise Security Suite.

warning

The Dr.Web Server may use the Oracle DBMS as an external database on all platforms except FreeBSD (see Installation and supported versions).

To use the Oracle DBMS

1.Install an instance of Oracle DB and set up the AL32UTF8 encoding. Also you may use existence instance which is configured to use the AL32UTF8 encoding.

2.Set up the database driver to use the respective external database. You can do this in configuration file or via Dr.Web Security Control Center: Dr.Web Server configuration, Database tab.

warning

If you are going to use the Oracle DB as an external database via the ODBC connection, then during installation (upgrading) of the Server, in the installer settings, disable the installation of embedded client for Oracle DBMS (in the Database support → Oracle database driver section).

Otherwise, interaction with the Oracle DB via ODBC will fail because of the libraries conflict.

 

Connection to the Oracle database as the SYS and SYSTEM users, and also with the SYSDBA and SYSOPER privileges is forbidden.

Installation and Supported Versions

To use Oracle as en external DB, you must  install the instance of the Oracle DB and set up AL32UTF8 (CHARACTER SET AL32UTF8 / NATIONAL CHARACTER SET AL16UTF16) encoding. This can be done in one of the following ways:

1.Using an Oracle installer (use an external mode of instance installation and configuration).

2.Using the CREATE DATABASE SQL command.

For more information on creating and configuring Oracle instances, see Oracle documentation.

warning

In case of using a different encoding,  national symbols may be displayed incorrectly.

A client to access the database (Oracle Instant Client) is included in the installation package of Dr.Web Enterprise Security Suite.

Platforms supported by the Oracle DBMS are listed on the web site of the vendor.

Platforms supported by the Oracle Client are listed on the web site of the vendor.

Dr.Web Enterprise Security Suite supports the Oracle DBMS of version 11 and later.

Also, please note the system requirements for Dr.Web Server when operating with the Oracle external database (see Installation Manual, p. System Requirements).

Parameters

To adjust access to the Oracle DBMS, use the parameters described in Table below.

Parameters of the Oracle DBMS

Parameter

Description

drworacle

Driver name

User

Database user name (obligatory)

Password

User password (obligatory)

ConnectionString

Database connection string (obligatory)

Prefetch-rows

Number of rows to be prefetched when executing a query to the database

Prefetch-mem

Memory allocated for rows to be prefetched when executing a query to the database

The format of the connection string to the Oracle DBMS is as follows:

//<host>:<port>/<service name>

where:

<host>—IP address or name of the Oracle server;

<port>—port that the server is ‘listening’;

<service name>—name of the DB to connect to.

For Example:

//myserver111:1521/bjava21

where:

myserver111—name of the Oracle server.

1521—port ‘listening’ to the server.

bjava21—name of the DB to connect to.

Oracle DBMS Driver Configuration

If you deploy Oracle, it is necessary to change the definition and the settings of the database driver by one of the following ways:

In the Control Center: Administration item in the main menu → Dr.Web Server configuration item in the control menu → Database tab → select in the Database drop-down list, the Oracle type, and set parameters according to the format listed below.

In the Server configuration file.