字符集问题 ,日志中 有问号

本帖最后由 hanshiqin 于 2013-8-9 19:39 编辑

大致环境:
10.2.4.0 RAC
系统平台:红旗linux

locale
LANG=zh_CN.GB18030
LC_CTYPE="zh_CN.GB18030"
LC_NUMERIC="zh_CN.GB18030"
LC_TIME="zh_CN.GB18030"
LC_COLLATE="zh_CN.GB18030"
LC_MONETARY="zh_CN.GB18030"
LC_MESSAGES="zh_CN.GB18030"
LC_PAPER="zh_CN.GB18030"
LC_NAME="zh_CN.GB18030"
LC_ADDRESS="zh_CN.GB18030"
LC_TELEPHONE="zh_CN.GB18030"
LC_MEASUREMENT="zh_CN.GB18030"
LC_IDENTIFICATION="zh_CN.GB18030"
LC_ALL=zh_CN.GB18030


select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY ?
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.4.0

20 rows selected.


下面为截取的一段 alert日志
Errors in file /oracle/admin/moe/bdump/moe2_dbw0_27042.trc:
ORA-01157: ????/?????? 201 - ??? DBWR ????
ORA-01110: ???? 201: '+DATA/moe/tempfile/temp.281.752557099'
ORA-17503: ksfdopn: 2 ?????? +DATA/moe/tempfile/temp.281.752557099
ORA-15012: ASM file '+DATA/moe/tempfile/temp.281.752557099' does not exist
Fri Aug 9 15:17:45 2013
Errors in file /oracle/admin/moe/bdump/moe2_dbw0_27042.trc:
ORA-01186: ?? 201 ??????
ORA-01157: ????/?????? 201 - ??? DBWR ????
ORA-01110: ???? 201: '+DATA/moe/tempfile/temp.281.752557099'
Fri Aug 9 15:17:45 2013
File 201 not verified due to error ORA-01157
Fri Aug 9 15:17:45 2013
Dictionary check complete
Fri Aug 9 15:17:45 2013
SMON: enabling tx recovery
Fri Aug 9 15:17:45 2013
Re-creating tempfile +DATA/moe/tempfile/temp.281.752557099 as +DATA/moe/tempfile/temp.312.823015065
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=39, OS id=14312
Fri Aug 9 15:17:49 2013
LOGSTDBY: Validating controlfile with logical metadata
Fri Aug 9 15:17:49 2013
LOGSTDBY: Validation complete
Starting control autobackup
Fri Aug 9 15:18:00 2013
Control autobackup written to DISK device
handle '/home/moe/qianyidata/control_0_c-2267531081-20130809-00.bak'
Completed: alter database open resetlogs
Fri Aug 9 15:19:10 2013
Thread 2 advanced to log sequence 2 (LGWR switch)
Current log# 5 seq# 2 mem# 0: +DATA/moe/onlinelog/group_5.344.823015049
Current log# 5 seq# 2 mem# 1: +DATA/moe/onlinelog/group_5.345.823015051
Fri Aug 9 15:21:01 2013
Thread 2 advanced to log sequence 3 (LGWR switch)
Current log# 6 seq# 3 mem# 0: +DATA/moe/onlinelog/group_6.346.823015055
Current log# 6 seq# 3 mem# 1: +DATA/moe/onlinelog/group_6.268.823015057
Fri Aug 9 15:21:12 2013
Thread 1 advanced to log sequence 2 (archiver wakeup)
Fri Aug 9 15:23:35 2013
Thread 2 advanced to log sequence 4 (LGWR switch)
Current log# 4 seq# 4 mem# 0: +DATA/moe/onlinelog/group_4.342.823015043
Current log# 4 seq# 4 mem# 1: +DATA/moe/onlinelog/group_4.343.823015047
Fri Aug 9 15:24:03 2013
Reconfiguration started (old inc 2, new inc 4)
List of nodes:


标签: 暂无标签
hanshiqin

写了 4 篇文章,拥有财富 71,被 2 人关注

转播转播 分享分享 分享淘帖
回复

使用道具

P4 | 发表于 2013-9-9 16:31:31
jackey.qiu 发表于 2013-8-27 22:36
这个应该是你的红旗linux问题,你安装的时候不要安装中文版,直接安装的时候选择英文 ...

噢,多谢。邱老师。
回复

使用道具

P4 | 发表于 2013-9-3 23:24:03
老师 已经是中文版了 怎么解决 网上办法一一试过不行  
例如 exprot LANG= ‘不行’

数据库中还是有中文乱码
回复

使用道具

P4 | 发表于 2013-8-27 22:36:53
这个应该是你的红旗linux问题,你安装的时候不要安装中文版,直接安装的时候选择英文
回复

使用道具

您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