Oracle Database Commands and Practical Examples

Wednesday 23 October 2019

RAC - Node connectivity check commands./runcluvfy.sh comp nodecon -n rac1,rac2 -verbose

Command to check cluster node connectivity check

Hostname :

sgdcplm01
sgdcplm02

Command :

./runcluvfy.sh comp nodecon -n sgdcplm01,sgdcplm02 -verbose

grid@sgdcplm02:/u04/MasterDB/oracle_grid_software/grid> ./runcluvfy.sh comp nodecon -n sgdcplm01,sgdcplm02 -verbose

Verifying node connectivity

Checking node connectivity...

Checking hosts config file...
Node Name Status
------------------------------------ ------------------------
sgdcplm02 passed
sgdcplm01 passed

Verification of the hosts config file successful

Interface information for node "sgdcplm02"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
em1 10.33.105.64 10.33.104.0 0.0.0.0 10.33.104.1 D0:43:1E:82:99:0E 1500
p4p2 192.168.0.64 192.168.0.0 0.0.0.0 10.33.104.1 B4:96:91:54:6F:B2 1500

Interface information for node "sgdcplm01"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
em1 10.33.105.63 10.33.104.0 0.0.0.0 10.33.104.1 D0:43:1E:82:99:01 1500
p8p2 192.168.0.63 192.168.0.0 0.0.0.0 10.33.104.1 B4:96:91:54:6C:62 1500

Check: Node connectivity of subnet "10.33.104.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
sgdcplm02[10.33.105.64] sgdcplm01[10.33.105.63] yes
Result: Node connectivity passed for subnet "10.33.104.0" with node(s) sgdcplm02,sgdcplm01

Check: TCP connectivity of subnet "10.33.104.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
sgdcplm02 : 10.33.105.64 sgdcplm02 : 10.33.105.64 passed
sgdcplm01 : 10.33.105.63 sgdcplm02 : 10.33.105.64 passed
sgdcplm02 : 10.33.105.64 sgdcplm01 : 10.33.105.63 passed
sgdcplm01 : 10.33.105.63 sgdcplm01 : 10.33.105.63 passed
Result: TCP connectivity check passed for subnet "10.33.104.0"

Check: Node connectivity of subnet "192.168.0.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
sgdcplm02[192.168.0.64] sgdcplm01[192.168.0.63] yes
Result: Node connectivity passed for subnet "192.168.0.0" with node(s) sgdcplm02,sgdcplm01

Check: TCP connectivity of subnet "192.168.0.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
sgdcplm02 : 192.168.0.64 sgdcplm02 : 192.168.0.64 passed
sgdcplm01 : 192.168.0.63 sgdcplm02 : 192.168.0.64 passed
sgdcplm02 : 192.168.0.64 sgdcplm01 : 192.168.0.63 passed
sgdcplm01 : 192.168.0.63 sgdcplm01 : 192.168.0.63 passed
Result: TCP connectivity check passed for subnet "192.168.0.0"

Interfaces found on subnet "10.33.104.0" that are likely candidates for VIP are:
sgdcplm02 em1:10.33.105.64
sgdcplm01 em1:10.33.105.63

Interfaces found on subnet "192.168.0.0" that are likely candidates for a private interconnect are:
sgdcplm02 p4p2:192.168.0.64
sgdcplm01 p8p2:192.168.0.63

WARNING:
Could not find a suitable set of interfaces with the same name for the private interconnect
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "10.33.104.0".
Subnet mask consistency check passed for subnet "192.168.0.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "10.33.104.0" for multicast communication with multicast group "224.0.0.251"...
Check of subnet "10.33.104.0" for multicast communication with multicast group "224.0.0.251" passed.

Check of multicast communication passed.

Verification of node connectivity was successful.
grid@sgdcplm02:/u04/MasterDB/oracle_grid_software/grid>

#########################################################################

grid@srv1:/u01/app/12.1.0/grid/bin> ./cluvfy stage -pre crsinst -n srv1,srv2 -verbose

Performing pre-checks for cluster services setup

Checking node reachability...

Check: Node reachability from node "srv1"
Destination Node Reachable?
------------------------------------ ------------------------
srv1 yes
srv2 yes
Result: Node reachability check passed from node "srv1"

Checking user equivalence...

Check: User equivalence for user "grid"
Node Name Status
------------------------------------ ------------------------
srv2 passed
srv1 passed
Result: User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...
Node Name Status
------------------------------------ ------------------------
srv1 passed
srv2 passed

Verification of the hosts config file successful

Interface information for node "srv1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.56.71 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:45:43:B8 1500
eth0 192.168.56.92 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:45:43:B8 1500
eth0 192.168.56.93 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:45:43:B8 1500
eth0 192.168.56.91 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:45:43:B8 1500
eth0 192.168.56.81 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:45:43:B8 1500
eth1 192.168.10.1 192.168.10.0 0.0.0.0 UNKNOWN 08:00:27:9E:49:9B 1500
eth1 169.254.52.81 169.254.0.0 0.0.0.0 UNKNOWN 08:00:27:9E:49:9B 1500

