System version:
Oracle Linux Server Release 5.7
Database version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
PL/SQL Release 11.2.0.3.0-production
CORE 11.2.0.3.0 Production
TNS for Linux:version 11.2.0.3.0-production
Nlsrtl Version 11.2.0.3.0-production
To view the character set:
Sql>select userenv (' language ') from dual;
USERENV (' LANGUAGE ') American_america. Al32utf8
Close one of the RAC nodes:
[[Email protected] ~] #cd/u01/app/11.2.0/grid/bin/crsctl
[[email protected] ~]#./crsctl Stop cluster
Execute on another node:
Sql>alter system set Cluster_database=false scope=spfile;
To close the database:
Sql>shutdown immediate;
Sql>startup Mount;
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.
To modify a character set:
Sql> ALTER DATABASE Character set Internal_use ZHS16GBK;
Database altered.
Restore the database to RAC:
Sql> alter system set CLUSTER_DATABASE=TRUE Scope=spfile;
sql> shutdown immediate;
sql>startup;
Sql> Execute sys.dbms_metadata_util.load_stylesheets;
Start another node Cluster service and verify that:
[[email protected] ~]#./crsctl start cluster
To view the character set:
Sql>select userenv (' language ') from dual;
USERENV (' LANGUAGE ')
American_america. Zhs16gbk
Reference post: http://blog.itpub.net/28939273/viewspace-1061440/
Oracle 11g RAC Modified character set