My distribution is CentOS 5.5, I installed Oracle 11g and create an instance setting its character set as AL32UTF8. The problem is the message from oracle cannot be shown correctly, like this:

ORA-00942: ???????

I guess that maybe the characterset of my CentOS differs from what oracle uses. So i turned to /etc/sysconfig/i18n and found:

LANG="zh_CN.UTF-8"

So i changed contents of i18n to:
LANG="zh_CN.AL32UTF8"
But still cannot solve the problem.
Maybe my linux don't know what AL32UTF8 is???
What shall I do ??? please help me !!!

As far as I know there is no character set AL32UTF8 in Linux. Maybe in Oracle. So change your LANG environment back. If you can not see UTF8 messages on console, try to switch it by command "unicode_start" and check that you have loaded unicode fonts.

Hye,

AL32UTF8 is an Oracle internal database character set. There is no dependency to the Linux character set.

To set Oracle charset on shell create the variable NLS_LANG.

To set Linux charset use shell variable LANG, or set the value persistent for all users across reboot in /etc/sysconfig/i18n.

1 members found this post helpful.