Interface information for node "srv2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.56.72 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:3B:08:65 1500
eth1 192.168.10.2 192.168.10.0 0.0.0.0 UNKNOWN 08:00:27:6A:EE:84 1500

Check: Node connectivity using interfaces on subnet "192.168.56.0"

Check: Node connectivity of subnet "192.168.56.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv1[192.168.56.81] srv2[192.168.56.72] yes
srv1[192.168.56.81] srv1[192.168.56.93] yes
srv1[192.168.56.81] srv1[192.168.56.71] yes
srv1[192.168.56.81] srv1[192.168.56.92] yes
srv1[192.168.56.81] srv1[192.168.56.91] yes
srv2[192.168.56.72] srv1[192.168.56.93] yes
srv2[192.168.56.72] srv1[192.168.56.71] yes
srv2[192.168.56.72] srv1[192.168.56.92] yes
srv2[192.168.56.72] srv1[192.168.56.91] yes
srv1[192.168.56.93] srv1[192.168.56.71] yes
srv1[192.168.56.93] srv1[192.168.56.92] yes
srv1[192.168.56.93] srv1[192.168.56.91] yes
srv1[192.168.56.71] srv1[192.168.56.92] yes
srv1[192.168.56.71] srv1[192.168.56.91] yes
srv1[192.168.56.92] srv1[192.168.56.91] yes
Result: Node connectivity passed for subnet "192.168.56.0" with node(s) srv1,srv2

Check: TCP connectivity of subnet "192.168.56.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv1 : 192.168.56.81 srv1 : 192.168.56.81 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.91 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.81 srv2 : 192.168.56.72 passed
srv2 : 192.168.56.72 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.93 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.71 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.92 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.91 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.81 srv1 : 192.168.56.93 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.91 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.81 srv1 : 192.168.56.71 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.91 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.81 srv1 : 192.168.56.92 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.91 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.81 srv1 : 192.168.56.91 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.91 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.91 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.91 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.91 passed
srv1 : 192.168.56.91 srv1 : 192.168.56.91 passed
Result: TCP connectivity check passed for subnet "192.168.56.0"

Check: Node connectivity using interfaces on subnet "192.168.10.0"

Check: Node connectivity of subnet "192.168.10.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv1[192.168.10.1] srv2[192.168.10.2] yes
Result: Node connectivity passed for subnet "192.168.10.0" with node(s) srv1,srv2

Check: TCP connectivity of subnet "192.168.10.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv1 : 192.168.10.1 srv1 : 192.168.10.1 passed
srv2 : 192.168.10.2 srv1 : 192.168.10.1 passed
srv1 : 192.168.10.1 srv2 : 192.168.10.2 passed
srv2 : 192.168.10.2 srv2 : 192.168.10.2 passed
Result: TCP connectivity check passed for subnet "192.168.10.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.56.0".
Subnet mask consistency check passed for subnet "192.168.10.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.10.0" for multicast communication with multicast group "224.0.0.251"...
Check of subnet "192.168.10.0" for multicast communication with multicast group "224.0.0.251" passed.

Check of multicast communication passed.

Checking ASMLib configuration.
Node Name Status
------------------------------------ ------------------------
srv1 passed
srv2 passed
Result: Check for ASMLib configuration passed.

Check: Total memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 4.5808GB (4803336.0KB) 4GB (4194304.0KB) passed
srv1 4.5808GB (4803336.0KB) 4GB (4194304.0KB) passed
Result: Total memory check passed

Check: Available memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 4.2556GB (4462276.0KB) 50MB (51200.0KB) passed
srv1 2.321GB (2433712.0KB) 50MB (51200.0KB) passed
Result: Available memory check passed

Check: Swap space
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 2.0059GB (2103292.0KB) 4.5808GB (4803336.0KB) failed
srv1 2.0059GB (2103292.0KB) 4.5808GB (4803336.0KB) failed
Result: Swap space check failed

Check: Free disk space for "srv2:/usr,srv2:/var,srv2:/etc,srv2:/u01/app/12.1.0/grid,srv2:/sbin"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/usr srv2 / 82.2773GB 6.9635GB passed
/var srv2 / 82.2773GB 6.9635GB passed
/etc srv2 / 82.2773GB 6.9635GB passed
/u01/app/12.1.0/grid srv2 / 82.2773GB 6.9635GB passed
/sbin srv2 / 82.2773GB 6.9635GB passed
Result: Free disk space check passed for "srv2:/usr,srv2:/var,srv2:/etc,srv2:/u01/app/12.1.0/grid,srv2:/sbin"

