Saturday , November 25 2017
Home / Oracle DBA / How to install Oracle 11g Grid Infrastructure software and step by step process for ASM configuration

How to install Oracle 11g Grid Infrastructure software and step by step process for ASM configuration

Tools and Software’s used for this Demonstration:

VMware Workstation 10.0

Oracle Enterprise Linux 6.0 (64-Bit)

Oracle Grid Infrastructure software 11.2.0.1 (64-Bit)

Oracle Database software 11.2.0.1 (64-Bit)

 

Step 1:  Install prerequisites packages for Oracle Database. You can get them from link  as per your operation system version.

 

yum -y install binutils-2.20.51.0.2-5.11.el6 compat-libcap1-1.10-1 compat-libstdc++-33-3.2.3-69.el6 compat-libstdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6 gcc-c++-4.4.4-13.el6 glibc-2.12-1.7.el6 glibc-2.12-1.7.el6 glibc-devel-2.12-1.7.el6 glibc-devel-2.12-1.7.el6.i686 ksh libgcc-4.4.4-13.el6 libgcc-4.4.4-13.el6 libstdc++-4.4.4-13.el6 libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6 libstdc++-devel-4.4.4-13.el6.i686 libaio-0.3.107-10.el6 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 libaio-devel-0.3.107-10.el6.i686 make-3.81-19.el6 sysstat-9.0.4-11.el6

 

 

Step 2: Setup ASM prerequisites packages for ORACLE LINUX. You can download these rpms  from http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html according to your system properties.

I have downloaded below rpm’s for 64-bit linux operating system.

Now, execute these packages:

Step 3: Add following groups for installation of oracle software and ASM.

 
groupadd -g 1001 oinstall
groupadd -g 1002 dba
groupadd -g 1003 oper
groupadd -g 1004 asmdba
groupadd -g 1005 asmadmin
groupadd -g 1006 asmoper

Step 4: Add following users and set passwords.

 
useradd -u 1101 -g oinstall -G dba,oper,asmdba oracle

passwd oracle

useradd -u 1102 -g oinstall -G dba,asmoper,asmdba,asmadmin grid

passwd grid

Step 5: Create oracle home and grid home locations and provide permissions.

 

mkdir -p /u01/app/oracle/product/11.2.0/dhome_1

mkdir -p /u01/app/grid/product/11.2.0/grid

chown -R oracle:oinstall /u01/

chown -R grid:oinstall /u01/app/grid/product/11.2.0/grid

chmod -R 775 /u01

Step 6: Create bash_profile for both users.

Oracle User

 
export oracle_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin

Grid User

 
export oracle_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
export PATH=$PATH:$ORACLE_HOME/bin

Step 7: Now, we need to add 3 additional hard disks in VM ware to allocate disks to ASM diskgroup. Following below step to add hard disks in VMWare.

==> Go to VMWare machine settings and select “Hard Disk(SCSI)” and press add button

==> Select “Hard Disk” and press Next.

==> Select “SCSI” and press Next.

==> Select “Create New Virtual Disk” and press Next.

==> Select disk size as per your requirement (I have selected 10GB) and select “Store virtual disk on a single file option” and press Next.

==> Press Finish. You will see that the additional disk is added to the properties.

NOTE: Similarly add two more hard disks and reboot the machine to mount the new hard disks.

 

Step 8: Press “fdisk –l” command to see the available disks. You can see below that sdb, sdc and sdd disks are added.


[root@localhost Desktop]# fdisk -l

Disk /dev/sda: 32.2 GB, 32212254720 bytes

255 heads, 63 sectors/track, 3916 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000621e5


Device Boot      Start         End      Blocks   Id  System

/dev/sda1   *           1        1275    10240000   83  Linux

/dev/sda2            1275        1722     3584000   82  Linux swap / Solaris

/dev/sda3            1722        3917    17632256   83  Linux


Disk /dev/sdb: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000


Disk /dev/sdc: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000


Disk /dev/sdd: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

 

Step 9: Now, partition the sdb, sdc and sdd hard disk drives by following below steps.

==> Execute “fdisk /dev/sdb/” command.

==> Type “n” and press Enter. It will ask to for below:

==> Type “p” and press Enter. It will ask for partition number, enter “1”.

==> Type “w” in below window and press Enter.

==> You can see that the disk partition is completed.

NOTE: Similarly, partition other disks also (/dev/sdc/ and /dev/sdd/). Once, you are done with all disk partitioning, you can see that the sdb1, sdc1 and sdd1 partitions are created.


[root@localhost Desktop]# fdisk -l


Disk /dev/sda: 32.2 GB, 32212254720 bytes

255 heads, 63 sectors/track, 3916 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000621e5


Device Boot      Start         End      Blocks   Id  System

/dev/sda1   *           1        1275    10240000   83  Linux

/dev/sda2            1275        1722     3584000   82  Linux swap / Solaris

/dev/sda3            1722        3917    17632256   83  Linux


Disk /dev/sdb: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xbd795a93


Device Boot      Start         End      Blocks   Id  System

/dev/sdb1               1        1305    10482381   83  Linux


Disk /dev/sdc: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x47f25d06


Device Boot      Start         End      Blocks   Id  System

/dev/sdc1               1        1305    10482381   83  Linux


Disk /dev/sdd: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xa70c9e4e


