11gR2 rac add node(11.2.0.2 for aix 7.1)

如下是一个简单的11gR2 rac add node(11.2.0.2 for aix 7.1)的步骤：

1. check os package/patch

--check os package
lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat \
bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte \
xlC.aix61.rte

--check patch


instfix -i -k "IZ87216 IZ87564 IZ89165 IZ97035"

2. add group

/usr/sbin/groupadd -g 1000 oinstall
/usr/sbin/groupadd -g 1100 asmadmin
/usr/sbin/groupadd -g 1200 dba
/usr/sbin/groupadd -g 1300 asmdba
/usr/sbin/groupadd -g 1301 asmoper


3. add user

/usr/sbin/useradd -u 1100 -d /home/grid  -g oinstall -G dba,asmadmin,asmoper,asmdba grid

passwd grid

/usr/sbin/useradd -u 1101 -d /home/oracle  -g oinstall -G dba,asmdba oracle

passwd oracle


编辑.profile

---grid
umask 022
export ORACLE_BASE=/oracle/app/grid #需手工创建
export ORACLE_HOME=/oracle/app/11.2/grid #需手工创建
export ORACLE_SID=+ASM3 #节点2 是+ASM2
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
#export PS1='hostname':'$PWD'"$
PATH=${PATH}:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH

---oracle

umask 022
export ORACLE_BASE=/oracle/db/oracle #需手工创建
export ORACLE_HOME=$ORACLE_BASE/product/11.2
export GRID_HOME=/oracle/app/11.2/grid
export ORACLE_SID=sce3
export ORACLE_UNQNAME=fawscedb
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$GRID_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
#export PS1='hostname':'$PWD'"$"

PATH=${PATH}:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.
#TSM backup var
export DSM_DIR=/usr/tivoli/tsm/client/ba/bin
export DSM_CONFIG=/usr/tivoli/tsm/client/ba/bin/dsm.opt
export DSM_LOG=/usr/tivoli/tsm/client/ba/bin

4. vi /etc/security/limits

default:
        fsize = -1
        core = -1
        cpu = -1
        data = -1
        rss = -1
        stack = -1
        nofiles = -1


5.   smitty chgsys

Maximum number of PROCESSES allowed per user [16384]
HIGH water mark for pending write I/Os per file [8193]
LOW water mark for pending write I/Os per file [4096]
Stack Execution Disable (SED) Mode   select

maxuprocs=16384
ncargs=128

6.  change network parameters


/usr/sbin/no -p -o tcp_ephemeral_low=32768 -o tcp_ephemeral_high=65535
/usr/sbin/no -p -o udp_ephemeral_low=32768 -o udp_ephemeral_high=65535

7. config ssh for grid,oracle

8. vi /etc/hosts

添加新节点的信息到hosts中（所有节点都需要修改）

9. Copy grid soft

$GI_HOME/oui/bin/addNode.sh -silent "CLUSTER_NEW_NODES={cdwmsdb3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={cdwmsdb3-vip>}"


10. check add node

$GI_HOME/bin/cluvfy stage -post nodeadd -n  cdwmsdb3  -verbose

11. tar $ORACLE_HOME

tar -cvf oracle_home.tar  /oracle/xxx

12. ftp file

传输oracle_home.tar 到新的节点上，然后解压

13. execute follow steps

perl $ORACLE_HOME/clone/bin/clone.pl '-O"CLUSTER_NODES={cdwmsdb1,cdwmsdb2,cdwmsdb3}"' '-O"LOCAL_NODE=cdwmsdb3"' ORACLE_BASE=$ORACLE_BASE ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=OraDb11g_home1 '-O-noConfig'


14. execute floww step

$ORACLE_HOME/oui/bin/runInstaller –updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={cdwmsdb1,cdwmsdb2,cdwmsdb3}"


15. execute root.sh

cd $ORACLE_HOME
./root.sh


16. change permissions

cd $ORACLE_HOME/bin
chgrp asmadmin oracle
chmod 6751 oracle
ls -l oracle

17. On any existing node, run DBCA ($ORACLE_HOME/bin/dbca) to add the new instance:

$ORACLE_HOME/bin/dbca -silent -addInstance -nodeList cdwmsdb3 -gdbName fawscedb -instanceName sce3 -sysDBAUserName sys -sysDBAPassword inforadmin


18. create listener/ vi tnsnames.ora


19. Verify the administrator privileges on the new node by running on existing node:

$ORACLE_HOME/bin/cluvfy comp admprv -o db_config -d $ORACLE_HOME -n cdwmsdb1,cdwmsdb2,cdwmsdb3 -verbose

20. check nodes ,check service

lsnodes
crs_stat -t -v

随时写的一个草稿， 本来今天要实施，结果，，，，，，,草稿也分享出来吧！