Installation of Oracle 10g in RHEL 4

To isntall Oracle Database 10g Release 2 (10.2.0.1) on Red Hat Enterprise Linux 4 (RHEL4.6), follow the steps below: here I am using Linux as as virtual machine.

Download Software

Unpack Files

Check Memory and Swap

Hosts File

Set Kernel Parameters

Setup

Installation

Post Installation

Open VM Workstation, at home click on New Virtual Machine.

Select the location of Linux S/W 

Enter username and password(this password would be to root user also) 

Select the location to install Linux or create a new folder.

Specify the size of the disk for linux installation. I am using 20gb disk size.

Customize your machine, mainly Ram. I use 2048mb of Ram. 

Click finish, linux installation automatically starts, after completion enter username and password.

Download the 10201_database_linux32.zip from oracle site and copy it to one of the folders in linux.

Unzip the files based on the space available in the drive.

Check Memory, temp and Swap spaces

To check the size of physical memory, execute:

grep MemTotal /proc/meminfo

To check the size of swap space, execute:

grep SwapTotal /proc/meminfo

To check the space in /tmp, run:

$ df /tmp

Hosts File

The "/etc/hosts" file must contain a fully qualified name for the server.

<IP-address> <fully-qualified-machine-name> <machine-name>

#ifconfig

#hostname

Copy and substitute the IP address to /etc/hosts file

Set Kernel Parameters

Add the following lines to the "/etc/sysctl.conf" file.

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default=262144

net.core.rmem_max=262144

net.core.wmem_default=262144

net.core.wmem_max=262144

 

Run the following command to change the current kernel parameters.

/sbin/sysctl -p

Add the following lines to the "/etc/security/limits.conf" file.

   *               soft    nproc   2047

   *               hard    nproc   16384

   *               Soft    nofile 1024

   *               hard    nofile 65536

Add the following line to the "/etc/pam.d/login" file, if it does not already exist.

session    required     pam_limits.so

Disable secure Linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.

SELINUX=disabled

 Install the following packages.

To check the RPMs, run:

rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs \

libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio

Packages name:-

  binutils-2.15.92.0.2-10.EL4

  compat-db-4.1.25-9

  control-center-2.8.0-12

  gcc-3.4.3-9.EL4

  gcc-c++-3.4.3-9.EL4

  glibc-2.3.4-2

  glibc-common-2.3.4-2

  gnome-libs-1.4.1.2.90-44.1

  libstdc++-3.4.3-9.EL4

  libstdc++-devel-3.4.3-9.EL4

  make-3.80-5

  pdksh-5.2.14-30

  sysstat-5.0.5-1

  xscreensaver-4.18-5.rhel4.2

Install the following packages in order to avoid dependency conflicts(these packages are in the Linux Red Hat Software)

rpm -Uvh glibc-kernheaders-2.4-9.1.100.EL.i386.rpm

rpm -Uvh glibc-headers-2.3.4-2.39.i386.rpm

rpm -Uvh glibc-devel-2.3.4-2.39.i386.rpm

rpm -Uvh gcc-3.4.6-9.i386.rpm

rpm -Uvh libstdc++-devel-3.4.6-9.i386.rpm

rpm -Uvh gcc-c++-3.4.6-9.i386.rpm

rpm -Uvh sysstat-5.0.5-16.rhel4.i386.rpm

rpm -Uvh libaio-0.3.105-2.i386.rpm

rpm -Uvh libaio-devel-0.3.105-2.i386.rpm

Create the new groups and users.

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba oracle

passwd oracle

Create the directories in which the Oracle software will be installed.

mkdir -p /home/app/oracle/product/10.2.0/db_1

chown -R oracle.oinstall /home

Login as root and issue the following command.

xhost +

Login as the oracle user and add the following lines at the end of the ".bash_profile" file.

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/home/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME

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

#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

if [ $USER = "oracle" ]; then

  if [ $SHELL = "/bin/ksh" ]; then

    ulimit -p 16384

    ulimit -n 65536

  else

    ulimit -u 16384 -n 65536

  fi

fi

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

$DISPLAY=:0.0; export DISPLAY           

$XCLOCK

                                                              To be continued in the next post