Setting Up the Genesys Administrator Extension Database (for Oracle)

Use the following procedure to set up the Oracle 11g R2 or Oracle 12c database that is used by Genesys Administrator Extension.

If you prefer to use PostgreSQL or Microsoft SQL Server, see Setting up the Genesys Administrator database (for Microsoft SQL Server) or Setting up the Genesys Administrator database (for PostgreSQL).

  1. Refer to the Oracle documentation to install the Oracle Database Management System on the host machine.
  2. Use the following SQL commands to create the users and ensure that they do not have excessive permissions:
    create user <username> identified by <password>;
    grant connect, resource to <username>;
    alter user <username> quota 10M on USERS;
  3. Note: The above quota value is an example. Consult the Oracle documentation to determine the correct quota value for your system.
  4. If you are setting up a new Configuration Server, perform the following steps on the Configuration Server host: Refer to the Oracle documentation for additional details on completing this step.

Note: To enable UTF-8 character encoding, see Enabling UTF-8 character encoding (for Oracle).