11gr2 asm – inside story – part1

11gR2 ASM – Inside story – Part1 By Wissem EL KHLIFI

Introduction:This is a series of articles which contains several important enhancements to Automatic Storage Management in Oracle 11gR2.In this part1, we are going to prepare, install our 11gR2 ASM environment.In this ASM inside story articles, we are going to use Oracle Linux 5 as the guest operating system, Oracle 11gR2 as database version.Oracle VirtualBox is our virtualization software.

Oracle Linux InstallationDownload and install Oracle Linux.

The following rpm packages must be installed in your system:binutils-2.17.50.0.6compat-libstdc++-33-3.2.3elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.5glibc-headers-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.2libgomp-4.1.2libstdc++-4.1.2libstdc++-devel-4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-devel-2.2.11

Example:

www.oracle-class.com Wissem EL KHLIFI

http://www.oracle-class.com/?p=1908

http://www.oracle-class.com/

For Automatic Memory Manager, make the shared memory file system big enough and add the “tmpfs” setting in the “/etc/fstab” file:

Add the following lines in the /etc/sysctl.conf file:

Run the following command to change the current kernel parameters:



http://www.oracle-class.com/wp-content/uploads/2011/02/ASMpart1/pre%20oracle%20install%206.jpg




Add the following lines to the “/etc/security/limits.conf” file:

Make sure the SELINUX=disabled in the “/etc/selinux/config” file.

System Users and Groups creation

Prepare Oracle binaries and software directories

Set environment variables for Oracle system userLogin as Oracle system user. Then, edit the file .bash_profile and add the following lines. After that, save the changes and run the command “source .bash_profile”:

Configure devices for ASM using file system files and loop devicesIn this step we are going to:1- Create a directory to hold the files to be used as ASM devices, as Oracle system user.2- Create 4 files to be used as Asm devices, 1GB of size for each, as root system user.3- Check the created files, as root system user.4- Create the loop devices, as root system user.5- Bind the loop devices to raw devices, as root system user.6- Setup raw devices permissions and ownership, as root system user.7- Edit the “/etc/rc.local” file and add the same commands mentioned before. why? Because after a reboot, the ownership and permisions will change back to root and “-rw-r–r–” files attributes.

123

[oracle@localhost orawiss]$ mkdir asmdisk[root@localhost orawiss]# dd if=/dev/zeroof=/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk1 bs=1024k







45678910111213141516171819202122232425262728293031323334353637383940414243444546474849

count=10001000+0 records in1000+0 records out1048576000 bytes (1.0 GB) copied, 23.5853 seconds, 44.5 MB/s[root@localhost orawiss]# dd if=/dev/zeroof=/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk2 bs=1024kcount=10001000+0 records in1000+0 records out1048576000 bytes (1.0 GB) copied, 22.9174 seconds, 45.8 MB/s[root@localhost orawiss]# dd if=/dev/zeroof=/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk3 bs=1024kcount=10001000+0 records in1000+0 records out1048576000 bytes (1.0 GB) copied, 32.2912 seconds, 32.5 MB/s[root@localhost orawiss]# dd if=/dev/zeroof=/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk4 bs=1024kcount=10001000+0 records in1000+0 records out1048576000 bytes (1.0 GB) copied, 36.1176 seconds, 29.0 MB/s [root@localhost orawiss]# /sbin/losetup /dev/loop1/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk1[root@localhost orawiss]# /sbin/losetup /dev/loop2/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk2[root@localhost orawiss]# /sbin/losetup /dev/loop3/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk3[root@localhost orawiss]# /sbin/losetup /dev/loop4/u01/app/oracle/product/11.2.0/orawiss/asmdisk/disk4 [root@localhost orawiss]# raw /dev/raw/raw1 /dev/loop1/dev/raw/raw1: bound to major 7, minor 1[root@localhost orawiss]# raw /dev/raw/raw2 /dev/loop2/dev/raw/raw2: bound to major 7, minor 2[root@localhost orawiss]# raw /dev/raw/raw3 /dev/loop3/dev/raw/raw3: bound to major 7, minor 3[root@localhost orawiss]# raw /dev/raw/raw4 /dev/loop4/dev/raw/raw4: bound to major 7, minor 4[root@localhost orawiss]# cd /dev/raw[root@localhost raw]# ls -ltrtotal 0crw------- 1 root root 162, 1 Feb 28 20:27 raw1crw------- 1 root root 162, 2 Feb 28 20:27 raw2



5051525354555657585960616263

