Thursday, 20 October 2011

Step By Step Instructions on Installing Oracle 10g R2 32-bit

Pre-Installation Task
  NOTE: Installing Oracle 10g on RedHat EL4 works matching way as that of on Cent OS 4.
             Installing Oracle 10g on RedHat EL3 works matching way as that of on Cent OS 3.

Installing CentOS:

If you perform not have CentOS fitted on your pc, goto and download the advantageous isos. You can use under
lead to exact reproduce iso record on the disc storage invention from Linux lead line I use scanbus pick of cdrecord utility to pinpoint the invention id

which is employed to draft written knowledge on. 
[root@shree ~]# cdrecord -scanbus Cdrecord-Clone 2.01-dvd (i686-pc-linux-gnu) Copyright (C) 1995-2004 Jörg Schilling Note: This version is an unofficial (modified) version with DVD support Note: and therefore may have bugs that are not present in the original. Note: Please send bug reports or support requests to Note: The author of cdrecord should not be bothered with problems in this version. scsidev: 'ATA' devname: 'ATA' scsibus: -2 target: -2 lun: -2 Linux sg driver version: 3.5.27 Using libscg version 'schily-0.8'. cdrecord: Warning: using inofficial libscg transport code version (schily - Red Hat-scsi-linux-sg.c-1.83-RH '@(#)scsilinux-sg.c 1.83 04/05/20 Copyright 1997 J. Schilling'). scsibus1: 1,0,0 100) 'TOSHIBA ' 'DVD-ROM SD-M1502' '1012' Removable CD-ROM 1,1,0 101) 'SONY ' 'CD-RW CRX140E ' 'A1.0' Removable CD-ROM 1,2,0 102) * 1,3,0 103) * 1,4,0 104) * 1,5,0 105) * 1,6,0 106) * 1,7,0 107) * [root@shree ~]# cdrecord –v –pad speed=4 dev=1,1,0 /path/to/iso/file.iso
Please goto to get detailed information on installing CentOS.
Before you start installing Oracle10g software, please make sure that you have the below packages installed on your Linux box,
        else you will get error(s) during the installation process.


Please execute the below comand as root to make sure that you have this rpms installed. If not installed, then download them
from appropriate linux site.

rpm -q glibc glibc-common gcc gcc-c++ libstdc++ libstdc++-devel libaio \        binutils make compat-db gnome-libs pdksh sysstat
For Redhat EL3/CentOS 3, you need the below rpms.
rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c++ compat-libstdc++ \        compat-libstdc++-devel openmotif21 setarch libaio \ 
 Memory and swap Space:
Oracle Documents declares that you want a least 512MB of recollection and 1024MB of swap space (Double the amount of recollection if you have RAM greater than 2 gigs) to run Oracle  (9i and above)  Database on Linux. Well, I have supervised to productively run one 9i and 2 10g cases (one ASM and one regular) simultaneously on a solitary linux packing box with 512 MB of memory. You basically want to acclimatise the init.ora recollection factor for that.
[root@shree ~]# cat /proc/meminfo | grep Total MemTotal: 515768 kB HighTotal: 0 kB LowTotal: 515768 kB SwapTotal: 4192956 kB VmallocTotal: 499704 kB
If you do not have enough Swap Space, you can add extra temporary swap space.
[root@shree ~]# df Filesystem 1K-blocks Used Available Use% Mounted on /dev/hda5 40662492 5226432 33370508 14% / none 257884 0 257884 0% /dev/shm /dev/hdb1 9621848 3341000 5792072 37% /backup [root@shree ~]# mkdir /swap [root@shree ~]# cd /swap [root@shree swap]# dd if=/dev/zero of=extraSwap bs=1024 count=128000 128000+0 records in 128000+0 records out [root@shree swap]# chmod 600 extraSwap [root@shree swap]# ls -l extr* -rw------- 1 root root 131072000 Nov 28 14:16 extraSwap [root@shree swap]# mkswap extraSwap Setting up swapspace version 1, size = 131067 kB [root@shree swap]# swapon extraSwap [root@shree swap]# swapoff extraSwap
Kernel Parameters:
Oracle recommends that you set shared memory segment attributes as well as semaphores to the pursuing values.
If not set, database instance innovation will fail. I supplemental the pursuing rows to /etc/sysctl.conf file. Every OS process requires
semaphore where It waits on for the resources. For more on semaphore, please read the UNIX os documents.
 NOTE: If the existing worth for any parameter is higher than the worth recorded in this office desk, afterward do not change the worth of that parameter.

