Wednesday 23 October 2019

RAC - Check Cluster Time Synchronization Service crsctl check ctss



grid@sgdcplm01:~> crsctl check ctss
CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0
grid@sgdcplm01:~> cluvfy comp clocksync

Verifying Clock Synchronization across the cluster nodes
Oracle Clusterware is installed on all nodes.
CTSS resource check passed
Query of CTSS for time offset passed

CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
Check of clock time offsets passed


Oracle Cluster Time Synchronization Services check passed

Verification of Clock Synchronization across the cluster nodes was successful.
grid@sgdcplm01:~> cluvfy comp clocksync -verbose

Verifying Clock Synchronization across the cluster nodes

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
  ------------------------------------  ------------------------
  sgdcplm01                             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
  ------------------------------------  ------------------------
  sgdcplm01                             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
  ------------  ------------------------  ------------------------
  sgdcplm01     0.0                       passed

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


Oracle Cluster Time Synchronization Services check passed

Verification of Clock Synchronization across the cluster nodes was successful.
grid@sgdcplm01:~>

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