Check: Free disk space for "srv1:/usr,srv1:/var,srv1:/etc,srv1:/u01/app/12.1.0/grid,srv1:/sbin"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/usr srv1 / 3.1484GB 6.9635GB failed
/var srv1 / 3.1484GB 6.9635GB failed
/etc srv1 / 3.1484GB 6.9635GB failed
/u01/app/12.1.0/grid srv1 / 3.1484GB 6.9635GB failed
/sbin srv1 / 3.1484GB 6.9635GB failed
Result: Free disk space check failed for "srv1:/usr,srv1:/var,srv1:/etc,srv1:/u01/app/12.1.0/grid,srv1:/sbin"

Check: Free disk space for "srv2:/tmp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/tmp srv2 /tmp 82.2773GB 1GB passed
Result: Free disk space check passed for "srv2:/tmp"

Check: Free disk space for "srv1:/tmp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/tmp srv1 /tmp 3.1484GB 1GB passed
Result: Free disk space check passed for "srv1:/tmp"

Check: User existence for "grid"
Node Name Status Comment
------------ ------------------------ ------------------------
srv2 passed exists(54323)
srv1 passed exists(54323)

Checking for multiple users with UID value 54323
Result: Check for multiple users with UID value 54323 passed
Result: User existence check passed for "grid"

Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
srv2 passed exists
srv1 passed exists

ERROR:
PRVF-4020 : Inconsistent group IDs found for group "oinstall"
Group ID is "1002" on nodes:srv2
Group ID is "54321" on nodes:srv1
Result: Group existence check failed for "oinstall"

PRVF-4020 : Inconsistent group IDs found for group "oinstall"

PRVF-4020 : Inconsistent group IDs found for group "oinstall" [1002:srv2; 54321:srv1]

PRVF-4020 : Inconsistent group IDs found for group "oinstall" [1002:srv2; 54321:srv1]

Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
srv2 passed exists
srv1 passed exists

ERROR:
PRVF-4020 : Inconsistent group IDs found for group "dba"
Group ID is "1003" on nodes:srv2
Group ID is "503" on nodes:srv1
Result: Group existence check failed for "dba"

PRVF-4020 : Inconsistent group IDs found for group "dba"

PRVF-4020 : Inconsistent group IDs found for group "dba" [1003:srv2; 503:srv1]

PRVF-4020 : Inconsistent group IDs found for group "dba" [1003:srv2; 503:srv1]

Check: Membership of user "grid" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Status
---------------- ------------ ------------ ------------ ------------ ------------
srv2 yes yes yes yes passed
srv1 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
---------------- ------------ ------------ ------------ ----------------
srv2 yes yes no failed
srv1 yes yes yes passed
Result: Membership check for user "grid" in group "dba" failed

Check: Run level
Node Name run level Required Status
------------ ------------------------ ------------------------ ----------
srv2 5 3,5 passed
srv1 5 3,5 passed
Result: Run level check passed

Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
srv2 hard 65536 65536 passed
srv1 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
---------------- ------------ ------------ ------------ ----------------
srv2 soft 1024 1024 passed
srv1 soft 1024 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
---------------- ------------ ------------ ------------ ----------------
srv2 hard 16384 16384 passed
srv1 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
---------------- ------------ ------------ ------------ ----------------
srv2 soft 2047 2047 passed
srv1 soft 2047 2047 passed
Result: Soft limits check passed for "maximum user processes"

Check: System architecture
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 x86_64 x86_64 passed
srv1 x86_64 x86_64 passed
Result: System architecture check passed

Check: Kernel version
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 4.12.14-120-default 3.12.28 passed
srv1 4.12.14-120-default 3.12.28 passed
Result: Kernel version check passed

Check: Kernel parameter for "semmsl"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 250 250 250 passed
srv2 250 250 250 passed
Result: Kernel parameter check passed for "semmsl"

Check: Kernel parameter for "semmns"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 256000 256000 32000 passed
srv2 32000 32000 32000 passed
Result: Kernel parameter check passed for "semmns"

Check: Kernel parameter for "semopm"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 100 100 100 passed
srv2 100 100 100 passed
Result: Kernel parameter check passed for "semopm"

Check: Kernel parameter for "semmni"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 1024 1024 128 passed
srv2 128 128 128 passed
Result: Kernel parameter check passed for "semmni"

Check: Kernel parameter for "shmmax"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 2998804480 2998804480 2459308032 passed
srv2 536870912 536870912 2459308032 failed Current value incorrect. Configured value incorrect.
Result: Kernel parameter check failed for "shmmax"

Check: Kernel parameter for "shmmni"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 4096 4096 4096 passed
srv2 4096 4096 4096 passed
Result: Kernel parameter check passed for "shmmni"

Check: Kernel parameter for "shmall"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 2097152 2097152 480333 passed
srv2 2097152 2097152 480333 passed
Result: Kernel parameter check passed for "shmall"

Check: Kernel parameter for "file-max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 6815744 6815744 6815744 passed
srv2 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
---------------- ------------ ------------ ------------ ------------ ------------
srv1 between 9000 & 65500 between 9000 & 65500 between 9000 & 65535 passed
srv2 between 9000 & 65500 between 9000 & 65500 between 9000 & 65535 passed
Result: Kernel parameter check passed for "ip_local_port_range"

Check: Kernel parameter for "rmem_default"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 4194304 4194304 262144 passed
srv2 4194304 4194304 262144 passed
Result: Kernel parameter check passed for "rmem_default"

Check: Kernel parameter for "rmem_max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 4194304 4194304 4194304 passed
srv2 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
---------------- ------------ ------------ ------------ ------------ ------------
srv1 262144 262144 262144 passed
srv2 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
---------------- ------------ ------------ ------------ ------------ ------------
srv1 1048586 1048586 1048576 passed
srv2 1048586 1048586 1048576 passed
Result: Kernel parameter check passed for "wmem_max"

Check: Kernel parameter for "aio-max-nr"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 1048576 1048576 1048576 passed
srv2 1048576 1048576 1048576 passed
Result: Kernel parameter check passed for "aio-max-nr"

Check: Kernel parameter for "panic_on_oops"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
srv1 1 1 1 passed
srv2 1 unknown 1 failed (ignorable) Configured value incorrect.

PRVG-1206 : Check cannot be performed for configured value of kernel parameter "panic_on_oops" on node "srv2"

Result: Kernel parameter check passed for "panic_on_oops"

Check: Package existence for "make"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 make-4.0-4.1 make-4.0 passed
srv1 make-4.0-4.1 make-4.0 passed
Result: Package existence check passed for "make"

Check: Package existence for "binutils"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 binutils-2.32-9.36.1 binutils-2.24 passed
srv1 binutils-2.32-9.36.1 binutils-2.24 passed
Result: Package existence check passed for "binutils"

Check: Package existence for "gcc-c++(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 missing gcc-c++(x86_64)-4.8 failed
srv1 gcc-c++(x86_64)-4.8-6.189 gcc-c++(x86_64)-4.8 passed
Result: Package existence check failed for "gcc-c++(x86_64)"

Check: Package existence for "libaio1"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libaio1-0.3.109-17.15 libaio1-0.3.109 passed
srv1 libaio1-0.3.109-17.15 libaio1-0.3.109 passed
Result: Package existence check passed for "libaio1"

Check: Package existence for "libaio-devel"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libaio-devel-0.3.109-17.15 libaio-devel-0.3.109 passed
srv1 libaio-devel-0.3.109-17.15 libaio-devel-0.3.109 passed
Result: Package existence check passed for "libaio-devel"

Check: Package existence for "libstdc++6"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libstdc++6-8.2.1+r264010-1.3.3 libstdc++6-4.8.3 passed
srv1 libstdc++6-8.2.1+r264010-1.3.3 libstdc++6-4.8.3 passed
Result: Package existence check passed for "libstdc++6"

Check: Package existence for "sysstat"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 sysstat-12.0.2-10.24.1 sysstat-8.1.5 passed
srv1 sysstat-12.0.2-10.24.1 sysstat-8.1.5 passed
Result: Package existence check passed for "sysstat"

Check: Package existence for "glibc-devel"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 glibc-devel-2.22-100.15.4 glibc-devel-2.19 passed
srv1 glibc-devel-2.22-100.15.4 glibc-devel-2.19 passed
Result: Package existence check passed for "glibc-devel"

Check: Package existence for "glibc"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 glibc-2.22-100.15.4 glibc-2.19 passed
srv1 glibc-2.22-100.15.4 glibc-2.19 passed
Result: Package existence check passed for "glibc"

Check: Package existence for "libcap-ng-utils(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap-ng-utils(x86_64)-0.7.3-4.125 libcap-ng-utils(x86_64)-0.7.3-4.125 passed
srv1 libcap-ng-utils(x86_64)-0.7.3-4.125 libcap-ng-utils(x86_64)-0.7.3-4.125 passed
Result: Package existence check passed for "libcap-ng-utils(x86_64)"

Check: Package existence for "libcap-ng0(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap-ng0(x86_64)-0.7.3-4.125 libcap-ng0(x86_64)-0.7.3-4.125 passed
srv1 libcap-ng0(x86_64)-0.7.3-4.125 libcap-ng0(x86_64)-0.7.3-4.125 passed
Result: Package existence check passed for "libcap-ng0(x86_64)"

Check: Package existence for "libcap-ng0-32bit(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap-ng0-32bit(x86_64)-0.7.3-4.125 libcap-ng0-32bit(x86_64)-0.7.3-4.125 passed
srv1 libcap-ng0-32bit(x86_64)-0.7.3-4.125 libcap-ng0-32bit(x86_64)-0.7.3-4.125 passed
Result: Package existence check passed for "libcap-ng0-32bit(x86_64)"

Check: Package existence for "libcap-progs(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap-progs(x86_64)-2.22-13.1 libcap-progs(x86_64)-2.22-11.709 passed
srv1 libcap-progs(x86_64)-2.22-13.1 libcap-progs(x86_64)-2.22-11.709 passed
Result: Package existence check passed for "libcap-progs(x86_64)"

Check: Package existence for "libcap1(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap1(x86_64)-1.10-61.1 libcap1(x86_64)-1.10-59.61 passed
srv1 libcap1(x86_64)-1.10-61.1 libcap1(x86_64)-1.10-59.61 passed
Result: Package existence check passed for "libcap1(x86_64)"

Check: Package existence for "libcap1-32bit(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap1-32bit(x86_64)-1.10-61.1 libcap1-32bit(x86_64)-1.10-59.61 passed
srv1 libcap1-32bit(x86_64)-1.10-61.1 libcap1-32bit(x86_64)-1.10-59.61 passed
Result: Package existence check passed for "libcap1-32bit(x86_64)"

Check: Package existence for "libcap2(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap2(x86_64)-2.22-13.1 libcap2(x86_64)-2.22-11.709 passed
srv1 libcap2(x86_64)-2.22-13.1 libcap2(x86_64)-2.22-11.709 passed
Result: Package existence check passed for "libcap2(x86_64)"

Check: Package existence for "libcap2-32bit(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libcap2-32bit(x86_64)-2.22-13.1 libcap2-32bit(x86_64)-2.22-11.709 passed
srv1 libcap2-32bit(x86_64)-2.22-13.1 libcap2-32bit(x86_64)-2.22-11.709 passed
Result: Package existence check passed for "libcap2-32bit(x86_64)"

Check: Package existence for "libgcc_s1(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libgcc_s1(x86_64)-8.2.1+r264010-1.3.3 libgcc_s1(x86_64)-4.8.3 passed
srv1 libgcc_s1(x86_64)-8.2.1+r264010-1.3.3 libgcc_s1(x86_64)-4.8.3 passed
Result: Package existence check passed for "libgcc_s1(x86_64)"

Check: Package existence for "libgcc_s1-32bit(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libgcc_s1-32bit(x86_64)-8.2.1+r264010-1.3.3 libgcc_s1-32bit(x86_64)-4.8.3 passed
srv1 libgcc_s1-32bit(x86_64)-8.2.1+r264010-1.3.3 libgcc_s1-32bit(x86_64)-4.8.3 passed
Result: Package existence check passed for "libgcc_s1-32bit(x86_64)"

Check: Package existence for "libXtst6(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libXtst6(x86_64)-1.2.2-7.1 libXtst6(x86_64)-1.2.2 passed
srv1 libXtst6(x86_64)-1.2.2-7.1 libXtst6(x86_64)-1.2.2 passed
Result: Package existence check passed for "libXtst6(x86_64)"

Check: Package existence for "libXtst6-32bit(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 libXtst6-32bit(x86_64)-1.2.2-7.1 libXtst6-32bit(x86_64)-1.2.1 passed
srv1 libXtst6-32bit(x86_64)-1.2.2-7.1 libXtst6-32bit(x86_64)-1.2.1 passed
Result: Package existence check passed for "libXtst6-32bit(x86_64)"

Check: Package existence for "nfs-kernel-server(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 nfs-kernel-server(x86_64)-1.3.0-34.18.1 nfs-kernel-server(x86_64)-1.3.0-6.9 passed
srv1 nfs-kernel-server(x86_64)-1.3.0-34.18.1 nfs-kernel-server(x86_64)-1.3.0-6.9 passed
Result: Package existence check passed for "nfs-kernel-server(x86_64)"

Check: Package existence for "xorg-x11-libs"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
srv2 xorg-x11-libs-7.6-45.14 xorg-x11-libs-7.6-45.14 passed
srv1 xorg-x11-libs-7.6-45.14 xorg-x11-libs-7.6-45.14 passed
Result: Package existence check passed for "xorg-x11-libs"

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
------------------------------------ ------------------------
srv2 passed
srv1 passed

Check for consistency of root user's primary group passed

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

Checking existence of NTP configuration file "/etc/ntp.conf" across nodes
Node Name File exists?
------------------------------------ ------------------------
srv2 no
srv1 yes
PRVG-1019 : The NTP configuration file "/etc/ntp.conf" does not exist on nodes "srv2"
No NTP Daemons or Services were found to be running
PRVF-5507 : NTP daemon or service is not running on any node but NTP configuration file exists on the following node(s):
srv1
Result: Clock synchronization check using Network Time Protocol(NTP) failed

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
------------ ------------------------ ------------------------
srv2 passed does not exist
srv1 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
------------ ------------------------ ------------------------ ----------
srv2 0022 0022 passed
srv1 0022 0022 passed
Result: Default user file creation mask check passed
Checking integrity of file "/etc/resolv.conf" across nodes

PRVG-2002 : Encountered error in copying file "/etc/resolv.conf" from node "srv2" to node "srv1"
protocol error: filename does not match request :failed

