Monday, February 2, 2015

Oracle Database 11g R2 (11.2.0.1) on SUSE Linux Enterprise Server 11




Install Oracle Database 11g R2 (11.2.0.1) on SUSE Linux Enterprise Server 11

By Wisam Adel on 02 Feb 2015


1- install Linux Suse interprise 11 with below  Hardware Requirements

Memory :

Recommended: 2 GB of RAM or more

Swap :

Minimum:  twice size of the Memory

Network :

define static ip


2-after installation Logging In to the System as root


Install below Required Packages :

binutils-2.19
gcc-4.3
gcc-c++-4.3
glibc-2.9
glibc-devel-2.9
ksh-93t
libstdc++33-3.3.3
libstdc++43-4.3.3_20081022
libstdc++43-devel-4.3.3_20081022
libaio-0.3.104
libaio-devel-0.3.104
libgcc43-4.3.3_20081022
libstdc++-devel-4.3
make-3.81
sysstat-8.1.5
unixODBC-2.2.12 or later
unixODBC-devel-2.2.12 or later
unixODBC-32bit-2.2.12 (32-bit) or later

to install the packages goto yast2 ==> online update


Search for each rpm and check it to install




Installing SELinux Packages and modifying GRUB


  1. Log in to your server as root and start YaST2.
  2. Select Software+Software Management

  1. Select View+Patterns and select the entire C/C++ Compiler and Tools software category for installation.
  2. Select View+Search and make sure that Search in Name, Keywords and Summary are selected. Now enter the keyword selinux and click Search. You now see a list of packages.
  3. Make sure that all the packages you’ve found are selected and click Accept to install them.


After installing the SELinux packages, you have to modify the GRUB boot loader. To do this, from YaST selectSystem > Boot loader. On the Section Management tab, you'll now see the current GRUB configuration. Select the label that starts with SUSE Linux Enterprise Server 11 SP2 and click Edit. Now select the line that contains the Optional Kernel Command Line Parameters and add the following to the end of this line:security=selinux selinux=1 enforcing=0

Group and users :


# groupadd oinstall
# groupadd dba
# groupadd oper

# useradd -m -g oinstall -G dba,oper -s /bin/bash oracle

# passwd oracle


Kernal Parameters :

# vi /etc/sysctl.conf

and add or amend the following lines :

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


enter the following command to ensure that the system reads the /etc/sysctl.conf file when it restarts:

# /sbin/chkconfig boot.sysctl on

Enter the following command to change the current values of the kernel parameters:

# /sbin/sysctl -p



 where the oinstall group GID is 1000:

# echo 1000 > /proc/sys/vm/hugetlb_shm_group

#vi /etc/sysctl.conf, and add this line

vm.hugetlb_shm_group=1000

# /sbin/sysctl -p


Limits :

# vi  /etc/security/limits.conf

Add the following lines 
oracle              soft    nproc   16384
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240

Create The Directories :


# mkdir -p /u01/app/
# chown -R oracle:oinstall /u01/app/
# chmod -R 775 /u01/app/
# mkdir -p /u01/app/tmp


Bash Profile

#vi /home/oracle/.profile

and add the following lines  :(note : amend "orcl" and "hostname.localdomain:  )


==========================
# Oracle Settings
TMP=/u01/app/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=hostname.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID

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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
============================

3- Install Database ( oracle 11gr2 )

- login as oracle user

- copy zip files to /u01/app/tmp and

- extract the zip files

- login to setup folder

- #./runInstaller

- follow screens to finish setup