Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Sunday, February 05, 2012

RDBMS Software Install -RAC 11g

Prior to installing the Database Software (RDBMS) it is highly recommended to run the cluster verification
utility (CLUVFY) to verify that Grid Infrastructure has been properly installed and the cluster nodes have

been properly configured to support the Database Software installation. In order to achieve this CLUVFY
must be run in pre dbinst mode. The following outlines how to achieve this task:
cmd> runcluvfy stage -pre dbinst -n -verbose

cluvfy stage -pre dbinst -n OR-11,OR-12 -verbose > c:\temp\dbinst.txt

Performing pre-checks for database installation

Checking node reachability...

Check: Node reachability from node "OR-11"
  Destination Node                      Reachable?             
  ------------------------------------  ------------------------
  OR-11                         yes                    
  OR-12                         yes                    
Result: Node reachability check passed from node "OR-11"


Checking user equivalence...

Check: User equivalence for user "Inam"
  Node Name                             Comment                
  ------------------------------------  ------------------------
  OR-12                         passed                 
  OR-11                         passed                 
Result: User equivalence check passed for user "Inam"

Checking node connectivity...


Interface information for node "OR-12"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 public 192.168.26.12   192.168.26.0    On-link         UNKNOWN         00:1A:A0:34:91:0A 1500 
 public 192.168.26.14   192.168.26.0    On-link         UNKNOWN         00:1A:A0:34:91:0A 1500 
 public 192.168.26.66   192.168.26.0    On-link         UNKNOWN         00:1A:A0:34:91:0A 1500 
 private 10.11.11.2      10.11.11.0      On-link         UNKNOWN         00:1A:A0:34:91:0C 1500 


Interface information for node "OR-11"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU  
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 public 192.168.26.11   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 public 192.168.26.13   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 public 192.168.26.64   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 public 192.168.26.65   192.168.26.0    On-link         UNKNOWN         00:1D:09:0C:B4:CD 1500 
 private 10.11.11.1      10.11.11.0      On-link         UNKNOWN         00:1D:09:0C:B4:CF 1500 


Check: Node connectivity for interface "public"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  OR-12[192.168.26.12]    OR-12[192.168.26.14]    yes            
  OR-12[192.168.26.12]    OR-12[192.168.26.66]    yes            
  OR-12[192.168.26.12]    OR-11[192.168.26.11]    yes            
  OR-12[192.168.26.12]    OR-11[192.168.26.13]    yes            
  OR-12[192.168.26.12]    OR-11[192.168.26.64]    yes            
  OR-12[192.168.26.12]    OR-11[192.168.26.65]    yes            
  OR-12[192.168.26.14]    OR-12[192.168.26.66]    yes            
  OR-12[192.168.26.14]    OR-11[192.168.26.11]    yes            
  OR-12[192.168.26.14]    OR-11[192.168.26.13]    yes            
  OR-12[192.168.26.14]    OR-11[192.168.26.64]    yes            
  OR-12[192.168.26.14]    OR-11[192.168.26.65]    yes            
  OR-12[192.168.26.66]    OR-11[192.168.26.11]    yes            
  OR-12[192.168.26.66]    OR-11[192.168.26.13]    yes            
  OR-12[192.168.26.66]    OR-11[192.168.26.64]    yes            
  OR-12[192.168.26.66]    OR-11[192.168.26.65]    yes            
  OR-11[192.168.26.11]    OR-11[192.168.26.13]    yes            
  OR-11[192.168.26.11]    OR-11[192.168.26.64]    yes            
  OR-11[192.168.26.11]    OR-11[192.168.26.65]    yes            
  OR-11[192.168.26.13]    OR-11[192.168.26.64]    yes            
  OR-11[192.168.26.13]    OR-11[192.168.26.65]    yes            
  OR-11[192.168.26.64]    OR-11[192.168.26.65]    yes            
Result: Node connectivity passed for interface "public"

Check: Node connectivity for interface "private"
  Source                          Destination                     Connected?     
  ------------------------------  ------------------------------  ----------------
  OR-12[10.11.11.2]       OR-11[10.11.11.1]       yes            
Result: Node connectivity passed for interface "private"

Result: Node connectivity check passed


Check: Total memory
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  OR-12  15.9951GB (1.6772032E7KB)  922MB (944128.0KB)        passed   
  OR-11  15.9951GB (1.6772032E7KB)  922MB (944128.0KB)        passed   
Result: Total memory check passed

Check: Available memory
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  OR-12  13.7993GB (1.4469632E7KB)  50MB (51200.0KB)          passed   
  OR-11  13.659GB (1.4322496E7KB)  50MB (51200.0KB)          passed   
Result: Available memory check passed

Check: Swap space
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  OR-12  31.9883GB (3.3542216E7KB)  15.9951GB (1.6772032E7KB)  passed   
  OR-11  31.9883GB (3.3542216E7KB)  15.9951GB (1.6772032E7KB)  passed   
Result: Swap space check passed

Check: Free disk space for "OR-12:C:\Windows\temp"
  Path              Node Name     Mount point   Available     Required      Comment    
  ----------------  ------------  ------------  ------------  ------------  ------------
  C:\Windows\temp   OR-12  C             36.0027GB     500MB         passed     
