Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Thread Rating:
  • 10 Vote(s) - 2.4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle Database 11g on Enterprise Linux 5 and CentOS 5
This articles covers the Installation of Oracle Database 11g Release 2 on Enterprise Linux 5 and Suse 11.
Oracle 11g Release 2 launched in August 2009. Now, the product is available on Linux platform. There are almost 400 aditional functionality added by Oracle 11g. After going through the Oracle webcast 11g Release 2, I feel Oracle 11g Rel. 2 more focus on High Availability(easy RAC installation and implementation),Compressing Data,Security,etc.

11g Release 2 required minimum 1gb RAM for the installation. I would recommend minimum 4gb ram will be ideally better. Swap should have double of physical ram.

I recommend the following Server Configuration:

Intel Xeon Processor W5580 3.20ghz
L3 8mb Cache
1 Quad Core
4 to 8gb Ram (an ideal configuration) .
146gb HDD (default) - This configuration can be changed, based on various factors.

The following packages is mandatory for Enterprise Linux : GNOME Desktop Environment ,Graphical Internet, X Window System ,Editors , Development Tools ,Server Configuration Tools,System Tools and Administration Tools.

You can download the software, subject to Oracle Licensing.


Standard Edition One – support upto 2 cpu
Standard Edition – support upot 4 cpu
Enterprise Edition – unlimited.
( Linux x86 | Disk 2(2.1 GB)

Set the Linux Kernal Parameters:
Linux Kernel Parameters

What is the Shared Memory ( reference with various linux/unix sites for these parameters.):

The shared memory will hve huge impact on Oracle Performance. So very carefully to be handled.

Shared memory allows processes to access common structures and data by placing them in shared memory segments. It's the fastest form of IPC (Interprocess Communication) available since no kernel involvement occurs when data is passed
between the processes.

Oracle uses shared memory segments for the SGA (Shared Global Area) which is an area of memory that is shared by all Oracle background and foreground processes.

Setting SHMMAX Parameter

This parameter defines the maximum size in bytes for a shared memory segment.
Since the SGA is comprised of shared memory, SHMMAX can potentially limit the size of the SGA.

Setting SHMMNI Parameter
This parameter sets the maximum number of shared memory segments system wide.

Setting SHMALL Parameter
This parameter sets the total amount of shared memory in bytes that can be used at one time on the system.

The SEMMSL Parameter
This parameter defines the maximum number of semaphores per semaphore set.
Oracle recommends to set SEMMSL to the largest PROCESSES init.ora parameter of any database on the Linux system.

The SEMMNI Parameter
This parameter defines the maximum number of semaphore sets in the entire Linux system.

The SEMMNS Parameter
This parameter defines the total number of semaphores (not semaphore set) in the entire Linux system.

The SEMOPM Parameter
This parameter defines the maximum number of semaphore operations that can be performed per [font="]semop(2)[/font] system call.

Setting File Handles
The maximum number of file handles denotes the maximum number of open files that you can have on the Linux system.

Setting System Wide Limit for File Handles

The value in
/proc/sys/fs/file-max sets the maximum number of file handles or open files that the Linux kernel will allocate. When you get error messages about running out of file handles, then you might want to raise this limit.
Change the parameters:

Copy sysctl.conf
cp sysctl.conf

Cd /etc

Vi sysctl.conf

Add the following:
kernel.shmmax = 2147483648
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536 # 512 * PROCESSES
net.ipv4.ip_local_port_range = 1024 65000

Press Esc :wq

Change the Hosts File Entry


Cp hosts hostsold

Vi hosts
IP-address Machinename.domainname Hostname

Press Esc and :wq
Go to /etc/security (cd /etc/security)
Vi limits.conf
Add or change /etc/security/limits.conf file:
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
to save Esc :wq

Go to /etc/pam.d (cd /etc/pam.d)
Vi login
Add or change line to the /etc/pam.d/login file

session required
session required /lib/security/
to save Esc :wq

Very important Steps:
On secure linux has to be disabled:
Go to /etc/selinux(cd /etc/selinux)
Vi config Change or add
to save Esc :wq

The following packages(rpm) required for Enterprise Linux 5.0 on various cd’s :
Insert the cd
and mount the same
Go to cd /media/cdrom/Server (cd /media/cdrom/Server)
(carefully use –force and –nodeps)

rpm -Uvh binutils-
rpm -Uvh compat-libstdc++-33-3.2.3
rpm -Uvh elfutils-libelf-0.125
rpm -Uvh elfutils-libelf-devel-0.125
rpm -Uvh elfutils-libelf-devel-static-0.125
rpm -Uvh gcc-4.1.2
rpm -Uvh gcc-c++-4.1.2
rpm -Uvh glibc-2.5-24
rpm -Uvh glibc-common-2.5
rpm -Uvh glibc-devel-2.5
rpm -Uvh glibc-headers-2.5
rpm -Uvh kernel-headers-2.6.18
rpm -Uvh ksh-20060214
rpm -Uvh libaio-0.3.106
rpm -Uvh libaio-devel-0.3.106
rpm -Uvh libgcc-4.1.2
rpm -Uvh libgomp-4.1.2
rpm -Uvh libstdc++-4.1.2
rpm -Uvh libstdc++-devel-4.1.2
rpm -Uvh make-3.81
rpm -Uvh sysstat-7.0.2
rpm -Uvh unixODBC-2.2.11
rpm -Uvh unixODBC-devel-2.2.11

eject or unmount

Linux Enterprise Server 11 - SUSE:

rpm -Uvh binutils-2.19
rpm -Uvh gcc-4.3
rpm -Uvh gcc-c++-4.3
rpm -Uvh glibc-2.9
rpm -Uvh glibc-devel-2.9
rpm -Uvh ksh-93t
rpm -Uvh libstdc++33-3.3.3
rpm -Uvh libstdc++43-4.3.3_20081022
rpm -Uvh libstdc++43-devel-4.3.3_20081022
rpm -Uvh libaio-0.3.104
rpm -Uvh libaio-devel-0.3.104
rpm -Uvh libgcc43-4.3.3_20081022
rpm -Uvh libstdc++-devel-4.3
rpm -Uvh make-3.81
rpm -Uvh sysstat-8.1.5

Create user and groups
Adding Groups

groupadd oinstall
groupadd dba
groupadd asmadmin
Adding user and assign the group:
useradd -g oinstall -G dba,oper,asmadmin oracle
Add password for Oracle user
passwd oracle

I would like to light on the "asmadmin" group is used for ASM.
Make directories in which the Oracle Binary to be installed:

mkdir -p /data1/app/oracle/product/11/db_1
chown -R oracle:oinstall /data1
chmod -R 777 /data1

Shutdown or
reboot the machine

Login as Oracle
Change/add user enviroment
Go to /home/oracle
Vi .bash_profile
Add the following:
ORACLE_BASE=/data1/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1; export ORACLE_HOME
PATH=/usr/sbin:$PATH; export PATH

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
ulimit -u 16384 -n 65536
Press Esc key :wq

Log out

Login as Oracle user

Run Install
Set the Display first
export DISPLAY=hostname:0.0
Go setup Disk directory
Cd Disk1

Rest follow the GUI provided by Oracle
Thanks given by:

Possibly Related Threads...
Thread Author Replies Views Last Post
  Oracle RAC Upgrade from to Zishan Ali 2 2,326 05-08-2016, 10:25 PM
Last Post: Kashif Manzoor
  Oracle E-Business Suite on Oracle Cloud Kashif Manzoor 0 1,999 04-07-2016, 10:20 PM
Last Post: Kashif Manzoor
  Oracle ERP in the Cloud Pryia Rai 0 2,519 12-13-2015, 06:06 AM
Last Post: Pryia Rai
  How to Increase the size of a Linux LVM by expanding the virtual machine disk Kashif Manzoor 0 1,335 08-23-2015, 07:19 PM
Last Post: Kashif Manzoor
  Oracle R12- ABC Analysis Chandak Badri 0 2,040 08-17-2015, 06:02 PM
Last Post: Chandak Badri
  Query- How to check the Oracle database version Zishan Ali 0 1,410 08-16-2015, 11:35 PM
Last Post: Zishan Ali
  Recover database without archivelogs Zishan Ali 0 1,077 08-15-2015, 07:42 AM
Last Post: Zishan Ali
  Query to Check Tablespace Size and frees pace in Oracle Database Ahmad Mujeeb 0 1,728 06-25-2015, 07:07 PM
Last Post: Ahmad Mujeeb
  What is Enterprise Resource Planning (ERP) Chandak Badri 0 1,293 12-20-2014, 08:14 AM
Last Post: Chandak Badri
  Oracle Applications R12.2 Installation on Linux Sara Khan 0 4,453 12-20-2013, 06:01 AM
Last Post: Sara Khan

Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!