Contents
Setting up the UCS Database
![]() |
Purpose: To set up the database or databases that UCS will use. |
Prerequisites
RDBMS, either Oracle or Microsoft SQL. See also the eServices 8.0 Deployment Guide. See the Deployment category page for overall prerequisites for deploying UCS.
Procedure
- Create a database in your RDBMS.
- Locate scripts in \Universal Contact Server\<application-name>\sql_scripts\<RDBMS-type>.
- Run ucs-<RDBMS-type>.sql for a new installation or choose the proper upgrade script for your RDBMS type.
For an existing UCS database, run all scripts that cover your existing version, the current version, and all versions in between. For example, to upgrade from 7.6.1 to 8.0.2, you must run- upgrade_<RDBMS-type>_7.6.1_to_8.0.0.sql
- upgrade_<RDBMS-type>_8.0.0_to_8.0.1.sql
- upgrade_<RDBMS-type>_8.0.1_to_8.0.2.sql
Genesys supplies upgrade scripts for all releases starting with 7.0.1.
Special Information for Oracle RAC
DAP Configuration
To connect UCS to an Oracle Real Application Cluster (RAC), configure a DAP for UCS as follows:
- Use the first node's host and port settings on the Server info tab.
-
For the host, port, and ONS settings of each additional node, create options in the settings section, as follows. Note that the ONS settings are optional.
-
Name: ONSConfiguration
Value: nodes=node1:node1port,node2:node2port, ... where port is the ONS port, usually 6251 -
Name: hostx, where x is a positive integer
Value: host of RAC -
Name: portx, where x is a positive integer matching one of the hostx options
Value: DB port of RAC, usually 1521
-
Name: ONSConfiguration
Here is an example configuration for three nodes, named rac1, rac2, and rac3. The DB port is 1521 and the ONS port is 6251 for all nodes.
[ServerInfo] host: rac1 ports: default, 1521 [Options > settings] ONSConfiguration: nodes=rac1:6251,rac2:6251,rac3:6251 host1: rac2 port1: 1521 host2: rac3 port2: 1521
UCP Library
Starting with the 8.1 release, support of Oracle RAC also requires that you deploy the Universal Connection Pool library, which Genesys is not able to deliver with the installation package. To deploy the UCP library:
- Download the ucp.jar file, version 11.2.0.1.0 or higher, from the Oracle web site: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
- Copy the jar file to the UCS home folder in ./lib/db/oracle
When connected to an Oracle RAC configuration, the UCS database layer uses this jar file for connection handling. If UCS is started against an Oracle RAC without ucp.jar, it will fail to start.