Jul 13, 2015

Cluster health check in Oracle 11gR2

$ cluvfy comp clu

Output :

$ cluvfy comp clu

Verifying cluster integrity

Checking cluster integrity...

Cluster integrity check passed

Verification of cluster integrity was successful.


 -- After creating cluster/ before creating database in cluster / after upgrading cluster:

$ cluvfy stage -post crsinst -n host1,host2 -verbose

output:


Performing post-checks for cluster services setup

Checking node reachability...

Check: Node reachability from node "eddb3"
  Destination Node                      Reachable?             
  ------------------------------------  ------------------------
  eddb3                                 yes                    
  eddb4                                 yes                    
Result: Node reachability check passed from node "eddb3"


Checking user equivalence...

Check: User equivalence for user "grid"
  Node Name                             Status                 
  ------------------------------------  ------------------------
  eddb4                                 passed                 
  eddb3                                 passed                 
Result: User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...
  Node Name                             Status                 
  ------------------------------------  ------------------------
  eddb4                                 passed                 
  eddb3                                 passed                 

Verification of the hosts config file successful


Interface information for node "eddb4"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 en0    10.10.8.33      10.10.0.0       10.10.8.33      10.10.10.30     CE:1C:47:44:EA:06 1500 
 en0    10.10.8.33      10.10.0.0       10.10.8.33      10.10.10.30     CE:1C:47:44:EA:06 1500 
 en0    10.10.8.33      10.10.0.0       10.10.8.33      10.10.10.30     CE:1C:47:44:EA:06 1500 
 en1    1.1.1.83        1.1.1.0         1.1.1.83        10.10.10.30     CE:1C:47:44:EA:07 1500 
 en1    1.1.1.83        1.1.1.0         1.1.1.83        10.10.10.30     CE:1C:47:44:EA:07 1500 


Interface information for node "eddb3"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 en0    10.10.8.31      10.10.0.0       10.10.8.31      10.10.10.30     3E:F4:C1:6D:C7:06 1500 
 en0    10.10.8.31      10.10.0.0       10.10.8.31      10.10.10.30     3E:F4:C1:6D:C7:06 1500 
 en0    10.10.8.31      10.10.0.0       10.10.8.31      10.10.10.30     3E:F4:C1:6D:C7:06 1500 
 en0    10.10.8.31      10.10.0.0       10.10.8.31      10.10.10.30     3E:F4:C1:6D:C7:06 1500 
 en1    1.1.1.82        1.1.1.0         1.1.1.82        10.10.10.30     3E:F4:C1:6D:C7:07 1500 
 en1    1.1.1.82        1.1.1.0         1.1.1.82        10.10.10.30     3E:F4:C1:6D:C7:07 1500 


Check: Node connectivity for interface "en0"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  eddb4[10.10.8.33]               eddb4[10.10.8.33]               yes            
  eddb4[10.10.8.33]               eddb4[10.10.8.33]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb4[10.10.8.33]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb4[10.10.8.33]               eddb3[10.10.8.31]               yes            
  eddb3[10.10.8.31]               eddb3[10.10.8.31]               yes            
  eddb3[10.10.8.31]               eddb3[10.10.8.31]               yes            
  eddb3[10.10.8.31]               eddb3[10.10.8.31]               yes            
  eddb3[10.10.8.31]               eddb3[10.10.8.31]               yes            
  eddb3[10.10.8.31]               eddb3[10.10.8.31]               yes            
  eddb3[10.10.8.31]               eddb3[10.10.8.31]               yes            
Result: Node connectivity passed for interface "en0"


Check: TCP connectivity of subnet "10.10.0.0"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  eddb3:10.10.8.31                eddb4:10.10.8.33                passed         
Result: TCP connectivity check passed for subnet "10.10.0.0"


Check: Node connectivity for interface "en1"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  eddb4[1.1.1.83]                 eddb4[1.1.1.83]                 yes            
  eddb4[1.1.1.83]                 eddb3[1.1.1.82]                 yes            
  eddb4[1.1.1.83]                 eddb3[1.1.1.82]                 yes            
  eddb4[1.1.1.83]                 eddb3[1.1.1.82]                 yes            
  eddb4[1.1.1.83]                 eddb3[1.1.1.82]                 yes            
  eddb3[1.1.1.82]                 eddb3[1.1.1.82]                 yes            
