Genesys Quality Management Suite 8.1.520 : Prerequisites: Preparing for Oracle

Preparing for Oracle

Before beginning a Genesys Quality Management Suite installation, complete the following tasks:

  1. Set up access and credentials, administrative database username & password and optional tablespace for Genesys Quality Management Suite, in a running Oracle database instance. An administrative username and password is needed when Creating DB Schema in Oracle.

  2. Set NLS_LANG Environment variable, via the following steps:
    1. Determine the NLS_LANG value.
      1. In the data warehouse database, run the command:

        SELECT * FROM V$NLS_PARAMETERS
      2. Make a note of the NLS_LANG value, which is in the format [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].

        For example: American_America.UTF8

    2. Set the variable for windows:
      1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
      2. In System variables section, click New.
      3. In the Variable Name field, enter NLS_LANG.
      4. In the Variable Value field, enter the NLS_LANG value that was returned in a

        The format for the NLS_LANG value should be [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].

        For example: American_America.UTF8.

    3. To set the value of the NLS_LANG parameter in UNIX, NLS_LANG is set as a local environment variable.
      If your data is 7-bit or 8-bit ASCII and the Informatica Server is running on UNIX, then set the value of NLS_LANG as <NLS_LANGUAGE>_<NLS_TERRITORY>.WE8ISO8859P1

      Icon
      Make sure you set the NLS_LANG variable correctly, as stated in this procedure, or your data will not display correctly.
    4. Reboot your machine after creating the variable.

Final Checks

by the end of these steps you should be able to provide the following info:

  • Oracle Server IP address
  • Oracle Server port
  • Oracle Service Name