# 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