Linux-Oracle-11gR2-RAC安装配置.doc

资源描述

环境： 9j"c*j{Mv'x22494861Oracle Linux CentOS 6.4两台 8a1v7e,aG(N8A22494861Oracle 11g R2 1、IP规划 127.0.0.1 localhost.localdomain localhost #public ip 4Z*QL3sQ}*uB2d1y22494861192.168.10.211 rac1ITPUB个人空间7~Bw6P[ 192.168.10.212 rac2 #priv ip "~"L${ x1Yg-x7y2249486110.10.10.211 rac1prvITPUB个人空间8dnL"{ bX)K]c'V 10.10.10.212 rac2prv #vip ip +VmB2@ E8u22494861192.168.10.213 rac1vipITPUB个人空间6[]4^Y$Ob1K&{2@4w"`;x} 192.168.10.214 rac2vip #scan ipITPUB个人空间`b&YC)F'u!V!V U 192.168.10.215 racscan 2、磁盘规划ITPUB个人空间,Y1u1J,c@9}&L6q#Y 3\Z Ot4rp3y�c*{22494861+CRS 三个2G的盘 #G-bu R [%it22494861+DGDATA 三个10G的盘ITPUB个人空间X@{ Q*? pd +DGRECOVERY 两个5G的盘 /usr/sbin/groupadd -g 501 oinstallITPUB个人空间7D+u:^"};] `] /usr/sbin/groupadd -g 502 dbaITPUB个人空间}2s-iY@[_ /usr/sbin/groupadd -g 503 operITPUB个人空间*D%{}%z�_f /usr/sbin/groupadd -g 504 asmadminITPUB个人空间{*A�k{F3v5U /usr/sbin/groupadd -g 505 asmoperITPUB个人空间%jQ1VmxsUy-Q /usr/sbin/groupadd -g 506 asmdba ~,} [!iw@%os22494861/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle 4D XOp6V!]`:G22494861/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid [root@ora1 ~]# id oracle ?o!~3C�Mu22494861uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)ITPUB个人空间Vh_;{sbto ` [root@ora1 ~]# id grid 'X�ri.J om0e22494861uid=502(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba) mkdir /oracle/app/ITPUB个人空间-cPT/Y/[Q chown -R grid:oinstall /oracle/app/ITPUB个人空间jCt^�q+{v chmod -R 775 /oracle/app/ mkdir -p /oracle/app/oraInventoryITPUB个人空间6n1miE,vxW*D chown -R grid:oinstall /oracle/app/oraInventoryITPUB个人空间F4v fO%QxB4A t chmod -R 775 /oracle/app/oraInventory mkdir -p /oracle/app/gridITPUB个人空间$t |%D ]0Q"{ mkdir -p /oracle/app/oracleITPUB个人空间9J*A*t9y|!}^ chown -R grid:oinstall /oracle/app/gridITPUB个人空间 d/T#jsAy5MKl2F chown -R oracle:oinstall /oracle/app/oracle ?D"I:_+BG22494861chmod -R 775 /oracle/app/oracleITPUB个人空间%g y,I^.tl]9n4K chmod -R 775 /oracle/app/grid ITPUB个人空间_@|'`2l&bHO-\&z:N passwd grid passwd oracle 2、操作系统版本： [root@rac1 ~]# lsb_release -aITPUB个人空间rK ~EY ]&PE\ LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch Distributor ID: CentOS Description: CentOS release 6.4 (Final) Release: 6.4 Codename: Final 1K8z w�u6Rc R M22494861[root@rac1 ~]# uname -a ]*Y'ur0h3h-B22494861 Linux MPR.coco 2.6.32-358.23.2.el6.x86_64 #1 SMP Wed Oct 16 18:37:12 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux ITPUB个人空间 |h&d)EDf-Ft B [root@rac1 ~]# 修改系统参数： P?TlI0v22494861vi /etc/security/limits.conf #ORACLE SETTINGITPUB个人空间BuoJ"C,J grid soft nproc 2047ITPUB个人空间"OZ%Nm(WX%ps)C grid hard nproc 16384ITPUB个人空间2J\c ~:o'l9B'M&z grid soft nofile 1024 ,e Snt%g?3E wt22494861grid hard nofile 65536ITPUB个人空间�XTQ:J1b,~tw.} oracle soft nproc 2047ITPUB个人空间9[pg%c?3f!V oracle hard nproc 16384ITPUB个人空间'v"N7`I.o*u6c9ub oracle soft nofile 1024 %q+R-Q7By'?Cdm22494861oracle hard nofile 65536 Fy5mW[kX0r;CE'R22494861vi /etc/pam.d/login #ORACLE SETTINGITPUB个人空间 S`$|7^F4o7P session required pam_limits.so # vi /etc/sysctl.conf r$dh-{A#}#Dl22494861#ORACLE SETTING qfiXq22494861fs.aio-max-nr = 1048576ITPUB个人空间7y_P;d"M,Z,^,aS fs.file-max = 6815744ITPUB个人空间|P"Zw4GC kernel.shmall = 2097152ITPUB个人空间^*a(U.Tx4t-_ @um kernel.shmmax = 536870912ITPUB个人空间 u*Fxy?.I)e8i kernel.shmmni = 4096 k4wQ!jORp22494861kernel.sem = 250 32000 100 128 @3O(v6Vyz&?uK22494861net.ipv4.ip_local_port_range = 9000 65500 k(@s�MGRRA6g22494861net.core.rmem_default = 262144ITPUB个人空间I9n,gv,Vr(~,~%h net.core.rmem_max = 4194304 Y`L7r~s1J_22494861net.core.wmem_default = 262144 '_9[rZ�Y�W0C22494861net.core.wmem_max = 1048586 ]|6\\G.}l`-gZ B)~22494861gird时间同步所需要的设置(11gR2新增检查项)ITPUB个人空间9Q$V-G2Ry~'Y #Network Time Protocol SettingITPUB个人空间]5{xc2\lT /sbin/service ntpd stop :E;nKQ YI22494861chkconfig ntpd off (d3v+Pej8C1U�Q Y22494861rm /etc/ntp.conf `$A%D2z(R+xSP1}\22494861mv /etc/ntp.conf to /etc/ntp.conf.org /dev/shm 共享内存不足的处理 dJ?p3E�M%{9^v?22494861解决方法： %J6@Z)gE:mp~hYEe22494861例如：为了将/dev/shm的大小增加到1GB，修改/etc/fstab的这行：默认的：ITPUB个人空间 [8\4D|;Z`B none /dev/shm tmpfs defaults 0 0 4xUESw(Tz*\22494861改成： ^Aa*P#rm?g4q A&H M22494861none /dev/shm tmpfs defaults,size=1024m 0 0ITPUB个人空间8d I)d�N8nB size参数也可以用G作单位：size＝1G。ITPUB个人空间0x.}b,zE4ZYK 重新mount /dev/shm使之生效： -^6W&NoZ\B8cd;a22494861# mount -o remount /dev/shm ,W5bzJl22494861或者： JY w#WN22494861# umount /dev/shm fP.|9R {Cb22494861# mount -aITPUB个人空间xQlLcO(Pz 马上可以用"df -h"命令检查变化。 ITPUB个人空间3i0b�D_ d 修改gird、oracle用户的.bash_profile文件： #grid 用户配置文件 ORACLE_HOSTNAME请自行设置 -C5HL2Y@0P*x22494861TMP=/tmp; export TMP t5JT4D�y0FZ22494861TMPDIR=$TMP; export TMPDIR ORACLE_SID=+ASM1; export ORACLE_SID PUt)V].b22494861ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE M(n#dWk"`22494861ORACLE_HOME=/oracle/app/grid/product/11.2.0; export ORACLE_HOME ,c.GO%\(Z22494861NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT )]$B.U{.V RDaF7` Kg&m:C22494861THREADS_FLAG=native; export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATH w7p j4|2p0L(T-f!o!l22494861THREADS_FLAG=native; export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATH if [ $USER = "oracle" ] || [ $USER = "grid" ]; thenITPUB个人空间|G9xx4t,H)H0F,bUK if [ $SHELL = "/bin/ksh" ]; then O&\B2Us:M22494861 ulimit -p 16384ITPUB个人空间5lY)d$Tt#N3r{*T ulimit -n 65536 PX6N o%J+e2}:]#A%w22494861 else 7a*f(E4MI$Krc22494861 ulimit -u 16384 -n 65536ITPUB个人空间&C;Q GqJ'Sp$n$e fiITPUB个人空间8?1X$AME2o umask 022ITPUB个人空间*{7ptb4P5h A)rBz fi ITPUB个人空间z-}w*`e6dh�E #oracle用户配置文件 ORACLE_HOSTNAME请自行设置 } ]"{%V j R22494861# Oracle Settings oracle H@�`+paHg$ur�e22494861TMP=/tmp; export TMP 8Y7_8VF!v^9N1H22494861TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASEITPUB个人空间6L)~3E!z$N2F| wr w ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOMEITPUB个人空间lxh2tk7U)BT ORACLE_SID=racdb1; export ORACLE_SID +S+yk KT+c] H22494861ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH ;]5|4~;i)f_C22494861PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHITPUB个人空间?Jz[-B3~(qz CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH o)V1|8KO&x+s ~22494861NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMATITPUB个人空间g}UW1A NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG if [ $USER = "oracle" ] || [ $USER = "grid" ]; thenITPUB个人空间x F'{1p6T b;Z;cH if [ $SHELL = "/bin/ksh" ]; then V Q8~*Z.bX3|L\22494861 ulimit -p 16384 W.B.inW V vnp22494861 ulimit -n 65536ITPUB个人空间9^0~(Av;{Rc"_f5~!~ elseITPUB个人空间@ZX.Z:h*pXv ulimit -u 16384 -n 65536ITPUB个人空间|8{~g;wX9a fi !o~DLDE8Q22494861 umask 022 XP-^%h fiC)v22494861fi tW;o4I(d22494861配置信任关系ITPUB个人空间g+J-t*N2f 设置SSH， rt;F$u6^Me224948611).在主节点RAC1上以grid,oracle用户身份生成用户的公匙和私匙ITPUB个人空间? @m!p;O0^B2N'S # ping rac2-eth0 +c!]Om GI{"TK,lU22494861# ping rac2-eth1ITPUB个人空间os&dDI|/dV # su - oracleITPUB个人空间1il.q R q7f M $ mkdir ~/.sshITPUB个人空间d8Ap/BU $ ssh-keygen -t rsaITPUB个人空间 M[;\1K�w $ ssh-keygen -t dsa 2).在副节点RAC2、RAC3上执行相同的操作，确保通信无阻ITPUB个人空间�@(T!G%f sNP&TN(dUb_ # ping rac1-eth0 1CS�{ zez22494861# ping rac1-eth1 {L{1enZ4IvI9e22494861# su - oracleITPUB个人空间;| `Yf9UY $ mkdir ~/.sshITPUB个人空间�n5d@C M/[7Bmj $ ssh-keygen -t rsa |2[ hCd22494861$ ssh-keygen -t dsa 3).在主节点RAC1上oracle用户执行以下操作 5I&S.j~Xz#D |;H22494861$ cat ~/.ssh/id_rsa.pub >> ./.ssh/authorized_keys Kmy_kTE(RbU[22494861$ cat ~/.ssh/id_dsa.pub >> ./.ssh/authorized_keysITPUB个人空间*E%U {+P+bL�USZ f $ ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys D�hI(l{,L6K22494861$ ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysITPUB个人空间'X^a*C)avj;b $ scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys 4).主节点RAC1上执行检验操作ITPUB个人空间W[o!Q@%J4Q $ ssh rac1 dateITPUB个人空间R | rv @ v+L6M $ ssh rac2 date [(v4o#Li?@;P22494861$ ssh rac3 dateITPUB个人空间!G+aY4fa!SH $ ssh rac1priv date ?8`y kj-O2Fx22494861$ ssh rac2priv dateITPUB个人空间:xm5k�z E9g $ ssh rac3priv date ITPUB个人空间6C3c\@ e {,ay,e 5).在副节点RAC2上执行检验操作ITPUB个人空间�Q{3H%T ^7xm(z~ $ ssh rac1 date /Ct-vL2I ip%ZT22494861$ ssh rac2 date ,A t4w*X7s22494861$ ssh rac3 dateITPUB个人空间+g�`a'_|!j-vN:ik'O,~ $ ssh rac1priv dateITPUB个人空间Y)a;E/q)O2h $ ssh rac2priv dateITPUB个人空间a"d/|,o8g*?)tP@ $ ssh rac3priv dateITPUB个人空间B1q AKM;x+l/_ 安装ASM oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm 0}Zn Sg(n;r'w'I|O22494861oracleasmlib-2.0.4-1.el5.i386.rpmITPUB个人空间;{W/IQ)N0id;J oracleasm-support-2.1.3-1.el5.i386.rpm 格式化硬盘 p~(w.e"d22494861Disk /dev/sdd: 2147 MB, 2147483648 bytesITPUB个人空间0XW"^8@x$G&o 255 heads, 63 sectors/track, 261 cylindersITPUB个人空间(mF$Z"\V`$R RP3W Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System %ZlmQn5XT-J E22494861/dev/sdd1 1 261 2096451 83 Linux Disk /dev/sde: 2147 MB, 2147483648 bytesITPUB个人空间�p6u`X+H 255 heads, 63 sectors/track, 261 cylindersITPUB个人空间0U!} c xN:zW Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System jfTc9L8RQ9d22494861/dev/sde1 1 261 2096451 83 Linux Disk /dev/sdf: 2147 MB, 2147483648 bytes 6F I,fWC(eD22494861255 heads, 63 sectors/track, 261 cylindersITPUB个人空间n;C6W"n~H!w Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System LS5c `)ua22494861/dev/sdf1 1 261 2096451 83 Linux Disk /dev/sdg: 10.7 GB, 10737418240 bytes 9rVgA9q0a/@22494861255 heads, 63 sectors/track, 1305 cylinders 4\)j9MO.aGL,gA22494861Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id SystemITPUB个人空间.mk Wf-|[ pb /dev/sdg1 1 1305 10482381 83 Linux Disk /dev/sdh: 10.7 GB, 10737418240 bytes k0V{O�zZ*Y?#V9O22494861255 heads, 63 sectors/track, 1305 cylindersITPUB个人空间N5sT@RF�`l Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id SystemITPUB个人空间P?M&r)w2a7d /dev/sdh1 1 1305 10482381 83 Linux Disk /dev/sdi: 10.7 GB, 10737418240 bytesITPUB个人空间r$@E n.R;p'R 255 heads, 63 sectors/track, 1305 cylinders *W3`gk*[22494861Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System 4_8@&z'V2f c�\D22494861/dev/sdi1 1 1305 10482381 83 Linux Disk /dev/sdj: 5368 MB, 5368709120 bytesITPUB个人空间N�\&nQM 255 heads, 63 sectors/track, 652 cylindersITPUB个人空间8o A'bv,^@!?%U'n Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System 7xn*c$ZMvQ6x22494861/dev/sdj1 1 652 5237158+ 83 Linux Disk /dev/sdk: 5368 MB, 5368709120 bytes (Y�H#N.D8t22494861255 heads, 63 sectors/track, 652 cylinders 2{5b#X&u&~i22494861Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System &G0p5Ozk+pu!d3cP(e22494861/dev/sdk1 1 652 5237158+ 83 Linux 配置ASMITPUB个人空间~A$j:Fl1pI ITPUB个人空间~(q�^H+aS [root@ora1 ~]# /etc/init.d/oracleasm configure !Li%C:HYV-c`22494861Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library h2QZ$R Q,VR$a22494861driver. The following questions will determine whether the driver is .a%FHrD&Z22494861loaded on boot and what permissions it will have. The current valuesITPUB个人空间{2Q"|)Z0n will be shown in brackets ('[]'). Hitting <ENTER> without typing anITPUB个人空间w9{A+uj answer will keep that current value. Ctrl-C will abort. Default user to own the driver interface []: gridITPUB个人空间+hz+U2C�C E;Y Default group to own the driver interface []: asmadminITPUB个人空间{#j,c0kYp]U Start Oracle ASM library driver on boot (y/n) [n]: yITPUB个人空间 T3jtA2m$L-~{b'a Scan for Oracle ASM disks on boot (y/n) [y]: y 2D Q2PJUW~22494861Writing Oracle ASM library driver configuration: doneITPUB个人空间^ \X5mQ2bJ5F Initializing the Oracle ASMLib driver: [ OK ] M]0UbQP8~th22494861Scanning the system for Oracle ASMLib disks: [ OK ]ITPUB个人空间.r]k[8]&|Duf8y }C)f3` T7S%n22494861 创建asm盘ITPUB个人空间I1shA5_1~"t,mh0_ ITPUB个人空间3? h&eO kd +CRS 三个2G的盘ITPUB个人空间&gHn R A0Es#L+F +DGDATA 三个10G的盘 Vk,_w,M22494861+DGRECOVERY 两个5G的盘 /dev/sdd: 2097152 YL n5MI6|Y%gw*jn.Y22494861/dev/sde: 2097152ITPUB个人空间"v^^zh[ /dev/sdf: 2097152 cVh-f-ceSf-s22494861/dev/sdg: 10485760ITPUB个人空间?FZOq /dev/sdh: 10485760 s�NqI#I!x22494861/dev/sdi: 10485760 :T I.M5c)A-e&N$\t0E;yd t22494861/dev/sdj: 5242880 pfSST0ci[$D6N22494861/dev/sdk: 5242880 [root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS1 /dev/sdd1ITPUB个人空间\(wj,B$e$[cs Marking disk "CRS1" as an ASM disk: [ OK ]ITPUB个人空间8^ ji0dF1U#Ls'? [root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS2 /dev/sde1ITPUB个人空间,Q'S}W r!h~g1K*e Marking disk "CRS2" as an ASM disk: [ OK ] %w;FA;Ug22494861[root@ora2 asm]# /etc/init.d/oracleasm createdisk CRS3 /dev/sdf1 .U7\gx4YB7ZMax{22494861Marking disk "CRS3" as an ASM disk: [ OK ]ITPUB个人空间A"qK3j$i.u9c_L [root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA1 /dev/sdg1 &y:}6Nw'R\22494861Marking disk "DATA1" as an ASM disk: [FAILED] eCzs!lcXb22494861[root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA1 /dev/sdg1ITPUB个人空间4j9EN1S�^/{PS Marking disk "DATA1" as an ASM disk: [ OK ] |S"l8jih5`#l{5?d22494861[root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA2 /dev/sdh1ITPUB个人空间t([ J.N5U Marking disk "DATA2" as an ASM disk: [ OK ] :EWPz9[(U9Y22494861[root@ora2 asm]# /etc/init.d/oracleasm createdisk DATA3 /dev/sdi1 HB;sV k1R8TM22494861Marking disk "DATA3" as an ASM disk: [

展开阅读全文