11gR2 rac add node(11.2.0.2 for aix 7.1)
本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客
如下是一个简单的11gR2 rac add node(11.2.0.2 for aix 7.1)的步骤：
|
1 2 3 4 5 6 7 8 9 10 11 |
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" |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 |
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
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 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
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 |
随时写的一个草稿， 本来今天要实施，结果，，，，，，,草稿也分享出来吧！
2 Responses to “11gR2 rac add node(11.2.0.2 for aix 7.1)”
新节点不需要配置信任关系什么的吗？时间同步？
这个过程，实施过了吗？
Leave a Reply
You must be logged in to post a comment.