How-to Install and Getting-Started on Oracle 11g R2 Database for Oracle Linux 6 Step-by-Step Easy Guide

This is an Easy and Step-by-Step Guide to Install and Getting-Started on the Oracle 11g R2 Database for an Oracle Linux 6.x Systems.

To Take the Most and Best from this WowGuide your Invited to Just Relax and Take the Time to Reading, Understanding and Executing Carefully the Instructions Contained here.

To the Post Bottom you Find Links to Oracle 11g Database Detailed Troubleshooting Guides.

1. Download the Database Release Oracle 11g R2
2. Open a Terminal Window
3. Login as SuperUser

   su

4. Make Network Configuration

   Check you hostname and IP is on /etc/hosts

   Get your hostname:

   hostname

   Get your IP:

   /sbin/ifconfig

   You will Find your Ip under the Output "lo" Section.

   Check if Hostname and IP are already inserted into the Enabled Hosts File.

   cat /etc/hosts

   If It's Not Present then Insert it!

   nano /etc/hosts

   Insert: <IP HOSTNAME.DOMAINNAME HOSTNAME>

   Example: '127.0.0.1 localhost.localdomain localhost' Add you Host IP to the List of Hosts Granted of Connection with the X Server

   xhost +<yourIP>

   Example: #xhost +127.0.0.1
5. 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 -s /bin/bash -m oracle

   passwd oracle

6. Create the directories where Oracle will be installed and give right ownership and permission

   mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1

   chown -R oracle:oinstall /u01

   chmod -R 775 /u01

7. Set Kernel's Parameters

   nano /etc/sysctl.conf

   Add or amend the following lines in the /etc/sysctl.conf file.

   #### 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 than give an error #net.bridge.bridge-nf-call-ip6tables = 0 #net.bridge.bridge-nf-call-iptables = 0 #net.bridge.bridge-nf-call-arptables = 0

   nano /etc/security/limits.conf

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

   #### 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
   

   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
   

   Run the following command to Load the New Kernel Parameters.

   /sbin/sysctl -p

8. Install the Prerequisite Packages

   yum install gcc compat-libstdc++-33 elfutils-libelf-devel glibc-headers gcc-c++ \
   libaio-devel libstdc++-devel unixODBC unixODBC-devel sysstat

9. Unzip the Oracle 11g Database, Set oracle as Owner and Move 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 /home/oracle

10. Add Paths to Oracle's .bash_profile Login as Oracle

    su oracle

    Edit the .bash_profile

    nano /home/oracle/.bash_profile

    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; export LD_LIBRARY_PATH
    CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
    

    Substitute HOSTNAME and DBSID with the Values you Will Use During Software Installation In this Example Respectively:

    • HOSTNAME = 127.0.0.1
    • DBSID = SID

    Then Load the New SetUp:

    source /home/oracle/.bashrc

11. Install the Oracle 11g Software

    cd /home/oracle/database

    ./runInstaller

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

    Oracle 11g DISPLAY Not Set Tip

    You Find the Oracle 11g Troubleshooting inside the Guide.
    

    On the first screen If you Do Not Dispose of an Oracle Subscription Just Leave Blank eMail and Un-Check the Demand of Security Update Support then Click on Next

    Then Confirm on Warning and Follow.

    On "Select Installation Option" Select "Install database software only" and Click on Next

    On Step 3 Leave Default "Single instance database installation" and Click on Next

    On Step 4 Select your Language and Click on Next

    On Step 5 Leave Default Enterprise Edition and Click on Next

    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 .bash_profile File...

    

    On "Create Inventory" if you Setup the Path on .bash_profile Like Here Leave Default and Click on Next

    On "Operating System Groups" if you Setup the Path on .bash_profile Like Here Leave Default and Click on Next

    On "Prerequisite Checks" you will Get Easily a "Warning Message" about some Missing Requirements

    Just Check: "Ignore All" and Follow Up with Installation...

    

    On the "Summary" Click on "Save Response File" to Take Note of Settings and then Click on Finish

    The Installation Product Procedure should Start... Wait Until Successful Achievement. Right Before the End of Process a Pop-Up Window will Show the Path to Two Configuration Scripts you Need to Execute on Terminal!

    Last Oracle Should Confirm you of a Successful Installation End.)

12. Create and Run a Listener for Oracle 11g

    The Tutorial Contains Detailed Instructions on Creating and Running Oracle 11g Database Listener.

13. How-to Create a Database for Oracle 11g

    Guide with Detailed Instruction 2 Create a Database for Oracle 11g.

After you have Access to 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 Managing, Start & Stop Oracle 11g R2 Database by SQLPlus Commands

SQLPlus Oracle 11g DB Quick-Start

Link to Detailed and Step-by-Step Visual Guide on Managing the Oracle 11g R2 Database by SQLPlus on Linux OpenSUSE.

Oracle 11g Database Troubleshooting Guides

• Oracle 11g Database Troubleshooting Guides I
• Oracle 11g Database Troubleshooting Guides II