Check for integrity of file "/etc/resolv.conf" failed

Check: Time zone consistency
Result: Time zone consistency check passed

Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ...
PRVG-2002 : Encountered error in copying file "/etc/nsswitch.conf" from node "srv2" to node "srv1"
protocol error: filename does not match request :failed
Check for integrity of name service switch configuration file "/etc/nsswitch.conf" failed

Checking daemon "avahi-daemon" is not configured and running

Check: Daemon "avahi-daemon" not configured
Node Name Configured Status
------------ ------------------------ ------------------------
srv2 no passed
srv1 no passed
Daemon not configured check passed for process "avahi-daemon"

Check: Daemon "avahi-daemon" not running
Node Name Running? Status
------------ ------------------------ ------------------------
srv2 no passed
srv1 no passed
Daemon not running check passed for process "avahi-daemon"

Starting check for Network interface bonding status of private interconnect network interfaces ...

Check for Network interface bonding status of private interconnect network interfaces passed

Starting check for /dev/shm mounted as temporary file system ...

Check for /dev/shm mounted as temporary file system passed

Starting check for /boot mount ...

Check for /boot mount passed

Starting check for zeroconf check ...
Parameter LINKLOCAL_INTERFACES is not set.
Parameter LINKLOCAL_INTERFACES is not set.
Parameter LINKLOCAL_INTERFACES is not set.
Parameter LINKLOCAL_INTERFACES is not set.

Check for zeroconf check passed

Pre-check for cluster services setup was unsuccessful on all the nodes.
grid@srv1:/u01/app/12.1.0/grid/bin>

PT : Hints Covered in the Lecture

Optimizer goal

All_rows
First_rows(n)

Table and Index Access Paths

Full
Index
Index_FFS
Index_SS
No_INDEX

Join Order

Ordered
Leading

Joins

USE_NL
USE_HASH
USE_MERGE

SQL Block Name

QB_NAME

Monday 23 September 2019

RAC - cluvfy stage -post crsinst -n all -verbose

[grid@srv2 bin]$ cluvfy stage -post crsinst -n all -verbose

Performing post-checks for cluster services setup

Checking node reachability...

Check: Node reachability from node "srv2"
Destination Node Reachable?
------------------------------------ ------------------------
srv2 yes
srv1 yes
Result: Node reachability check passed from node "srv2"

Checking user equivalence...

Check: User equivalence for user "grid"
Node Name Status
------------------------------------ ------------------------
srv2 passed
srv1 passed
Result: User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...
Node Name Status
------------------------------------ ------------------------
srv2 passed
srv1 passed

Verification of the hosts config file successful

Interface information for node "srv2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.56.72 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:DC:1C:5E 1500
eth0 192.168.56.91 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:DC:1C:5E 1500
eth0 192.168.56.82 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:DC:1C:5E 1500
eth1 192.168.10.2 192.168.10.0 0.0.0.0 UNKNOWN 08:00:27:09:F1:BA 1500
eth1 169.254.106.5 169.254.0.0 0.0.0.0 UNKNOWN 08:00:27:09:F1:BA 1500

Interface information for node "srv1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.56.71 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:9E:23:4A 1500
eth0 192.168.56.81 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:9E:23:4A 1500
eth0 192.168.56.92 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:9E:23:4A 1500
eth0 192.168.56.93 192.168.56.0 0.0.0.0 UNKNOWN 08:00:27:9E:23:4A 1500
eth1 192.168.10.1 192.168.10.0 0.0.0.0 UNKNOWN 08:00:27:16:8C:B3 1500
eth1 169.254.107.17 169.254.0.0 0.0.0.0 UNKNOWN 08:00:27:16:8C:B3 1500

Check: Node connectivity using interfaces on subnet "192.168.56.0"

Check: Node connectivity of subnet "192.168.56.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv1[192.168.56.81] srv1[192.168.56.93] yes
srv1[192.168.56.81] srv2[192.168.56.91] yes
srv1[192.168.56.81] srv2[192.168.56.82] yes
srv1[192.168.56.81] srv2[192.168.56.72] yes
srv1[192.168.56.81] srv1[192.168.56.92] yes
srv1[192.168.56.81] srv1[192.168.56.71] yes
srv1[192.168.56.93] srv2[192.168.56.91] yes
srv1[192.168.56.93] srv2[192.168.56.82] yes
srv1[192.168.56.93] srv2[192.168.56.72] yes
srv1[192.168.56.93] srv1[192.168.56.92] yes
srv1[192.168.56.93] srv1[192.168.56.71] yes
srv2[192.168.56.91] srv2[192.168.56.82] yes
srv2[192.168.56.91] srv2[192.168.56.72] yes
srv2[192.168.56.91] srv1[192.168.56.92] yes
srv2[192.168.56.91] srv1[192.168.56.71] yes
srv2[192.168.56.82] srv2[192.168.56.72] yes
srv2[192.168.56.82] srv1[192.168.56.92] yes
srv2[192.168.56.82] srv1[192.168.56.71] yes
srv2[192.168.56.72] srv1[192.168.56.92] yes
srv2[192.168.56.72] srv1[192.168.56.71] yes
srv1[192.168.56.92] srv1[192.168.56.71] yes
Result: Node connectivity passed for subnet "192.168.56.0" with node(s) srv1,srv2

