sql> alter system set cluster_database=false scope=spfile sid='prod1';
--------注意sid根据不同环境要修改
在rac两节点都要关闭数据库:
sql>shutdown immediate;
在rac1节点将数据库启动到nomount状态:
SQL>SHUTDOWN IMMEDIATE;
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='prod1';
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
在rac两节点都要关闭数据库:
sql>shutdown immediate;
在rac1节点将数据库启动到nomount状态:
SQL>SHUTDOWN IMMEDIATE;
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='prod1';
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的字符集
可能遇到的问题,节点启动时报错,不能在exclusive模式下启动
问题原因:
更改字符集时,修改了 cluster_database=false
忘记了设置cluster_database=true
更改字符集时,修改了 cluster_database=false
忘记了设置cluster_database=true
解决方法:
使用如下命令设置cluster_database=true
使用如下命令设置cluster_database=true
alter system set cluster_database=true scope=spfile sid='*';
如果两个节点的spfile或pfile不在一起,需要在两个节点上都设置。