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).
- Refer to the Oracle documentation to install the Oracle Database Management System on the host machine.
- 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;
Note: The above quota value is an example. Consult the Oracle documentation to determine the correct quota value for your system.
- If you are setting up a new Configuration Server, perform the following steps on the Configuration Server host:
- Run the Oracle Net Configuration Assistant.
- Select Local Net Service Name Configuration to create an entry in the tnsnames.ora file to map the
Local Net Service Name to the host, port, and SID (System ID) used by the database.
Note: The Local Net Service Name must be the same as the SID in order for Setup Mode in GAX to work properly.
- The ORACLE_HOME environment variable must be set to the installation directory of the Oracle database client.
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).