2 Replies Latest reply: Dec 22, 2012 6:50 PM by Srini Chavali-Oracle RSS

    How to determine correct NLS_LANG settings

      Hi everyone,

      My Database server is RHEL 5.8 32bit with Oracle 11gR2, nls_characterset is AL32UTF8

      My client machine is Windows XP SP2 32bit, Chinese Simplified

      What should be the correct NLS_LANG settings for my client machine?

      When I am not setting the NLS_LANG value, the sqlplus seemed to work, but when I set NLS_LANG=AL32UTF8, the sqlplus gives me below error:
      SP2-1503: Unable to initialize Oracle call interface
      SP2-0152: ORACLE may not be functioning properly