General Description
The Oracle Database (or Oracle DBMS) is an object-relational DBMS. Oracle may be used as an external DB for Dr.Web ESS.
|
The Dr.Web Enterprise 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 Control Center: Configure Dr.Web Enterprise Server, Database tab.
|
If you are going to use the ODBC for Oracle as an external database, select the Custom option and in the opened window disable the installation of Oracle client in the Database support - Oracle database driver section in the installer settings during the Server installation (or upgrade). Otherwise, Oracle DB functioning 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:
◆Using an Oracle installer (use an external mode of instance installation and configuration);
◆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 ESS.
Platforms supported by the Oracle DBMS are listed on the web site of the vendor http://www.oracle.com/technology/software/tech/oci/instantclient/index.html.
Dr.Web ESS 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 ‘listening’ to the server;
◆<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.
An Example of the drwcsd.conf Configuration File
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 Enterprise 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. Fragment of configuration file with corresponding parameters is listed below:
... ;Database definition. Mandatory. ;Only one definition is allowed. database
;DB driver (DLL or shared object name) drworacle ; Oracle DB, unix & windows
;load library from this path; empty - use default from "" using "User=DRWCS Password=root ConnectionString=//192.168.0.1:1521/ORADB" |