RedHatLinux5安装oracle11GR2 RAC手记20120530

2012年5月30日 7538点热度 0人点赞 0条评论

◆◆环境:
◆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位:
p10404530_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
ora....network 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

liking

这个人很懒,什么都没留下

文章评论