Configuring Oracle Character Set Support

Status

If you are...	This task is...
Installing a new iProcess Engine Version 11.8.0	Possibly required
Upgrading from an iProcess Engine Version 11.0 or later	Possibly required

Database

Oracle

Description

Oracle’s NLS_LANG parameter sets the language, territory, and character set that the iProcess Engine uses to communicate with the Oracle database. The iProcess Engine requires that NLS_LANG uses an 8-bit character set.

Node-Cluster

NLS_LANG must be set to the same value on the master server and on each slave server.

Procedure

To set NLS_LANG, complete the following steps:

1. Log in as the user (root, iProcess Files-install Owner, or iProcess Schema-install Owner), see iProcess Engine Architecture for more information) who will run the installer.

2. Set the NLS_LANG environment variable to use an 8-bit character set component (charset).

3. If you are using a TNS connection, make sure that the character set component (charset) of the NLS_LANG environment variable for the Oracle client matches the character set component of the NLS_LANG setting on the Oracle database.

The format of the NLS_LANG string is: NLS_LANG = language_territory.charset

Example

export NLS_LANG=American_America.WE8ISO8859P1