CIC Database Configuration options for Oracle

We offer two CIC Database Configuration options to allow database administrators the flexibility to create the database using different accounts with different permissions without sharing those credentials, and also give the freedom to have this work performed before the CIC server installation begins.

Option 1: Typical CIC installation sequence for Oracle using IC Setup Assistant

When running IC Setup Assistant as part of the CIC server installation, Setup Assistant prompts for CIC Database Configuration information for Oracle. Setup Assistant performs the necessary database creation and configuration for CIC during the commit stage.

This method is most commonly used and is highly recommended.

Option 2: Database creation/upgrade scripts

Manually run the database creation scripts to create the CIC database any time prior to the CIC server installation.

Oracle database creation/upgrade scripts for the latest release are available in the \Installs\Additional Files\SQL directory on the CIC 2016 R1 or later release and patch iso .files. The zip file is also available on the Downloads page at https://help.genesys.com/pureconnect/secure/Downloads.aspx  .

Important: Migrating data between 2.4 or 3.0 and 2015 R1 or later versions of CIC is not covered in this content. For more information, see the Interaction Migrator Technical Reference.

When running IC Setup Assistant as part of the CIC server installation, complete the database-related screens in Setup Assistant to configure CIC to use the database. In the Configure the IC Database Schema screen, choose to use an existing database.

This option is the most complex and requires manual SQL execution. This method is provided for sites where the database administrator doesn't want to share credentials or wants to know what the scripts will do ahead of time.