To suppose the existing setting in the seed, please exercise the on the floor heading down command.
/sbin/sysctl -a | grep sem      -- for semmsl, semmns, semopm, semmni /sbin/sysctl -a | grep shm      -- for shmall, shmmax, shmmni /sbin/sysctl -a | grep file-max /sbin/sysctl -a | grep ip_local_port_range /sbin/sysctl -a | grep rmem_default
Please add/change the appropriate variables value in the /etc/sysctl.conf file as shown below.
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 = 2147483648 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
After adding these lines to /etc/sysctl.conf, please run the below command as root to make them enabled.

[root@shree ~]# sysctl -p

  Creating oracle OS User Account:
You want OS “oracle” customer account brought ahead which owns the Oracle software. Oracle Software installation
wants to be progresses by this account. Oracle programs putting in (without Companion CD) demands 2.5 GB
of free space obtainable for the ORACLE_BASE directory. Please assure that the get on purpose where you
        arrange to fit Software has demanded free space available. You can use “df –k” to review this out.

[root@shree ~]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda5 40662492 5345128 33251812 14% /
none 257884 0 257884 0% /dev/shm
/dev/hdb1 9621848 3344928 5788144 37% /backup
I had about 33GB of free space available on “/” mount point. So I decided to install Oracle under this
mount point.
groupadd dba groupadd oinstall useradd -g oinstall -G dba oracle passwd oracle
You do not deficiency oinstall assembly if you are not installing on the demonstration attendant or you (or your team) are the
simply person
responsible for future installations/upgrades of Oracle Software.
Setting Shell Limits for the Oracle User:
To transform the performance of the software on Linux webs, you must enhance the pursuing shell limits
 for the
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 or edit the following line in the /etc/pam.d/login file, if it does not already exist:
                session required /lib/security/

For the Bourne, Bash, or Korn shell,  add the following lines to the /etc/profile:
        if [ $USER = "oracle" ]; then
           if [ $SHELL = "/bin/ksh" ]; then
              ulimit -p 16384
              ulimit -n 65536
              ulimit -u 16384 -n 65536

For the C shell (csh or tcsh), add the following lines to the /etc/csh.login.
       if ( $USER == "oracle" ) then
          limit maxproc 16384
          limit descriptors 65536

Creating Oracle Software Directories: 
oracle_sw_owner is the operating system user name of the Oracle software owner, for example oracle.
[root@shree ~]# mkdir -p /u01/app/oracle [root@shree ~]# chown -R oracle:oinstall /u01/app/oracle [root@shree ~]# mkdir -p /u02/oradata/db102 [root@shree ~]# chown -R oracle:oinstall /u02/oradata/db102 [root@shree ~]# chmod -R 775 /u01/app/oracle [root@shree ~]# chmod -R 775 /u02/oradata/db102
 Setup Oracle User Account: 

export ORACLE_BASE=/u01/app export ORACEL_SID=db10
Obtaining Oracle 10g Software: 

[root@shree ~]# unzip /tmp/ [root@shree ~]# mkisofs -r /tmp/databases | cdrecord -v dev=1,1,0 speed=20 
Installation Process of Oracle 10g Software
[root@shree ~]# xhost + access control disabled, clients can connect from any host [root@shree ~]# mount /media/cdrom [root@shree root]# mount /mnt/cdrom -- Incase of RedHat EL3 [root@shree ~]# su - oracle [oracle@shree ~]$ echo $ORACLE_BASE /u01/app/oracle [oracle@shree ~]$ echo $ORACLE_SID db102 [oracle@shree ~]$ /media/cdrom/runInstaller
 Installing Oracle 10g Software: 

Followthese steps to install Oracle 10g software.

Updating .bash_profile:
Now .bash_profile needs to be updated with the value of ORACLE_HOME, path and LD_LIBRARY_PATH.
export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1

 Oracle suggests that you run the utlrp.sql script after conceiving or upgrading a database to recompile all
PL/SQL modules that might be in an invalid state, encompassing packages, methods, and types. This is an optional step but Oracle suggests that you manage it throughout setting up and not at a subsequent date.