Installing Oracle Database 9.2.0.8 on RHEL 4.8

Operating System: RHEL4.8-x86_64-AS
Database Software: amd64_db_9204_Disk{1..3}.cpio.gz
Database Patches: p4547809_92080_Linux-x86-64.zip

Requirements

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \
gcc glibc-kernheaders glibc-headers glibc-devel compat-gcc-32 compat-gcc-32-c++ \
libstdc++-devel glibc-devel libaio

Install packages.

mkdir /mnt/rhiso
mount /dev/cdrom /mnt/rhiso

cd /mnt/rhiso/RedHat/RPMS/
rpm -ivh gcc-3.4.6-11.x86_64.rpm
rpm -ivh glibc-kernheaders-2.4-9.1.103.EL.x86_64.rpm
rpm -ivh glibc-headers-2.3.4-2.43.x86_64.rpm
rpm -ivh glibc-devel-2.3.4-2.43.x86_64.rpm
rpm -ivh compat-gcc-32-3.2.3-47.3.x86_64.rpm
rpm -ivh compat-gcc-32-c++-3.2.3-47.3.x86_64.rpm
rpm -ivh libstdc++-devel-3.4.6-11.x86_64.rpm
rpm -ivh libaio-0.3.105-2.x86_64.rpm

Configuring Operating Systems

~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
IPADDR=192.168.184.10
NETMASK=255.255.255.0
GATEWAY=192.168.184.2
DNS1=114.114.114.114

~]# service restart network
~]# echo "192.168.184.10    oracle9i" >>/etc/hosts
~]# service iptables stop
~]# chkconfig iptables off
~]# sed -i '/SELINUX=/{s/enforcing/disabled/}' /etc/selinux/config
~]# sed -i 's/^HOSTNAME=.*/HOSTNAME=oracle9i/' /etc/sysconfig/network

Setting Up a Working Environment for Oracle

Creating Oracle User Accounts.

groupadd dba
groupadd oinstall
useradd -g oinstall -G dba -c "Oracle Software Owner" oracle
echo oracle | passwd --stdin oracle

Creating Oracle Directories.

mkdir -p /u01/app/oracle/product/9.2.0
chown -R oracle.oinstall /u01
chmod -R 775 /u01

Setting Oracle Environment Variables.

cat >>/home/oracle/.bash_profile <<'EOF'
# Oracle 9i
umask 0022
# export LD_ASSUME_KERNEL=2.4.1    # for Red Hat Enterprise Linux 3
export LD_ASSUME_KERNEL=2.4.19   # for Red Hat Enterprise Linux 4
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
EOF

cat >>/etc/profile <<EOF
# Oracle 9i
if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi
EOF

Setting System Parameters

Setting kernel parameters.

cat >>/etc/sysctl.conf <<EOF
# Oracle 9i
kernel.sem=250 32000 100 128
kernel.shmmax=2147483648
kernel.shmmni=4096
kernel.shmall=2097152
fs.file-max=65536
net.ipv4.ip_local_port_range=9000 65500
EOF

sysctl -p

Setting shell limits.

cat >>/etc/security/limits.conf <<EOF
# Oracle 9i
oracle  soft  nproc  2047
oracle  hard  nproc  16384
oracle  soft  nofile  1024
oracle  hard  nofile  65536
EOF

Setting PAM.

cat >> /etc/pam.d/login << EOF
# Oracle 9i
session  required  pam_limits.so
EOF

Unpacking the Installation Files and starting runInstaller

mkdir /soft
chown -R oracle.dba /soft
chmod -R 775 /soft

# login as oracle user
cd /soft
zcat amd64_db_9204_Disk1.cpio.gz | cpio -idmv
zcat amd64_db_9204_Disk2.cpio.gz | cpio -idmv
zcat amd64_db_9204_Disk3.cpio.gz | cpio -idmv
/soft/Disk1/runInstaller

Use netca create a listener, dbca create a instance.

Patching Oracle 9.2.0.4.0 to 9.2.0.8.0

・ p4547809_92080_Linux-x86-64

Shutdown database and listener beforce start patch.

unzip /soft/p4547809_92080_Linux-x86-64.zip -d /soft/4547809
/soft/4547809/Disk1/runInstaller

Oracle Post Installation Tasks

Setting automatic startup.

sed -i '/orcl/s/:N/:Y/' /etc/oratab

