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*Q
L3sQ}*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*{22494861CRS        三个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 X
Op6V!]`: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),505asmoper),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^.t
l]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[p
g%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,z
E4ZYK
重新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
P
Ut)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)dTt#N3r{*T
              ulimit -n 65536
PX6N o%J+e2}:]#A%w22494861  else
7a*f(E4MI$Krc22494861   ulimit -u 16384 -n 65536ITPUB个人空间&C;Q
G
qJ'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 fi
C)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个人空间;| `Yf9U
Y
$ mkdir ~/.sshITPUB个人空间�n5d@C M/[7B
mj
$ 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 | r
v @ 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:z
W
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
9rVg
A9q0a/@22494861255 heads, 63 sectors/track, 1305 cylinders
4\)j9MO.aGL,g
A22494861Units = 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!d3c
P(e22494861/dev/sdk1               1         652     5237158+  83  Linux

配置ASMITPUB个人空间~A$j:Fl1pI
 ITPUB个人空间~(q�^H+a
S
 [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
h2Q
Z$R Q,V
R$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 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#L
s'?
[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: [