RAC_INSTALL.txt

1、系统版本检查，安装包确认，补丁集确认
oslevel -s
lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.rte
instfix -i -k "IZ87216 IZ87564 IZ89165 IZ97035"

2、共享内存参数
vmo -p -o maxperm%=90;
vmo -p -o minperm%=3;
vmo -p -o maxclient%=90;
vmo -p -o strict maxperm=0;
vmo -p -o strict maxclient=1;
vmo -p -o lru_file_repage=0;
vmo -r -o page_steal_method=1;
##(need to reboot to take into effect)
vmo -p -o strict_maxclient=1
vmo -p -o strict_maxperm=0;

3、关闭 CPU Folding
schedo -p -o vpm_fold_policy=0

4、修改网络参数
ioo -po aio_maxservers=80
ioo -po aio_minservers=40
no -p -o rfc1323=1
no -p -o sb_max=41943040
no -r -o ipqmaxlen=512
no -p -o udp_sendspace=2097152
no -p -o udp_recvspace=20971520
no -p -o tcp_sendspace=1048576
no -p -o tcp_recvspace=1048576
no -p -o tcp_ephemeral_low=9000
no -p -o tcp_ephemeral_high=65500
no -p -o udp_ephemeral_low=9000
no -p -o udp_ephemeral_high=65500



5、内核参数
修改 chdev -l sys0 -a ncargs='256'
修改 chdev -l sys0 -a maxuproc=16384



7、修改系统资源限制
vi /etc/security/limits
fsize = -1
db = -1
cpu = -1
data = -1
rss = -1
stack = -1
nofiles = -1


8、创建用户
mkgroup -'A' id='501' adms='root' oinstall
mkgroup -'A' id='502' adms='root' asmadmin
mkgroup -'A' id='503' adms='root' asmdba
mkgroup -'A' id='504' adms='root' asmoper
mkgroup -'A' id='505' adms='root' dba
mkgroup -'A' id='506' adms='root' oper
mkuser id='501' pgrp='oinstall' groups='dba,asmadmin,asmdba,asmoper' home='/home/grid' capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid
mkuser id='502' pgrp='oinstall' groups='dba,asmdba,oper' home='/home/oracle' capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

9、主机地址信息
# vi /etc/hosts保留回环地址之外加入:
#public ip
192.168.123.203 dbrac1
192.168.123.205 dbrac2

#private ip
172.17.8.11 dbrac1-priv
172.17.8.12 dbrac2-priv

#vip
192.168.123.207 dbrac1-vip
192.168.123.208 dbrac2-vip

#scanip
192.168.123.206 rac-scan


10、建立互信
【grid 2个节点】
vi /etc/hosts.allow
sshd: zjjdcs13,zjjdcs14,zjjdcs13-priv,zjjdcs14-priv

【2个节点】
##有时：$sshsetup/sshUserSetup.sh -user oracle -hosts "zjjdcs13zjjdcs14" -advanced -noPromptPassphrase
su - grid
cd
rm -rf .ssh
mkdir ~/.ssh
chmod 700 ~/.ssh
【节点1】
ssh-keygen -b 1024 -t dsa
ssh-keygen -b 1024 -t rsa
cd ~/.ssh
cat *rsa.pub >> authorized_keys
cat *dsa.pub >> authorized_keys2
scp *zjjdcs14:/home/grid/.ssh

【oracle 2个节点】
su - oracle
cd
rm -rf .ssh
mkdir ~/.ssh
chmod 700 ~/.ssh
【节点1】
ssh-keygen -b 1024 -t dsa
ssh-keygen -b 1024 -t rsa
cd ~/.ssh
cat *rsa.pub >> authorized_keys
cat *dsa.pub >> authorized_keys2
scp *zjjdcs14:$HOME/.ssh





创建目录
mkdir -p /u01/app/grid
mkdir -p /u01/app/11.2.0/grid
chown -R grid.oinstall /u01
mkdir -p /u01/app/oracle
chown -R oracle.oinstall /u01/app/oracle
chmod -R 755 /u01



创建环境变量
su - grid
vi /home/grid/.profile
【节点1】
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export ORACLE_SID=+ASM1
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
umask 022
export AIXTHREAD_SCOPE=S
export JAVA_HOME=$ORACLE_HOME/jdk
export LIBPATH=$ORACLE_HOME/lib
【节点2】
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export ORACLE_SID=+ASM2
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin: $PATH
umask 022


su - oracle
vi /home/oracle/.profile
【节点1】
export ORACLE_UNQNAME=zjcrm
export ORACLE_SID=zjcrm1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db
#export GRID_HOME=/u01/app/11.2.0/grid
export DISPLAY=10.70.188.101:0.0
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH
umask 022
export AIXTHREAD_SCOPE=S
export LIBPATH=$ORACLE_HOME/lib
alias alertlog='cd ${ORACLE_BASE}/diag/rdbms/${ORACLE_UNQNAME}/${ORACLE_SID}/trace'
unset ORA_NLS10
unset ORA_NLS33
unset LD_LIBRARY_PATH
unset CRS_HOME
unset SHLIB_PATH
unset CLASSPATH
export PS1=`whoami`" -> 11g "@`hostname`:"\$PWD$"
export EDITOR=vi

【节点2】
export ORACLE_UNQNAME=zjcrm
export ORACLE_SID=zjcrm2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db
#export GRID_HOME=/u01/app/11.2.0/grid
export DISPLAY=10.70.188.101:0.0
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH
umask 022
alias alertlog='cd /u01/oracle/app/oracle/diag/rdbms/zjcrm/zjcrm2/trace'
unset ORA_NLS10
unset ORA_NLS33
unset LD_LIBRARY_PATH
unset CRS_HOME
unset SHLIB_PATH
unset CLASSPATH
export PS1=`whoami`" -> 11g "@`hostname`:"\$PWD$"
export EDITOR=vi

安装
su - grid
export DISPLAY=XXX.XXX.XXX.XXX:0.0
./runcluvfy.sh stage -pre crsinst -n xxxxx,xxxxx -fixup -verbose