Monday, July 16, 2012

Oracle 10g R2 installation (RHEL 5.4 x64)

This articles describes the step-by-step installation procedure of Oracle 10g Release 2 (10.2.0.4) on RHEL 5.4 (x64) operating system.

1. Environment details
››  Operating System: RHEL 5.4 (x64)
››  Physical memory used: 4G
››  Swap memory used: 8G
››  Oracle Release 10g (10.2.0.4)
››  Hostname: rhel5401.shannura.com (192.168.1.4)
››  Database Name [DB_NAME]: 'dbuat01'
››  Database domain [DB_DOMAIN]: 'shannura.com'
Additional notes:
To determine the physical RAM, issue the following command:
$ grep MemTotal /proc/meminfo

To determine the size of the configured SWAP space, issue the following command:
$ grep SwapTotal /proc/meminfo

Swap memory used: 8G. However equal size can be assigned. For example,
Between 1024M and 2048M: 1.5 times the size of RAM
Between 2048M and 8192M: Equal to the size of RAM
More than 8192M: 0.75 times the size of RAM
2. Oracle Software dump

Download these files from Oracle site.

10201_database_linux_x86_64.cpio.gz
p6810189_10204_linux-86-64.zip


Unzip & extract the files
$ gunzip 10201_database_linux_x86_64.cpio.gz
$ cpio -idmv < 10201_database_linux_x86_64.cpio
$ unzip p6810189_10204_linux-86-64.zip
3. Configuring the host

i) Modify '/etc/hosts' and must contain a fully-qualified name of the host server.

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

ii) Setting kernel parameters

Add the following entries in '/etc/sysctl.conf' file.

kernel.shmmax = 68719476736 /* it's usually, 1/2 of physical RAM */
kernel.shmall = 4294967296 /* it's usually, <physical RAM> / <pagesize> */
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576


Make the changes as permanent using:
$ /sbin/sysctl -p
Add the following lines to '/etc/security/limits.conf' file.

*     soft     nproc      2047
*     hard     nproc      16384
*     soft     nofile     4096
*     hard     nofile     65536

Add the following line to '/etc/pam.d/login' file.

session     required     pam_limits.so

Disable secure Linux by editing the '/etc/selinux/config' file.

SELINUX=disabled
4. Dependency Package installation
Mount the RHEL 5.4 DVD or .iso image
$ mount /dev/cdrom /mnt
$ vi /etc/yum.repos.d/rhel-debuginfo.repo
/etc/yum.repos.d/rhel-debuginfo.repo
[rhel-debuginfo]
name=Red Hat Enterprise Linux $releasever - $basearch - Debug
#baseurl=ftp://ftp.redhat.com/pub/redhat/linux/enterprise/$releasever/en/os/$bas
earch/Debuginfo/
baseurl=file:///mnt/Server
enabled=1
gpgcheck=0
#gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

This ensures that the mounted DVD will be used as package repositories. Then, go ahead and install the following minimum recommended packages.
binutils-2.17.50.0.6-2 (x86_64)
compat-db-4.2.52-5.1 (x86_64)
compat-libstdc++-296-2.96-138 (i386)
compat-libstdc++-33-3.2.3-61(x86_64)
compat-libstdc++-33-3.2.3-61 (i386)
control-center-2.16.0-14 (x86_64)
gcc-4.1.1-52 (x86_64)
gcc-c++-4.1.1-52 (x86_64)
glibc-2.5-12 (x86_64)
glibc-2.5-12 (i686)
glibc-common-2.5-12 (x86_64)
glibc-devel-2.5-12 (x86_64)
glibc-devel-2.5-12 (i386)
glibc-headers-2.5-12 (x86_64)
ksh-20060214-1.4 (x86_64)
libaio-0.3.106-3.2 (x86_64)
libgcc-4.1.1-52 (i386)
libgcc-4.1.1-52 (x86_64)
libgnome-2.16.0-6 (x86_64)
libgnomeui-2.16.0-5 (x86_64)
libgomp-4.1.1-52 (x86_64)
libstdc++-4.1.1-52 (x86_64)
libstdc++-devel-4.1.1-52 (x86_64)
libXp-1.0.0-8 (i386)
libXtst-1.0.1-3.1(i386)
make-3.81-1.1 (x86_64)
sysstat-7.0.0-3 (x86_64)

For example,
$ yum install binutils-2.17.50.0.6-2 (x86_64)
5. Adding groups and user
Adding groups and user:
$ groupadd oinstall
$ groupadd dba
$ groupadd oper
$ useradd -g oinstall -G dba ora10g
$ passwd ora10g
6. Creating Oracle software directory structure

Create the directories in which the Oracle software will be installed.
Oracle directory structure:
$ mkdir -p /u01/app/oracle/product/10.2.0/db_1
$ chown -R ora10g:oinstall /u01
7. Oracle environment settings

Login as 'ora10g' user and add the following lines at the end of '~/.bash_profile'
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
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

if [ $USER = "oracle" ]; then
   if [ $SHELL = "/bin/ksh" ]; then
      ulimit -u 16384
      ulimit -n 65536
   else
      ulimit -u 16384 -n 65536
   fi
fi
8. Starting installation

Login as root and issue the following command:
GUI server access
$ xhost +rhel5401  /* rhel5401 is the machine name */

Edit '/etc/redhat-release' file, replace the current release information ('Red Hat Enterprise Linux Server release 5.4 (Tikanga)' with the following:

redhat-4

Login as 'ora10g' user in GUI mode. Open the terminal and export the following DISPLAY environment variable.
Setting DISPLAY environment:
$ DISPLAY=rhel5401:0.0; export DISPLAY

Logout and login again as 'ora10g' in GUI mode. Start the installation and proceed with the desired configurations.
Execute the script:
$ ./runInstaller -ignoreSysPrereqs
9. Post installation

Modify '/etc/redhat-release' file and restore the original release information.

Red Hat Enterprise Linux Server release 5.4 (Tikanga)

Add the Oracle SID and it's home in '/etc/oratab' file.

DBUAT01:/u01/app/oracle/product/10.2.0/db_1:N
Top
Last modified: Jul 16, 2012 13:30 IST

No comments: