Default Value: No default value
Valid Values: Any valid service name
Changes Take Effect: After restart
Specifies the network service name of a database; see the service_names parameter in the init.ora (or init<dbName>.ora) file. If the service name is specified, the service name replaces the database name. This option applies only to Oracle databases.
Setting up the UCS Database
Purpose: To set up the database or databases that UCS will use.
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.
- 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
Genesys supplies upgrade scripts for all releases starting with 7.0.1.
Special Information for Oracle RAC
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.
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
- Create a service option to specify the network service name of the Oracle database.
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
Support of Oracle RAC also requires that you deploy the Universal Connection Pool library.
When connected to an Oracle RAC configuration, the UCS database layer uses the ucp.jar file for connection handling. If UCS is started against an Oracle RAC without the jar file, UCS will fail to start.
Starting from version 8.5.300.36, UCS now provides the ucp.jar file as part of the installation package.
The below section applies only for UCS versions prior to 8.5.300.36
To deploy the UCP library:
- Download the ucp.jarfile, version 220.127.116.11.0 (higher versions are not supported) from the Oracle web site.
- Copy the jar file to the UCS home folder in ./lib/db/oracle.