修改oracle数据库字符集

关闭db1，保留一个节点SQL> shutdown immediate在db1上以root用户执行，停止该节点的cluster服务./crsctl stop crs在db2上查看是否使用sfile启动SQL>show parameter spfile;若VALUE为空，表示用pfile参数启动，即修改为spfile参数启动：SQL>CREATE SPFILE FROM PFILE;SQL>shutdown immediate;SQL>startup;修改字符集：SQL> alter system set cluster_database=false scope=spfile;SQL> shutdown immediateSQL> startup mountSQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;SQL> alter database open;SQL> ALTER DATABASE character set INTERNAL_USE AL32UTF8;SQL> alter system set cluster_database=true scope=spfile;SQL> shutdown immediateSQL> startup在db1上以root用户执行，启动该结点的cluster服务./crsctl start crs在db1上执行SQL> startup查看结果SQL> col parameter format a28SQL> col value format a35select * from nls_database_parameters;