solaris11 spac for oracle rac

THREADS_FLAG=native; export THREADS_FLAG # TEMP, TMP, and TMPDIR export TEMP=/tmp export TMPDIR=/tmp # UMASK umask 022 stty erase ^H $ source .profile # su - oracle $ vi .profile # ORACLE_SID ORACLE_SID=rac1; export ORACLE_SID # ORACLE_UNQNAME ORACLE_UNQNAME=rac; export ORACLE_UNQNAME # ORACLE_BASE ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE # ORACLE_HOME ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME #ORA_GRID_HOME ORA_GRID_HOME=/oracle/app/grid_home/ export NLS_LANG=american_america.zhs16gbk # JAVA_HOME JAVA_HOME=$ORACLE_HOME/jdk; export JAVA_HOME # PATH PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_GRID_HOME/bin PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH - 13/57 -

# LD_LIBRARY_PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib export LD_LIBRARY_PATH # CLASSPATH CLASSPATH=$ORACLE_HOME/JRE CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib export CLASSPATH # THREADS_FLAG THREADS_FLAG=native; export THREADS_FLAG # TEMP, TMP, and TMPDIR export TEMP=/tmp export TMPDIR=/tmp # UMASK umask 022 stty erase ^H

- 14/57 -

3.9 配置Solaris内核参数

在rac1和rac02节点上配置同样的Solaris内核参数。

a) 为grid用户和oracle用户创建projects，配置共享内存参数：

# /usr/sbin/ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port 32768 i 65535 In the preceding example, tcp_smallest_anon_port is set to the default range (32768-65535). If necessary for your anticipated workload or number of servers , update the UDP and TCP ephemeral port range to a broader range. For example: # /usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000 # /usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500 # /usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000 # /usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500 Oracle recommends that you make these settings permanent. Refer to your system administration documentation for information about how to automate this ephemeral port range alteration on system restarts. 创建文件vi /etc/rc2.d/S99nddconfig，设置TCP UDP内核参数，内容如下：（两节点） /usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000 /usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500 /usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000 /usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500 /usr/sbin/ndd -set /dev/udp udp_xmit_hiwat 65536 /usr/sbin/ndd -set /dev/udp udp_recv_hiwat 65536 b) 调整2个节点的swap空间大小

# zfs set volsize=64G rpool/swap # zfs get volsize rpool/swap NAME PROPERTY VALUE SOURCE rpool/swap volsize 64G local c) 修改两台节点的/etc/system文件 set noexec_user_stack=1

set semsys:seminfo_semmni=128 set semsys:seminfo_semmns=1024 set semsys:seminfo_semmsl=256 set semsys:seminfo_semvmx=23767

set shmsys:shminfo_shmmax=274877906943 set shmsys:shminfo_shmmni=128

3.10 双机时间同步

Oracle 11g R2 中新添加了时间同步服务Cluster Time Synchronization - 15/57 -

Service(CTSS)，要想使用该功能，就必须先关闭ntp服务。

在2个节点上关闭NTP服务和sendmail服务：

# svcadm disable ntp # svcadm disable sendmail

把节点2的时间与节点1同步，下面四个操作在2个RAC节点都执行 # svcs -a|grep time

显示以下内容 (都处于不可用状态)

disabled 18:20:49 svc:/network/daytime:stream disabled 18:20:49 svc:/network/daytime:dgram disabled 18:20:50 svc:/network/time:stream disabled 18:20:50 svc:/network/time:dgram 把后面2个改为可用

# svcadm enable time:stream # svcadm enable time:dgram

(以上内容节点idcdb1、idcdb2都执行) root@rac1 # svcs -a|grep time

disabled May_23 svc:/network/daytime:dgram disabled May_23 svc:/network/daytime:stream online 11:34:41 svc:/network/time:stream online 11:34:47 svc:/network/time:dgram 在节点2上执行以下命令，与节点1的时间同步

root@rac2# rdate idcdb1

Grid安装完后检查CTSS是否active： # su - grid

$ crsctl check ctss 此时可单独重启CTSS服务

3.11 配置等效性

需要建立grid用户和oracle用户在节点间的SSH互信关系。建立互信关系的优选方案是使用Grid和Oracle Database安装程序的自动配置功能。如果自动配置功能不能成功，使用如下方法建立互信关系。（grid和oracle用户分别按以下步骤完成配置） 步骤一、idcdb1:

1、mkdir -p ~/.ssh

2、chmod -R 700 /u01(对整个oracle目录受权,关键要保证.ssh的目录权限为700) 3、ssh-keygen -t rsa 4、ssh-keygen -t dsa

步骤二、idcdb2:

1、mkdir -p ~/.ssh

- 16/57 -