数据库RAC添加新节点的操作步骤(门户数据库PDSDB)(2)

ssh ftpds_priv3 date ssh ftpds_priv4 date

7.修改核心参数

vi /etc/sysctl.conf

# Controls the maximum shared segment size, in bytes kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages kernel.shmall = 4294967296 kernel.core_uses_pid = 1 kernel.panic = 1

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65000

# For 11g, recommended value for file-max is 6815744

# For 10g, uncomment 'fs.file-max 327679', comment other entries for this parameter and re-run sysctl -p

# fs.file-max:327679

kernel.msgmni = 2878

kernel.sem = 250 32000 100 142

kernel.shmmni = 4096

net.core.rmem_default = 1048576

# For 11g, recommended value for net.core.rmem_max is 4194304 net.core.rmem_max = 4194304

# For 10g, uncomment 'net.core.rmem_max 2097152', comment other entries for this parameter and re-run sysctl -p

# net.core.rmem_max=2097152 net.core.wmem_default = 262144

# For 11g, recommended value for wmem_max is 1048576

net.core.wmem_max = 1048576

# For 10g, uncomment 'net.core.wmem_max 262144', comment other entries for this parameter and re-run sysctl -p

# net.core.wmem_max:262144

fs.aio-max-nr = 3145728

# For 11g, recommended value for ip_local_port_range is 9000 65500

# For 10g, uncomment 'net.ipv4.ip_local_port_range 1024 65000', comment other entries for this parameter and re-run sysctl -p

# net.ipv4.ip_local_port_range:1024 65000 sysctl -p 立刻生效

vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536

vi /etc/pam.d/login

session required pam_limits.so

vi /etc/rc.d/rc.local

/sbin/modprobehangcheck_timer

设置hangcheck内核模块参数： vi /etc/modprobe.conf

optionshangcheck-timer hangcheck_tick=30 hangcheck_margin=180 设置hangcheck内核模块开机加载 vi /etc/rc.d/rc.local

/sbin/modprobehangcheck-timer

要立即加载模块，执行： modprobe -v hangcheck-timer

检查加载情况：

[root@zhh1 ~]# lsmod | grephangcheck_timer

hangcheck_timer 5593 0

8.安装ASM包，配置ASM，并搜索ASM

--在rac3上安装ASMLibs, tools, support 三个rpm文件 # rpm -ivh *.rpm --nodeps --force

-- 运行 /etc/init.d/oracleasm configure 回答 oracle , dba, y, y 就可以了

vi /usr/local/sbin/oraraw.sh

#####

# Oracle Cluster Registry (OCR) devices ##### chownroot:oinstall /dev/mapper/ocr

chmod 660 /dev/mapper/*

raw /dev/raw/raw1 /dev/mapper/ocr sleep 2

chownroot:oinstall /dev/raw/raw1 chmod 660 /dev/raw/raw1

#####

# Oracle Cluster Voting disks

#####

chownoracle:oinstall /dev/mapper/vtdsk

raw /dev/raw/raw2 /dev/mapper/vtdsk sleep 2

chownoracle:oinstall /dev/raw/raw2

chownoracle:oinstall /dev/mapper/arch chownoracle:oinstall /dev/mapper/data* chownoracle:oinstall /dev/mapper/redo*

9.安装CRS

cd /apps/software/clusterware/cluvfy

./cluvfy stage -post hwos -n BJ-FT-1F-120-11,BJ-FT-1F-120-13

./cluvfy stage -post hwos -n BJ-FT-1F-120-11,BJ-FT-1F-120-12,BJ-FT-1F-120-13,BJ-FT-1F-120-14 ./runcluvfy.sh stage -pre

BJ-FT-1F-120-11,BJ-FT-1F-120-12,BJ-FT-1F-120-13,BJ-FT-1F-120-14

crsinst

-n

./runInstaller -updateNodeList \LOCAL_NODE=\

. 为新节点添加CRS Home

启动vnc http://192.168.120.13:5801/ xhost+ su - oracle

export LANG=en

在【BJ-FT-1F-120-13】上运行CRS Home下的addNode.sh，启动OUI添加节点。原计划在BJ-FT-1F-120-11上执行，但是上面报错，报错内容为

SEVERE: OUI-25023: The local node is not selected for installing this product. Include the local node in the cluster list or perform t

he installation on the nodes on which the install is to be performed. 未找到解决办法，在节点13上执行通过。 cd /apps/oracle/crs/oui/bin ./addNode.sh