07 Oracle ASM software Installation & ASM disk creation

Описание: In this Tutorial we will see how we can configure 11.2 standalone database with ASM manually. You might have to create ASM instance manually when you want to have allocation unit (AU_SIZE) other than 1 MB(default). For 11.2.0.1 and 11.2.0.2 Grid Installation OUI or AMSCA does not have provision to modify allocation unit while creating the instance. This feature is available from 11.2.0.3 ASMCA.

Following environment was used to test this setup on VMWare.

Operating System : OEL 5.3 (32 bit)
Oracle Version : 11.2.0.2
Grid Infrastructure Version : 11.2.0.2

The approach would remain same for different 11.2 patchset on Linux platform.

We will NOT be covering installation of VMWare, guest OS and VMWare tools in this article. You can find lot of articles helping you to do this.

So lets start with list of tasks that needs to be done to accomplish our goal.

Install Missing RPM packages
Add disks at OS level for ASM
Create oracle user and directories
Set Kernel Parameters
Install ASMLib and configure devices
Install Grid Infrastructure Binaries
Install Oracle Database Binaries
Start CSSD service
Create ASM Service & Instance
Create Database Service & Instance

Install Missing RPM packages

Login as root and ensure that following packages are applied.

rpm q binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

Install any of the missing packages.

Add disks at OS level for ASM

For ASM we will be needing disks. In a production environment this would be provided by storage admin. For this test setup I am utilizing VMware ability to add disks.