SQLPLUS doesn't start after export NLS_LANG
497150Jan 6 2007 — edited Jan 8 2007I have the problem on 10.2.0.2 oracle install on a aix5.2 box - ora10.2.0.2. The oracle clients tried are 9.2.0.7 & 10.2.0.2 on linux-SLSE9 (32-bit).
The developers need to experiment with different character sets but when they issue export NLS_LANG=AMERICAN_AMERICA.UTF8 and try to start SQLPLUS after that they get the error below. If we do not export NLS_LANG, we get unappropriate values.
What we are doing wrong and how can we oversome this problem?
Thanks a lot,
MJ
error:
user1@lnx3:~/depot_linux/apps/test$export NLS_LANG=AMERICAN_AMERICA.UTF8
user1@lnx3:~/depot_linux/apps/test$ echo $NLS_LANG
AMERICAN_AMERICA.UTF8
user1@lnx3:~/depot_linux/apps/test$ sqlplus user/pwd1@ora10gr2
Message 133 not found; product=SQLPlus; facility=SP2
: Release 9.2.0.7.0 - Production on Fri Jan 5 15:48:20 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified
Enter user-name: