RAC环境修改数据库字符集

sql> alter system set cluster_database=false scope=spfile sid=‘qcjk1‘;   --------注意sid根据不同环境要修改


在rac两节点都要关闭数据库：
sql>shutdown immediate;


在rac1节点将数据库启动到nomount状态：
sql>startup nomount;


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.


4、修改字符集
SQL> ALTER DATABASE character set INTERNAL_USE zhs16gbk;
sql> alter system set cluster_database=true scope=spfile sid=‘qcjk1‘;




5、验证（两个节点都要测）
Database altered.
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.


Total System Global Area 1577058304 bytes
Fixed Size                  2084264 bytes
Variable Size             436208216 bytes
Database Buffers         1124073472 bytes
Redo Buffers               14692352 bytes
Database mounted.
Database opened.
SQL> select userenv(‘language‘) from dual;


USERENV(‘LANGUAGE‘)
--------------------------------------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK




6、启动rac2，验证rac2的字符集

RAC环境修改数据库字符集

标签：lang   ora   immediate   sele   instance   sys   character   tar   star