How-to Install and Getting-Started on Oracle 11g R2 Database on Red Hat RHEL 6.x 32/64bit Easy Visual-Guide

February 27th, 2014 by thelinuxevangelist

Install Oracle 11g DB on Red Hat Enterprise 6.x




This is an Easy and Step-by-Step Guide on Installing the Oracle 11g R2 i686/x8664 Database on Red Hat Enterprise 6.1/6.2/6.3/6.4/6.5/6.6/6.7/6.8/6.9 32/64bit Linux Desktop/Server.

The Guide Include All the Essentials Commands and Basic Screenshots of the Installation Process.

The Process is somewhat Extended and Advanced so it Demand a Basic Command Line Confidence.

So Just Relax and Take the Time of Reading, Understanding and Executing Carefully the Instructions Contained here.

To the Post Bottom you Find Link to Oracle 11g Database Installation Troubleshooting Guides.

Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 - Featured

  1. Download the Oracle 11g R2 Database for Linux:
    Oracle 11g R2 .zip for Linux
    The Link Contains the List of Oracle 11g r2 Database Releases.

  2. Open Terminal Window
    (Press “Enter” to Execute Commands)
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 - Gnome Open Terminal
  3. Login as SuperUser:
    su 
  4. Make Network Configuration
    • Get hostname:

      hostname
    • Get IP:
      /sbin/ifconfig

      You will Find It Under the lo >> inet Section.

    • Check if Hostname is Already into the Enabled Hosts File.
      cat /etc/hosts

      If It’s Not Present then Insert it with:

      nano /etc/hosts

      Insert: <IP HOSTNAME>

      Example: ‘127.0.0.1 localhost.localdomain’

      Ctrl+Shift+v to Paste Content into nano
      Ctrl+x to Save and Exit
      from nano Editor :)

    • Grant Connection to X Server
      xhost +<hostIP>

      Example: # xhost +127.0.0.1

  5. Installing Required Packages
    yum install binutils glibc compat-libstdc++-33 glibc-common \
    glibc-devel glibc-headers elfutils-libelf elfutils-libelf-devel \
    elfutils gcc gcc-c++ ksh libaio libaio-devel libgcc libstdc++-devel \
    make numactl-devel sysstat mksh
  6. Add Groups and User
    groupadd -g 502 oinstall
    groupadd -g 503 dba
    groupadd -g 504 oper
    groupadd -g 505 asmadmin
    useradd -u 502 -g oinstall -G dba,asmadmin,oper oracle
    passwd oracle
  7. Make Target Directories
    mkdir -p /u01/app/oracle/product/11.2.0/
    chown -R oracle:oinstall /u01
    chmod -R 775 /u01
  8. Parameters Configuration SetUp
    • Edit /etc/sysctl.conf file.
      nano /etc/sysctl.conf

      Then hit Ctrl+x to Save and Exit from nano Editor
      Add or amend the following lines

      #### Oracle 11g Kernel Parameters ####
      fs.suid_dumpable = 1
      fs.aio-max-nr = 1048576
      fs.file-max = 6815744
      kernel.shmall = 2097152
      kernel.shmmax = 536870912
      kernel.shmmni = 4096
      # semaphores: semmsl, semmns, semopm, semmni
      kernel.sem = 250 32000 100 128
      net.ipv4.ip_local_port_range = 9000 65500
      net.core.rmem_default=4194304
      net.core.rmem_max=4194304
      net.core.wmem_default=262144
      net.core.wmem_max=1048586
      

      Comment out these lines below that Gives an Error

      #net.bridge.bridge-nf-call-ip6tables = 0
      #net.bridge.bridge-nf-call-iptables = 0
      #net.bridge.bridge-nf-call-arptables = 0
    • Edit /etc/security/limits.conf file.
      nano /etc/security/limits.conf

      Add the following lines

      #### oracle User Settings 4 Oracle 11g ####
      oracle       soft  nproc  2047
      oracle       hard  nproc  16384
      oracle       soft  nofile 1024
      oracle       hard  nofile 65536
      oracle       soft  stack  10240
      
    • Disable SELINUX
      nano /etc/selinux/config

      Disable Secure Linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows.

      SELINUX=disabled
      
    • Load the New Kernel Parameters.

      /sbin/sysctl -p
  9. Unzip the Oracle 11g Database, Set oracle as Owner and Relocate it into the oracle’s Home
    cd </path/To/linux_11gR2*.zip>
    unzip linux_11gR2_database_1of2.zip
    unzip linux_11gR2_database_2of2.zip
    chown -R oracle:oinstall database
    mv database /tmp
  10. Add Environment Variables to oracle’s .bashrc
    Login as oracle User

    su oracle

    Edit .bashrc file

    nano ~/.bashrc

    Insert:

    # Oracle Settings
    TMP=/tmp; export TMP
    TMPDIR=$TMP; export TMPDIR
    
    ORACLE_HOSTNAME=<HOSTNAME>; export ORACLE_HOSTNAME
    ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
    ORACLE_SID=<DBSID>; export ORACLE_SID
    
    PATH=/usr/sbin:$PATH; export PATH
    PATH=$ORACLE_HOME/bin:$PATH; export PATH
    
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; export LD_LIBRARY_PATH
    CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
    

    Replace [HOSTNAME] with IP and [DBSID] with SID Name
    In this Example Respectively:

    • HOSTNAME = 127.0.0.1
    • DBSID = SID

    Load New .bashrc Settings

    source ~/.bashrc

    Last and Optional to Add Full Env-Integration edit also oracle’s .bashrc

    nano ~/.bashrc

    Inserting

    if [ -f ~/.bashrc ]; then
        source ~/.bashrc
    fi
    
  11. Installing the Oracle 11g Database Software
    cd /tmp/database
    ./runInstaller

    If you Get: “Check if the DISPLAY variable is set. Failed”. Look Link Below.

    Link2+ Oracle 11g Database Troubleshooting

    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 - Start Oracle 11g R2 Installation

    On the first screen Just Insert your email and Possibly Un-Check the Demand of Security Update Support then Click on Next
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 - Oracle 11g R2 Installation Step 1

    If Failed Connection Just Check Remain Uninformed and Follow-Up.
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Failed Connection

    On “Select Installation Option” Select “Install database software only” and Click on Next
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 2

    On Step 3 Leave Default “Single instance database installation” and Click on Next
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 3

    On Step 4 Select your Language and Click on Next
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 4

    On Step 5 Leave Default Enterprise Edition and Click on Next
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 5

    On “Installation Location” Set All As Here Below and Click on Next

    • Oracle Base: /u01/app/oracle
    • Software Location: /u01/app/oracle/product/11.2.0/dbhome_1

    These are the Same Settings Inserted into the .bashrc File…

    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 6

    On “Create Inventory” if you Setup the Path on .bashrc Like Here Leave Default and Click on Next
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 7

    On “Operating System Groups” if you Setup the Path on .bashrc Like Here Leave Default and Click on Next
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 8

    On “Prerequisite Checks” you will Get Easily a “Warning Message” about some Missing Requirements
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 9

    On the “Summary” Click on “Save Response File” to Take Note of Settings and then Click on Finish
    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 10

    The Installation Product Procedure should Start…

  12. Executing Scripts

    Right Before the End of Process a Pop-Up Window will Show the Path to Two Configuration Scripts you Need to Execute on Terminal!

    Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Oracle 11g R2 Installation Step 11

    Next Oracle Should Confirm you of the Successful Installation Achivement.)
    Install Oracle 11g DB on Linux Red Hat 6.1/6.2/6.3/6.4/6.x/6.6 i686/x8664 Oracle 11g R2 Installation Step 12

  13. How-to Create and Run an Oracle 11g Listener:

    Oracle 11g DB Listener Guide
  14. Install Oracle 11g DB on Linux Red Hat 6.x i686/x8664 Penguin Oracle 11g
  15. How-to Create an Oracle 11g Database Instance:

    Oracle 11g Database Guide
