/*今天群里有哥们问一个关于乱码的问题,遂贴上以前处理的一个乱码相关的处理文档*/
/*oracle alert日志乱码处理*/
--日志乱码如下:
client_id='' type='UNKNOWN' level='16'
host_id='M1HFData' host_addr='::1' module=''
pid='31745'>
Errors in file /m1hf/diag/rdbms/m1hf/m1hf/trace/m1hf_j000_31745.trc:
ORA-12012: 脳脭露炉脰麓脨脨脳梅脪碌 64 鲁枚麓铆
ORA-04063: package body "SYSMAN.EMD_MAINTENANCE" 脫脨麓铆脦贸
ORA-06508: PL/SQL: 脦脼路篓脮脪碌陆脮媒脭脷碌梅脫脙 : "SYSMAN.EMD_MAINTENANCE" 碌脛鲁脤脨貌碌楼脭陋
ORA-06512: 脭脷 line 1
host_id='M1HFData' host_addr='::1' module=''
pid='31745'>
Errors in file /m1hf/diag/rdbms/m1hf/m1hf/trace/m1hf_j000_31745.trc:
ORA-12012: 脳脭露炉脰麓脨脨脳梅脪碌 64 鲁枚麓铆
ORA-04063: package body "SYSMAN.EMD_MAINTENANCE" 脫脨麓铆脦贸
ORA-06508: PL/SQL: 脦脼路篓脮脪碌陆脮媒脭脷碌梅脫脙 : "SYSMAN.EMD_MAINTENANCE" 碌脛鲁脤脨貌碌楼脭陋
ORA-06512: 脭脷 line 1
查看OS字符集:
[oracle@m1hfdata ~]$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
查看数据库字符集:
SQL> select * from v$nls_parameters where parameter ='NLS_CHARACTERSET';
PARAMETER VALUE
------------------------- --------------------
NLS_CHARACTERSET ZHS16GBK
------------------------- --------------------
NLS_CHARACTERSET ZHS16GBK
查看用户环境变量:
[oracle@m1hfdata ~]$ id
uid=501(oracle) gid=501(oinstall) 组=501(oinstall),502(dba) 环境=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@m1hfdata ~]$ env | grep NLS_
NLS_LANG=Simplified Chinese_china.ZHS16GBK
uid=501(oracle) gid=501(oinstall) 组=501(oinstall),502(dba) 环境=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@m1hfdata ~]$ env | grep NLS_
NLS_LANG=Simplified Chinese_china.ZHS16GBK
/*由以上信息可知,OS的字符集和数据库字符集不一致导致 alert 日志文件中的中文错误信息出现乱码。*/
--即修改后如下:
[oracle@m1hfdata ~]$ locale
LANG=zh_CN.gbk
LC_CTYPE="zh_CN.gbk"
LC_NUMERIC="zh_CN.gbk"
LC_TIME="zh_CN.gbk"
LC_COLLATE="zh_CN.gbk"
LC_MONETARY="zh_CN.gbk"
LC_MESSAGES="zh_CN.gbk"
LC_PAPER="zh_CN.gbk"
LC_NAME="zh_CN.gbk"
LC_ADDRESS="zh_CN.gbk"
LC_TELEPHONE="zh_CN.gbk"
LC_MEASUREMENT="zh_CN.gbk"
LC_IDENTIFICATION="zh_CN.gbk"
LC_ALL=
[oracle@m1hfdata ~]$ locale
LANG=zh_CN.gbk
LC_CTYPE="zh_CN.gbk"
LC_NUMERIC="zh_CN.gbk"
LC_TIME="zh_CN.gbk"
LC_COLLATE="zh_CN.gbk"
LC_MONETARY="zh_CN.gbk"
LC_MESSAGES="zh_CN.gbk"
LC_PAPER="zh_CN.gbk"
LC_NAME="zh_CN.gbk"
LC_ADDRESS="zh_CN.gbk"
LC_TELEPHONE="zh_CN.gbk"
LC_MEASUREMENT="zh_CN.gbk"
LC_IDENTIFICATION="zh_CN.gbk"
LC_ALL=
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26143577/viewspace-719912/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26143577/viewspace-719912/