NLS_LANG variable set in the user profile are not taken in account or overwritten by Dollar Universe during uproc execution.

Document ID : KB000085594
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
No error message.

Patch level detected:Dollar Universe 6.0.00
Product Version: Dollar.Universe 6.0.0

Description :NLS_LANG variable set in the user profile are not taken in account or overwritten by Dollar Universe during uproc execution. As a consequence, Oracle jobs or any jobs that use NLS_LANG may fail.
Environment:
OS: All Unix
OS Version: ALL UNIX/LINUX
Cause:
Cause type:
Configuration
Root Cause: The main reason for this is because the variable NLS_LANG does not contain any value in the Technical Settings for Oracle in the NodeSettings of the Dollar Universe node.
Resolution:
There two possible workarounds as explained below.

Option 1:

*** Please note that when you have to use Oracle Manager, you will need to put the original variables.xml back ***

-Stop Dollar Universe.

- Make a backup of /bin/variables.xml.

-Then, modify the /bin/variables.xml by removing the following lines(This will remove the parameter NLS_LANG Oracle variable(used by the OAP service) in the NodeSettings of Dollar Universe):



NLS_LANG Oracle variable (used by the OAP service)
Variable Oracle NLS_LANG (utilisée par le service OAP)
STATIC







-Restart Dollar Universe.


Option 2:

-Load the environment or user profile again. For example in customer’s profile or another environment file which contains the correct definition of the NLS_LANG, load it first before launching your Oracle jobs or any jobs that used NLS_LANG.

Fix Status: No Fix

Additional Information:
Workaround :
N/A