Installing Oracle 11g R2 on RHEL6 - 64 bit

Installing Oracle 11g R2 -64 bit

Initially When installing Red Hat 6 Its is required to have minimum redhat package modules(RPM) for installing the Oracle Base.Those packages may not come under the normal installation.So Special  RPM packages have to be  used to install Oracle.This package depends on the Linux version you use.

Oracle recommends that you do not customize the RPMs during installation
Oracle highly recommends deploying the Oracle Unbreakable Enterprise Kernel in your Linux environment.

This shows the pre-activities/OS level activities to be carried out before installing Oracle DB .

How to check whether package is installed or not

syntax      RPM    -q     package_name   #give the full name version not required

example   RPM    -q    gcc

Download and install required RPMs 

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)

else can be installed with YUM repository.

Above RPMs saved in a text file -- /tmp/rpm.txt

mount the CD (media) to the /media/RHEL6

create a  soft symbolic link 

  ln -s source destination

  ln -s /media/RHEL6 /tmp --create a link to /tmp folder

then create a repo file  vi /etc/yum.repos.d/localrepo.repo

insert following lines 

 [localrepo.repo]

 baseurl://filename (path) --/tmp folder

 gpgcheck=no

then in a terminal type 

 yum install -y `cat /tmp/rpm.txt`

create oracle user ,ORAInventory and OSDBA group for the user.

groupadd -g 500 oinstall  --g for a number 

groupadd -g 501 dba       --g for a number 

useradd -m-u 500 -g oinstall -G dba oracle -- -G sub groups apart from main group

set the password for oracle 

passwd oracle

check user oracle exist  -> id oracle

check user nobody exist  -> id nobody

if not exist add nobody  ->useradd nobody 

set sysctl.con setting  (startup, driver,kernal parameters) according to Oracle recommendations.

go in to /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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

for with out restarting the host.if  you want to apply changes execute 

sysctl -p 

To improve the performance of the Linux system Oracle recommends to set shell resource limits for  user oracle. hard and soft resource limits (discriptors,stacks) file located in /etc/security/limits.conf

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

Hardware Requirements 

Memory
          Minimum :1 GB
          Recommended : 2 GB

check the memory  syntax is #grep MemTotal /proc/meminfo

Install more memory if this does not have minimum required amount.

Relationship between installed RAM and configured Swap area.

RAM	Swap Space
Between 1 GB and 2 GB	1.5 times the size of the RAM
Between 2 GB and 16 GB	Equal to the size of the RAM
More than 16 GB	16 GB

Disk space requirements

1 GB in /temp folder in the file system 

syntax the diskspace df -h /temp

For major installation files

Installation Type	Requirement for Software Files (GB)
Enterprise Edition	4.7
Standard Edition	4.6

For  data files

Installation Type	Disk Space for Data Files (GB)
Enterprise Edition	1.7
Standard Edition	1.5

Minimum resolution is 1024 x 768 or higher.

Create directories and give permission
mkdir -p /u01/app/
chown -R oracle:oinstall  /u01/app/
chmode -R 775 /u01/app/

set umask on .bash_profile

su oracle
vi  .bash_profile

enter umask 022 to the file
compile it   using              .~/.bash_profile

Just before running run installer.
run   xhost  +
       xclock
                    on server machines
if it is remote machine
export DISPLAY=IP_REMOTE_MACHINE:0

Search  the .runInstaller  location of the CD
 and run it from the oracle home.
Do not go into the software folder.


go to bash profile of oracle and add following entries

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=mydb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
umask 022


compile the bash profile
.~ /.bash_profile

Automatically its create the DB and the Listner ,In case if that does not happen, please enter
1. dbca  for  database creation
2. netca for listner creation