Oracle Database 11g R2 Preinstallation Requirements on Linux

We learned installation of Oracle Enterprise Linux in previous article . You can not install Oracle by clicking Next Next button  on Linux :). There are a number of parameters to be set on Linux. In this article we will prepare Oracle Enterprise Linux to the installation of Oracle Database 11gR2. I will tell you step by step what you need to do to this . Unless otherwise specified all of the following process steps must be made with user “root” .

1- Edit hosts file.

$vi /etc/hosts

<IP-address> <fully-qualified-machine-name> <machine-name> ora11gr2.localdomain ora11gr2

2- Set kernel parameters in sysctl.conf file. These values are suggested by Oracle. According to your server, you can change some values.

$vi /etc/sysctl.conf

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

The server must be restarted for applying the changes. Or you can do that with following command.

$/sbin/sysctl –p

– kernel.shmmax  parameter must be equal to half of the physical memory
– kernel.shmall  paramter must be equal to page size.

3- Set limit values in limits.conf file.

$vi /etc/security/limits.conf

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

4- Open /etc/pam.d/login file and add following line.

$vi /etc/pam.d/login

session required

5- You must disable SELINUX. Edit /etc/selinux/config file to disable it.

$vi /etc/selinux/config

6- RPM packages which are required by Oracle must be installed .  You can check needed rpm packages with following command;

$rpm -q binutils compat-db compat-libstdc++-33 libgcc glibc glibc-devel glibc-headers gcc gcc-c++ libgcc libstdc++ cpp make libaio ksh elfutils-libelf make sysstat libaio libaio-devel setarch libXp –qf “%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n”|sort

If a rpm is not installed then you can install it from Oracle DVD/ISO

$cd /media/cdrom/Server
$rpm -ivh binutils-2.*

7- Create oracle operating system user and groups.

– First create groups
$ /usr/sbin/groupadd -g 501 oinstall
$ /usr/sbin/groupadd -g 500 dba
– Create directory which will be used for oracle software installation. I create default directory. You can change it.
$ mkdir -p /u01/app/oracle/product/11.2.0/db_1
– Create oracle operating system user.
$ /usr/sbin/useradd -m -u 501 -g oinstall -G dba -d /u01/app/oracle/product/11.2.0/db_1 oracle
– Set owner of oracle base directory as oracle user .
$ chown -R oracle:oinstall /u01
– Give permissions to this directory.
$ chmod -R 775 /u01
– Specify password of oracle user.
$ passwd oracle

8- Login as oracle user and edit .bash_profile file to add following lines.

$vi .bash_profile
TMP=/tmp; export TMP

ORACLE_HOSTNAME=11gr2.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/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

After that save the bash profile file and run it to set operating system environment variables.

$. .bash_profile
Our Oracle Enterprise Linux server is ready to install Oracle database.

Oracle Enterprise Linux 5 sunucumuz Oracle Veritabanı kurulumuna hazırdır. In the next article I will write about step by step installation of Oracle Database 11g R2.

Talip Hakan ÖZTÜRK


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s