Copyright © Ari Kuswanto
Design by Dzignine
Jumat, 18 Februari 2011

ORACLE 11g R2 Linux x86_64 Installation Guide on Redhat Enterprise Linux 5.4

Prprequisite Installation

a. RAM min 4G
HDD min 3.73 for Software and 1.48 for Data Files (Standard edition)

b. JRE or JDK file version 1.5 or above.

Install JDK file, the setup file can be copied from

//192.168.1.2/public/java/jdk-6u22-linux-x64_2.bin then enter the command

#./ jdk-6u22-linux-x64_2.bin

Don’t forget to setup the path environment for all user profile of Java home directory

For example, the following is the java version on 192.168.1.51

# java -version

java version "1.6.0_22"

Java(TM) SE Runtime Environment (build 1.6.0_22-b04)

Java HotSpot(TM) 64-Bit Server VM (build 17.1-b03, mixed mode)

c. RPMs files

Install RPM files as follow with the command :

#rpm –ivh rpm_file.rpm

The followings are the additional RPMs file to be needed by Oracle 11g R2 installation.

binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

compat-libstdc++-33-3.2.3 (32 bit)

elfutils-libelf-0.125

elfutils-libelf-devel-0.125

gcc-4.1.2

gcc-c++-4.1.2

glibc-2.5-24

glibc-2.5-24 (32 bit)

glibc-common-2.5

glibc-devel-2.5

glibc-devel-2.5 (32 bit)

glibc-headers-2.5

ksh-20060214

libaio-0.3.106

libaio-0.3.106 (32 bit)

libaio-devel-0.3.106

libaio-devel-0.3.106 (32 bit)

libgcc-4.1.2

libgcc-4.1.2 (32 bit)

libstdc++-4.1.2

libstdc++-4.1.2 (32 bit)

libstdc++-devel 4.1.2

make-3.81

numactl-devel-0.9.8.x86_64

sysstat-7.0.2

unixODBC-2.2.11 (32 bit)

unixODBC-2.2.11

unixODBC-devel-2.2.11 (32 bit)

unixODBC-devel-2.2.11

The RPMs file can be found in folder “server” of DVD Redhat Enterprise Linux 5.4 that we have.

II. Oracle 11gR2 Installation

Login as root into Redhat EL 5.

Add group installation and dba

# /usr/sbin/groupadd oinstall

# /usr/sbin/groupadd dba

Add user oracle

# /usr/sbin/useradd -g oinstall -G dba oracle

# passwd oracle

Login as “oracle” user into Redhat EL 5.

# su – oracle

Copy the zip installation file :

“linux.x64_11gR2_database_1of2.zip & linux.x64_11gR2_database_2of2.zip” into oracle home directory: /home/oracle

Use WinSCP to copy zip file from your windows xp into oracle home directory

Unzip the zip installation file :

$ unzip linux.x64_11gR2_database_1of2.zip

You will have “database” folder containing the installation oracle files.

Login as root into Redhat EL 5.

Edit and Setup Kernel Parameter

# vi /etc/sysctl.conf

Add the following line into sysctl.conf file

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

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 = 1048586

Save the file by command [Esc]:wq! [ENTER]

Reboot or Restart Computer to get an effect from new kernel setup

Setup Resources Limitation

Edit file resource limitation

#vi /etc/security/limits.conf

Add the following line into limits.conf file

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

Make Folder installation and change the directory the permission to “oracle” user software

# mkdir -p /u01/app/

# chown -R oracle:oinstall /u01/app/

# chmod -R 775 /u01/app/

Login as “oracle”user by type :

# su – oracle

Edit and setup your profile (bash profile)

$ vi .bash_profile

Add the following line into .bash_profile file

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

export ORACLE_SID=orcl

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

export ORACLE_OWNR=oracle

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

Relogin as “oracle” user to get an effect from .bash_profile.

$ exit

# su – oracle

Login through desktop of RHEL 5.4 then open the terminal window.

Install the Oracle Database by type the following command:

$cd database

$pwd

/home/oracle/database

$./runInstaller

“Good Luck”