现字符集

SQL>  select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

rac环境转换字符集

关闭数据库
[root@rac2 ~]# srvctl stop database -db hap

转换
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 4999609048 bytes
Fixed Size                  9145048 bytes
Variable Size             956301312 bytes
Database Buffers         4026531840 bytes
Redo Buffers                7630848 bytes
SQL> alter system set cluster_database=FALSE scope=spfile sid='*';
System altered.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 4999609048 bytes
Fixed Size                  9145048 bytes
Variable Size             956301312 bytes
Database Buffers         4026531840 bytes
Redo Buffers                7630848 bytes
Database mounted.
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 AL32UTF8;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

启动并检查
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 4999609048 bytes
Fixed Size                  9145048 bytes
Variable Size             956301312 bytes
Database Buffers         4026531840 bytes
Redo Buffers                7630848 bytes
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';
System altered.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 4999609048 bytes
Fixed Size                  9145048 bytes
Variable Size             956301312 bytes
Database Buffers         4026531840 bytes
Redo Buffers                7630848 bytes
Database mounted.
Database opened.
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
SQL>

这样rac的字符集就从ZHS16GBK转换成AL32UTF8。