ORACEL RAC 字符集
记录下ORACEL RAC 修改字符集的步骤:
一:查看当前的字符集
服务器端字符集:
SQL> select userenv(\'language\') from dual;
USERENV(\'LANGUAGE\')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
客户端字符集:
SQL> select * from v$nls_parameters;
二:修改:
[root@hp131 ~]# su - oracle
hp131-> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 17 14:42:43 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1895825408 bytes
Fixed Size 2084840 bytes
Variable Size 436207640 bytes
Database Buffers 1442840576 bytes
Redo Buffers 14692352 bytes
Database mounted.
SQL> alter session set sql_trace=true;
Session altered.
SQL> alter system enable restricted session;
System altered.
SQL> alter system set job_queue_processes=0;
System altered.
SQL> alter system set aq_tm_processes=0;
System altered.
SQL> alter database open;
Database altered.
SQL> alter database character set INTERNAL_USE UTF8;
alter database character set INTERNAL_USE UTF8
*
ERROR at line 1:
ORA-12720: operation requires database is in EXCLUSIVE mode
关闭其中一个节点
hp131-> srvctl stop nodeapps -n hp132
SQL> alter system set cluster_database=false scope=spfile sid=\'wzticket1\';
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1895825408 bytes
Fixed Size 2084840 bytes
Variable Size 436207640 bytes
Database Buffers 1442840576 bytes
Redo Buffers 14692352 bytes
SQL> Alter database mount exclusive;
Database altered.
SQL> Alter system enable restricted session;
System altered.
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
System altered.
SQL> Alter database open;
Database altered.
SQL> alter database character set INTERNAL_USE UTF8;
Database altered.
SQL> update props$ set VALUE$=\'ZHS16GBK\' where NAME=\'NLS_NCHAR_CHARACTERSET\';
1 row updated.
SQL> commit;
Commit complete.
SQL> alter system set cluster_database=true scope=spfile sid=\'wzticket1\';
System altered.
建议继续学习:
- linux下vim的编译以及终端乱码的最终解决方案 (阅读:3510)
- 区分一个包含汉字的字符串是 UTF-8 还是 GBK (阅读:3293)
- 如何在MYSQL5.5只支出utf8环境下正常使用GBK网站 (阅读:2849)
- oracle查看字符集 修改字符集 (阅读:2826)
- Oracle RAC廉价数据仓库解决方案 (阅读:2600)
- Oracle RAC中的RDS内部互联 (阅读:2588)
- mysql latin1转utf8 的两种方法 (阅读:2469)
- RAC的负载均衡 (阅读:2561)
- kswapd 进程占用过多资源导致RAC宕机 (阅读:2455)
- mysql字符集和校验规则概念小介 (阅读:2279)
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:Mike.Xu 来源: DBA Blog
- 标签: RAC 字符集
- 发布时间:2012-11-02 13:03:25
- [68] Go Reflect 性能
- [68] 如何拿下简短的域名
- [67] Oracle MTS模式下 进程地址与会话信
- [62] IOS安全–浅谈关于IOS加固的几种方法
- [61] 图书馆的世界纪录
- [60] 【社会化设计】自我(self)部分――欢迎区
- [58] android 开发入门
- [56] 视觉调整-设计师 vs. 逻辑
- [49] 给自己的字体课(一)——英文字体基础
- [48] 读书笔记-壹百度:百度十年千倍的29条法则