Check: TCP connectivity of subnet "192.168.56.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv1 : 192.168.56.81 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.81 passed
srv2 : 192.168.56.91 srv1 : 192.168.56.81 passed
srv2 : 192.168.56.82 srv1 : 192.168.56.81 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.81 passed
srv1 : 192.168.56.81 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.93 passed
srv2 : 192.168.56.91 srv1 : 192.168.56.93 passed
srv2 : 192.168.56.82 srv1 : 192.168.56.93 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.93 passed
srv1 : 192.168.56.81 srv2 : 192.168.56.91 passed
srv1 : 192.168.56.93 srv2 : 192.168.56.91 passed
srv2 : 192.168.56.91 srv2 : 192.168.56.91 passed
srv2 : 192.168.56.82 srv2 : 192.168.56.91 passed
srv2 : 192.168.56.72 srv2 : 192.168.56.91 passed
srv1 : 192.168.56.92 srv2 : 192.168.56.91 passed
srv1 : 192.168.56.71 srv2 : 192.168.56.91 passed
srv1 : 192.168.56.81 srv2 : 192.168.56.82 passed
srv1 : 192.168.56.93 srv2 : 192.168.56.82 passed
srv2 : 192.168.56.91 srv2 : 192.168.56.82 passed
srv2 : 192.168.56.82 srv2 : 192.168.56.82 passed
srv2 : 192.168.56.72 srv2 : 192.168.56.82 passed
srv1 : 192.168.56.92 srv2 : 192.168.56.82 passed
srv1 : 192.168.56.71 srv2 : 192.168.56.82 passed
srv1 : 192.168.56.81 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.93 srv2 : 192.168.56.72 passed
srv2 : 192.168.56.91 srv2 : 192.168.56.72 passed
srv2 : 192.168.56.82 srv2 : 192.168.56.72 passed
srv2 : 192.168.56.72 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.92 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.71 srv2 : 192.168.56.72 passed
srv1 : 192.168.56.81 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.92 passed
srv2 : 192.168.56.91 srv1 : 192.168.56.92 passed
srv2 : 192.168.56.82 srv1 : 192.168.56.92 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.92 passed
srv1 : 192.168.56.81 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.93 srv1 : 192.168.56.71 passed
srv2 : 192.168.56.91 srv1 : 192.168.56.71 passed
srv2 : 192.168.56.82 srv1 : 192.168.56.71 passed
srv2 : 192.168.56.72 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.92 srv1 : 192.168.56.71 passed
srv1 : 192.168.56.71 srv1 : 192.168.56.71 passed
Result: TCP connectivity check passed for subnet "192.168.56.0"

Check: Node connectivity using interfaces on subnet "192.168.10.0"

Check: Node connectivity of subnet "192.168.10.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv2[192.168.10.2] srv1[192.168.10.1] yes
Result: Node connectivity passed for subnet "192.168.10.0" with node(s) srv2,srv1

Check: TCP connectivity of subnet "192.168.10.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
srv2 : 192.168.10.2 srv2 : 192.168.10.2 passed
srv1 : 192.168.10.1 srv2 : 192.168.10.2 passed
srv2 : 192.168.10.2 srv1 : 192.168.10.1 passed
srv1 : 192.168.10.1 srv1 : 192.168.10.1 passed
Result: TCP connectivity check passed for subnet "192.168.10.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.56.0".
Subnet mask consistency check passed for subnet "192.168.10.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.10.0" for multicast communication with multicast group "224.0.0.251"...
Check of subnet "192.168.10.0" for multicast communication with multicast group "224.0.0.251" passed.

Check of multicast communication passed.

Checking whether the ASM filter driver is active and consistent on all nodes
Result: ASM filter driver library is not installed on any of the cluster nodes.
Result: ASM filter driver configuration was found consistent across all the cluster nodes.
Check: Time zone consistency
Result: Time zone consistency check passed

Checking Cluster manager integrity...

Checking CSS daemon...

Node Name Status
------------------------------------ ------------------------
srv2 running
srv1 running

Oracle Cluster Synchronization Services appear to be online.

Cluster manager integrity check passed

UDev attributes check for OCR locations started...
Result: UDev attributes check passed for OCR locations

UDev attributes check for Voting Disk locations started...
Result: UDev attributes check passed for Voting Disk locations

Check default user file creation mask
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
srv2 0022 0022 passed
srv1 0022 0022 passed
Result: Default user file creation mask check passed

Checking cluster integrity...

Node Name
------------------------------------
srv1
srv2

Cluster integrity check passed

Checking OCR integrity...

