Oracle 11gR2 software and database installation on Oracle Linux 6.5

Here we are installing Oracle 11g Release-2 (11.2)(64-bit) on Oracle Linux release-6 (64-bit)

Kindly have a look on Pre-requisites before proceeding for oracle 11gR2 installation.

Memory requirements:

  • Minimum 1 GB RAM, Recommended 2 GB or more than that.
  • Following commands will helpyou to determine RAM of your system:
    • # grep MemTotal /proc/meminfo
    • # free -m // shows RAM + SWAP
  • If RAM of your system does not meet minimum requirement than increase it.
  • SWAP partition requirement for oracle installation is only depend on RAM installed in your system, according to oracle docs.
    1. If your RAM between 1 GB to 2 GB than your swap partition size should be 1.5 times the size of the RAM.
    2. If your RAM between 2 GB to 16 GB than your swap partition size should be equal to the size of the RAM.
    3. If your RAM more than 16 GB than your swap partition size should be 16 GB.

Disk space requirement:

  • /tmp directory size would be at least 1 GB.
  • Determine available disk space of /tmp directory with following command:
    • # df -h /tmp
  • Minimum requirement of total disk space of the system would directly depend upon size of your database, Oracle installation files take maximum 4.5 GB to 4.7GB of disk space.
  • Determine total diskc space available with following:
    • # df -h

Verify your system architecture with following command:

# uname -m

Update host file “/etc/hosts” with fully qualified name like below:

Ex:
 115.xxx.xxx.xxx ol6.localdomain ol6

Note:
In my case “ol6.localdomain” is fully qualified name with machine name.

Update following entries in “/etc/sysctl.conf” file:

 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 = 1048576

To change kernel parameter, run following:

 # /sbin/sysctl -p
 OR
 # sysctl -p

Update following entries in “/etc/security/limits.conf” file:

 oracle soft nproc 16384
 oracle hard nproc 16384
 oracle soft nofile 4096
 oracle hard nofile 65536
 oracle soft stack 10240

Install following packages by yum or rpm:

 binutils-2.20.51.0.2-5.11.el6 (x86_64)
 compat-libcap1-1.10-1 (x86_64)
 compat-libstdc++-33-3.2.3-69.el6 (x86_64)
 compat-libstdc++-33-3.2.3-69.el6.i686
 gcc-4.4.4-13.el6 (x86_64)
 gcc-c++-4.4.4-13.el6 (x86_64)
 glibc-2.12-1.7.el6 (i686)
 glibc-2.12-1.7.el6 (x86_64)
 glibc-devel-2.12-1.7.el6 (x86_64)
 glibc-devel-2.12-1.7.el6.i686
 ksh
 libgcc-4.4.4-13.el6 (i686)
 libgcc-4.4.4-13.el6 (x86_64)
 libstdc++-4.4.4-13.el6 (x86_64)
 libstdc++-4.4.4-13.el6.i686
 libstdc++-devel-4.4.4-13.el6 (x86_64)
 libstdc++-devel-4.4.4-13.el6.i686
 libaio-0.3.107-10.el6 (x86_64)
 libaio-0.3.107-10.el6.i686
 libaio-devel-0.3.107-10.el6 (x86_64)
 libaio-devel-0.3.107-10.el6.i686
 make-3.81-19.el6
 sysstat-9.0.4-11.el6 (x86_64)
 unixODBC-2.2.14-11.el6 (x86_64) or later
 unixODBC-2.2.14-11.el6.i686 or later
 unixODBC-devel-2.2.14-11.el6 (x86_64) or later
 unixODBC-devel-2.2.14-11.el6.i686 or later

Note:
Determine required packages are installed or not with the help of following command:

# rpm -q package_name

Create oracle groups and users:

 groupadd -g 501 oinstall
 groupadd -g 502 dba
 groupadd -g 503 oper
 groupadd -g 504 asmadmin
 groupadd -g 506 asmdba
 groupadd -g 505 asmoper
 useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
 passwd oracle

Set SELINUX flag ‘disable’ in “/etc/selinux/config” file.

 SELINUX=disabled

Restart server after setting SELINUX disabled.

Create directory for oracle software to be installed:

 # mkdir -p /u01/app/
 # chown -R oracle:oinstall /u01/app/
 # chmod -R 775 /u01/app/

Disable IP tables:

 # service iptables stop
 # chkconfig iptables off //This command will make changes persistent over reboot.

Configure VNC server for GUI, Nice article here.

Oracle software download link.

 

Unzip installer and continue..

On GUI, open terminal prompt as a root user & issue the following command:
 xhost +
 su – oracle

Run universal installer and follow the steps by step installation of oracle 11gR2:

 ./runIstaller

And follow the steps mentioned below:

Oracle 11gR2 installation on Oracle Linux 6.5 - Configure Security Updates

Oracle 11gR2 installation on Oracle Linux 6.5 – Configure Security Updates

 

You can directly create and configure a database by selecting first radio button, in my case first i will install database software only and than database.

Oracle 11gR2 installation on Oracle Linux 6.5 - Select Installation Option

Oracle 11gR2 installation on Oracle Linux 6.5 – Select Installation Option

 

Select single instance database installation radio button and continue, as we are installing single instance database:

Oracle 11gR2 installation on Oracle Linux 6.5 - Node selection

Oracle 11gR2 installation on Oracle Linux 6.5 – Node selection

 

Select Product Languages according to your convenience, in my case it is English, default language.

Oracle 11gR2 installation on Oracle Linux 6.5 - Select Product Languages

Oracle 11gR2 installation on Oracle Linux 6.5 – Select Product Languages

 

Select database edition as per your requirement, in my case it would be Standard Edition.

Oracle 11gR2 installation on Oracle Linux 6.5 - Select database edition

Oracle 11gR2 installation on Oracle Linux 6.5 – Select database edition

 

Provide path of oracle base and continue, In my case its default.

Oracle 11gR2 installation on Oracle Linux 6.5 - specify installation location

Oracle 11gR2 installation on Oracle Linux 6.5 – specify installation location

 

Provide ‘Inventory Directory’, ‘OraInventory group’ and continue.

Oracle 11gR2 installation on Oracle Linux 6.5 - Create Inventory

Oracle 11gR2 installation on Oracle Linux 6.5 – Create Inventory

 

Select ‘Database Administrator Group’ and ‘Database Operator Group’ and continue.

Oracle 11gR2 installation on Oracle Linux 6.5 - Privilege Operation System Group

Oracle 11gR2 installation on Oracle Linux 6.5 – Privilege Operation System Group

 

If your system already installed latest version of mentioned packages, then you can ignore and continue. In my case, latest version available.

Oracle 11gR2 installation on Oracle Linux 6.5 - Perform Prerequisite Check

Oracle 11gR2 installation on Oracle Linux 6.5 – Perform Prerequisite Check

Oracle 11gR2 installation on Oracle Linux 6.5 - Summary

Oracle 11gR2 installation on Oracle Linux 6.5 – Summary

Oracle 11gR2 installation on Oracle Linux 6.5 - Install Product

Oracle 11gR2 installation on Oracle Linux 6.5 – Install Product

 

Execute mentioned configuration script as root user and continue.

Oracle 11gR2 installation on Oracle Linux 6.5 - Execute Configuration Scripts

Oracle 11gR2 installation on Oracle Linux 6.5 – Execute Configuration Scripts

Software installation completed successfully.

Now database installation, for that i have instantiated DBCA from oracle_home/bin directory.

Oracle 11gR2 installation on Oracle Linux 6.5

Oracle 11gR2 installation on Oracle Linux 6.5

Oracle 11gR2 installation on Oracle Linux 6.5 - Create database

Oracle 11gR2 installation on Oracle Linux 6.5 – Create database

Oracle 11gR2 installation on Oracle Linux 6.5 - General purpose or Transaction Processing

Oracle 11gR2 installation on Oracle Linux 6.5 – General purpose or Transaction Processing

 

Provide ‘Global Database Name’, ‘SID’, and continue.

Oracle 11gR2 installation on Oracle Linux 6.5 - Database Identification

Oracle 11gR2 installation on Oracle Linux 6.5 – Database Identification

 

Checked ‘Configuration Enterprise Manager’ check box in case of you wanted to configure it, In my case, its not my requirement.

Oracle 11gR2 installation on Oracle Linux 6.5 - Management Option

Oracle 11gR2 installation on Oracle Linux 6.5 – Management Option

 

Provide SYS and SYSTEM user password, otherwise provide common password for the both user and continue.

Oracle 11gR2 installation on Oracle Linux 6.5 - Database Credentials

Oracle 11gR2 installation on Oracle Linux 6.5 – Database Credentials

 

Select Database file locations according to your requirements, in my case i am using default option, i.e. From Template.

Oracle 11gR2 installation on Oracle Linux 6.5 - Database File Location

Oracle 11gR2 installation on Oracle Linux 6.5 – Database File Location

 

Provide Flash Recovery Area path and its size according to your convenience. You can also enable Archive log mode.

Oracle 11gR2 installation on Oracle Linux 6.5 - Recovery Configuration

Oracle 11gR2 installation on Oracle Linux 6.5 – Recovery Configuration

Oracle 11gR2 installation on Oracle Linux 6.5 - Database Content

Oracle 11gR2 installation on Oracle Linux 6.5 – Database Content

 

Configure memory, sizing, character Sets and connection mode according to your convenience and continue.

Oracle 11gR2 installation on Oracle Linux 6.5 - Initialization Parameters

Oracle 11gR2 installation on Oracle Linux 6.5 – Initialization Parameters

 

Verify controlfile multiplexing, datafiles and redo log group and continue.

Oracle 11gR2 installation on Oracle Linux 6.5 - Database Storage

Oracle 11gR2 installation on Oracle Linux 6.5 – Database Storage

Oracle 11gR2 installation on Oracle Linux 6.5 - Creation Option

Oracle 11gR2 installation on Oracle Linux 6.5 – Creation Option

Oracle 11gR2 installation on Oracle Linux 6.5 - Database Configuration Assistant

Oracle 11gR2 installation on Oracle Linux 6.5 – Database Configuration Assistant

 

Cheers!! Oracle software and database creation successfully completed.

Stay tune. 🙂

Leave a Reply