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.

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.

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.

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.

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 website of the vendor http://www.oracle.com/technology/software/tech/oci/instantclient/index.html.

Dr.Web Enterprise Security Suite supports the following versions of the DBMS: Oracle9i Database Release 2: 9.2.0.1—9.2.0.8 and higher.

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)

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.