Oracle AppsDBAs World: Installing Oracle Database 9i (9.2.0.8) on RHEL 4

Prerequisites to Install Oracle Database 9i (9.2.0.8) on RHEL 4
-------------------------------------------------------------------------

Things to check before installation:
------------------------------------------
Prerequisite Red Hat Packages:
---------------------------------------
Install below Red Hat RPM packages:

make-3.80-6.EL4
compat-db-4.1.25-9
compat-gcc-32-3.2.3-47.3
compat-gcc-32-c++-3.2.3-47.3
compat-oracle-rhel4-1.0-5
compat-libcwait-2.0-2
compat-libgcc-296-2.96-132.7.2
compat-libstdc++-296-2.96-132.7.2
compat-libstdc++-33-3.2.3-47.3
gcc-3.4.6-3
gcc-c++-3.4.6-3
gnome-libs-1.4.1.2.90-44.1
gnome-libs-devel-1.4.1.2.90-44.1
libaio-devel-0.3.105-2
libaio-0.3.105-2
openmotif21-2.1.30-11.RHEL4.6
xorg-x11-deprecated-libs-devel-6.8.2-1.EL.13.37.5
xorg-x11-deprecated-libs-6.8.2-1.EL.13.37.5

Oracle Supplied Compat Packages:
----------------------------------------
compat-oracle-rhel4-1.0-5.i386.rpm
compat-libcwait-2.0-2.i386.rpm

Oracle Software:
--------------------
Download below files
ship_9204_linux_disk1.cpio.gz
ship_9204_linux_disk2.cpio.gz
ship_9204_linux_disk3.cpio.gz

Patches:
--------------
p4198954_21_LINUX.zip
p4547809_92080_LINUX.zip
p5632264_92080_LINUX.zip

Check Installed Required RPMs
-------------------------------------
rpm -q make compat-db compat-gcc-32 compat-gcc-32-c++ compat-oracle-rhel4 compat-libcwait compat-libgcc-296 compat-libstdc++-296 compat-libstdc++-33 gcc gcc-c++ gnome-libs gnome-libs-devel libaio-devel libaio openmotif21 xorg-x11-deprecated-libs-devel xorg-x11-deprecated-libs

If any of packages are not installed, Download and intsall that packages using below command
rpm -ivh (or)Uvh packagename --nodeps
-ivh – to install packages
-Uvh – to upgrade packages
-- nodeps to uncheck dependencies.

Install oracle supplied packages:
-------------------------------------------

[root@csd u01]# cd 4198954/
[root@csd 4198954]# rpm -Uvh compat-oracle-rhel4-1.0-5.i386.rpm compat-libcwait-2.0-2.i386.rpm
Preparing... ########################################### [100%]
cat: /etc/ld.so.preload: No such file or directory
1:compat-libcwait ########################################### [ 50%]
2:compat-oracle-rhel4 ########################################### [100%]
[root@deskpro 4198954]#

Create USER and GROUPS:
--------------------------------

[root@csd ~]# groupadd dba
[root@csd ~]# groupadd oinstall
[root@csd ~]# useradd -c "Oracle software owner" -g oinstall -G dba oracle
[root@csd ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@csd 4198954]#

Create Oracle Software Directory:
-----------------------------------------

[root@csd ~]# mkdir -p /u01/app/oracle/product/9.2.0
[root@csd ~]# chown -R oracle.oinstall /u01
[root@csd ~]# chmod -R 775 /u01

Set Kernel Parameters, File Handlers, and Limits:
-------------------------------------------------------
Adding these parameters to /etc/sysctl.conf will take effect only after reboot. To make this effective immediately, issue the following command

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 1073741824
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536

Shell Limits:
--------------------
Login as root, and add below lines to /etc/security/limits.conf
oracle soft nofile 63536
oracle hard nofile 63536
oracle soft nproc 16384
oracle hard nproc 16384
Add soft and hard limit to ~oracle/.bash_profile
ulimit -n 63536
ulimit -u 16384

Create Swap Space:
-------------------------
root@csd ~]# grep MemTotal /proc/meminfo
MemTotal: 385956 kB
[root@csd ~]# cat /proc/swaps
Filename Type Size Used Priority
/dev/hda2 partition 1048468 160 -1

Here is the command to create temporary swap space.
[root@csd ~]# dd if=/dev/zero of=tmpswap bs=1k count=900000
900000+0 records in
900000+0 records out
[root@csd ~]# chmod 600 tmpswap
[root@csd ~]# mkswap tmpswap
Setting up swapspace version 1, size = 921595 kB
[root@csd ~]# swapon tmpswap

Setup Oracle Environment Variables:
-------------------------------------------
Add below lines to ~oracle/.bash_profile
export LD_ASSUME_KERNEL=2.4.19
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=db9i1
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
Unpack Oracle Software Archives:

[oracle@csd ~]$ gunzip ship_9204_linux_disk1.cpio.gz ship_9204_linux_disk2.cpio.gz ship_9204_linux_disk3.cpio.gz

[oracle@csd ~]$ cpio -idmv < ship_9204_linux_disk1.cpio
[oracle@csd ~]$ cpio -idmv < ship_9204_linux_disk2.cpio
[oracle@csd ~]$ cpio -idmv < ship_9204_linux_disk3.cpio
[oracle@csd ~]$ chown -R oracle.dba Disk1/ Disk2/ Disk3/

Verify X-Windows:
-----------------------
Execute the below command
[oracle@csd ~]$ xclock
If you don’t see a graphical clock on the console then, Issue the below command in terminal
[oracle@csd ~]$ echo "DISPLAY=localhost:0.0;export DISPLAY"
[oracle@csd ~]$ source .bash_profile
[oracle@csd ~]$ xclock

Starting Oracle Universal Installer:
--------------------------------------------
Execute the below command to start the installation
[oracle@csd ~]$ cd Disk1/
[oracle@csd Disk1]$ ./runInstaller

posted by Senthil Kumaran @ 11:32 PM

0 Comments: