Wednesday, November 26, 2008

Oracle 10gR2 installation on RHEL5

Oracle 10gR2 installation on RHEL5.X

1) System Memory
# grep MemTotal /proc/meminfo -- At least 512Mb

2) Swap Space
# grep SwapTotal /proc/meminfo
Up to 512 MB 2 times the size of RAM
Between 1024 MB and 2048 MB 1.5 times the size of RAM
Between 2049 MB and 8192 MB Equal to the size of RAM
More than 8192 MB 0.75 times the size of RAM

3) Disk space Requirement
# df -h
400 MB of disk space in the /tmp directory
Between 1.5 GB and 3.5 GB of disk space for the Oracle software

4) Kernel Version
# uname -r
The system must be running 2.6.18-8 kernel version or a later.

5) Required Packages

i) gcc-c++-4.1.1-52.el5.x86_64.rpm and all its dependent packages.
The dependent packages are:
libstdc++-devel-4.1.1-52.el5.x86_64.rpm
glibc-headers-2.5-12.x86_64.rpm
glibc-devel-2.5-12.x86_64.rpm
libgomp-4.1.1-52.el5.x86_64.rpm
gcc-4.1.1-52.el5.x86_64.rpm
ii) glibc-devel-2.5-12.i386.rpm
iii) compat-libstdc++-33-3.2.3-61.x86_64.rpm
iv) compat-libstdc++-33-3.2.3-61.i386.rpm
v) compat-libstdc++-296-2.96-138.i386.rpm
vi) libXp-1.0.0-8.i386.rpm
vii) sysstat-7.0.0-3.el5.x86_64.rpm
NOTE: i386 packages might require the --force option during installation if the 64-bit version of the same package is already installed. For example, "rpm -ivh --force glibc-devel-2.5-12.i386.rpm" may be required.

6) Set the kernel parameters

Add the following the lines in the file /etc/sysctl.conf
kernel.shmmni = 4096
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
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 262144 262144 262144

To place these changes into effect, execute the command
# sysctl -p

7) Create Oracle user and groups
# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle
# passwd oracle

8) Create the required directories for Oracle database and change the ownership

# mkdir -p /u01/app/oracle -- ORACLE_BASE
# chown -R oracle:oinstall /u01/app/oracle

9) Set the session limits for Oracle user

Add the following lines to the /etc/security/limits.conf file
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Add the following line in the /etc/pam.d/login file
session required pam_limits.so

Add the following lines to the /etc/profile.
-- This assumes that oracle user is using bash shell which is given by default.
-- Change this accordingly if the oracle user has a different shell
if [ $USER = "oracle" ]; then
ulimit -u 16384
ulimit -n 65536
fi

10) Configure the Oracle user's environment

For example, if oracle user is using bash shell, and has the home directory as /home/oracle,
The following lines to be added to /home/oracle/.bash_profile
export ORACLE_BASE=/u01/app/oracle

11) Invoking OUI to install database software
-- Install Software Only
Login as Oracle User
$ ./runInstaller -ignoreSysPrereqs

12) Invoking OUI to install companion products on the same ORACLE_HOME
$ ./runInstaller -ignoreSysPrereqs

13) Invoking OUI to install Latest Patch Set on the ORACLE_HOME
$ ./runInstaller -ignoreSysPrereqs

14) Set ORACLE_HOME and ORACLE_SID on _bash_profile

15) Run dbca to proceed with database creation


No comments:

Post a Comment