Linux+Oracle11gR2RAC安装配置详细过程.docx
- 文档编号:23842929
- 上传时间:2023-05-21
- 格式:DOCX
- 页数:99
- 大小:66.20KB
Linux+Oracle11gR2RAC安装配置详细过程.docx
《Linux+Oracle11gR2RAC安装配置详细过程.docx》由会员分享,可在线阅读,更多相关《Linux+Oracle11gR2RAC安装配置详细过程.docx(99页珍藏版)》请在冰豆网上搜索。
Linux+Oracle11gR2RAC安装配置详细过程
环境:
9j"c*j_{_M_v'x22494861OracleLinuxAS5.5两台
8a1v7e,a_G(N8A22494861Oracle11gR2
1、IP规划
127.0.0.1localhost.localdomainlocalhost
#publicip
4Z*Q_L3s
Q_}*u_B2d1y22494861192.168.10.211 rac1ITPUB个人空间7~_B_w6P_[
192.168.10.212 rac2
#privip
"~"L${x1Y_g-x7y2249486110.10.10.211 rac1prvITPUB个人空间8d_n_L"{
b_X)K_]_c'V
10.10.10.212 rac2prv
#vipip
+V_m_B2@E8u22494861192.168.10.213 rac1vipITPUB个人空间6[_]4^_Y$O_b1K&{2@4w"`;x_}
192.168.10.214 rac2vip
#scanipITPUB个人空间_`_b&Y_C)F'u!
V!
VU
192.168.10.215 racscan
2、磁盘规划ITPUB个人空间,Y1u1J,c_@9}&L6q#Y
3\_ZO_t4r_p3y�c*{22494861+CRS 三个2G的盘
#G-b_u
R[%it22494861+DGDATA 三个10G的盘ITPUB个人空间_X_@{Q*?
pd
+DGRECOVERY两个5G的盘
/usr/sbin/groupadd-g501oinstallITPUB个人空间7D+u:
^"};]
`_]
/usr/sbin/groupadd-g502dbaITPUB个人空间_}2s-i_Y_@_[__
/usr/sbin/groupadd-g503operITPUB个人空间*D%{_}%z�__f
/usr/sbin/groupadd-g504asmadminITPUB个人空间_{*A�k_{_F3v5U
/usr/sbin/groupadd-g505asmoperITPUB个人空间%j_Q1V_mx
s_U_y-Q
/usr/sbin/groupadd-g506asmdba
~,}[!
i_w_@%os2*******/usr/sbin/useradd-goinstall-Gdba,asmdba,operoracle
4DX_O_p6V!
]_`:
G2*******/usr/sbin/useradd-goinstall-Gasmadmin,asmdba,asmoper,oper,dbagrid
[root@ora1~]#idoracle
?
_o!
~3C�M_u22494861uid=501(oracle)gid=501(oinstall)groups=501(oinstall),502(dba),503(oper),506(asmdba)ITPUB个人空间_V_h__;{_s
b_t_o`
[root@ora1~]#idgrid
'X�ri.J
o_m0e22494861uid=502(grid)gid=501(oinstall)groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)
mkdir/oracle/app/ITPUB个人空间-c_P_T/Y/[_Q
chown-Rgrid:
oinstall/oracle/app/ITPUB个人空间_j_C_t_^�q+{_v
chmod-R775/oracle/app/
mkdir-p/oracle/app/oraInventoryITPUB个人空间6n1m_i_E,v_xW*D
chown-Rgrid:
oinstall/oracle/app/oraInventoryITPUB个人空间_F4vf_O%Q_x_B4A
t
chmod-R775/oracle/app/oraInventory
mkdir-p/oracle/app/gridITPUB个人空间$t|%D
]0Q"{
mkdir-p/oracle/app/oracleITPUB个人空间9J*A*t9y_|!
}_^
chown-Rgrid:
oinstall/oracle/app/gridITPUB个人空间d/T#j
sA_y5M_K_l2F
chown-Roracle:
oinstall/oracle/app/oracle
_?
_D"I:
_+B_G2*******chmod-R775/oracle/app/oracleITPUB个人空间%gy,I_^.t_l_]9n4K
chmod-R775/oracle/app/grid
ITPUB个人空间___@_|'`2l&b_H
O-\&z:
N
passwdgrid
passwdoracle
2、操作系统版本:
[root@rac1~]#lsb_release-aITPUB个人空间_r_K~_E_Y]&P_E_\
LSBVersion:
:
core-3.1-ia32:
core-3.1-noarch:
graphics-3.1-ia32:
graphics-3.1-noarch
&Kl"Z#@4I5g22494861DistributorID:
EnterpriseEnterpriseServer
z__4e_d_N(D/k_b_t6E_`22494861Description:
EnterpriseLinuxEnterpriseLinuxServerrelease5.5(Carthage)
;K
@3g&i_V_e_l22494861Release:
5.5ITPUB个人空间_n_[1E_]_e8~_i_Q_u
Codename:
Carthage
1K8zw�u6R_cRM22494861[root@rac1~]#uname-a
_]*Y'u_r0h3h-B22494861Linuxrac12.6.18-194.el5#1SMPMonMar2920:
06:
41EDT2010i686i686i386GNU/LinuxITPUB个人空间|_h&d)E_D_f-F
t
B
[root@rac1~]#
修改系统参数:
P
?
T
l_I0v22494861vi/etc/security/limits.conf
#ORACLESETTINGITPUB个人空间
B_u_oJ"C,J
grid soft nproc 2047ITPUB个人空间"O_Z%N_m(W_X%p_s)C
grid hard nproc 16384ITPUB个人空间2J_\_c~:
o'l9B'M&z
grid soft nofile 1024
eS_n_t%g_?
3Ewt22494861grid hard nofile 65536ITPUB个人空间�X_T_Q:
J1b,~_t_w.}
oracle soft nproc 2047ITPUB个人空间9[_p_g%c_?
3f!
V
oracle hard nproc 16384ITPUB个人空间'v"N7`
I.o*u6c9u_b
oracle soft nofile 1024
%q+R-Q7B_y'?
C_d_m22494861oracle hard nofile 65536
_F_y5m_W_[_k_X0r;C_E'R22494861vi/etc/pam.d/login
#ORACLESETTINGITPUB个人空间
S
`$|7^_F4o7P
session required pam_limits.so
#vi/etc/sysctl.conf
r$d_h-{_A#}#D_l22494861#ORACLESETTING
q
fiX_q22494861fs.aio-max-nr=1048576ITPUB个人空间7y__
P;d"M,Z,^,a_S
fs.file-max=6815744ITPUB个人空间_|P"Z_w4G_C
kernel.shmall=2097152ITPUB个人空间_^*a(U.T_x4t-_@_u_m
kernel.shmmax=536870912ITPUB个人空间u*F_x_y_?
.I)e8i
kernel.shmmni=4096
_k4w_Q!
jO_R_p2*******kernel.sem=25032000100128
_@3O(v6V
y_z&?
_u_K22494861net.ipv4.ip_local_port_range=900065500
_k(@_s�MG_R_R_A6g22494861net.core.rmem_default=262144ITPUB个人空间_I9n,gv,V_r(~,~%h
net.core.rmem_max=4194304
_Y_`_L7r_~_s1J__22494861net.core.wmem_default=262144
'_9[_r_Z�Y�W0C22494861net.core.wmem_max=1048586
]_|6\_\_G.}_l_`-g_ZB)~22494861gird时间同步所需要的设置(11gR2新增检查项)ITPUB个人空间9Q$V-G2R_y_~'Y
#NetworkTimeProtocolSettingITPUB个人空间]5{_x_c2\_l_T
/sbin/servicentpdstop
:
E;n_K_QY_I22494861chkconfigntpdoff
(d3v+P_e_j8C1U�QY22494861rm/etc/ntp.conf
_`$A%D2z(R+x_S_P1}_\22494861mv/etc/ntp.confto/etc/ntp.conf.org
/dev/shm共享内存不足的处理
_d
J_?
_p3E�M%{9^_v_?
22494861解决方法:
%J6@_Z)gE:
m
p_~h_Y_E_e22494861例如:
为了将/dev/shm的大小增加到1GB,修改/etc/fstab的这行:
默认的:
ITPUB个人空间[8\4D_|;Z_`_B
none /dev/shm tmpfs defaults 00
4x
U_E_S
w(Tz*\22494861改成:
^
A_a*P#r_m?
g4qA&HM22494861none /dev/shm tmpfs defaults,size=1024m 00ITPUB个人空间8dI)d�N8n_B
size参数也可以用G作单位:
size=1G。
ITPUB个人空间0x.}_b,z_E4Z_Y_K
重新mount/dev/shm使之生效:
-^6W&N_oZ_\_B8c_d;a22494861#mount-oremount/dev/shm
W5b_z_J_l22494861或者:
J_Y
w#W_N22494861#umount/dev/shm
_f_P.|9R{_C_b22494861#mount-aITPUB个人空间_x_Q_l_L_c_O(P_z
马上可以用"df-h"命令检查变化。
ITPUB个人空间3i0b�D__d
修改gird、oracle用户的.bash_profile文件:
#grid用户配置文件ORACLE_HOSTNAME请自行设置
-C5H
L2Y@0P*x22494861TMP=/tmp;exportTMP
_t5J_T4D�y0F_Z22494861TMPDIR=$TMP;exportTMPDIR
ORACLE_SID=+ASM1;exportORACLE_SID
_P_U_t)V_].b22494861ORACLE_BASE=/oracle/app/oracle;exportORACLE_BASE
_M(n#d_W_k"`22494861ORACLE_HOME=/oracle/app/grid/product/11.2.0;exportORACLE_HOME
c.G_O%\(Z22494861NLS_DATE_FORMAT="yyyy-mm-ddHH24:
MI:
SS";exportNLS_DATE_FORMAT
)]$B.U_{.VR_D_a_F7`
Kg&m:
C22494861THREADS_FLAG=native;exportTHREADS_FLAG
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
_w7pj4|2p0L(T-f!
o!
l22494861THREADS_FLAG=native;exportTHREADS_FLAG
PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
if[$USER="oracle"]||[$USER="grid"];thenITPUB个人空间_|_G9x_x4t,H)H0F,b_U_K
if[$SHELL="/bin/ksh"];then
_O&\_B2U
s:
M22494861 ulimit-p16384ITPUB个人空间5lY)d$Tt#N3r_{*T
ulimit-n65536
P_X6No%J+e2}:
]#A%w22494861 else
7a*f(E4M_I$K_r
c22494861 ulimit-u16384-n65536ITPUB个人空间&C;Q
G_q_J'S_p$n$e
fiITPUB个人空间8?
1X$A_M_E2o
umask022ITPUB个人空间*{7p_t_b4P5hA)r_B_z
fi
ITPUB个人空间_z-}w*`_e6d_h�E
#oracle用户配置文件ORACLE_HOSTNAME请自行设置
}]"{%VjR22494861#OracleSettingsoracle
H_@�`+pa_H_g$u_r�e22494861TMP=/tmp;exportTMP
8Y7_8V_F!
v_^9N1H22494861TMPDIR=$TMP;exportTMPDIR
ORACLE_BASE=/oracle/app/oracle;exportORACLE_BASEITPUB个人空间6L)~3E!
z$N2F_|w_rw
ORACLE_HOME=$ORACLE_BASE/product/11.2.0;exportORACLE_HOMEITPUB个人空间_l_x_h2t_k7U)B_T
ORACLE_SID=racdb1;exportORACLE_SID
+S+y_kK_T+c_]H22494861ORACLE_TERM=xterm;exportORACLE_TERM
PATH=/usr/sbin:
$PATH;exportPATH
;]5|4~;i)f__C22494861PATH=$ORACLE_HOME/bin:
$PATH;exportPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
/lib:
/usr/lib;exportLD_LIBRARY_PATHITPUB个人空间_?
_J_z_[-B3~(q_z
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbms/jlib;exportCLASSPATH
o)V1|8K_O&x+s~22494861NLS_DATE_FORMAT="yyyy-mm-ddHH24:
MI:
SS";exportNLS_DATE_FORMATITPUB个人空间_g_}_U_W1A
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;exportNLS_LANG
if[$USER="oracle"]||[$USER="grid"];thenITPUB个人空间_xF'{1p6Tb;Z;cH
if[$SHELL="/bin/ksh"];then
_VQ8~*Z.b_X3|L_\22494861 ulimit-p16384
W.B.i_n_WVv_n_p2******* ulimit-n65536ITPUB个人空间9^0~(A_v;{_R_c"__f5~!
~
elseITPUB个人空间_@_Z_X.Z:
h*p_X_v
ulimit-u16384-n65536ITPUB个人空间_|8{_~_g;w_X9a
fi
!
o_~_D_L_D_E8Q22494861 umask022
_X_P-^%hf_i_C)v22494861fi
_t_W;o4I(d2*******配置信任关系ITPUB个人空间_g+J-t*N2f
设置SSH,
r_t;F$u6^_M_e224948611).在主节点RAC1上以grid,oracle用户身份生成用户的公匙和私匙ITPUB个人空间_?
@_m!
p;O0^_B2N'S
#pingrac2-eth0
+c!
]_O_mG_I_{"T_K,l_U22494861#pingrac2-eth1ITPUB个人空间_o_s&d_D_I_|/d_V
#su-oracleITPUB个人空间1i_l.qRq7fM
$mkdir~/.sshITPUB个人空间d8A_p/B_U
$ssh-keygen-trsaITPUB个人空间M_[;\1K�w
$ssh-keygen-tdsa
2).在副节点RAC2、RAC3上执行相同的操作,确保通信无阻ITPUB个人空间�@(T!
G%fs
NP&T_N(d_U_b__
#pingrac1-eth0
1CS�{
z_e_z22494861#pingrac1-eth1
_{L_{1e_n_Z4I_vI9e22494861#su-oracleITPUB个人空间;|`_Y_f9U_Y
$mkdir~/.sshITPUB个人空间�n5d_@_CM/[7B_mj
$ssh-keygen-trsa
_|2[h_C_d2*******$ssh-keygen-tdsa
3).在主节点RAC1上oracle用户执行以下操作
5I&S.j_~_X_z#D|;H22494861$cat~/.ssh/id_rsa.pub>>./.ssh/authorized_keys
_K_m_y__k_T_E(R_b_U_[22494861$cat~/.ssh/id_dsa.pub>>./.ssh/authorized_keysITPUB个人空间*E%U{+P+b_L�U_S_Zf
$sshrac2cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keys
D�h_I(l_{,L6K22494861$sshrac2cat~/.ssh/id_dsa.pub>>~/.ssh/authorized_keysITPUB个人空间'X_^_a*C)a
v_j;b
$scp~/.ssh/authorized_keysrac2:
~/.ssh/authorized_keys
4).主节点RAC1上执行检验操作ITPUB个人空间W_[_o!
Q_@%J4Q
$sshrac1dateITPUB个人空间_R|r_v@v+L6M
$sshrac2date
_[(v4o#L_i?
_@;P2*******$sshrac3dateITPUB个人空间!
G+a_Y4f_a!
S_H
$sshrac1privdate
?
8`_yk_j-O2F_x22494861$sshrac2privdateITPUB个人空间:
x_m5k�z
E9g
$sshrac3privdate
ITPUB个人空间6C3c_\_@e{,a
y,e
5).在副节点RAC2上执行检验操作ITPUB个人空间�Q_{3H%T^7x_m(z_~
$sshrac1date
/C_t-v_L2Ii_p%Z_T22494861$sshrac2date
At4w*X7s22494861$sshrac3dateITPUB个人空间+g�`_a'__|!
j-v_N:
i_k'O,~
$sshrac1privdateITPUB个人空间Y)a;E/q)O2h
$sshrac2privdateITPUB个人空间_a"d/|,o8g*?
)t_P_@
$sshrac3privdateITPUB个人空间B1qA_K_M;x+l/_
安装ASM
oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm
0}_Z_n
Sg(n;r'w'I_|_O22494861oracleasmlib-2.0.4-1.el5.i386.rpmITPUB个人空间;{_W/I_Q)N0i_d;J
oracleasm-support-2.1.3-1.el5.i386.rpm
格式化硬盘
_p_~(w.e"d2*******Disk/dev/sdd:
2147MB,2147483648bytesITPUB个人空间0X_W"^8@
x$G&o
255heads,63sectors/track,261cylindersITPUB个人空间(m_F$Z"\_V_`$R
R_P3W
Units=cylindersof16065*512=8225280bytes
DeviceBoot Start End Blocks Id System
%Z_l_m_Q_n5X_T-J
E22494861/dev/sdd1 1 261 2096451 83 Linux
Disk/dev/sde:
2147MB,2147483
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Linux Oracle11gR2RAC 安装 配置 详细 过程