Result: Free disk space check passed for "OR-12:C:\Windows\temp"

Check: Free disk space for "OR-11:C:\Windows\temp"
  Path              Node Name     Mount point   Available     Required      Comment    
  ----------------  ------------  ------------  ------------  ------------  ------------
  C:\Windows\temp   OR-11  C             42.5386GB     500MB         passed     
Result: Free disk space check passed for "OR-11:C:\Windows\temp"

Check: System architecture
  Node Name     Available                 Required                  Comment  
  ------------  ------------------------  ------------------------  ----------
  OR-12  64-bit                    64-bit                    passed   
  OR-11  64-bit                    64-bit                    passed   
Result: System architecture check passed

Checking length of value of environment variable "PATH"
Check: Length of value of environment variable "PATH"
  Node Name         Set?          Maximum Length  Actual Length  Comment        
  ----------------  ------------  ------------  ------------  ----------------
  OR-12     yes           1023          359           passed         
  OR-11     yes           1023          368           passed         
Result: Check for length of value of environment variable "PATH" passed.

Checking for Media Sensing status of TCP/IP
  Node Name     Enabled?                  Comment                
  ------------  ------------------------  ------------------------
  OR-12  no                        passed                 
  OR-11  no                        passed                 
Result: Media Sensing status of TCP/IP check passed

Checking CRS integrity...
The Oracle Clusterware is healthy on node "OR-12"
The Oracle Clusterware is healthy on node "OR-11"

CRS integrity check passed

Checking Cluster manager integrity...


Checking CSS daemon...

  Node Name                             Status                 
  ------------------------------------  ------------------------
  OR-12                         running                
  OR-11                         running                

Oracle Cluster Synchronization Services appear to be online.

Cluster manager integrity check passed


Checking node application existence...

Checking existence of VIP node application (required)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  OR-12  yes                       yes                       passed   
  OR-11  yes                       yes                       passed   
VIP node application check passed

Checking existence of NETWORK node application (required)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  OR-12  yes                       yes                       passed   
  OR-11  yes                       yes                       passed   
NETWORK node application check passed

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

Checking existence of ONS node application (optional)
  Node Name     Required                  Running?                  Comment  
  ------------  ------------------------  ------------------------  ----------
  OR-12  no                        yes                       passed   
  OR-11  no                        yes                       passed   
ONS node application 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                 
  ------------------------------------  ------------------------
  OR-12                         passed                 
  OR-11                         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                  
  ------------------------------------  ------------------------
  OR-12                         Observer               
  OR-11                         Observer               
CTSS is in Observer state. Switching over to clock synchronization checks using NTP


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

Checking daemon liveness...

Check: Liveness for "W32Time"
  Node Name                             Running?               
  ------------------------------------  ------------------------
  OR-12                         yes                    
  OR-11                         yes                    
Result: Liveness check passed for "W32Time"
Check for NTP daemon or service alive passed on all nodes

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


Oracle Cluster Time Synchronization Services check passed
Check: Time zone consistency
Result: Time zone consistency check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability

Checking for status of Automount feature
  Node Name     Enabled?                  Comment                
  ------------  ------------------------  ------------------------
  OR-12  yes                       passed                 
  OR-11  yes                       passed                 
Result: Check for status of Automount feature passed

Pre-check for database installation was successful.

  • Start the OUI by running the setup.exe command as the Local Administrator user from the DB
    directory of the Oracle Database 11g Release 2 (11.2.0.1) installation media and click next to begin
    the installation process.
  • If using the DVD installation media (from edelivery.oracle.com) the first screen to appear will be the
    Select a Product to Install screen. Choose Oracle Database 11g and click next to continue. If the OTN
    media is used the RDBMS/ASM and Clusterware are separate downloads and the first screen to be
    displayed will be Installation Type screen
  • The first OUI screen will prompt for an email address to allow you to be notified of security issues
    and to enable Oracle Configuration Manager. If you wish NOT to be notified or not to use Oracle
    Configuration Manager leave the email box blank and uncheck the check box. After entering the
    desired information click Next to continue.

 Choose Install database software only on the Select Installation Option screen and click Next to continue.


On the Grid Installation Options screen, choose Real Application Clusters database installation and select ALL nodes for the software installation. Click Next to continue.
 
Choose the appropriate language on the Select Product Languages screen and click Next to continue.

 On the Select Database Edition screen choose Enterprise Edition and click Next to continue.
 NOTE
If there is a need for specific database options to be installed or not installed, these options can be chosen by clicking the Select Options button.



 Specify the location for Oracle Base (e.g. d:\app\oracle) and the database software installation (e.g.
d:\app\oracle\product\11.2.0\db_1) on the Specify Installation Location screen. Click Next to allow the OUI to perform the prerequisite checks on the target nodes.
NOTE
It is recommended that the same Oracle Base location is used for the database installation that was used for the Grid Infrastructure installation.

After the prerequisite checks have successfully completed, review the summary of the pending installation and click Finish to install the database software.




On the Finish screen click Close to exit the OUI.



No comments: