You must set the following environment variables when connecting to an Oracle data source:

For Oracle databases on Linux platforms, the account running iHub processes must have a definition for the standard Oracle environment variable ORACLE_HOME. You can provide this definition in a login script such as .cshrc or .profile, or you can include it in the scripts that start the iHub processes.

For Oracle databases on Windows, also ensure that the definition of the environment variable PATH indicates the location of the dynamic link library that selects the proper database.

The Oracle Linux environment variable and Windows registry setting NLS_LANG specifies the Oracle locale, that consists of the language, territory, and character set. The default value for NLS_LANG is American_America.US7ASCII. The administrator must ensure the NLS_LANG setting is correct for the information in the Oracle database.

On Linux systems, add the environment variable NLS_LANG to the pmd11.sh script, the iHub request server startup script. On Windows servers, the Oracle installer configures NLS_LANG.

The following example sets NLS_LANG for simplified Chinese on Linux:

Double quotes are required when setting a value that contains spaces.

On Microsoft Windows server operating systems, set the NLS_LANG registry value in the key HKEY_LOCAL_MACHINE \Software\Oracle\Home.

For information about the NLS_LANG values, see the Oracle documentation.