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>
192.168.0.2 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 pam_limits.so
5- You must disable SELINUX. Edit /etc/selinux/config file to disable it.
$vi /etc/selinux/config
SELINUX=disabled
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
TMPDIR=$TMP; export TMPDIR
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
ORACLE_SID=DB11GR2; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
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/JRE:$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
fi
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
Talip Hakan Ozturk's ORACLE BLOG 