cat >>/etc/rc.local <<EOF
# Oracle 9i
su - oracle -c "lsnrctl start"
su - oracle -c "dbstart"
EOF

su - oracle -c 'sqlplus /nolog << EOF
conn / as sysdba
create pfile from spfile;
exit
EOF'

Installation Errors

Issue: no matching key exchange method found. Their offer: diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1

Unable to negotiate with 192.168.184.10 port 22: no matching key exchange method found. Their offer: diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1
/bin/scp: Connection closed

Unable to negotiate with 192.168.184.10 port 22: no matching host key type found. Their offer: ssh-rsa,ssh-dss
/bin/scp: Connection closed

Solution: Add scp options.

scp -o KexAlgorithms=+diffie-hellman-group1-sha1 -o HostKeyAlgorithms=+ssh-dss amd64_db_9204_Disk* root@192.168.184.10:/soft

---

Issue: Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2023-06-03_11-46-39PM/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

Solution:

rpm -ivh --nodeps xorg-x11-deprecated-libs-6.8.2-1.EL.63.i386.rpm
rpm -ivh --nodeps xorg-x11-libs-6.8.2-1.EL.63.i386.rpm

---

Issue: Install stuck at 17% copying naeet.o.

Solution: export LD_ASSUME_KERNEL=2.4.19

---

Issue: Error in invoking target ntcontab.o of makefile /u01/app/oracle/product/9.2.0/network/lib/ins_net_client.mk

/u01/app/oracle/oraInventory/logs/installActions2025-10-27_11-42-29AM.log

Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target ntcontab.o of makefile /u01/app/oracle/product/9.2.0/network/lib/ins_net_client.mk
Exception Severity: 1

/u01/app/oracle/product/9.2.0/install/make.log

/usr/bin/make -f ins_net_client.mk ntcontab.o ORACLE_HOME=/u01/app/oracle/product/9.2.0
(if [ "compile" = "compile" ] ; then \
  /u01/app/oracle/product/9.2.0/bin/gennttab > ntcontab.c ;\
  gcc  -c ntcontab.c ;\
  rm -f /u01/app/oracle/product/9.2.0/lib/ntcontab.o ;\
  mv ntcontab.o /u01/app/oracle/product/9.2.0/lib/ ;\
          /usr/bin/ar rv /u01/app/oracle/product/9.2.0/lib/libn9.a /u01/app/oracle/product/9.2.0/lib/ntcontab.o ; fi)
