RAC 特定参数设置

除了实例和线程参数外,还有一些在RAC环境中有特殊意义的参数:

Cluster_Database

Cluster_Interconnects

Active_Instance_Count

Max_Commit_Propagation_Delay

[@more@]

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

cluster_database 决定着控制文件是否要在共享模式下安装,大多数情况下必须将此值设置为true;升级打补丁时所有实例必须关闭,且只有该实例被打开并将cluster_database设置为false;升级脚本通常在startup migrate 命令之后运行;另外情况是数据库要设置成归档日志模式或闪回模式时必须将所有实例关闭后将cluster_database设置为false;然后才能startup mount 设置alter database archivelog

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

cluster_interconnects 用于指定集群中的IPC通信网络;在修改cluster_interconnects时必须对每个实例都进行修改,像下面这样指定实例名:

alter system set cluster_interconnects = '192.168.1.25' scope = spfile sid = 'grid1';

alter system set cluster_interconnects = '192.168.1.26' scope = spfile sid = 'grid2';

指定两个IP地址可以在中间加上冒号

alter system set cluster_interconnects = '10.1.1.11:192.168.1.25' scope = spfile sid = 'grid2';

alter system set cluster_interconnects = '10.1.1.12:192.168.1.26' scope = spfile sid = 'grid2';

在sqlplus 中用oradebug ipc命令检查互连情况,首先必须加入pid

SQL> oradebug setmypid

statement processed

SQL>oradebug ipc

Information written to trace file

admno 0x4169a831 admport:
SSKGXPT 0x1044acb0 flags SSKGXPT_READPENDING socket no 7 IP 10.0.0.2 UDP 33381
context timestamp 0x36
no ports
sconno accono ertt state seq# sent async sync rtrans acks
0x65b62428 0x7589e9e0 32 3 32766 3 3 0 0 3
0x65b62429 0x3aff8b50 32 3 32764 1 1 0 0 1

在udump 查找跟踪文件有显示IP字样

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

active_instance_count 该参数最好设置为集群中实例的总数

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

max_commit_propagation_delay定义本地实例的SGA中系统变更号(system change number,SCN)在被LGWR进程刷新之前保持的最长时间,默认设置为700(7秒);如果置0 会看到Lamport方案被选中,会增加网络上的消息通信量,对性能造成轻微影响

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/216109/viewspace-1002430/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/216109/viewspace-1002430/