Step by Step Instructions on How we can install Oracle 11g Release 2 on Redhat 5 Linux.

1. Log in to the Linux PC with the Root Credentials and Let’s Begin: 

a.       Insert the Redhat Linux CD, Open the Terminal and Install the Following Packages by going to the path directed as shown on the Screen:

b.       While in the Sever Directory Run these commands one by one or Copy these commands and paste them on the terminal while at the Server Directory:

  

c.       After Copying the RPM commands paste them on the terminal and Observe how the packages are installed:

2. The Second task is to ensure we go to the to a file “sysctl.conf ”  under the path “/etc/sysctl.conf “  and edit it using GEDIT Program:

Lines to add on the sysctl.conf :

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

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

3. Run the Following Command to ensure the System Parameters are put into action:

“/sbin/sysctl -p | sort “

4. Next, Find the “limits.conf “ file which is located under the path “/etc/security/limits.conf”.

Add the Following Lines:

oracle              soft    nproc   2047

oracle              hard   nproc 16384

oracle              soft    nofile   1024

oracle              hard  nofile   65536

oracle              soft    stack    10240

5. Next, Find the “login” file under the path “/etc/pam.d/login” and: 

Add the following lines:

session            required           /lib/security/pam_limits.so

6. Create the Following Groups and the User that will be used to install Oracle Database 11g Release 2:

groupadd oinstall

groupadd dba

groupadd oper

groupadd asmadmin

7. Create a User to be used to Install Oracle Database the username for the account will be “Oracle”:

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

8. Set the Password for the User Oracle:

passwd oracle

9. Create the following Directories that will be used as Oracle Home i.e. where Oracle Software will be installed and provide ownership and full permission to oracle user o those folders.

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

chown -R oracle:oinstall /u01

chmod -R 775 /u01

10. After doing all that, Logout as root and log in as Oracle to verify the user has been created, and after that log out again and login as root to finalize the last processes.

11. Go to the Oracle’s Home directory and add the below lines to the file .bash_profile which is located under the path </home/oracle/.bash_profile> :

Please make sure you change the Values for ORACLE_HOSTNAME to match the machine name and ORACLE_UNQNAME to match the database name that you will use.

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=PC1; export ORACLE_HOSTNAME

ORACLE_UNQNAME=ORCL; 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=ORCL; 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

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

12. After doing all that copy the compressed Oracle Database from your storage device to Oracle’s Desktop so that Oracle can login and begin the installation.

13. Provide all the Permissions (read, write and Execute) for user Oracle to be able to access the folder and execute any executable files in it.

14. After all that lets login as user oracle and begin the Decompression of the Oracle 11g R2 Database before beginning the installation. Please note that after decompressing all the files, they will will create the database folder where all the installation files will be in it.

After decompressing the database files <linux_11gR2_database_1of2 and linux_11gR2_database_2of2> enter to the database folder and let’s begin the Oracle database installation by launching the Oracle Universal Installer:

Launch the runInstaller to bring up the Oracle Universal Installer:

After the OUI to pop up we will start with the Configure Security Updates Section.

Since we are not in the Production enviroment the Security Updates will not be necccesary. Untick the selection of of “I wish to receive security updates via Oracle Support” and proceed with Next >> 

Select Yes on the Warning dialog box of the “Email Address not Specified” and then proceed:

On the Next Phase select Create and Configure a database for Oracle to install its software and create the database and then Select Next > :

On the System Class Category Select the Server Class option if you are installing it on a server Machine:

On the Grid Option select the Single Instance Database Installation then Select Next >>

On the Install type Select the Advanced Install type and then Select Next >>

On the Product Languages Select English and the proceed by Selecting Next >>

On the Database Editions select the Enterprise Edition then Select Next >>

In the Installation Location Folder make sure you specify the ORACLE_HOME and ORACLE_BASE Location as specified during redhat preparations:

On the Create Inventory Section leave default selections and then select Next:

On the Configuration Type select the General Purpose /Transaction Processing option then select Next >>

On the Database Identifiers, provide your database name as you prefer, for me I will leave its default name as ORCL :

On the Configuration Option Leave every option default but Select the Sample Schema Tab and ensure that create database with Sample schema is selected and then proceed by selecting Next >>

On the Management Option Leave the Default Option and then Select Next >>

On the Database Storage Section, make selection of the File System and ensure the path to where the datafiles will be stored is properly specified :

On the Backup and Recovery Option, Leave the Option of Do Not Enable Automated Backups since it’s among the modules that we will look on how we can do Backups and Recovery:

On the Schema Password, since we are in the Learning Environment and not in the Production Environment make selection of the use the same password for all accounts:

On the Operating System Groups leave the default options and proceed by selecting Next >>

After that the Computer will be performing a prerequisite check before beginning installation then select Finish for Oracle to Begin Installation:

After the Installation of the Oracle Software and the Creation of the Database, the Database Configuration will bring out the Below Dialog Box ,  

Select the Password Management button and unlock the Users HR and SCOTT by unticking their selection and providing the password you desire and then Select OK:

After that Oracle will bring the Execute Configuration Scripts which requires to open another Terminal and Login as root and run those scripts:

After running the Scripts as shown on the terminal Above return back to the Execute Configuration action Scripts and Select OK and the below screen will be as shown below :

After all that close all the windows and open another Terminal to add some of the Variables on the .bashrc file located at the Oracle’s home folder:

After doing all that you can now Connect to the Database using SQLPLUS as shown below : 

For more Information on how you prepare your linux machine before installing Oracle 11G Release 2 go to the Link Below : 

http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1110