Installing Oracle 10G on Centos 5 (32bit)

Creating Oracle User Account :

$ su - root
$ groupadd dba
$ groupadd oinstall
$ useradd -c "Oracle Software Owner" -g oinstall -G dba oracle
$ passwd oracle

Setting Oracle Environments

$ su - oracle
$ pwd #the directory has to be /home/oracle

use vi or nano to edit profile

$ nano .bash_profile

content of .bash_profile :

echo "Welcome to ORACLE Environment"

export ORACLE_BASE=/oracle</em></span>
export ORACLE_HOME=/oracle/product/10.1.0
export ORACLE_SID=oraclesid  #name of oracle instance service
export JAVA_HOME=/usr/java/jdk1.5.0_15 #Home directory for java (edit by yourself)
export PATH=$JAVA_HOME/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=/lib:$JAVA_HOME/lib:$ORACLE_HOME/lib:.

Creating Oracle Home Directory (as mention in .bash_profile)

$ su - root
$ mkdir /oracle

Change Ownership for Oracle Home Directory (/oracle)

$ chown -R oracle:oinstall /oracle

Check Installed RPMs (make sure all RPMs is Installed)

$ rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio compat-libstdc++-33 glibc-devel

Results :

binutils-2.17.50.0.6-14.el5
package compat-db is not installed
control-center-2.16.0-16.el5
gcc-4.1.2-48.el5
package gcc-c++ is not installed
glibc-2.5-49.el5_5.7
glibc-common-2.5-49.el5_5.7
package gnome-libs is not installed
libstdc++-4.1.2-48.el5
package libstdc++-devel is not installed
make-3.81-3.el5
package pdksh is not installed
package sysstat is not installed
package xscreensaver is not installed
libaio-0.3.106-5

.:: Install Package which not installed ::.

Install xorg-x11-deprecated-libs

$ yum install xorg-x11-deprecated-libs

Set Display to allow from any hosts

$ su - root
$ xhost +

Change RedHat Release

$ cp /etc/redhat-release /etc/redhat-release.orig
$ cat > /etc/redhat-release << EOF
$ Red Hat Enterprise Linux AS release 3 (Taroon)
$ EOF

After you are done with the Oracle10g installation, undo the changes you made to /etc/redhat-release

$ su - root</span><em>
$ cp /etc/redhat-release.orig   /etc/redhat-release

Checking Kernel Parameters (Important!)
To see all kernel parameters, execute:

$ su - root
$ sysctl -a

For Oracle10G, the following kernel parameters have to be set to values greater than or equal to the recommended values which can be changed in the proc filesystem:

shmmax  = 2147483648 (To verify, execute: cat /proc/sys/kernel/shmmax)
shmmni  = 4096 (To verify, execute: cat /proc/sys/kernel/shmmni)
shmall  = 2097152 (To verify, execute: cat /proc/sys/kernel/shmall)   (for 10g R1)
shmmin  = 1 (To verify, execute: ipcs -lm |grep “min seg size”)
shmseg  = 10 (It’s hardcoded in the kernel – the default is much higher)
semmsl  = 250 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $1}’)
semmns  = 32000 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $2}’)
semopm  = 100 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $3}’)
semmni  = 128 (To verify, execute: cat /proc/sys/kernel/sem | awk ‘{print $4}’)
file-max = 65536 (To verify, execute: cat /proc/sys/fs/file-max)
ip_local_port_range = 1024 65000 (To verify, execute: cat /proc/sys/net/ipv4/ip_local_port_range)

NOTE: Do not change the value of any kernel parameter on a system where it is already higher than listed as minimum requirement.

Edit /etc/sysctl.cont

$ nano /etc/sysctl.conf

add :

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.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Download / copy Oracle 10G Source Binary to Oracle User Directory (/home/oracle)
10201_database_linux_x86_64.cpio.gz

$ gunzip 10201_database_linux_x86_64.cpio.gz
$ cpio -idmv < 10201_database_linux_x86_64.cpio
$ cd database
$ ./runInstaller