Linux安装oracle11G RAC手记

◆◆环境：
◆VWware workstation 8.0
◆Red Hat linux 5：
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Kernel 2.6.18-194.el5 on an x86_64
◆openfiler最新版本：
Linux openfiler1 2.6.32-71.18.1.el6-0.20.smp.gcc4.1.x86_64 #1 SMP Fri Mar 25 23:12:47 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
◆oracle 11g 112030最新版本64位：
p1*******_112030_Linux-x86-64_1of7.zip

◆◆参考文档：
◆在 Oracle Enterprise Linux 和 iSCSI 上构建您自己的 Oracle RAC 11_2g_1.mht
◆在 Oracle Enterprise Linux 和 iSCSI 上构建您自己的 Oracle RAC 11_2g_2.mht
◆在 Oracle Enterprise Linux 和 iSCSI 上构建您自己的 Oracle RAC 11_2g_3.mht

◆信息汇总：

# Public Network - (eth0)
192.168.1.151 racnode1
192.168.1.152 racnode2

# Private Interconnect - (eth1)
192.168.2.151 racnode1-priv
192.168.2.152 racnode2-priv

# Public Virtual IP (VIP) addresses - (eth0:1)
192.168.1.251 racnode1-vip
192.168.1.252 racnode2-vip

# Single Client Access Name (SCAN)
192.168.1.187 racnode-cluster-scan

# Private Storage Network for Openfiler - (eth1)
192.168.1.195 openfiler1
192.168.2.195 openfiler1-priv

◆grid用户：
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/11.2.0/grid
ORACLE_SID=+ASM1
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

◆oracle用户：
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=racdb1
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

Openfiler 的默认管理员登录凭证为：端口446
Username： openfiler
Password： password

◆以下四个package找的我好苦！

ASMLib 内核驱动程序：
oracleasm-x.x.x-x.el5-x.x.x-x.el5.x86_64.rpm —（用于默认内核）
oracleasm-x.x.x-x.el5xen-x.x.x-x.el5.x86_64.rpm —（用于 xen 内核）
用户空间库：
oracleasmlib-x.x.x-x.el5.x86_64.rpm
驱动程序支持文件：
oracleasm-support-x.x.x-x.el5.x86_64.rpm

在racnode1上做了如下测试：
[root@racnode1 dba]# rpm -qa|grep oracle
oracleasm-2.6.18-194.el5-2.0.5-1.el5
oracleasmlib-2.0.4-1.el5
oracleasm-support-2.1.4-1.el4
oracleasm-2.6.18-194.el5xen-2.0.5-1.el5

great！

◆执行最后的检查：
./runcluvfy.sh stage -post hwos -n racnode1,racnode2 -verbose
检查全部ok即可，如下：
[grid@racnode1 grid]$ ./runcluvfy.sh stage -post hwos -n racnode1,racnode2 -verbose

Performing post-checks for hardware and operating system setup

Checking node reachability...

Check: Node reachability from node "racnode1"
Destination Node Reachable?
------------------------------------ ------------------------
racnode1 yes
racnode2 yes
Result: Node reachability check passed from node "racnode1"


Checking user equivalence...

Check: User equivalence for user "grid"
Node Name Status
--

---------------------------------- ------------------------
racnode2 passed
racnode1 passed
Result: User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...
Node Name Status
------------------------------------ ------------------------
racnode2 passed
racnode1 passed

Verification of the hosts config file successful


Interface information for node "racnode2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.1.152 192.168.1.0 0.0.0.0 10.18.255.254 00:0C:29:2D:8A:0A 1500
eth1 192.168.2.152 192.168.2.0 0.0.0.0 10.18.255.254 00:0C:29:2D:8A:1E 1500
eth2 10.18.11.137 10.18.0.0 0.0.0.0 10.18.255.254 00:0C:29:2D:8A:14 1500


Interface information for node "racnode1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.1.151 192.168.1.0 0.0.0.0 10.18.255.254 00:0C:29:C2:96:D4 1500
eth2 10.18.11.148 10.18.0.0 0.0.0.0 10.18.255.254 00:0C:29:C2:96:E8 1500
eth1 192.168.2.151 192.168.2.0 0.0.0.0 10.18.255.254 00:0C:29:C2:96:DE 1500


Check: Node connectivity of subnet "192.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racnode2[192.168.1.152] racnode1[192.168.1.151] yes
Result: Node connectivity passed for subnet "192.168.1.0" with node(s) racnode2,racnode1


Check: TCP connectivity of subnet "192.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racnode1:192.168.1.151 racnode2:192.168.1.152 passed
Result: TCP connectivity check passed for subnet "192.168.1.0"


Check: Node connectivity of subnet "192.168.2.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racnode2[192.168.2.152] racnode1[192.168.2.151] yes
Result: Node connectivity passed for subnet "192.168.2.0" with node(s) racnode2,racnode1


Check: TCP connectivity of subnet "192.168.2.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racnode1:192.168.2.151 racnode2:192.168.2.152 passed
Result:

TCP connectivity check passed for subnet "192.168.2.0"


Check: Node connectivity of subnet "10.18.0.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racnode2[10.18.11.137] racnode1[10.18.11.148] yes
Result: Node connectivity passed for subnet "10.18.0.0" with node(s) racnode2,racnode1


Check: TCP connectivity of subnet "10.18.0.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
racnode1:10.18.11.148 racnode2:10.18.11.137 passed
Result: TCP connectivity check passed for subnet "10.18.0.0"


Interfaces found on subnet "10.18.0.0" that are likely candidates for VIP are:
racnode2 eth2:10.18.11.137
racnode1 eth2:10.18.11.148

Interfaces found on subnet "192.168.1.0" that are likely candidates for a private interconnect are:
racnode2 eth0:192.168.1.152
racnode1 eth0:192.168.1.151

Interfaces found on subnet "192.168.2.0" that are likely candidates for a private interconnect are:
racnode2 eth1:192.168.2.152
racnode1 eth1:192.168.2.151
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.1.0".
Subnet mask consistency check passed for subnet "192.168.2.0".
Subnet mask consistency check passed for subnet "10.18.0.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "192.168.2.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.2.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "10.18.0.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "10.18.0.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed
Check: Time zone consistency
Result: Time zone consistency check passed

Checking shared storage accessibility...

WARNING:
racnode1:Unable to determine the sharedness of /dev/sda on nodes:
racnode2,racnode1

Disk Sharing Nodes (2 in count)
------------------------------------ ------------------------
/dev/sdb racnode2 racnode1

Disk Sharing Nodes (2 in count)
------------------------------------ ------------------------
/dev/sdc racnode2 racnode1

Disk Sharing Nodes (2 in count)

------------------------------------ ------------------------
/dev/sdd racnode2 racnode1


Shared storage check was successful on nodes "racnode2,racnode1"
Post-check for hardware and operating system setup was successful.

◆安装完grid后的截屏：
[grid@racnode1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE racnode1
ora....ER.lsnr ora....er.type ONLINE ONLINE racnode1
ora....N1.lsnr ora....er.type ONLINE ONLINE racnode1
ora.asm ora.asm.type ONLINE ONLINE racnode1
ora.cvu ora.cvu.type ONLINE ONLINE racnode1
ora.gsd ora.gsd.type OFFLINE OFFLINE
https://www.wendangku.net/doc/9513925364.html,work ora....rk.type ONLINE ONLINE racnode1
ora.oc4j ora.oc4j.type ONLINE ONLINE racnode1
ora.ons ora.ons.type ONLINE ONLINE racnode1
ora....SM1.asm application ONLINE ONLINE racnode1
ora....E1.lsnr application ONLINE ONLINE racnode1
ora....de1.gsd application OFFLINE OFFLINE
ora....de1.ons application ONLINE ONLINE racnode1
ora....de1.vip ora....t1.type ONLINE ONLINE racnode1
ora....SM2.asm application ONLINE ONLINE racnode2
ora....E2.lsnr application ONLINE ONLINE racnode2
ora....de2.gsd application OFFLINE OFFLINE
ora....de2.ons application ONLINE ONLINE racnode2
ora....de2.vip ora....t1.type ONLINE ONLINE racnode2
ora....ry.acfs ora....fs.type ONLINE ONLINE racnode1
ora.scan1.vip ora....ip.type ONLINE ONLINE racnode1