Checking the absence of a non-clustered configuration...
All nodes free of non-clustered, local-only configurations

Checking daemon liveness...

Check: Liveness for "CRS daemon"
Node Name Running?
------------------------------------ ------------------------
srv2 yes
srv1 yes
Result: Liveness check passed for "CRS daemon"

Checking OCR config file "/etc/oracle/ocr.loc"...

OCR config file "/etc/oracle/ocr.loc" check successful

Disk group for ocr location "+CRS/rac/OCRFILE/registry.255.1019754845" is available on all the nodes

Checking OCR dump functionality

OCR dump check passed

NOTE:
This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

OCR integrity check passed

Checking CRS integrity...

Clusterware version consistency passed.
The Oracle Clusterware is healthy on node "srv2"
The Oracle Clusterware is healthy on node "srv1"

CRS integrity check passed

Checking node application existence...

Checking existence of VIP node application (required)
Node Name Required Running? Comment
------------ ------------------------ ------------------------ ----------
srv2 yes yes passed
srv1 yes yes passed
VIP node application check passed

Checking existence of NETWORK node application (required)
Node Name Required Running? Comment
------------ ------------------------ ------------------------ ----------
srv2 yes yes passed
srv1 yes yes passed
NETWORK node application check passed

Checking existence of ONS node application (optional)
Node Name Required Running? Comment
------------ ------------------------ ------------------------ ----------
srv2 no yes passed
srv1 no yes passed
ONS node application check passed

Checking Single Client Access Name (SCAN)...
SCAN Name Node Running? ListenerName Port Running?
---------------- ------------ ------------ ------------ ------------ ------------
srv-scan srv2 true LISTENER_SCAN1 1521 true
srv-scan srv1 true LISTENER_SCAN2 1521 true
srv-scan srv1 true LISTENER_SCAN3 1521 true

Checking TCP connectivity to SCAN listeners...
Node ListenerName TCP connectivity?
------------ ------------------------ ------------------------
srv2 LISTENER_SCAN1 yes
srv2 LISTENER_SCAN2 yes
srv2 LISTENER_SCAN3 yes
TCP connectivity to SCAN listeners exists on all cluster nodes

Checking name resolution setup for "srv-scan"...

Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ...
Checking if "hosts" entry in file "/etc/nsswitch.conf" is consistent across nodes...
Checking file "/etc/nsswitch.conf" to make sure that only one "hosts" entry is defined
More than one "hosts" entry does not exist in any "/etc/nsswitch.conf" file
All nodes have same "hosts" entry defined in file "/etc/nsswitch.conf"
Check for integrity of name service switch configuration file "/etc/nsswitch.conf" passed

SCAN Name IP Address Status Comment
------------ ------------------------ ------------------------ ----------
srv-scan 192.168.56.91 passed
srv-scan 192.168.56.93 passed
srv-scan 192.168.56.92 passed

Checking SCAN IP addresses...
Check of SCAN IP addresses passed

Verification of SCAN VIP and listener setup passed

Checking OLR integrity...
Check of existence of OLR configuration file "/etc/oracle/olr.loc" passed
Check of attributes of OLR configuration file "/etc/oracle/olr.loc" passed

WARNING:
This check does not verify the integrity of the OLR contents. Execute 'ocrcheck -local' as a privileged user to verify the contents of OLR.

OLR integrity check passed

Checking Oracle Cluster Voting Disk configuration...

Oracle Cluster Voting Disk configuration check passed

Checking to make sure user "grid" is not in "root" group
Node Name Status Comment
------------ ------------------------ ------------------------
srv2 passed does not exist
srv1 passed does not exist
Result: User "grid" is not part of "root" group. Check passed

Checking if Clusterware is installed on all nodes...
Oracle Clusterware is installed on all nodes.

Checking if CTSS Resource is running on all nodes...
Check: CTSS Resource running on all nodes
Node Name Status
------------------------------------ ------------------------
srv2 passed
srv1 passed
CTSS resource check passed

Querying CTSS for time offset on all nodes...
Query of CTSS for time offset passed

Check CTSS state started...
Check: CTSS state
Node Name State
------------------------------------ ------------------------
srv2 Active
srv1 Active
CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
Reference Time Offset Limit: 1000.0 msecs
Check: Reference Time Offset
Node Name Time Offset Status
------------ ------------------------ ------------------------
srv2 0.0 passed
srv1 0.0 passed

Time offset is within the specified limits on the following set of nodes:
"[srv2, srv1]"
Result: Check of clock time offsets passed

Oracle Cluster Time Synchronization Services check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.

Post-check for cluster services setup was successful.
[grid@srv2 bin]$

HOME

Wednesday 23 October 2019

RAC - Node connectivity check commands./runcluvfy.sh comp nodecon -n rac1,rac2 -verbose

PT : Hints Covered in the Lecture

Monday 23 September 2019

RAC - cluvfy stage -post crsinst -n all -verbose