Oracle installation on 64 bit requires that certain 32bit packages also needs to be installed on system. So first of all you should be able to distinguish between a 32-bit or 64-bit package. Following rpm command can be used for this purpose.
#rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep
For example, rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
See the oracle installation documentation that comes with oracle installation disks.
For e.g. for installing Oracle 10gR2 on 64 bit RHEL 5:
Check system RPMs while installing 10gR2 on 64 bit and install RPMS using yum
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep binutils
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat-db
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat-libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep control-center
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc-c++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-common
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-headers
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gnome-libs
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libaio
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgomp
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libXp
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep make
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep pdksh
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep sysstat
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep binutils
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat-libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-32bit
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libaio
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libelf
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++-devel
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep make
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep sysstat
avahi-compat-libdns_sd-0.6.16-6.el5 (x86_64)
binutils-2.17.50.0.6-12.el5 (x86_64)
control-center-2.16.0-16.el5 (i386)
control-center-2.16.0-16.el5 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
glibc-2.5-42 (i686)
glibc-2.5-42 (x86_64)
glibc-common-2.5-42 (x86_64)
glibc-common-2.5-42 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
libaio-0.3.106-3.2 (i386)
libaio-0.3.106-3.2 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
libstdc++-4.1.2-46.el5 (x86_64)
libstdc++-4.1.2-46.el5 (i386)
libstdc++-4.1.2-46.el5 (x86_64)
libstdc++-4.1.2-46.el5 (i386)
libXpm-3.5.5-3 (x86_64)
make-3.81-3.el5 (x86_64)
binutils-2.17.50.0.6-12.el5 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
glibc-2.5-42 (i686)
glibc-2.5-42 (x86_64)
glibc-common-2.5-42 (x86_64)
libaio-0.3.106-3.2 (i386)
libaio-0.3.106-3.2 (x86_64)
elfutils-libelf-0.137-3.el5 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
libstdc++-4.1.2-46.el5 (x86_64)
libstdc++-4.1.2-46.el5 (i386)
make-3.81-3.el5 (x86_64)
groupadd oinstall
usermod -g oinstall oracle
yum groupinstall "X Window System" "GNOME Desktop Environment"
yum install compat-db.i386
yum install compat-db.x86_64
yum install compat-libstdc++-33.i386
yum install compat-libstdc++-33.x86_64
yum install control-center.i386
yum install control-center.x86_64
yum install control-center-devel.i386
yum install control-center-devel.x86_64
yum install gcc-c++.x86_64
yum install gcc-c++.x86_64
yum install gcc-c++.x86_64
yum install glibc-devel.i386
yum install glibc-devel.x86_64
yum install glibc-devel.x86_64
yum install glibc-devel.i386
yum install compat-glibc-headers.x86_64
yum install glibc-headers.x86_64
yum install imake.x86_64
yum install libaio.i386
yum install libaio.x86_64
yum install libaio-devel.i386
yum install libaio-devel.x86_64
yum install libgomp.x86_64
yum install libstdc++
yum install libstdc++.i386
yum install libstdc++.x86_64
yum install libstdc++-devel.i386
yum install libstdc++-devel.x86_64
yum install libstdc++-devel.x86_64
yum install sysstat.x86_64
yum install libXp.i386
yum install libXp.x86_64
yum install libXpm.i386
yum install libXpm.x86_64
yum install libXpm-devel.i386
yum install libXpm-devel.x86_64
yum install libXp-devel.i386
yum install libXp-devel.x86_64
yum install mutt
yum install unixODBC-devel.x86_64
yum install mysql-connector-odbc-3.51.26r1127-1.el5.x86_64
yum install mysql.x86_64
yum install mysql-server.x86_64
make install
yum install mysql-devel.x86_64
yum install php-mysql.x86_64
yum provides *myodbc-installer*
See above for how to tackle the missing library error.
Now find the name of missing required rpm by command
yum provides libXt.so.6
This will give you the name of missing package. Install its 32bit or its 64 bit version of package, or both, depending on the case and go ahed! Here in this case i386 implies 32 bit version of missing package is required.
#rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep
For example, rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
See the oracle installation documentation that comes with oracle installation disks.
For e.g. for installing Oracle 10gR2 on 64 bit RHEL 5:
Check system RPMs while installing 10gR2 on 64 bit and install RPMS using yum
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep binutils
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat-db
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat-libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep control-center
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc-c++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-common
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-headers
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gnome-libs
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libaio
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgomp
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libXp
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep make
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep pdksh
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep sysstat
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep binutils
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat-libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-32bit
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc-devel
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libaio
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libelf
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgcc
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++-devel
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep make
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep sysstat
avahi-compat-libdns_sd-0.6.16-6.el5 (x86_64)
binutils-2.17.50.0.6-12.el5 (x86_64)
control-center-2.16.0-16.el5 (i386)
control-center-2.16.0-16.el5 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
glibc-2.5-42 (i686)
glibc-2.5-42 (x86_64)
glibc-common-2.5-42 (x86_64)
glibc-common-2.5-42 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
libaio-0.3.106-3.2 (i386)
libaio-0.3.106-3.2 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
libstdc++-4.1.2-46.el5 (x86_64)
libstdc++-4.1.2-46.el5 (i386)
libstdc++-4.1.2-46.el5 (x86_64)
libstdc++-4.1.2-46.el5 (i386)
libXpm-3.5.5-3 (x86_64)
make-3.81-3.el5 (x86_64)
binutils-2.17.50.0.6-12.el5 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
glibc-2.5-42 (i686)
glibc-2.5-42 (x86_64)
glibc-common-2.5-42 (x86_64)
libaio-0.3.106-3.2 (i386)
libaio-0.3.106-3.2 (x86_64)
elfutils-libelf-0.137-3.el5 (x86_64)
libgcc-4.1.2-46.el5 (x86_64)
libgcc-4.1.2-46.el5 (i386)
libstdc++-4.1.2-46.el5 (x86_64)
libstdc++-4.1.2-46.el5 (i386)
make-3.81-3.el5 (x86_64)
groupadd oinstall
usermod -g oinstall oracle
yum groupinstall "X Window System" "GNOME Desktop Environment"
yum install compat-db.i386
yum install compat-db.x86_64
yum install compat-libstdc++-33.i386
yum install compat-libstdc++-33.x86_64
yum install control-center.i386
yum install control-center.x86_64
yum install control-center-devel.i386
yum install control-center-devel.x86_64
yum install gcc-c++.x86_64
yum install gcc-c++.x86_64
yum install gcc-c++.x86_64
yum install glibc-devel.i386
yum install glibc-devel.x86_64
yum install glibc-devel.x86_64
yum install glibc-devel.i386
yum install compat-glibc-headers.x86_64
yum install glibc-headers.x86_64
yum install imake.x86_64
yum install libaio.i386
yum install libaio.x86_64
yum install libaio-devel.i386
yum install libaio-devel.x86_64
yum install libgomp.x86_64
yum install libstdc++
yum install libstdc++.i386
yum install libstdc++.x86_64
yum install libstdc++-devel.i386
yum install libstdc++-devel.x86_64
yum install libstdc++-devel.x86_64
yum install sysstat.x86_64
yum install libXp.i386
yum install libXp.x86_64
yum install libXpm.i386
yum install libXpm.x86_64
yum install libXpm-devel.i386
yum install libXpm-devel.x86_64
yum install libXp-devel.i386
yum install libXp-devel.x86_64
yum install mutt
yum install unixODBC-devel.x86_64
yum install mysql-connector-odbc-3.51.26r1127-1.el5.x86_64
yum install mysql.x86_64
yum install mysql-server.x86_64
make install
yum install mysql-devel.x86_64
yum install php-mysql.x86_64
yum provides *myodbc-installer*
See above for how to tackle the missing library error.
Now find the name of missing required rpm by command
yum provides libXt.so.6
This will give you the name of missing package. Install its 32bit or its 64 bit version of package, or both, depending on the case and go ahed! Here in this case i386 implies 32 bit version of missing package is required.