/bin/sh: gcc: command not found
mv: cannot stat `ntcontab.o': No such file or directory
/usr/bin/ar: /u01/app/oracle/product/9.2.0/lib/ntcontab.o: No such file or directory
make: *** [ntcontab.o] Error 1

Solution: rpm -ivh gcc-3.4.6-11.x86_64.rpm

---

Issue: Error in invoking target install_isqlplus of makefile /u01/app/oracle/product/9.2.0/sqlplus/lib/ins_sqlplus.mk or Error in invoking target install of makefile /u01/app/oracle/product/9.2.0/rdbms/lib/ins_rdbms.mk

/u01/app/oracle/oraInventory/logs/installActions2025-10-27_11-42-29AM.log

Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target install_isqlplus of makefile /u01/app/oracle/product/9.2.0/sqlplus/lib/ins_sqlplus.mk
Exception Severity: 1

---

Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target install of makefile /u01/app/oracle/product/9.2.0/rdbms/lib/ins_rdbms.mk
Exception Severity: 1

/u01/app/oracle/product/9.2.0/install/make.log

make[1]: Entering directory `/u01/app/oracle/product/9.2.0/sqlplus/lib'
gcc -m32 -o installisqlplus32 -L/u01/app/oracle/product/9.2.0/sqlplus//lib32/ -L/u01/app/oracle/product/9.2.0/lib32/ -L/u01/app/oracle/product/9.2.0/lib32/stubs/  -L/u01/app/oracle/product/9.2.0/Apache/fastcgi/ /u01/app/oracle/product/9.2.0/sqlplus/lib32/safiimfg.o -lisqlplus -lsqlplus -lfcgi -lclntsh  `cat /u01/app/oracle/product/9.2.0/lib32/ldflags`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /u01/app/oracle/product/9.2.0/lib32/ldflags`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9  -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lwtc9 -lmm -lnls9  -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /u01/app/oracle/product/9.2.0/lib32/ldflags`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /u01/app/oracle/product/9.2.0/lib32/ldflags`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9  -lvsn9 -lwtc9 -lcommon9 -lgeneric9  -ltrace9 -lnls9  -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lclient9  -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lnls9  -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9   `cat /u01/app/oracle/product/9.2.0/lib32/sysliblist` -Wl,-rpath,/u01/app/oracle/product/9.2.0/lib:/lib:/usr/lib -lm -lpthread   `cat /u01/app/oracle/product/9.2.0/lib32/sysliblist` -ldl -lm -lpthread  /u01/app/oracle/product/9.2.0/rdbms/lib32/defopt.o -lpls9  -lsql9 -lxsd9
/usr/bin/ld: crt1.o: No such file: No such file or directory
collect2: ld returned 1 exit status
make[1]: *** [installisqlplus32] Error 1
make[1]: Leaving directory `/u01/app/oracle/product/9.2.0/sqlplus/lib'
make: *** [isqlplus] Error 2

---

Linking external procedure agent (/u01/app/oracle/product/9.2.0/rdbms/lib/extproc32)
rm -f /u01/app/oracle/product/9.2.0/rdbms/lib/extproc32
gcc -m32 -o /u01/app/oracle/product/9.2.0/rdbms/lib/extproc32 -L/u01/app/oracle/product/9.2.0/rdbms/lib32/ -L/u01/app/oracle/product/9.2.0/lib32/ -L/u01/app/oracle/product/9.2.0/lib32/stubs/   /u01/app/oracle/product/9.2.0/rdbms/lib32/hormc.o  /u01/app/oracle/product/9.2.0/rdbms/lib32/defopt.o  /u01/app/oracle/product/9.2.0/rdbms/lib32/homts.o             -lagtsh -lpls9  -lplp9   -lclntsh -lnls9  -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 /u01/app/oracle/product/9.2.0/lib32/libgeneric9.a   `cat /u01/app/oracle/product/9.2.0/lib32/sysliblist` -Wl,-rpath,/u01/app/oracle/product/9.2.0/lib:/lib:/usr/lib -lm    `cat /u01/app/oracle/product/9.2.0/lib32/sysliblist` -ldl -lm    -lvsn9
/usr/bin/ld: warning: libwtc9.so, needed by /u01/app/oracle/product/9.2.0/lib32//libclntsh.so, not found (try using -rpath or -rpath-link)
/u01/app/oracle/product/9.2.0/lib32//libclntsh.so: undefined reference to `wtcstu'
/u01/app/oracle/product/9.2.0/lib32//libclntsh.so: undefined reference to `wtclkm'
/u01/app/oracle/product/9.2.0/lib32//libclntsh.so: undefined reference to `wtcsrin'
/u01/app/oracle/product/9.2.0/lib32//libclntsh.so: undefined reference to `wtcMerr'
/u01/app/oracle/product/9.2.0/lib32//libclntsh.so: undefined reference to `wtcsrin0'
/u01/app/oracle/product/9.2.0/lib32//libclntsh.so: undefined reference to `wtcsrfre'
/u01/app/oracle/product/9.2.0/lib32//libclntsh.so: undefined reference to `wtcLerr'
collect2: ld returned 1 exit status
make[1]: Leaving directory `/u01/app/oracle/product/9.2.0/rdbms/lib'
make[1]: *** [/u01/app/oracle/product/9.2.0/rdbms/lib/extproc32] Error 1
make: *** [extproc32] Error 2

Solution:

Install glibc-devel.i386 and downgrade gcc/g++ version, reboot the system.

rpm -ivh glibc-devel-2.3.4-2.43.i386.rpm

mv /usr/bin/gcc /usr/bin/gcc.orig
mv /usr/bin/g++ /usr/bin/g++.orig
ln -s /usr/bin/x86_64-redhat-linux-gcc32 /usr/bin/gcc
ln -s /usr/bin/x86_64-redhat-linux-g++32 /usr/bin/g++

Deinstall Oracle 9i

rm -f /etc/oraInst.loc
rm -f /etc/oratab
rm -f /usr/local/bin/dbhome
rm -f /usr/local/bin/oraenv
rm -f /usr/local/bin/coraenv
rm -rf /u01

Requirements

・ Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) (Doc ID 169706.1).pdf |
・ Requirements for Installing Oracle 9iR2 64-bit on RHEL 4 x86-64 (AMD64,EM64T) (Doc ID 353529.1).pdf |

Appendix

Install software only.

netca.

dbca.