crw------- 1 root root 162, 3 Feb 28 20:28 raw3crw------- 1 root root 162, 4 Feb 28 20:28 raw4[root@localhost raw]# ---change owner raw devices [root@localhost raw]# chown -R oracle:oinstall *[root@localhost raw]# chmod 660 *[root@localhost raw]# ls -ltrtotal 0crw-rw---- 1 oracle oinstall 162, 1 Feb 28 20:27 raw1crw-rw---- 1 oracle oinstall 162, 2 Feb 28 20:27 raw2crw-rw---- 1 oracle oinstall 162, 3 Feb 28 20:28 raw3crw-rw---- 1 oracle oinstall 162, 4 Feb 28 20:28 raw4[root@wissem tmp]# chown -R oracle:oinstall/u01/app/oracle/product/11.2.0/orawiss/*[root@localhost raw]# vi /etc/rc.local

Also add in the “/etc/rc.local” file “chown -R oracle:oinstall *” and “chmod 660 *” lines:

Note that to delete a loop device, you can use the following sintax: “losetup –d /dev/loopX”

Oracle binary files installationThis is my own method I use; I first install the Oracle binaries, install the grid infrastructure for standalone server and then use the dbca to install the Oracle database.To install the Oracle binaries, you can follow the screen shots below.

1[oracle@wissem database]$ ./runInstallerInsert you Oracle metalink credentials:



http://www.oracle-class.com/wp-content/uploads/2011/02/ASMpart1/28022011/ASM.jpg

Choose to install the Oracle software only:

Choose a single instance installation against Real Application Clusters installation method:

Select the Oracle software languages:

Choose enterprise edition:



http://www.oracle-class.com/wp-content/uploads/2011/02/ASMpart1/28022011/db1.jpg




Confirm the Oracle base and software locations:

Choose your OSDBA and OSOPER groups:

Automatic verification of the configuration requirements:

Confirm the global settings resume:







The installation progress:

Open a new terminal window, login as root and run the “*.root.sh” scripts. After that click on “ok”.

Now the Oracle binaries are installed. Let’s configure ASM when installing the Oracle grid infrastructure for standalone server.

Grid Infrastructure Installation for standalone serverTo configure ASM, we are going to install the grid infrastructure for standalone server.The following screen shots best describe the steps you need to perform.

1[oracle@wissem grid]$ ./runInstallerChoose to install Grid Infrastructure for standalone server option:






Select the software languages:

Select the ASM disk files we already created in the previous section:

Choose the sys password for SYSASM new privilege appeared with Oracle 11g version.



http://www.oracle-class.com/wp-content/uploads/2011/02/ASMpart1/28022011/grid1.jpg



Choose the operating system groups for OSDBA, OSOPER and OSASM.

Confirm the Oracle base and the grid infrastructure software locations:

Configuration requirements verification status:






Confirm the Oracle grid infrastructure resume:

Installation progress:

Open a new terminal window, login as root and run the “root.sh” script. After that click on “ok”.






123456789101112131415161718192021222324252627282930313233

[root@wissem ~]# /u01/app/oracle/product/11.2.0/grid/root.shRunning Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]:The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]:The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.2011-03-01 11:29:22: Checking for super user privileges2011-03-01 11:29:22: User has super user privileges2011-03-01 11:29:22: Parsing the host nameUsing configuration parameter file:/u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directory/home/oracle/.bash_profile: line 1: racle: command not foundLOCAL ADD MODECreating OCR keys for user 'oracle', privgrp 'oinstall'..




343536373839404142434445

Operation successful.CRS-4664: Node wissem successfully pinned.Adding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is starting wissem 2011/03/01 11:33:09/u01/app/oracle/product/11.2.0/grid/cdata/wissem/backup_20110301_113309.olrSuccessfully configured Oracle Grid Infrastructure for a Standalone ServerUpdating inventory properties for clusterwareStarting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 1702 MB PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /u01/app/oraInventory'UpdateNodeList' was successful.[root@wissem ~]#

Installation progress:

The installation confirmation message:




Database installationUsing dbca, we are going to install the Oracle 11gR2 database.The screen shots below best describe the installation steps.

1[oracle@wissem database]$ dbca

Click next:

Choose to create a database against a tempalte:






Choose your database template:

Insert your Global database name, SID identifier:

Choose to configure Enterprise manager, database control:






Insert and confirm the user accounts password:

Choose ASM for storage management type and +DATA for Oracle managed files database area:

Specify ASMSNMP password:






In the recovery configuration screen click next:

Choose or not to add the sample schemas in your database:

Specify the global memory size and the database character Set:






Confirm and click next:

Choose to create a database and generate a creation database script for future quick database installation:






Confirm the next window:






Verify your database installation using ASM to manage the storage:

Nice reading ,






11gr2 asm – inside story – part1

Documents