At the moment I’m working for a customer that installs all client computers with a German version of Windows. Ok, I can live with that. But unfortunately, all Oracle tools are installed by default in German as well. But I want to use the Oracle tools in English. Whenever you tried to understand the German translations of Oracle error messages you probably know what I mean…
Usually, the base language of all Oracle client tools is derived by the Oracle Installer from the language settings of the operating system. This can be useful in many cases, but sometimes you want to configure different language settings in Oracle. The environment variable NLS_LANG is available for such cases. When this variable is set to English, the original messages are displayed in SQL*Plus and most other Oracle tools.
But Oracle Warehouse Builder does not care about these settings and uses its own language configuration. In previous releases of OWB we were able to change the language in the Preferences menu of OWB Design Center. Unfortunately, this is not possible anymore since OWB 11g Release 2. But there is a workaround which still allows to change the language in the OWB Client tools. Open the configuration file $ORACLE_HOME/ide/bin/ide.conf and add the following line to the file:
After you saved the file and reopen OWB Design Center, all menu items, object types and messages of Oracle Warehouse Builder will be displayed in English – independent of the operating system language.