Preparing for Oracle
Before beginning a Genesys Quality Management Suite installation, complete the following tasks:
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.
- Set NLS_LANG Environment variable, via the following steps:
- Determine the NLS_LANG value.
In the data warehouse database, run the command:
SELECT * FROM V$NLS_PARAMETERS
- Make a note of the NLS_LANG value, which is in the format [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
For example:
American_America.UTF8
- Set the variable for windows:
- Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
- In System variables section, click New.
- In the Variable Name field, enter
NLS_LANG. - 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.
- Reboot your machine after creating the variable.
- Determine the NLS_LANG value.
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