Setup Menus in Admin Panel

DBATalent

Installing Oracle database 11gR2 RDBMS on Oracle Enterprise Linux 6 or RHEL 6

Knowledge Base > Oracle Database > Installing Oracle database 11gR2 RDBMS on Oracle Enterprise Linux 6 or RHEL 6

in Oracle Database

  • This article explains how to install Oracle database 11gR2 RDBMS software on OEL 6 or RHEL 6

    CONTENTS:

    NOTE:

    This document describes the requirements for installation of Oracle Database 11g Release 2 64 bit on redhat enterprise linux 6, the installation process of the software and creation of a database using database configuration assistant (DBCA) and manual method.

    Software details: Download the software ( V17530-01_1of2.zip Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64 and V17530-01_2of2.zip Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64 ) from www.edelivery.oracle.com


    PREREQUISITES:

    (i) Operating system requirements:

    The machine should be running redhat enterprise linux 6 or oracle enterprise linux 6. To check,

    $ cat /etc/redhat-release

    (ii) Hardware requirements:

    a) CPU with 64-bit architecture. Command to display the processor type is,

    $ uname -m

    Verify that the processor architecture matches the Oracle software release to install. If you do not see the expected output, then you cannot install the software on this system.

    b) At least 1.0 GB of physical RAM. Command to check amount of RAM installed on the system is,

    $ free -m (or) $ grep MemTotal  /proc/meminfo

    c) Swap size should be proportional to RAM size as follows,

    RAM (GB) SWAP
    1-2 1.5 times RAM size
    2-16 Equal to RAM size
    More than 16 16 GB

    Swap size can be checked using,

    $ free -m (or) $ grep SwapTotal  /proc/meminfo

    d) 1.0 GB of minimum free space /tmp directory and maximum of 2 TB free space. To check the amount of free space in /tmp,

    $ df -h /tmp


    e) More than 7 GB free space if you are going to install enterprise edition or more 4.6 GB free space on the mount point if you are going to install standard edition of the RDBMS software.

    (iii) Software requirements:

    a) RHEL6 servers must be running kernel 2.6.32-7el6 or higher. OL6 servers must also be running kernel 2.6.32-71.el6 or higher version or Unbreakable Enterprise Kernel 1 (UEK1, kernel version 2.6.32-100.28.5) or Unbreakable enterprise kernel 2. To check the version of the kernel, execute

    $ uname -r (or) $ cat /proc/version (or) $ uname -a

     

    b) Required OS components:

    Check for following 64 bit RPMs. To check if any RPM is installed, use the following command

    $ rpm -aq | grep <RPM name> (or) $ rpm -q <RPM name>

    binutils-2.20.51.0.2-5.11.el6 (x86_64)

    compat-libstdc++-33-3.2.3-69.el6 (x86_64)

    glibc-2.12-1.7.el6 (x86_64)

    ksh-*.el6 (x86_64) —–> any version of ksh is acceptable

    libaio-0.3.107-10.el6 (x86_64)

    libgcc-4.4.4-13.el6 (x86_64)

    libstdc++-4.4.4-13.el6 (x86_64)make-3.81-19.el6 (x86_64)

    • Install other required RPMs listed below. To install an RPM,

    $ rpm -ivh <RPM name >

    compat-libcap1-1.10-1 (x86_64)

    gcc-4.4.4-13.el6 (x86_64)

    gcc-c++-4.4.4-13.el6 (x86_64)

    glibc-devel-2.12-1.7.el6 (x86_64)

    libaio-devel-0.3.107-10.el6 (x86_64)

    libstdc++-devel-4.4.4-13.el6 (x86_64)

    sysstat-9.0.4-11.el6 (x86_64)

    • If you want to install the 11.2.0.3 32-bit Client software, you should also install these packages,
    compat-libstdc++-33-3.2.3-69.el6glibc-2.12-1.7.el6glibc-devel-2.12-1.7.el6libaio-0.3.107-10.el6libaio-devel-0.3.107-10.el6libgcc-4.4.4-13.el6libstdc++-4.4.4-13.el6
    libstdc++-devel-4.4.4-13.el6

    (iv) Environment:

    a) Modify your kernel settings in /etc/sysconf as follows. If the current value for any parameter is higher than the value listed in this table, do not change the value of that parameter.

    kernel.shmall = physical RAM sizekernel.shmmax = 1/2 of physical RAMkernel.shmmni = 4096kernel.sem = 250 32000 100 128

    fs.file-max = 512 x processes

    fs.aio-max-nr = 1048576

    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

    As root user, execute “sysctl -p” to activate these new parameters.

    b) Add the following settings to “/etc/security/limit.conf” where oracle is the username.

    This will limit the shell for the user performing RDBMS installation.

    oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536

    oracle soft stack 1024

    INSTALLATION PROCEDURE:

    (i) Download Oracle 11gR2 RDBMS 64-bit software for linux from www.oracle.com

    (ii) Unzip the downloaded files

    (iii) The “/etc/hosts” file must contain a fully qualified name for the server. Add the ip address and full hostname to /etc/hosts file in the following format

    <IP-address>  <fully-qualified-machine-name> <machine-name>

    (iv) Create the new groups and users using following commands as root user.

    # groupadd oinstall

    # groupadd dba

    # useradd -g oinstall -G dba,oper,asmadmin oracle

    # passwd oracle

    To check whether the group is created, use the following command and check the entry after “inst_group”

    $ grep dba /etc/group (or) $ more /etc/oraInst.loc

    To determine whether the oracle user exists and belongs to the correct groups, enter the following command. If the oracle user exists, then this command displays information about the groups to which the user belongs.

    $ id oracle

    If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, then enter the following command

    # usermod -g oinstall -G dba oracle

    (v) Create required directories and change permissions using the following commands

    # mkdir -p /u01/app/oracle/product/11.2.0/dbhome_3

    # chown -R oracle:oinstall /u01

    # chmod -R 775 /u01

     

    (vi) Now login as oracle user and start the Oracle universal installer (OUI) by using the following command in the database directory.

    $ ./runInstaller

    Proceed with the installation and the installation steps you encounter during installation are listed below.

    • Configure Security Updates. Provide your oracle support email and password to receive updates on security threats.

    11g_inst_1

    • Choose “Install database software only” to install the software. Or you can optionally choose “Create and configure a database” if you would like to create a database after installation using DBCA.

    11g_inst_2

    • Choose whether you want to install single instance database software or multiple instance (RAC) database software.

    11g_inst_3

    • Select the languages in which you want the RDBMS software to run

    11g_inst_4

    • Select the database edition you want to install

    11g_inst_5

    • Give path for oracle base and software installation location

    11g_inst_6

    • Select the database administrator and database operator groups.

    11g_inst_7

    • OUI performs pre-installation check before installation. If any packages required by the installer as shown in the picture below, install those packages using yum utility before proceeding with the installation.

    11g_inst_8

    • The following screen will be displayed if there are no additional package or services requirement. Click on “Finish” at the bottom to proceed with the installation.

    11g_inst_9

    • Now, the installation process has started and progress is represented on the bar as shown.

    11g_inst_10

    • At the end of the installation process you will be provided with a script. Run the script as root user and click ok to proceed.

    11g_inst_11

    • Installation process is now complete. Click on “close” at the bottom of the screen to exit the OUI.

    11g_inst_12

0