在db1上执行
SQL> shutdown immediate
在db1上以root用户执行,停止该结点的cluster服务
./crsctl stop cluster
在db2上执行
SQL> alter system set cluster_database=false scope=spfile;
SQL> shutdown immediate
SQL> startup mount
SQL> 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 immediate
SQL> startup
在db1上以root用户执行,启动该结点的cluster服务
./crsctl start cluster
在db1上执行
SQL> startup
查看结果
SQL> col parameter format a28
SQL> col value format a35
select * from nls_database_parameters;