Oracle^® Business Intelligence Applications Installation and Configuration Guide > Preinstallation and Predeployment Considerations for Oracle BI Applications > Deploying Oracle Business Analytics Warehouse in Latin-1 General, Unicode and Non-English Environments >

Setting the NLS_LANG Environment Variable for Oracle Databases

Follow this procedure to set the NLS_LANG environment variable for Oracle databases.

NOTE:  You need to set the NLS_LANG environment variable on the machine that runs the Informatica server, and on the machine that runs the Oracle client.

To set the NLS_LANG environment variable for Oracle databases

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. 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 Step 1.

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

      For example: American_America.UTF8.

3. For UNIX, set the variable as shown below:

   setenv NLS_LANG <NLS_LANG>

   For example: setenv NLS_LANG American_America.UTF8.

   If your data is 7-bit or 8-bit ASCII and the Informatica Server is running on UNIX, then set

   NLS_LANG <NLS_LANGUAGE>_<NLS_TERRITORY>.WE8ISO8859P1

   CAUTION:  Make sure you set the NLS_LANG variable correctly, as stated in this procedure, or your data will not display correctly.

4. Reboot the machine after creating the variable.