Device Boot      Start         End      Blocks   Id  System

/dev/sdd1           1        1305    10482381   83  Linux

Step 10: Now, provide permission to created disks.

 

chown -R grid:asmadmin /dev/sdb1

chmod 660 /dev/sdb1

chown -R grid:asmadmin /dev/sdc1

chmod 660 /dev/sdc1

chown -R grid:asmadmin /dev/sdd1

chmod 660 /dev/sdd1

 

Step 11: Configure ASM using following command. It will ask for default user and group. Enter grid and asmadmin respectively.


[root@localhost Desktop]# /etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.


This will configure the on-boot properties of the Oracle ASM library

driver.  The following questions will determine whether the driver is

loaded on boot and what permissions it will have.  The current values

will be shown in brackets ('[]').  Hitting <ENTER> without typing an

answer will keep that current value.  Ctrl-C will abort.


Default user to own the driver interface []: grid

Default group to own the driver interface []: asmadmin

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver:                     [  OK  ]

Scanning the system for Oracle ASMLib disks:               [  OK  ]

 

Step 12: Once ASM is configured, we need to create ASM disk using below command.

/etc/init.d/oracleasm createdisk ASM1 /dev/sdb1

/etc/init.d/oracleasm createdisk ASM2 /dev/sdc1

/etc/init.d/oracleasm createdisk ASM3 /dev/sdd1


[root@localhost Desktop]# /etc/init.d/oracleasm createdisk ASM1 /dev/sdb1

Marking disk "ASM1" as an ASM disk:                        [  OK  ]

[root@localhost Desktop]# /etc/init.d/oracleasm createdisk ASM2 /dev/sdc1

Marking disk "ASM2" as an ASM disk:                        [  OK  ]

[root@localhost Desktop]# /etc/init.d/oracleasm createdisk ASM3 /dev/sdd1

Marking disk "ASM3" as an ASM disk:                        [  OK  ]

 

Step 13: Now, we have to install 11gr2 grid infrastructure and database software’s. I have copied both grid and database to my server and shared the same with the VM.

Grid Infrastructure 11.2.0.1

Oracle Database 11.2.0.1

 

[root@localhost Oracle_11gr2_softwares]# ls

database grid

>> run the software through ./runInstaller.

>> Ensure Skip software updates are selected

>> Click Next.

>> Select Install and Configure Grid Infrastructure for a Standalone Server

>> Click Next.

>> Click Next.

>> Set Disk Group Name to ASM_SPF_DATA

>> Ensure the Redundancy radio button is set to External

>> Ensure the Candidate Disk ratio button is selected.

>> SELECT 3rd disk (ORCL VOL3) ,this disk is ASM SP file purpose choosing

>> Click Next.

>> Select Use same passwords for these accounts

>> Enter a valid password in the Specify Password box.

>> Enter a valid password in the Confirm Password box.

>> Click Next.

>> click on yes.

>> Set the ASM Database Administrator (OSDBA) Group to asmdba

>> Set the ASM Instance Administration Operator (OSOPER) Group to asmoper

>> Set the ASM Instance Administrator (OSASM) Group to asmadmin

>> Click Next.

>> Ensure Oracle Base is set to /u01/app/grid

>> Ensure software location is /u01/app/grid /product/11.2.0/grid_home

>> Click Next.

>> Ensure the Inventory Directory is set to /u01/app/oraInventory

>> Click Next.

>> Select ignore all .

>> click on Next.

>> Review the Summary screen

>> Click INSTALL.

>> As root, ask the UNIX administrator to run /u01/app/oraInventory/orainstRoot.sh

>> As root, ask the UNIX administrator to run /u01/app/grid/product/11.2.0/grid_home/root.sh

>>Click ok.

 

>> to run /u01/app/oraInventory/orainstRoot.sh

>>to run /u01/app/grid/product/11.2.0/grid_home/root.sh

>

> Click Close.

 

>> Now Install oracle 11g database software:

 

>> Go to oracle software loation cd /opt/11gr2/database/

>> run the software through on ./runInstaller.

>> deselect the I wish to receive security updates via My Oracle Support box.

>> click on Next.

>> This is site specific and should be reviewed. Click yes.

>> Click Next.

>> Ensure Skip software updates are Selected

>> Click Next.

>> Ensure select install database software only

>> Click Next.

>> Ensure Single instance database installation is selected.

>> Click Next.

>> Ensure languages English (United Kingdom) are selected.

>> Click Next.

>> Ensure Enterprise Edition is selected.

>> Click Next.

>> Set Oracle Base to /u01/app/oracle

>> Allow Software Location to /u01/app/oracle/product/11.2.0/db_home.

>> Click Next.

>> Ensure Database Administrator (OSDBA) Group is set to oinstall

>> Ensure Database Operator (OSOPER) Group is set to oper

>> Click Next.

>> Select ignore all .

>> click on Next.

>> review the summary screen

>> Click INSTALL.

>> Unix Administrator to run root.sh. – Note: There is a known issue with running this script.

>> Click OK.

 

>> To run /u01/app/oracle/product/11.2.0/db_home/root.sh

>> click on close.

 

 

 

Comments

comments

Check Also

Step by Step process on how to configure Dataguard for Standby Database

Dataguard is used to create standby database for live production database which will be used …

Leave a Reply

Your email address will not be published. Required fields are marked *