OEL6.3 64位部署ORACLE 11gR2(11.2.0.4) RAC+DG(4)環境配置

stonebox1122發表於2016-04-08

4配置本地YUM

    參考http://blog.itpub.net/28536251/viewspace-1750096/配置本地YUM。

 

5.配置DNS伺服器

不配置DNS,直接使用hosts檔案。

 

6.配置網路

分別為RAC1節點和RAC2節點增加一個網路卡,啟動系統後再進行配置。

6.1 節點1網路卡配置

1)網路卡eth0

[root@rac1 ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth0

[root@rac1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE="eth0"

BOOTPROTO="none"

HWADDR="00:0c:29:34:18:7f"

NM_CONTROLLED="yes"

ONBOOT="yes"

TYPE="Ethernet"

IPADDR=192.168.247.131

NETMASK=255.255.255.0

GATEWAY=192.168.247.2

DNS1=192.168.247.2

ARPCHECK=no

 

 

2)網路卡eth1

[root@rac1 ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth1

[root@rac1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth1

DEVICE=eth1

HWADDR=00:0C:29:17:B8:0E

TYPE=Ethernet

ONBOOT=yes

NM_CONTROLLED=yes

BOOTPROTO=none

IPADDR=172.16.0.11

NETMASK=255.255.255.0

ARPCHECK=no

 

3)地址對映

[root@rac1 ~]# vim /etc/hosts

[root@rac1 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

#Public

192.168.247.131   rac1

192.168.247.132   rac2

#Virtual

192.168.247.133   rac1-vip

192.168.247.134   rac2-vip

#Private

172.16.0.11   rac1-priv

172.16.0.12   rac2-priv

#SCAN

192.168.247.135   rac-scan

 

4)重啟網路

[root@rac1 ~]# /etc/init.d/network restart

Shutting down interface eth0:                              [  OK  ]

Shutting down loopback interface:                          [  OK  ]

Bringing up loopback interface:                            [  OK  ]

Bringing up interface eth0:                                [  OK  ]

Bringing up interface eth1:                                [  OK  ]

 

6.2 節點2網路卡配置

1)網路卡eth0

[root@rac2 ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth0

[root@rac2 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0

HWADDR=00:0c:29:23:53:1c

TYPE=Ethernet

ONBOOT=yes

NM_CONTROLLED=yes

BOOTPROTO=none

IPADDR=192.168.247.132

NETMASK=255.255.255.0

GATEWAY=192.168.247.2

ARPCHECK=NO

 

2)網路卡eth1

[root@rac1 ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth1

[root@rac1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth1

DEVICE=eth1

HWADDR=00:0C:29:23:53:26

TYPE=Ethernet

ONBOOT=yes

NM_CONTROLLED=yes

BOOTPROTO=none

IPADDR=172.16.0.12

NETMASK=255.255.255.0

ARPCHECK=no

 

3)地址對映

[root@rac2 ~]# vim /etc/hosts

[root@rac2 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

#Public

192.168.247.131   rac1

192.168.247.132   rac2

#Virtual

192.168.247.133   rac1-vip

192.168.247.134   rac2-vip

#Private

172.16.0.11   rac1-priv

172.16.0.12   rac2-priv

#SCAN

192.168.247.135   rac-scan

 

4)重啟網路

[root@rac2 ~]# /etc/init.d/network restart

Shutting down interface eth0:                              [  OK  ]

Shutting down loopback interface:                          [  OK  ]

Bringing up loopback interface:                            [  OK  ]

Bringing up interface eth0:                                [  OK  ]

Bringing up interface eth1:                                [  OK  ]

 

7.建立組、使用者及目錄

使用以下指令碼進行建立,請根據實際情況進行修改,分別在兩個節點執行。

[root@rac1 ~]# vim oracle_ugd.sh

[root@rac1 ~]# cat oracle_ugd.sh

#!/bin/bash

groupadd -g 5000 asmadmin

groupadd -g 5001 asmdba

groupadd -g 5002 asmoper

groupadd -g 6000 oinstall

groupadd -g 6001 dba

groupadd -g 6002 oper

useradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid -s /bin/bash -c "Grid Infrastructure Owner" grid

useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle

mkdir -p /u01/app/grid

mkdir -p /u01/app/11.2.0/grid

chown -R grid:oinstall /u01

mkdir -p /u01/app/oracle

chown oracle:oinstall /u01/app/oracle

chmod -R 775 /u01

echo "123456" | passwd --stdin grid

echo "123456" | passwd --stdin oracle

 

8.配置環境變數

8.1 節點1環境變數

1grid使用者環境變數

切換到grid使用者,在.bash_profile檔案中增加以下內容。

[grid@rac1 ~]$ vim .bash_profile

[grid@rac1 ~]$ source .bash_profile

[grid@rac1 ~]$ tail -6 .bash_profile

#Grid Settings

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

 

2oracle使用者環境變數設定

切換到oracle使用者,在.bash_profile檔案中增加以下內容。

[oracle@rac1 ~]$ vim .bash_profile

[oracle@rac1 ~]$ source .bash_profile

[oracle@rac1 ~]$ tail -13 .bash_profile

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=rac1; export ORACLE_HOSTNAME

ORACLE_UNQNAME=stone; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_SID=stone1; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

BASE_PATH=/usr/sbin:$PATH; export BASE_PATH

PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

 

8.2 節點2環境變數

1grid使用者環境變數

切換到grid使用者,在.bash_profile檔案中增加以下內容。

[grid@rac2 ~]$ vim .bash_profile

[grid @rac2 ~]$ source .bash_profile

[grid@rac2 ~]$ tail -6 .bash_profile

#Grid Settings

ORACLE_BASE=/u01/app/grid

ORACLE_HOME=/u01/app/11.2.0/grid

ORACLE_SID=+ASM2

PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

 

2oracle使用者環境變數設定

切換到oracle使用者,在.bash_profile檔案中增加以下內容。

[oracle@rac2 ~]$ vim .bash_profile

[oracle@rac2 ~]$ source .bash_profile

[oracle@rac2 ~]$ tail -13 .bash_profile

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=rac2; export ORACLE_HOSTNAME

ORACLE_UNQNAME=stone; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_SID=stone2; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

BASE_PATH=/usr/sbin:$PATH; export BASE_PATH

PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

 

9.配置ASM

9.1 RAC1節點配置

    先對三塊共享盤進行分割槽。

[root@rac1 ~]# fdisk -l

 

Disk /dev/sda: 42.9 GB, 42949672960 bytes

255 heads, 63 sectors/track, 5221 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x0007b4fb

 

   Device Boot      Start         End      Blocks   Id  System

/dev/sda1   *           1          26      204800   83  Linux

Partition 1 does not end on cylinder boundary.

/dev/sda2              26         536     4096000   82  Linux swap / Solaris

Partition 2 does not end on cylinder boundary.

/dev/sda3             536        5222    37641216   83  Linux

 

Disk /dev/sdb: 21.5 GB, 21474836480 bytes

255 heads, 63 sectors/track, 2610 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

 

 

Disk /dev/sdc: 8589 MB, 8589934592 bytes

255 heads, 63 sectors/track, 1044 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

 

 

Disk /dev/sdd: 2147 MB, 2147483648 bytes

255 heads, 63 sectors/track, 261 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

 

[root@rac1 ~]# fdisk /dev/sdb

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Building a new DOS disklabel with disk identifier 0x675c8c27.

Changes will remain in memory only, until you decide to write them.

After that, of course, the previous content won't be recoverable.

 

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

 

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

 

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-2610, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-2610, default 2610):

Using default value 2610

 

Command (m for help): w

The partition table has been altered!

 

Calling ioctl() to re-read partition table.

Syncing disks.

[root@rac1 ~]# fdisk /dev/sdc

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Building a new DOS disklabel with disk identifier 0xf8c80158.

Changes will remain in memory only, until you decide to write them.

After that, of course, the previous content won't be recoverable.

 

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

 

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

 

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-1044, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-1044, default 1044):

Using default value 1044

 

Command (m for help): w

The partition table has been altered!

 

Calling ioctl() to re-read partition table.

Syncing disks.

[root@rac1 ~]# fdisk /dev/sdd

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Building a new DOS disklabel with disk identifier 0x685927b7.

Changes will remain in memory only, until you decide to write them.

After that, of course, the previous content won't be recoverable.

 

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

 

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

         switch off the mode (command 'c') and change display units to

         sectors (command 'u').

 

Command (m for help): n

Command action

   e   extended

   p   primary partition (1-4)

p

Partition number (1-4): 1

First cylinder (1-261, default 1):

Using default value 1

Last cylinder, +cylinders or +size{K,M,G} (1-261, default 261):

Using default value 261

 

Command (m for help): w

The partition table has been altered!

 

Calling ioctl() to re-read partition table.

Syncing disks.

[root@rac1 ~]# partprobe

Warning: WARNING: the kernel failed to re-read the partition table on /dev/sda (Device or resource busy).  As a result, it may not reflect all of your changes until after reboot.

Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0 has been opened read-only.

[root@rac1 ~]# fdisk -l

 

Disk /dev/sda: 42.9 GB, 42949672960 bytes

255 heads, 63 sectors/track, 5221 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x0007b4fb

 

   Device Boot      Start         End      Blocks   Id  System

/dev/sda1   *           1          26      204800   83  Linux

Partition 1 does not end on cylinder boundary.

/dev/sda2              26         536     4096000   82  Linux swap / Solaris

Partition 2 does not end on cylinder boundary.

/dev/sda3             536        5222    37641216   83  Linux

 

Disk /dev/sdb: 21.5 GB, 21474836480 bytes

255 heads, 63 sectors/track, 2610 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x675c8c27

 

   Device Boot      Start         End      Blocks   Id  System

/dev/sdb1               1        2610    20964793+  83  Linux

 

Disk /dev/sdc: 8589 MB, 8589934592 bytes

255 heads, 63 sectors/track, 1044 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xf8c80158

 

   Device Boot      Start         End      Blocks   Id  System

/dev/sdc1               1        1044     8385898+  83  Linux

 

Disk /dev/sdd: 2147 MB, 2147483648 bytes

255 heads, 63 sectors/track, 261 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x685927b7

 

   Device Boot      Start         End      Blocks   Id  System

/dev/sdd1               1         261     2096451   83  Linux

 

分割槽結果:

[root@rac1 ~]# cat /proc/partitions

major minor  #blocks  name

 

   8        0   41943040 sda

   8        1     204800 sda1

   8        2    4096000 sda2

   8        3   37641216 sda3

   8       16   20971520 sdb

   8       17   20964793 sdb1

   8       32    8388608 sdc

   8       33    8385898 sdc1

   8       48    2097152 sdd

   8       49    2096451 sdd1

 

將分割槽對映為raw裝置:

[root@rac1 ~]# vim /etc/udev/rules.d/60-raw.rules

# Enter raw device bindings here.

#

# An example would be:

#   ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"

# to bind /dev/raw/raw1 to /dev/sda, or

#   ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"

# to bind /dev/raw/raw2 to the device with major 8, minor 1.

 

ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"

KERNEL=="raw1", OWNER="grid",GROUP="asmadmin", MODE="0660"

ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw2 %N"

KERNEL=="raw2", OWNER="grid",GROUP="asmadmin", MODE="0660"

ACTION=="add", KERNEL=="sdd1", RUN+="/bin/raw /dev/raw/raw3 %N"

KERNEL=="raw3", OWNER="grid",GROUP="asmadmin", MODE="0660"

 

[root@rac1 ~]# ls /dev/raw/

rawctl

[root@rac1 ~]# start_udev

Starting udev:                                             [  OK  ]

[root@rac1 ~]# ll /dev/raw/

total 0

crw-rw---- 1 grid asmadmin 162, 1 Apr  6 00:23 raw1

crw-rw---- 1 grid asmadmin 162, 2 Apr  6 00:23 raw2

crw-rw---- 1 grid asmadmin 162, 3 Apr  6 00:23 raw3

crw-rw---- 1 root disk     162, 0 Apr  6  2016 rawctl

 

9.2 RAC2節點配置

RAC2節點無需再進行分割槽,但需要執行partprobe命令使RAC2節點核心識別到分割槽。

[root@rac2 ~]# partprobe

Warning: WARNING: the kernel failed to re-read the partition table on /dev/sda (Device or resource busy).  As a result, it may not reflect all of your changes until after reboot.

Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0 has been opened read-only.

[root@rac2 ~]# cat /proc/partitions

major minor  #blocks  name

 

   8        0   41943040 sda

   8        1     204800 sda1

   8        2    4096000 sda2

   8        3   37641216 sda3

   8       16   20971520 sdb

   8       17   20964793 sdb1

   8       32    8388608 sdc

   8       33    8385898 sdc1

   8       48    2097152 sdd

   8       49    2096451 sdd1

 

將分割槽對映為raw裝置:

[root@rac2 ~]# vim /etc/udev/rules.d/60-raw.rules

# Enter raw device bindings here.

#

# An example would be:

#   ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"

# to bind /dev/raw/raw1 to /dev/sda, or

#   ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"

# to bind /dev/raw/raw2 to the device with major 8, minor 1.

 

ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"

KERNEL=="raw1", OWNER="grid",GROUP="asmadmin", MODE="0660"

ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw2 %N"

KERNEL=="raw2", OWNER="grid",GROUP="asmadmin", MODE="0660"

ACTION=="add", KERNEL=="sdd1", RUN+="/bin/raw /dev/raw/raw3 %N"

KERNEL=="raw3", OWNER="grid",GROUP="asmadmin", MODE="0660"

 

[root@rac2 ~]# ls /dev/raw/

rawctl

[root@rac2 ~]# start_udev

Starting udev:                                             [  OK  ]

[root@rac2 ~]# ll /dev/raw/

total 0

crw-rw---- 1 grid asmadmin 162, 1 Apr  6 00:24 raw1

crw-rw---- 1 grid asmadmin 162, 2 Apr  6 00:24 raw2

crw-rw---- 1 grid asmadmin 162, 3 Apr  6 00:24 raw3

crw-rw---- 1 root disk     162, 0 Apr  6 00:24 rawctl

 

10.安裝依賴包

分別在兩個節點上面使用YUM安裝依賴包。

[root@rac1 ~]#yum install gcc compat-libstdc++-33 elfutils-libelf-devel gcc-c++ libaio-devel libstdc++-devel ksh libcap.so.1 –y

[root@rac1 ~]# cd /lib64

[root@rac1 lib64]# ln -s libcap.so.2.16 libcap.so.1

 

[root@rac2 ~]#yum install gcc compat-libstdc++-33 elfutils-libelf-devel gcc-c++ libaio-devel libstdc++-devel ksh libcap.so.1 –y

[root@rac2 ~]# cd /lib64

[root@rac2 lib64]# ln -s libcap.so.2.16 libcap.so.1

 

 

11.禁用NTP

分別在2個節點禁用NTP服務。

[root@rac1 ~]# /etc/init.d/ntpd stop

Shutting down ntpd:                                        [FAILED]

[root@rac1 ~]# chkconfig ntpd off

[root@rac1 ~]# mv /etc/ntp.conf /etc/ntp.conf.bak

 

[root@rac2 ~]# /etc/init.d/ntpd stop

Shutting down ntpd:                                        [FAILED]

[root@rac2 ~]# chkconfig ntpd off

[root@rac2 ~]# mv /etc/ntp.conf /etc/ntp.conf.bak

 

12.驗證環境

12.1 安裝cvuqdisk

分別在2個節點解壓GI安裝包,安裝cvuqdisk。

節點1

[root@rac1 ~]# su - grid

[grid@rac1 ~]$ unzip /mnt/hgfs/data/oracle/software/11204/p13390677_112040_Linux-x86-64_3of7.zip

切換到root使用者進行安裝。

[root@rac1 ~]# cd /home/grid/grid/rpm/

[root@rac1 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm

Preparing...                ########################################### [100%]

Using default group oinstall to install package

   1:cvuqdisk               ########################################### [100%]

 

節點2

[root@rac2 ~]# su - grid

[grid@rac2 ~]$ unzip /mnt/hgfs/data/oracle/software/11204/p13390677_112040_Linux-x86-64_3of7.zip

切換到root使用者進行安裝。

[root@rac2 ~]# cd /home/grid/grid/rpm/

[root@rac2 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm

Preparing...                ########################################### [100%]

Using default group oinstall to install package

   1:cvuqdisk               ########################################### [100%]

 

12.2 驗證安裝環境

此處操作是在GI安裝完成後進行的。因為11G R2版本可以自動配置SSH等價(就是使用ssh訪問對方不需要輸入密碼),比較方便。

[root@rac1 ~]# su - grid

[grid@rac1 ~]$ cd grid/

[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbose

 

Performing pre-checks for cluster services setup

 

Checking node reachability...

 

Check: Node reachability from node "rac1"

  Destination Node                      Reachable?             

  ------------------------------------  ------------------------

  rac2                                  yes                    

  rac1                                  yes                    

Result: Node reachability check passed from node "rac1"

 

 

Checking user equivalence...

 

Check: User equivalence for user "grid"

  Node Name                             Status                 

  ------------------------------------  ------------------------

  rac2                                  passed                 

  rac1                                  passed                 

Result: User equivalence check passed for user "grid"

 

Checking node connectivity...

 

Checking hosts config file...

  Node Name                             Status                 

  ------------------------------------  ------------------------

  rac2                                  passed                 

  rac1                                  passed                 

 

Verification of the hosts config file successful

 

 

Interface information for node "rac2"

 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 eth0   192.168.247.132 192.168.247.0   0.0.0.0         192.168.247.2   00:0C:29:81:1B:75 1500 

 eth0   192.168.247.134 192.168.247.0   0.0.0.0         192.168.247.2   00:0C:29:81:1B:75 1500 

 eth0   192.168.247.135 192.168.247.0   0.0.0.0         192.168.247.2   00:0C:29:81:1B:75 1500 

 eth1   172.16.0.12     172.16.0.0      0.0.0.0         192.168.247.2   00:0C:29:81:1B:7F 1500 

 eth1   169.254.9.250   169.254.0.0     0.0.0.0         192.168.247.2   00:0C:29:81:1B:7F 1500 

 

 

Interface information for node "rac1"

 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 eth0   192.168.247.131 192.168.247.0   0.0.0.0         192.168.247.2   00:0C:29:34:18:7F 1500 

 eth0   192.168.247.133 192.168.247.0   0.0.0.0         192.168.247.2   00:0C:29:34:18:7F 1500 

 eth1   172.16.0.11     172.16.0.0      0.0.0.0         192.168.247.2   00:0C:29:34:18:89 1500 

 eth1   169.254.79.136  169.254.0.0     0.0.0.0         192.168.247.2   00:0C:29:34:18:89 1500 

 

 

Check: Node connectivity for interface "eth0"

  Source                          Destination                     Connected?     

  ------------------------------  ------------------------------  ----------------

  rac2[192.168.247.132]           rac2[192.168.247.134]           yes            

  rac2[192.168.247.132]           rac2[192.168.247.135]           yes            

  rac2[192.168.247.132]           rac1[192.168.247.131]           yes            

  rac2[192.168.247.132]           rac1[192.168.247.133]           yes            

  rac2[192.168.247.134]           rac2[192.168.247.135]           yes            

  rac2[192.168.247.134]           rac1[192.168.247.131]           yes            

  rac2[192.168.247.134]           rac1[192.168.247.133]           yes            

  rac2[192.168.247.135]           rac1[192.168.247.131]           yes            

  rac2[192.168.247.135]           rac1[192.168.247.133]           yes            

  rac1[192.168.247.131]           rac1[192.168.247.133]           yes            

Result: Node connectivity passed for interface "eth0"

 

 

Check: TCP connectivity of subnet "192.168.247.0"

  Source                          Destination                     Connected?     

  ------------------------------  ------------------------------  ----------------

  rac1:192.168.247.131            rac2:192.168.247.132            passed         

  rac1:192.168.247.131            rac2:192.168.247.134            passed         

  rac1:192.168.247.131            rac2:192.168.247.135            passed         

  rac1:192.168.247.131            rac1:192.168.247.133            passed         

Result: TCP connectivity check passed for subnet "192.168.247.0"

 

 

Check: Node connectivity for interface "eth1"

  Source                          Destination                     Connected?     

  ------------------------------  ------------------------------  ----------------

  rac2[172.16.0.12]               rac1[172.16.0.11]               yes            

Result: Node connectivity passed for interface "eth1"

 

 

Check: TCP connectivity of subnet "172.16.0.0"

  Source                          Destination                     Connected?     

  ------------------------------  ------------------------------  ----------------

  rac1:172.16.0.11                rac2:172.16.0.12                passed         

Result: TCP connectivity check passed for subnet "172.16.0.0"

 

Checking subnet mask consistency...

Subnet mask consistency check passed for subnet "192.168.247.0".

Subnet mask consistency check passed for subnet "172.16.0.0".

Subnet mask consistency check passed.

 

Result: Node connectivity check passed

 

Checking multicast communication...

 

Checking subnet "192.168.247.0" for multicast communication with multicast group "230.0.1.0"...

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

 

Checking subnet "172.16.0.0" for multicast communication with multicast group "230.0.1.0"...

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

 

Check of multicast communication passed.

 

Checking ASMLib configuration.

  Node Name                             Status                 

  ------------------------------------  ------------------------

  rac2                                  passed                 

  rac1                                  passed                 

Result: Check for ASMLib configuration passed.

 

Check: Total memory

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          1.9472GB (2041828.0KB)    1.5GB (1572864.0KB)       passed   

  rac1          1.9472GB (2041828.0KB)    1.5GB (1572864.0KB)       passed   

Result: Total memory check passed

 

Check: Available memory

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          659.668MB (675500.0KB)    50MB (51200.0KB)          passed   

  rac1          578.3125MB (592192.0KB)   50MB (51200.0KB)          passed   

Result: Available memory check passed

 

Check: Swap space

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          3.9062GB (4095996.0KB)    2.9209GB (3062742.0KB)    passed   

  rac1          3.9062GB (4095996.0KB)    2.9209GB (3062742.0KB)    passed   

Result: Swap space check passed

 

Check: Free disk space for "rac2:/u01/app/11.2.0/grid,rac2:/tmp"

  Path              Node Name     Mount point   Available     Required      Status     

  ----------------  ------------  ------------  ------------  ------------  ------------

  /u01/app/11.2.0/grid  rac2          /             17.998GB      7.5GB         passed     

  /tmp              rac2          /             17.998GB      7.5GB         passed     

Result: Free disk space check passed for "rac2:/u01/app/11.2.0/grid,rac2:/tmp"

 

Check: Free disk space for "rac1:/u01/app/11.2.0/grid,rac1:/tmp"

  Path              Node Name     Mount point   Available     Required      Status     

  ----------------  ------------  ------------  ------------  ------------  ------------

  /u01/app/11.2.0/grid  rac1          /             15.8014GB     7.5GB         passed     

  /tmp              rac1          /             15.8014GB     7.5GB         passed     

Result: Free disk space check passed for "rac1:/u01/app/11.2.0/grid,rac1:/tmp"

 

Check: User existence for "grid"

  Node Name     Status                    Comment                

  ------------  ------------------------  ------------------------

  rac2          passed                    exists(1100)           

  rac1          passed                    exists(1100)           

 

Checking for multiple users with UID value 1100

Result: Check for multiple users with UID value 1100 passed

Result: User existence check passed for "grid"

 

Check: Group existence for "oinstall"

  Node Name     Status                    Comment                

  ------------  ------------------------  ------------------------

  rac2          passed                    exists                 

  rac1          passed                    exists                 

Result: Group existence check passed for "oinstall"

 

Check: Group existence for "dba"

  Node Name     Status                    Comment                

  ------------  ------------------------  ------------------------

  rac2          passed                    exists                 

  rac1          passed                    exists                 

Result: Group existence check passed for "dba"

 

Check: Membership of user "grid" in group "oinstall" [as Primary]

  Node Name         User Exists   Group Exists  User in Group  Primary       Status     

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              yes           yes           yes           yes           passed     

  rac1              yes           yes           yes           yes           passed     

Result: Membership check for user "grid" in group "oinstall" [as Primary] passed

 

Check: Membership of user "grid" in group "dba"

  Node Name         User Exists   Group Exists  User in Group  Status         

  ----------------  ------------  ------------  ------------  ----------------

  rac2              yes           yes           yes           passed         

  rac1              yes           yes           yes           passed         

Result: Membership check for user "grid" in group "dba" passed

 

Check: Run level

  Node Name     run level                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          5                         3,5                       passed   

  rac1          5                         3,5                       passed   

Result: Run level check passed

 

Check: Hard limits for "maximum open file descriptors"

  Node Name         Type          Available     Required      Status         

  ----------------  ------------  ------------  ------------  ----------------

  rac2              hard          65536         65536         passed          

  rac1              hard          65536         65536         passed         

Result: Hard limits check passed for "maximum open file descriptors"

 

Check: Soft limits for "maximum open file descriptors"

  Node Name         Type          Available     Required      Status         

  ----------------  ------------  ------------  ------------  ----------------

  rac2              soft          1024          1024          passed         

  rac1              soft          65536         1024          passed         

Result: Soft limits check passed for "maximum open file descriptors"

 

Check: Hard limits for "maximum user processes"

  Node Name         Type          Available     Required      Status         

  ----------------  ------------  ------------  ------------  ----------------

  rac2              hard          16384         16384         passed         

  rac1              hard          16384         16384         passed         

Result: Hard limits check passed for "maximum user processes"

 

Check: Soft limits for "maximum user processes"

  Node Name         Type          Available     Required      Status         

  ----------------  ------------  ------------  ------------  ----------------

  rac2              soft          2047          2047          passed         

  rac1              soft          2047          2047          passed         

Result: Soft limits check passed for "maximum user processes"

 

Check: System architecture

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          x86_64                    x86_64                    passed   

  rac1          x86_64                    x86_64                    passed    

Result: System architecture check passed

 

Check: Kernel version

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          2.6.39-200.24.1.el6uek.x86_64  2.6.32                    passed   

  rac1          2.6.39-200.24.1.el6uek.x86_64  2.6.32                    passed   

Result: Kernel version check passed

 

Check: Kernel parameter for "semmsl"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              250           250           250           passed         

  rac1              250           250           250           passed         

Result: Kernel parameter check passed for "semmsl"

 

Check: Kernel parameter for "semmns"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              32000         32000         32000         passed         

  rac1              32000         32000         32000         passed         

Result: Kernel parameter check passed for "semmns"

 

Check: Kernel parameter for "semopm"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              100           100           100           passed         

  rac1              100           100           100           passed         

Result: Kernel parameter check passed for "semopm"

 

Check: Kernel parameter for "semmni"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              128           128           128           passed         

  rac1              128           128           128           passed         

Result: Kernel parameter check passed for "semmni"

 

Check: Kernel parameter for "shmmax"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              68719476736   68719476736   1045415936    passed         

  rac1              68719476736   68719476736   1045415936    passed         

Result: Kernel parameter check passed for "shmmax"

 

Check: Kernel parameter for "shmmni"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              4096          4096          4096          passed         

  rac1              4096          4096          4096          passed         

Result: Kernel parameter check passed for "shmmni"

 

Check: Kernel parameter for "shmall"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              4294967296    4294967296    2097152       passed         

  rac1              4294967296    4294967296    2097152       passed         

Result: Kernel parameter check passed for "shmall"

 

Check: Kernel parameter for "file-max"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              6815744       6815744       6815744       passed         

  rac1              6815744       6815744       6815744       passed         

Result: Kernel parameter check passed for "file-max"

 

Check: Kernel parameter for "ip_local_port_range"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed         

  rac1              between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed         

Result: Kernel parameter check passed for "ip_local_port_range"

 

Check: Kernel parameter for "rmem_default"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              262144        262144        262144        passed         

  rac1              262144        262144        262144        passed         

Result: Kernel parameter check passed for "rmem_default"

 

Check: Kernel parameter for "rmem_max"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              4194304       4194304       4194304       passed         

  rac1              4194304       4194304       4194304       passed         

Result: Kernel parameter check passed for "rmem_max"

 

Check: Kernel parameter for "wmem_default"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              262144        262144        262144        passed         

  rac1              262144        262144        262144        passed         

Result: Kernel parameter check passed for "wmem_default"

 

Check: Kernel parameter for "wmem_max"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              1048576       1048576       1048576       passed         

  rac1              1048576       1048576       1048576       passed         

Result: Kernel parameter check passed for "wmem_max"

 

Check: Kernel parameter for "aio-max-nr"

  Node Name         Current       Configured    Required      Status        Comment    

  ----------------  ------------  ------------  ------------  ------------  ------------

  rac2              1048576       1048576       1048576       passed          

  rac1              1048576       1048576       1048576       passed         

Result: Kernel parameter check passed for "aio-max-nr"

 

Check: Package existence for "binutils"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          binutils-2.20.51.0.2-5.34.el6  binutils-2.20.51.0.2      passed   

  rac1          binutils-2.20.51.0.2-5.34.el6  binutils-2.20.51.0.2      passed   

Result: Package existence check passed for "binutils"

 

Check: Package existence for "compat-libcap1"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          compat-libcap1-1.10-1     compat-libcap1-1.10       passed   

  rac1          compat-libcap1-1.10-1     compat-libcap1-1.10       passed   

Result: Package existence check passed for "compat-libcap1"

 

Check: Package existence for "compat-libstdc++-33(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          compat-libstdc++-33(x86_64)-3.2.3-69.el6  compat-libstdc++-33(x86_64)-3.2.3  passed   

  rac1          compat-libstdc++-33(x86_64)-3.2.3-69.el6  compat-libstdc++-33(x86_64)-3.2.3  passed   

Result: Package existence check passed for "compat-libstdc++-33(x86_64)"

 

Check: Package existence for "libgcc(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          libgcc(x86_64)-4.4.6-4.el6  libgcc(x86_64)-4.4.4      passed   

  rac1          libgcc(x86_64)-4.4.6-4.el6  libgcc(x86_64)-4.4.4      passed   

Result: Package existence check passed for "libgcc(x86_64)"

 

Check: Package existence for "libstdc++(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          libstdc++(x86_64)-4.4.6-4.el6  libstdc++(x86_64)-4.4.4   passed   

  rac1          libstdc++(x86_64)-4.4.6-4.el6  libstdc++(x86_64)-4.4.4   passed   

Result: Package existence check passed for "libstdc++(x86_64)"

 

Check: Package existence for "libstdc++-devel(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          libstdc++-devel(x86_64)-4.4.6-4.el6  libstdc++-devel(x86_64)-4.4.4  passed   

  rac1          libstdc++-devel(x86_64)-4.4.6-4.el6  libstdc++-devel(x86_64)-4.4.4  passed   

Result: Package existence check passed for "libstdc++-devel(x86_64)"

 

Check: Package existence for "sysstat"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          sysstat-9.0.4-20.el6      sysstat-9.0.4             passed   

  rac1          sysstat-9.0.4-20.el6      sysstat-9.0.4             passed   

Result: Package existence check passed for "sysstat"

 

Check: Package existence for "gcc"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          gcc-4.4.6-4.el6           gcc-4.4.4                 passed   

  rac1          gcc-4.4.6-4.el6           gcc-4.4.4                 passed    

Result: Package existence check passed for "gcc"

 

Check: Package existence for "gcc-c++"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          gcc-c++-4.4.6-4.el6       gcc-c++-4.4.4             passed   

  rac1          gcc-c++-4.4.6-4.el6       gcc-c++-4.4.4             passed   

Result: Package existence check passed for "gcc-c++"

 

Check: Package existence for "ksh"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          ksh-20100621-16.el6       ksh-20100621              passed   

  rac1          ksh-20100621-16.el6       ksh-20100621              passed   

Result: Package existence check passed for "ksh"

 

Check: Package existence for "make"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          make-3.81-20.el6          make-3.81                 passed   

  rac1          make-3.81-20.el6          make-3.81                 passed   

Result: Package existence check passed for "make"

 

Check: Package existence for "glibc(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          glibc(x86_64)-2.12-1.80.el6  glibc(x86_64)-2.12        passed   

  rac1          glibc(x86_64)-2.12-1.80.el6  glibc(x86_64)-2.12        passed   

Result: Package existence check passed for "glibc(x86_64)"

 

Check: Package existence for "glibc-devel(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          glibc-devel(x86_64)-2.12-1.80.el6  glibc-devel(x86_64)-2.12  passed   

  rac1          glibc-devel(x86_64)-2.12-1.80.el6  glibc-devel(x86_64)-2.12  passed   

Result: Package existence check passed for "glibc-devel(x86_64)"

 

Check: Package existence for "libaio(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          libaio(x86_64)-0.3.107-10.el6  libaio(x86_64)-0.3.107    passed   

  rac1          libaio(x86_64)-0.3.107-10.el6  libaio(x86_64)-0.3.107    passed   

Result: Package existence check passed for "libaio(x86_64)"

 

Check: Package existence for "libaio-devel(x86_64)"

  Node Name     Available                 Required                  Status   

  ------------  ------------------------  ------------------------  ----------

  rac2          libaio-devel(x86_64)-0.3.107-10.el6  libaio-devel(x86_64)-0.3.107  passed   

  rac1          libaio-devel(x86_64)-0.3.107-10.el6  libaio-devel(x86_64)-0.3.107  passed   

Result: Package existence check passed for "libaio-devel(x86_64)"

 

Checking for multiple users with UID value 0

Result: Check for multiple users with UID value 0 passed

 

Check: Current group ID

Result: Current group ID check passed

 

Starting check for consistency of primary group of root user

  Node Name                             Status                  

  ------------------------------------  ------------------------

  rac2                                  passed                 

  rac1                                  passed                 

 

Check for consistency of root user's primary group passed

 

Starting Clock synchronization checks using Network Time Protocol(NTP)...

 

NTP Configuration file check started...

Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes

No NTP Daemons or Services were found to be running

 

Result: Clock synchronization check using Network Time Protocol(NTP) passed

 

Checking Core file name pattern consistency...

Core file name pattern consistency check passed.

 

Checking to make sure user "grid" is not in "root" group

  Node Name     Status                    Comment                

  ------------  ------------------------  ------------------------

  rac2          passed                    does not exist         

  rac1          passed                    does not exist         

Result: User "grid" is not part of "root" group. Check passed

 

Check default user file creation mask

  Node Name     Available                 Required                  Comment  

  ------------  ------------------------  ------------------------  ----------

  rac2          0022                      0022                      passed   

  rac1          0022                      0022                      passed   

Result: Default user file creation mask check passed

Checking consistency of file "/etc/resolv.conf" across nodes

 

Checking the file "/etc/resolv.conf" to make sure only one of domain and search entries is defined

File "/etc/resolv.conf" does not have both domain and search entries defined

Checking if domain entry in file "/etc/resolv.conf" is consistent across the nodes...

domain entry in file "/etc/resolv.conf" is consistent across nodes

Checking if search entry in file "/etc/resolv.conf" is consistent across the nodes...

search entry in file "/etc/resolv.conf" is consistent across nodes

Checking DNS response time for an unreachable node

  Node Name                             Status                 

  ------------------------------------  ------------------------

  rac2                                  passed                 

  rac1                                  passed                 

The DNS response time for an unreachable node is within acceptable limit on all nodes

 

File "/etc/resolv.conf" is consistent across nodes

 

Check: Time zone consistency

Result: Time zone consistency check passed

 

Starting check for Reverse path filter setting ...

Reverse path filter setting is correct for all private interconnect network interfaces on node "rac2".

Reverse path filter setting is correct for all private interconnect network interfaces on node "rac1".

 

Check for Reverse path filter setting passed

 

Pre-check for cluster services setup was successful.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28536251/viewspace-2077581/,如需轉載,請註明出處,否則將追究法律責任。

相關文章