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.
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: , tab.
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.
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 , p. System Requirements). Parameters To adjust access to the Oracle DBMS, use the parameters described in Table below. Parameters of the Oracle DBMS
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. //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: item in the main menu → item in the control menu → tab → select in the drop-down list, the type, and set parameters according to the format listed below. •In the Server configuration file. |