Richmond Database (01)

Friday 16 May, 2008 - 06:48

Starting DB software installation.

Since I am running out of time (five (5) weeks to go), I have decided to follow the best practices path completely. This means that I will be using ASM with the asmlib driver for the cluster filesystem.

I have configured the following disks:

SCSI Address Device Size (Gb) ASM Vol ID
1:3 /dev/sde 8 ASM1
1:4 /dev/sdf 8 ASM2
1:5 /dev/sdg 12 FRA1
1:6 /dev/sdh 12 FRA2

The design here is to put the whole database onto ASM1 (with ASM2 as the other failure group) and the flashback recovery area onto FRA1 (with FRA2 as the other failure group). Bad physical design.

$ cluvfy stage -pre dbinst -n richmond1,richmond2 -verbose

Performing pre-checks for database installation

Checking node reachability...

Check: Node reachability from node "richmond1"
Destination Node Reachable?
------------------------------------ ------------------------
richmond2 yes
richmond1 yes
Result: Node reachability check passed from node "richmond1".


Checking user equivalence...

Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
richmond2 passed
richmond1 passed
Result: User equivalence check passed for user "oracle".

Checking administrative privileges...

Check: Existence of user "oracle"
Node Name User Exists Comment
------------ ------------------------ ------------------------
richmond2 yes passed
richmond1 yes passed
Result: User existence check passed for "oracle".

Check: Existence of group "oinstall"
Node Name Status Group ID
------------ ------------------------ ------------------------
richmond2 exists 600
richmond1 exists 600
Result: Group existence check passed for "oinstall".

Check: Membership of user "oracle" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
richmond2 yes yes yes yes passed
richmond1 yes yes yes yes passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed.

Check: Existence of group "dba"
Node Name Status Group ID
------------ ------------------------ ------------------------
richmond2 exists 601
richmond1 exists 601
Result: Group existence check passed for "dba".

Check: Membership of user "oracle" in group "dba"
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
richmond2 yes yes yes no passed
richmond1 yes yes yes no passed
Result: Membership check for user "oracle" in group "dba" passed.

Administrative privileges check passed.

Checking node connectivity...


Interface information for node "richmond2"
Interface Name IP Address Subnet
------------------------------ ------------------------------ ----------------
eth0 192.168.100.66 192.168.100.0
eth0 192.168.100.34 192.168.100.0
eth0 192.168.100.33 192.168.100.0
eth1 192.168.101.2 192.168.101.0


Interface information for node "richmond1"
Interface Name IP Address Subnet
------------------------------ ------------------------------ ----------------
eth0 192.168.100.65 192.168.100.0
eth1 192.168.101.1 192.168.101.0


Check: Node connectivity of subnet "192.168.100.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
richmond2:eth0 richmond2:eth0 yes
richmond2:eth0 richmond2:eth0 yes
richmond2:eth0 richmond1:eth0 yes
richmond2:eth0 richmond2:eth0 yes
richmond2:eth0 richmond1:eth0 yes
richmond2:eth0 richmond1:eth0 yes
Result: Node connectivity check passed for subnet "192.168.100.0" with node(s) richmond2,richmond1.

Check: Node connectivity of subnet "192.168.101.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
richmond2:eth1 richmond1:eth1 yes
Result: Node connectivity check passed for subnet "192.168.101.0" with node(s) richmond2,richmond1.

Suitable interfaces for the private interconnect on subnet "192.168.100.0":
richmond2 eth0:192.168.100.66 eth0:192.168.100.34 eth0:192.168.100.33
richmond1 eth0:192.168.100.65

Suitable interfaces for the private interconnect on subnet "192.168.101.0":
richmond2 eth1:192.168.101.2
richmond1 eth1:192.168.101.1

ERROR:
Could not find a suitable set of interfaces for VIPs.

Result: Node connectivity check failed.



Checking system requirements for 'database'...

Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 1003.38MB (1027460KB) 512MB (524288KB) passed
richmond1 1003.38MB (1027460KB) 512MB (524288KB) passed
Result: Total memory check passed.

Check: Free disk space in "/tmp" dir
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 2.65GB (2783648KB) 400MB (409600KB) passed
richmond1 2.73GB (2860992KB) 400MB (409600KB) passed
Result: Free disk space check passed.

Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 1.95GB (2040244KB) 1GB (1048576KB) passed
richmond1 1.95GB (2040244KB) 1GB (1048576KB) passed
Result: Swap space check passed.

Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 i686 i686 passed
richmond1 i686 i686 passed
Result: System architecture check passed.

Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 2.4.21-40.EL 2.4.21-15EL passed
richmond1 2.4.21-40.EL 2.4.21-15EL passed
Result: Kernel version check passed.

Check: Package existence for "make-3.79"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 make-3.79.1-17.1 passed
richmond1 make-3.79.1-17.1 passed
Result: Package existence check passed for "make-3.79".

Check: Package existence for "binutils-2.14"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 binutils-2.14.90.0.4-42 passed
richmond1 binutils-2.14.90.0.4-42 passed
Result: Package existence check passed for "binutils-2.14".

Check: Package existence for "gcc-3.2"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 gcc-3.2.3-54 passed
richmond1 gcc-3.2.3-54 passed
Result: Package existence check passed for "gcc-3.2".

Check: Package existence for "compat-db-4.0.14-5"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 compat-db-4.0.14-5.1 passed
richmond1 compat-db-4.0.14-5.1 passed
Result: Package existence check passed for "compat-db-4.0.14-5".

Check: Package existence for "compat-gcc-7.3-2.96.128"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 compat-gcc-7.3-2.96.128 passed
richmond1 compat-gcc-7.3-2.96.128 passed
Result: Package existence check passed for "compat-gcc-7.3-2.96.128".

Check: Package existence for "compat-gcc-c++-7.3-2.96.128"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 compat-gcc-c++-7.3-2.96.128 passed
richmond1 compat-gcc-c++-7.3-2.96.128 passed
Result: Package existence check passed for "compat-gcc-c++-7.3-2.96.128".

Check: Package existence for "compat-libstdc++-7.3-2.96.128"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 compat-libstdc++-7.3-2.96.128 passed
richmond1 compat-libstdc++-7.3-2.96.128 passed
Result: Package existence check passed for "compat-libstdc++-7.3-2.96.128".

Check: Package existence for "compat-libstdc++-devel-7.3-2.96.128"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 compat-libstdc++-devel-7.3-2.96.128 passed
richmond1 compat-libstdc++-devel-7.3-2.96.128 passed
Result: Package existence check passed for "compat-libstdc++-devel-7.3-2.96.128".

Check: Package existence for "glibc-2.3.2-95.27"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 glibc-2.3.2-95.39 passed
richmond1 glibc-2.3.2-95.39 passed
Result: Package existence check passed for "glibc-2.3.2-95.27".

Check: Package existence for "openmotif-2.2.3"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 openmotif-2.2.3-5.RHEL3.2 passed
richmond1 openmotif-2.2.3-5.RHEL3.2 passed
Result: Package existence check passed for "openmotif-2.2.3".

Check: Package existence for "setarch-1.3-1"
Node Name Status Comment
------------------------------ ------------------------------ ----------------
richmond2 setarch-1.3-1 passed
richmond1 setarch-1.3-1 passed
Result: Package existence check passed for "setarch-1.3-1".

Check: Kernel parameter for "semmsl"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 250 250 passed
richmond1 250 250 passed
Result: Kernel parameter check passed for "semmsl".

Check: Kernel parameter for "semmns"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 32000 32000 passed
richmond1 32000 32000 passed
Result: Kernel parameter check passed for "semmns".

Check: Kernel parameter for "semopm"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 100 100 passed
richmond1 100 100 passed
Result: Kernel parameter check passed for "semopm".

Check: Kernel parameter for "semmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 128 128 passed
richmond1 128 128 passed
Result: Kernel parameter check passed for "semmni".

Check: Kernel parameter for "shmall"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 2097152 2097152 passed
richmond1 2097152 2097152 passed
Result: Kernel parameter check passed for "shmall".

Check: Kernel parameter for "shmmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 4096 4096 passed
richmond1 4096 4096 passed
Result: Kernel parameter check passed for "shmmni".

Check: Kernel parameter for "file-max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 104857 65536 passed
richmond1 104857 65536 passed
Result: Kernel parameter check passed for "file-max".

Check: Kernel parameter for "rmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 1048576 262144 passed
richmond1 1048576 262144 passed
Result: Kernel parameter check passed for "rmem_default".

Check: Kernel parameter for "rmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 1048576 262144 passed
richmond1 1048576 262144 passed
Result: Kernel parameter check passed for "rmem_max".

Check: Kernel parameter for "wmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 262144 262144 passed
richmond1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default".

Check: Kernel parameter for "wmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
richmond2 262144 262144 passed
richmond1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_max".

Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
richmond2 exists passed
richmond1 exists passed
Result: Group existence check passed for "dba".

Check: User existence for "nobody"
Node Name Status Comment
------------ ------------------------ ------------------------
richmond2 exists passed
richmond1 exists passed
Result: User existence check passed for "nobody".

System requirement passed for 'database'

Checking CRS integrity...

Checking daemon liveness...

Check: Liveness for "CRS daemon"
Node Name Running
------------------------------------ ------------------------
richmond2 yes
richmond1 yes
Result: Liveness check passed for "CRS daemon".

Checking daemon liveness...

Check: Liveness for "CSS daemon"
Node Name Running
------------------------------------ ------------------------
richmond2 yes
richmond1 yes
Result: Liveness check passed for "CSS daemon".

Checking daemon liveness...

Check: Liveness for "EVM daemon"
Node Name Running
------------------------------------ ------------------------
richmond2 yes
richmond1 yes
Result: Liveness check passed for "EVM daemon".

Liveness of all the daemons
Node Name CRS daemon CSS daemon EVM daemon
------------ ------------------------ ------------------------ ----------
richmond2 yes yes yes
richmond1 yes yes yes

Checking CRS health...

Check: Health of CRS
Node Name CRS OK?
------------------------------------ ------------------------
richmond2 yes
richmond1 yes
Result: CRS health check passed.

CRS integrity check passed.

Checking node application existence...


Checking existence of VIP node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
richmond2 yes exists passed
richmond1 yes exists passed
Result: Check passed.

Checking existence of ONS node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
richmond2 no exists passed
richmond1 no exists passed
Result: Check passed.

Checking existence of GSD node application
Node Name Required Status Comment
------------ ------------------------ ------------------------ ----------
richmond2 no exists passed
richmond1 no exists passed
Result: Check passed.


Pre-check for database installation was unsuccessful on all the nodes.

In other words, the only problem is that cluvfy is stil complaining about no public IP addresses.