技术头条 - 一个快速在微博传播文章的方式     搜索本站
您现在的位置首页 --> Oracle --> ORACEL RAC 字符集

ORACEL RAC 字符集

浏览:4628次  出处信息

记录下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.

建议继续学习:

  1. linux下vim的编译以及终端乱码的最终解决方案    (阅读:3518)
  2. 区分一个包含汉字的字符串是 UTF-8 还是 GBK    (阅读:3299)
  3. 如何在MYSQL5.5只支出utf8环境下正常使用GBK网站    (阅读:2854)
  4. oracle查看字符集 修改字符集    (阅读:2842)
  5. Oracle RAC廉价数据仓库解决方案    (阅读:2620)
  6. Oracle RAC中的RDS内部互联    (阅读:2607)
  7. mysql latin1转utf8 的两种方法    (阅读:2475)
  8. RAC的负载均衡    (阅读:2592)
  9. kswapd 进程占用过多资源导致RAC宕机    (阅读:2461)
  10. mysql字符集和校验规则概念小介    (阅读:2287)
QQ技术交流群:445447336,欢迎加入!
扫一扫订阅我的微信号:IT技术博客大学习
© 2009 - 2024 by blogread.cn 微博:@IT技术博客大学习

京ICP备15002552号-1