Result: Node connectivity passed for interface "en1"


Check: TCP connectivity of subnet "1.1.1.0"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  eddb3:1.1.1.82                  eddb4:1.1.1.83                  passed         
Result: TCP connectivity check passed for subnet "1.1.1.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "10.10.0.0".
Subnet mask consistency check passed for subnet "1.1.1.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

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

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

Check of multicast communication passed.
Check: Time zone consistency
Result: Time zone consistency check passed

Checking Oracle Cluster Voting Disk configuration...

ASM Running check passed. ASM is running on all specified nodes

Oracle Cluster Voting Disk configuration check passed

Checking Cluster manager integrity...


Checking CSS daemon...

  Node Name                             Status                 
  ------------------------------------  ------------------------
  eddb4                                 running                
  eddb3                                 running                

Oracle Cluster Synchronization Services appear to be online.

Cluster manager integrity check passed


Check default user file creation mask
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  eddb4         022                       0022                      passed   
  eddb3         022                       0022                      passed   
Result: Default user file creation mask check passed

Checking cluster integrity...

  Node Name                          
  ------------------------------------
  eddb3                              
  eddb4                              

Cluster integrity check passed


Checking OCR integrity...

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


ASM Running check passed. ASM is running on all specified nodes

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

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


Disk group for ocr location "+CRS" available on all the nodes


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 "eddb4"
The Oracle Clusterware is healthy on node "eddb3"

CRS integrity check passed

Checking node application existence...

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

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

Checking existence of GSD node application (optional)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  eddb4         no                        no                        exists   
  eddb3         no                        no                        exists   
GSD node application is offline on nodes "eddb4,eddb3"

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


Checking Single Client Access Name (SCAN)...
  SCAN Name         Node          Running?      ListenerName  Port          Running?   
  ----------------  ------------  ------------  ------------  ------------  ------------
  imcl-scan-cluster  eddb4         true          LISTENER_SCAN1  1521          true       
  imcl-scan-cluster  eddb3         true          LISTENER_SCAN2  1521          true       
  imcl-scan-cluster  eddb3         true          LISTENER_SCAN3  1521          true       

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

Checking name resolution setup for "imcl-scan-cluster"...

Checking integrity of name service switch configuration file "/etc/netsvc.conf" ...
Checking if "hosts" entry in file "/etc/netsvc.conf" is consistent across nodes...
"hosts" entry does not exist in any "/etc/netsvc.conf" file
Check for integrity of name service switch configuration file "/etc/netsvc.conf" passed

  SCAN Name     IP Address                Status                    Comment  
  ------------  ------------------------  ------------------------  ----------
  imcl-scan-cluster  10.10.8.38                passed                             
  imcl-scan-cluster  10.10.8.37                passed                             
  imcl-scan-cluster  10.10.8.39                passed                             

Verification of SCAN VIP and Listener setup passed

Checking OLR integrity...

Checking OLR config file...

OLR config file check successful


Checking OLR file attributes...

OLR file check successful


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
OCR detected on ASM. Running ACFS Integrity checks...

Starting check to see if ASM is running on all cluster nodes...

ASM Running check passed. ASM is running on all specified nodes

Starting Disk Groups check to see if at least one Disk Group configured...
Disk Group Check passed. At least one Disk Group configured

Task ACFS Integrity check passed

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

Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed

Checking if CTSS Resource is running on all nodes...
Check: CTSS Resource running on all nodes
  Node Name                             Status                 
  ------------------------------------  ------------------------
  eddb4                                 passed                 
  eddb3                                 passed                 
Result: CTSS resource check passed


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

Check CTSS state started...
Check: CTSS state
  Node Name                             State                  
  ------------------------------------  ------------------------
  eddb4                                 Active                 
  eddb3                                 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                 
  ------------  ------------------------  ------------------------
  eddb4         0.0                       passed                 
  eddb3         0.0                       passed                 

Time offset is within the specified limits on the following set of nodes:
"[eddb4, eddb3]"
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. 

Note : eddb3 is the hostname for node1 and eddb4 is the host name for node2.

You can install ORAcheck from metalink and verify the entire database/ cluster setting details.





1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete

Translate >>