Tuesday, 18 October 2011

Installation Of Grid Structure For Linux

Install the Grid Infrastructure

Make sure both virtual machines are started, then login to "ol6-112-rac1" as the oracle user and start the Oracle installer.
$ cd /host/software/oracle/11gR2/11.2.0.3.0/linux64_grid
$ ./runInstaller
Select the "Skip software updates" option, then click the "Next" button.







 
Click the "SSH Connectivity..." button and enter the password for the "oracle" user. Click the "Setup" button to to configure SSH connectivity, and the "Test" button to test it once it is complete.


 
Click the "Identify network interfaces..." button and check the public and private networks are specified correctly. Once you are happy with them, click the "OK" button and the "Next" button on the previous screen.

 
Set the redundancy to "External", click the "Change Discovery Path" button and set the path to "/dev/asm*". Return the main screen and select all 4 disks and click the "Next" button.







 
The output from the "orainstRoot.sh" file should look something like that listed below.
# cd /u01/app/oraInventory
# ./orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
 
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
#
The output of the root.sh will vary a little depending on the node it is run on. Example output can be seen here (Node1, Node2).
Once the scripts have completed, return to the "Execute Configuration Scripts" screen on "rac1" and click the "OK" button.

 
We expect the verification phase to fail with an error relating to the SCAN, assuming you are not using DNS.
INFO: Checking Single Client Access Name (SCAN)...
INFO: Checking name resolution setup for "rac-scan.localdomain"...
INFO: ERROR:
INFO: PRVF-4664 : Found inconsistent name resolution entries for SCAN name "rac-scan.localdomain"
INFO: ERROR:
INFO: PRVF-4657 : Name resolution setup check for "rac-scan.localdomain" (IP address: 192.168.2.201) failed
INFO: ERROR:
INFO: PRVF-4664 : Found inconsistent name resolution entries for SCAN name "rac-scan.localdomain"
INFO: Verification of SCAN VIP and Listener setup failed
Provided this is the only error, it is safe to ignore this and continue by clicking the "Next" button.
Click the "Close" button to exit the installer.
 
The grid infrastructure installation is now complete.

Install the Database

Make sure the "ol6-112-rac1" and "ol6-112-rac2" virtual machines are started, then login to "ol6-112-rac1" as the oracle user and start the Oracle installer.
$ cd /host/software/oracle/11gR2/11.2.0.3.0/linux64_database
$ ./runInstaller
Uncheck the security updates checkbox and click the "Next" button and "Yes" on the subsequent warning dialog.




 
Enter "/u01/app/oracle/product/11.2.0/db_1" for the software location. The storage type should be set to "Automatic Storage Manager". Enter the appropriate passwords and database name, in this case "RAC.localdomain".






 
The RAC database creation is now complete.

Check the Status of the RAC

There are several ways to check the status of the RAC. The srvctl utility shows the current configuration and status of the RAC database.
$ srvctl config database -d RAC
Database unique name: RAC
Database name: RAC
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/RAC/spfileRAC.ora
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RAC
Database instances: RAC2,RAC1
Disk Groups: DATA
Mount point paths: 
Services: 
Type: RAC
Database is administrator managed
$
 
$ srvctl status database -d RAC
Instance RAC1 is running on node ol6-112-rac1
Instance RAC2 is running on node ol6-112-rac2
$
The V$ACTIVE_INSTANCES view can also display the current status of the instances.
$ sqlplus / as sysdba
 
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 27 22:20:14 2011
 
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
 
SQL> SELECT inst_name FROM v$active_instances;
 
INST_NAME
--------------------------------------------------------------------------------
ol6-112-rac1.localdomain:RAC1
ol6-112-rac2.localdomain:RAC2
 
SQL>
If you have configured Enterprise Manager, it can be used to view the configuration and current status of the database using a URL like "https://ol6-112-rac1.localdomain:1158/em".