可以往表test里插入汉字,但是select test时就显示乱码。
SCOTT@PROD>select empno,ename,sal from test;
EMPNO ENAME SAL
---------- ---------- ----------
7900 JAMES 950
7902 ?? 3000
7934 ?? 1430
9000 ?? 2090
查询了oracle server端的字符集:
SCOTT@PROD>select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
解决过程如下:
/etc/sysconfig/i18n内容设置如下:
LANG="zh_CN.GB18030"
SUPPORTED="zh_CN.GB18030:zh_CN:zh:en_US.UTF-8:en_US:en"
SYSFONT="latarcyrheb-sun16"
默认是如下的:(被注释掉)
#LANG="en_US.UTF-8"
#SUPPORTED="en_US.UTF-8:en_US:en"
#SYSFONT="latarcyrheb-sun16"
exit退出sqlplus,以oracle用户执行命令:
[oracle@redhat ~]$export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
其中NLS_LANG的格式为:LANGUAGE_TERRITORY.CHARACTERSET
可以从V$NLS_PARAMETERS里查询到。
LANGUAGE指定:
-Oracle消息使用的语言
-日期中月份和日显示
TERRITORY指定
-货币和数字格式
-地区和计算星期及日期的习惯
CHARACTERSET:
-控制客户端应用程序使用的字符集
执行命令后,重新登陆sqlplus 查询即可:
SCOTT@PROD>select empno,ename,sal from test;
EMPNO ENAME SAL
---------- ---------- ----------
7900 JAMES 950
7902 发哥 3000
7934 阿郎 1430
9000 乔丹 2090
可以将命令:
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
加入到.bash_profile文件里。
更多参考:
the specified nodes are not clusterable
根据rowid删除表中重复的行
Agent process exited abnormally during initialization
一次字符乱码的解决过程
rman实验(一)
rman实验(二)
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
linux下完全删除oracle
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
centos4.8_64上安装oracle10201建库报ORA-12547
EM乱码解决
ORA-31613 Master process DM00 failed during startup
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-24324 ORA-01041 ORA-03113
centos5.3升级oracle
pdksh-5.2.14-36.el5.i386.rpm
使用rman进行数据库迁移
oracle10.2.0.1升级到10.2.0.4报错
Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
改oracle的name和dbid
修改oracle实例名
Solaris8上迁移oracle8i---上
Solaris8上迁移oracle8i---下
未备份归档日志导致数据丢失的实验
使用NBU进行数据库迁移
catalog备份数据库
RMAN FORMAT字符串格式化
Error: can not register my instance state - -1
not all alterations performed
The ASM instance configured on the local node is a single-instance ASM
/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared
Initializing the Oracle ASMLib driver: [FAILED]
ORA-00245: control file backup operation failed
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
模拟恢复参数文件
Interface eth0 checked failed
import server uses ZHS16GBK character set (possible charset conversion)