Oracle database 11g release 2 installation on suse and Enterprise Linux

Introduction

This article covers the Installation of Oracle Database 11g Release 2 on Enterprise Linux 5 and Suse 11.

Oracle 11g Release 2 was launched in August 2009. Now, the product is available on all platforms. There are almost 400 additional functionalities added by Oracle 11g. After going through the Oracle webcast 11g Release 2, I feel Oracle 11g Rel. 2 focuses more 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
• 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 are 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.
http://www.oracle.com/technology/software/products/database/index.html 

• Standard Edition One – support upto 2 CPU
• Standard Edition – support upto 4 CPU
• Enterprise Edition – unlimited
• (11.2.0.1.0)
• Linux x86 | Disk 1, Disk 2 (2.1 GB)

Change the parameters:

Copy sysctl.conf
cp sysctl.conf sysctl.confold
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.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
net.ipv4.ip_local_port_range = 1024 65000
Press Esc :wq

          Change the Hosts File Entry
               Cd /etc

               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     pam_limits.so
session    required     /lib/security/pam_limits.so
to save Esc :wq

Very Important Steps

Secure linux has to be disabled:

Go to /etc/selinux(cd /etc/selinux)
Vi config
Change or add
SELINUX=disabled
to save Esc :wq

The following packages(rpm) are required for Enterprise Linux 5.0 on various cds:

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-2.17.50.0.6
               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
groupadd oper

Adding user and assigning 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.2/db_1
chown -R oracle:oinstall /data1/app/oracle/product/11.2/db_1
chmod -R 777 /data1/

Shutdown or reboot the machine

• Login as Oracle
• Change/add user environment
• Go to /home/oracle
• Vi .bash_profile

Add the following:

ORACLE_HOSTNAME=machinename.domainname
ORACLE_BASE=/data1/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11/db_1; export ORACLE_HOME
ORACLE_SID=orcl11g; 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
Press Esc key :wq
 
Log out

Login as Oracle user

Run Install Steps

Set the Display first:

export DISPLAY=hostname:0.0

Or:

DISPAY=HOSTNAME:0.0
export DISPLAY

Go setup Disk directory

Cd Disk1
./runInstaller

Rest follow the GUI provided by Oracle.

Issue: 01. Both files(installation binary 1 and 2 should be 1 directory)

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-11-30_12-47-24AM. Please wait ...
Invalid source path '../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles' specified for unzip. Unzip command failed. Please check oraparam.ini and specify a valid source path.

mkdir /data1/Disk1
Copy both binaries to this /data1/Disk1Unzip