Error free installation of Oracle 9i Database Release 2 (9.2.0.1.0) on CentOS 4.3 (Dell PowerEdge 6850)

  • boot the server machine, and remove all existing SCSI or RAID configurations
    by pressing CTRL + R at start

  • now boot server machine from “Dell PowerEdge TM 6850 Installation and Server Management bootable CD”,
    • version = 5.2, make necessary configurations
      and select Red Hat Enterprise Linux Server 4 ,as Operating System
    • when the server prompts for RH EL server 4 CD/DVD, RESTART THE SERVER

  • Now, Direct boot from CentOS DVD 4.7, and follow the instructions

    /boot = 1 GB
    swap = 8 GB
    /home = 40 GB
    /usr = 10 GB
    / = all other space

  • root pass = root123456

  • login = sysadmin , pass = root123456 for basic configurations.

  • IP = 192.168.1.94 and 192.168.1.95 (in use)

  • Allow remote desktop sharing. (from sysadmin login, and later on from oracle login)

  • *Disable firewall and restart the PC

  • set the hostname = pro-db.com
    gedit /etc/sysconfig/network

  • Now enter IP and host name in /etc/hosts file

    gedit /etc/hosts
    192.168.1.95 pro-db.com pro-db

    hostname -f to check full hostname or

    uname -n to check full hostname

  • uname -r
    2.6.9-78.ELsmp
    this is the kernel at this time

  • JRE

  • ⚠️ DO NOT INSTALL ANY VERSION OF JRE
env variables  
in /etc/profile   file, copy the following lines  
  
ORACLE_BASE=/u01/app/oracle  
ORACLE_HOME=/u01/app/oracle/product/9.2.0.1.0  
ORACLE_SID=prod  
  
PATH=$PATH:$ORACLE_HOME/bin  
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/network/lib  
LD_ASSUME_KERNEL=2.4.1  
  
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH LD_ASSUME_KERNEL  

su to root and create following users and group  
/usr/sbin/groupadd oinstall  
/usr/sbin/groupadd dba  
/usr/sbin/groupadd open  
/usr/sbin/useradd -g oinstall -G dba oracle  
passwd oracle
  • Create the following folders
# mkdir /u01 /u02  

# chown oracle.dba /u01 /u02  

# chmod 775 /u01 /u02  

# umask  

# umask 0022

  • Edit /etc/sysctl.conf file and add the lines

    kernel.shmall = 2097152
    kernel.shmmax = 2147483648
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 65536
    net.ipv4.ip_local_port_range = 1024 65000

  • after adding lines, check the parameter using this command
    /sbin/sysctl -p

  • Install the following rpms

    xorg-x11-deprecated-libs-6.8.2-1.EL.13.20.i386.rpm
    xorg-x11-libs-6.8.2-1.EL.13.20.i386.rpm
    xorg-x11-xfs-6.8.2-1.EL.13.20.i386.rpm

    alsa-lib-devel-1.0.6-5.RHEL4.i386.rpm
    fontconfig-devel-2.2.3-7.i386.rpm
    freetype-devel-2.1.9-1.i386.rpm
    libjpeg-devel-6b-33.i386.rpm
    libtiff-devel-3.6.1-8.i386.rpm
    libungif-devel-4.1.3-1.i386.rpm
    xorg-x11-6.8.2-1.EL.13.20.i386.rpm
    xorg-x11-deprecated-libs-devel-6.8.2-1.EL.13.20.i386.rpm
    xorg-x11-devel-6.8.2-1.EL.13.20.i386.rpm

    audiofile-devel-0.2.6-1.i386.rpm
    esound-devel-0.2.35-2.i386.rpm
    libaio-0.3.103-3.i386.rpm
    libaio-devel-0.3.103-3.i386.rpm
    openmotif21-2.1.30-11.RHEL4.4.i386.rpm

    glib-devel-1.2.10-15.i386.rpm
    gnome-libs-devel-1.4.1.2.90-44.1.i386.rpm
    gtk+-devel-1.2.10-33.i386.rpm
    imlib-devel-1.9.13-23.i386.rpm
    ORBit-devel-0.5.17-14.i386.rpm

  • Download the two files from web and install.
    http://oss.oracle.com/projects/compat-oracle/files/RedHat/
    compat-libcwait-2.1-1.i386.rpm
    compat-oracle-rhel4-1.0-5.i386.rpm

  • Copy all three CDs of oracle 9i db in /home/oracle Disk1, Disk2, Disk3

  • chown oracle:dba /home/oracle/Disk1 -R
  • chmod 775 /home/oracle/Disk1 -R

  • gedit /etc/redhat-release
    Delete first line and add this
    Red Hat Enterprise Linux AS release 4

  • Now run the installer

    • /home/oracle/Disk1/runInstaller

    • ✨ welcome screen ✨ click Next ➡️

    • Inventory Location, /u01/app/oracle/orainventory

    • UNIX group name = oinstall

    • run a scrip as root, continue

  • File Locations

    • source
      /home/oracle/Disk1/stage/products.jar

    • Destination
      Name = OUIHome
      /u01/app/oracle/product/9.2.0.1.0

  • Available Products

    Oracle 9i Database 9.2.0.4.0

  • Installation Type

    Enterprise Edition (2.84GB)

  • Database Configuration
    General Purpose

  • Database Identification

    Global Database Name = prod
    SID = prod

  • Database File Location

    /u01/app/oracle/oradata

  • Database Character Set

    Use the default character set

  • Summary , click install

  • run a script as root

/u01/app/oracle/product/9.2.0.1.0/root.sh  
[root@pro-db sysadmin]# /u01/app/oracle/product/9.2.0.1.0/root.sh  
Running Oracle9 root.sh script...  
nThe following environment variables are set as:  
ORACLE_OWNER= oracle  
ORACLE_HOME=  /u01/app/oracle/product/9.2.0.1.0  
Enter the full pathname of the local bin directory: [/usr/local/bin]:  
Copying dbhome to /usr/local/bin ...  
Copying oraenv to /usr/local/bin ...  
Copying coraenv to /usr/local/bin ...  
nCreating /etc/oratab file...  
Adding entry to /etc/oratab file...  
Entries will be added to the /etc/oratab file as needed by  
Database Configuration Assistant when a database is created  
Finished running generic part of root.sh script.  
Now product-specific root actions will be performed.

  • Enter the full path of local bin directory : /usr/local/bin:
    press enter

  • Enter sys and system passwords for two times
    login = sys, pass = root123456
    login = system, pass = root123456

  • Problem 🤔⚠️🤔

    Agent Configuration Assistant
    Parameter “orahome”=/u01/app/oracle/product/9.2.0.1.0
    Parameter “nodeinfo”=NO_VALUE

  • 💡 Solution

    download this patch from internet and do the follwoings
    p3238244_9204_LINUX.zip
    unzip it to folder
    3238244

  chwon oracle:dba 3238244/ -R
  chmod 776 3238244/ -R  
  
  cp 3238244/files/lib/stubs/*.*
  /u01/app/oracle/product/9.2.0.1.0/lib/stubs/  
  
  cd /u01/app/oracle/product/9.2.0.1.0/network/lib/  
  
  make -f ins_oemagent.mk install  

  now Retry the installation process  
  
  and at this time , it will be OK

  • The following information is available in:

    /u01/app/oracle/product/9.2.0.1.0/Apache/Apache/setupinfo.txt

The HTTP Server can be accessed using the following URLs:

Non SSL Mode:
http://pro-db:7777

SSL mode (executed at install time):
http://pro-db:7778
https://pro-db:4443