After you Should Access the “Enterprise Manager” on Browser by the URL shown on the Last Screen.
On a Localhost for Example you Should Access the Enterprise Manager by the Address:

https://127.0.0.1:1158/em

And you can Login with:
User Name: SYS
Password: oracleDatabasePassword
From the Drop-down below Select >> Connect as SYSDBA
You Should be Able to Access the Database by the Enterprise Manager!

How-to Start and Stop All the Oracle 11g Database Components

  • Start the Oracle Listener, Database and Manager
    1. Login as Oracle User
      su oracle
    2. Start the Listner:
      lsnrctl start
    3. Start the Database process:
      sqlplus '/ as sysdba'

      Insert YourOracleAccountPassword

      >startup

      Wait until the database is Up!

      ORACLE instance started.
      ...
      Database opened.
      

      Exit from sqlplus

      >exit
    4. Start Database Manager Console
      emctl start dbconsole
    5. Access the Oracle Database Manager on Browser
      https://127.0.0.1:1158/em
  • Stop the Oracle Database
    1. Stop the Database process:
      sqlplus '/ as sysdba'
      >shutdown immediate
      >exit
    2. Stop the Listner:
      lsnrctl stop
  • How-to Getting-Started with SQLPlus for Oracle 11g DB:

    SQLPlus Oracle 11g Quick-Start

If you have Several Oracle Databases Everytime Before to Start a New one you have to Set SID:

export ORACLE_SID=DbSID
Oracle 11g Database Troubleshooting Guides

Enjoy this “Step by Step” Clear Installation and Getting Started…
Good Luck! :)

Tags: , , , , , , , , , , , , , , , ,