I will be listing down steps for 11g Release 2 installation on Linux x86. There has been few changes incorporated in 11gR2 which must be given due consideration before starting installation. ASM instance now runs from new Oracle Home called Grid Infrastructure.
If you wish to use ASM for storing database files, then you should install first Oracle grid infrastructure for a standalone server. It is also required if you wish to use Oracle Restart feature (Provides for automatic restart of DB and other components after a hardware or software failure or whenever your database host computer restarts) for single instance.
Environment used for this setup
Operating System - Oracle Enterprise Linux Release 5(OEL5) on Vmware
Physical Ram - 1Gb
Asmlib for labeling ASM Disks.Refer to following OTN article for configuring asmlib and creating disks.
Software can be downloaded from OTN at following link
Oracle Database 11g Release 2 Grid Infrastructure (220.127.116.11.0) for Linux x86
Oracle Database 11g Release 2 (18.104.22.168.0) for Linux x86
All the pre-requisites for installation can be found here
I have tried to shorten it by keeping things which are relevant to our setup.
binutils-22.214.171.124.6 compat-libstdc++-33-3.2.3 elfutils-libelf-0.125 elfutils-libelf-devel-0.125 elfutils-libelf-devel-static-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-common-2.5 glibc-devel-2.5 glibc-headers-2.5 kernel-headers-2.6.18 ksh-20060214 libaio-0.3.106 libaio-devel-0.3.106 libgcc-4.1.2 libgomp-4.1.2 libstdc++-4.1.2 libstdc++-devel-4.1.2 make-3.81 sysstat-7.0.2 unixODBC-2.2.11 unixODBC-devel-2.2.11
If you have yum installed on your machine, then it is very easy to install the packages. You can copy the list of packages in a text file and insert 'yum install ' in beginning and execute it as root. This will install any missing packages. To know more about setting up yum, refer to my previous post
If Kernel parameters are not setup correctly, Oracle 11g OUI provides you a fixup script and also ability to resume the installation process without need to re-run the earlier steps. Please refer to article here
Users,Roles and Groups for Installation
osdba group for ASM - Membership in the OSDBA group allows access to the files managed by Automatic Storage Management. It can be same as database osdba group. We will be using group dba in our setup.
OSASM group - Members of the OSASM group can use SQL to connect to an Automatic Storage Management instance as SYSASM using operating system authentication. The SYSASM privileges permit mounting and dismounting disk groups, and other storage administration tasks. SYSASM privileges provide no access privileges on an RDBMS instance. We will use asmadmin
OSOPER group - Similar to SYSOPER privilege in RDBMS, this is used for limited privileges like starting up and stopping the Oracle ASM instance. We will not be using separate group for it, will be selecting dba in our setup
oinstall - This is similar to previous releases, and used for Oracle Inventory group
I am using oracle user for installing Grid Infrastructure and Oracle Database Software. You can have a separate user say oragrid with oinstall membership and permission on oracle inventory directory.
Create Base directory where software will be installed. I used /u02/app/oracle
Add users and groups
/usr/sbin/groupadd -g 501 dba /usr/sbin/groupadd -g 504 asmadmin /usr/sbin/groupadd oinstall /usr/sbin/useradd -u 502 -g oinstall -G dba,asmadmin oracle
Add following entries to /etc/security/limits.conf
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
Add or edit the following line in the /etc/pam.d/login file, if it does not already exist:
session required pam_limits.so
Add/replace following entries in /etc/sysctl.conf
fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586
Execute following command as root to change the current kernel parameters:
Copy following in your login profile.
if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi
We need to start with Grid Infrastructure installation. Unzip the contents and execute runInstaller . This would require 2.8Gb of disk space.
Execute root.sh from Grid ORACLE_HOME as root user
The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u02/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]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2009-09-02 05:07:26: Checking for super user privileges 2009-09-02 05:07:26: User has super user privileges 2009-09-02 05:07:26: Parsing the host name Using configuration parameter file: /u02/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params Creating trace directory LOCAL ADD MODE Creating OCR keys for user 'oracle', privgrp 'oinstall'.. Operation successful. CRS-4664: Node db11g successfully pinned. Adding daemon to inittab CRS-4123: Oracle High Availability Services has been started. ohasd is starting db11g 2009/09/02 05:09:24 /u02/app/oracle/product/11.2.0/grid/cdata/db11g/backup_20090902_050924.olr Successfully configured Oracle Grid Infrastructure for a Standalone Server Updating inventory properties for clusterware Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 2399 MB Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /u01/app/oraInventory 'UpdateNodeList' was successful.
To install Database software, Unzip the contents of both the zip files and execute runInstaller . Ensure you have 3.95Gb of free disk space
Please click on image for displaying screenshots for 11gR2 Database installation .
You are done 🙂