db file sequential reads

Db file sequential reads

Possible Causes :
· Use of an unselective index
· Fragmented Indexes
· High I/O on a particular disk or mount point
· Bad application design
· Index reads performance can be affected by slow I/O subsystem and/or poor database files layout, which result in a higher average wait time

Actions :
· Check indexes on the table to ensure that the right index is being used

· Check the column order of the index with the WHERE clause of the Top SQL statements

· Rebuild indexes with a high clustering factor

· Use partitioning to reduce the amount of blocks being visited

· Make sure optimizer statistics are up to date

· Relocate ‘hot’ datafiles

· Consider the usage of multiple buffer pools and cache frequently used indexes/tables in the KEEP pool

· Inspect the execution plans of the SQL statements that access data through indexes

· Is it appropriate for the SQL statements to access data through index lookups?

· Would full table scans be more efficient?

· Do the statements use the right driving table?

· The optimization goal is to minimize both the number of logical and physical I/Os.

Remarks:
· The Oracle process wants a block that is currently not in the SGA, and it is waiting for the database block to be read into the SGA from disk.
· Significant db file sequential read wait time is most likely an application issue.
· If the DBA_INDEXES.CLUSTERING_FACTOR of the index approaches the number of blocks in the table, then most of the rows in the table are ordered. This is desirable.

· However, if the clustering factor approaches the number of rows in the table, it means the rows in the table are randomly ordered and thus it requires more I/Os to complete the operation. You can improve the index’s clustering factor by rebuilding the table so that rows are ordered according to the index key and rebuilding the index thereafter.

· The OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING initialization parameters can influence the optimizer to favour the nested loops operation and choose an index access path over a full table scan.

TNS-12555 / TNS-12560 / TNS-00525 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

Problem:LSNRCTL for Linux: Version 10.2.0.1.0 – Production
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type “help” for information.
LSNRCTL> start
Starting /u01/app/oracle/oracle/product/10.2.0/db_1//bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 10.2.0.2.0 – Production
System parameter file is /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
Listener failed to start. See the error message(s) above…
LSNRCTL>
Cause:
1) Ensure that /tmp/.oracle or /var/tmp/.oracle directory exists.
2) Confirm that the DBA user who is trying to start the listener has adequate read and write permissions on the directory specified above. The permissions
should be 777.
3) If the /tmp directory has reached full capacity, this would cause the listener to fail to write the socket files.

Solution
To implement the solution, please use the following example:

1. cd /var/tmp
2. Check the whether the .oracle directory exists:
cd .oracle
3. If the directory does not exist, request the System Administrator create the directory and set the ownership as root:root with the permissions set to 01777

mkdir /var/tmp/.oracle
chmod 01777 /var/tmp/.oracle
chown root /var/tmp/.oracle
chgrp root /var/tmp/.oracle

4. Next try starting the TNS Listener using the ‘lsnrctl start <listener_name>’ command.

Pre-Requests for Installing oracle 10g on RHEL 4 x86_64

Steps  to meet  all the pre-requests for installation of oracle 10g on RHEL6 x86_64 server

 [oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ uname -a

Linux sumit-linux-10g_server 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:00:54 EDT 2005 x86_64 x86_64 x86_64 GNU/Linux

[oracle@sumit-linux-10g_server ~]$ pwd

/home/oracle

[oracle@sumit-linux-10g_server ~]$ cat /etc/hosts

127.0.0.1 sumit-linux-10g_server  localhost.localdomain     localhost

192.145.4.56  sumit-linux-10g_server

[oracle@sumit-linux-10g_server ~]$ id oracle

uid=500(oracle) gid=500(oracle) groups=500(oracle)

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ id nobody

uid=99(nobody) gid=99(nobody) groups=99(nobody)

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ cat /etc/*-release

Red Hat Enterprise Linux ES release 4 (Nahant Update 2)

[oracle@sumit-linux-10g_server ~]$

[root@sumit-linux-10g_server ~]# cat /etc/oraInst.loc

cat: /etc/oraInst.loc: No such file or directory

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]# /usr/sbin/groupadd oinstall

[root@sumit-linux-10g_server ~]# /usr/sbin/groupadd dba

[root@sumit-linux-10g_server ~]# /usr/sbin/usermod -g oinstall -G dba oracle

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]# id oracle

uid=500(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)

[root@sumit-linux-10g_server ~]# vi /etc/sysctl.conf

# Kernel sysctl configuration file for Red Hat Linux

#

# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and

# sysctl.conf(5) for more details.

# Controls IP packet forwarding

net.ipv4.ip_forward = 0

# Controls source route verification

net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing

net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel

kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.

# Useful for debugging multi-threaded applications.

kernel.core_uses_pid = 1

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.shmall = 2097152

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.rmem_max = 262144

net.core.wmem_default = 262144

net.core.wmem_max = 262144

~

~

~

"/etc/sysctl.conf" 32L, 887C written

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]# /sbin/sysctl -p

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.shmmni = 4096

kernel.shmall = 2097152

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.rmem_max = 262144

net.core.wmem_default = 262144

net.core.wmem_max = 262144

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]# vi /etc/security/limits.conf

# /etc/security/limits.conf

#

#Each line describes a limit for a user in the form:

#

#<domain>        <type>  <item>  <value>

#

#Where:

#<domain> can be:

#        - an user name

#        - a group name, with @group syntax

#        - the wildcard *, for default entry

#        - the wildcard %, can be also used with %group syntax,

#                 for maxlogin limit

#

#<type> can have the two values:

#        - "soft" for enforcing the soft limits

#        - "hard" for enforcing hard limits

#

#<item> can be one of the following:

#        - core - limits the core file size (KB)

#        - data - max data size (KB)

#        - fsize - maximum filesize (KB)

#        - memlock - max locked-in-memory address space (KB)

#        - nofile - max number of open files

#        - rss - max resident set size (KB)

#        - stack - max stack size (KB)

#        - cpu - max CPU time (MIN)

#        - nproc - max number of processes

#        - as - address space limit

#        - maxlogins - max number of logins for this user

#        - priority - the priority to run user process with

#        - locks - max number of file locks the user can hold

#

#<domain>      <type>  <item>         <value>

#

#*               soft    core            0

#*               hard    rss             10000

#@student        hard    nproc           20

#@faculty        soft    nproc           20

#@faculty        hard    nproc           50

#ftp             hard    nproc           0

#@student        -       maxlogins       4

oracle soft nofile 65536

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

"/etc/security/limits.conf" 51L, 1619C written

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]#

[root@sumit-linux-10g_server ~]# su - oracle

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ vi /home/oracle/.bash_profile

# .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

# User specific environment and startup programs

export ORACLE_BASE=/home/oracle/10.2.0/product

export ORACLE_HOME=$ORACLE_BASE/db_1

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=orcl

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

export TMP=/home/oracle/tempdir

export TEMPDIR=/home/oracle/tempdir

unset USERNAME

~

~

".bash_profile" 23L, 544C written

[oracle@sumit-linux-10g_server ~]$ export PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin

[oracle@sumit-linux-10g_server ~]$ source ~/.bash_profile

[oracle@sumit-linux-10g_server ~]$ echo $PATH

/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/10.2.0/product/db_1/bin

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ mkdir 10.2.0

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ mkdir tempdir

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ ls -lrth

total 766M

drwxrwxr-x  2 oracle oinstall 4.0K Jun 25 18:20 Desktop

-rwxrwxr-x  1 oracle oinstall 765M Jun 26 08:55 10201_database_linux_x86_64.cpio

drwxr-xr-x  2 oracle oinstall 4.0K Jun 26 09:20 10.2.0

drwxr-xr-x  2 oracle oinstall 4.0K Jun 26 09:21 tempdir

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$

[oracle@sumit-linux-10g_server ~]$ cd 10.2.0

[oracle@sumit-linux-10g_server 10.2.0]$ mkdir product

[oracle@sumit-linux-10g_server 10.2.0]$ cd product

[oracle@sumit-linux-10g_server product]$ mkdir db_1

[oracle@sumit-linux-10g_server product]$ ls -lrth

total 4.0K

drwxr-xr-x  2 oracle oinstall 4.0K Jun 26 09:23 db_1

[oracle@sumit-linux-10g_server product]$

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" binutils

binutils-2.15.92.0.2.15 (x86_64)

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" compat-db

compat-db-4.1.25.9 (i386)

compat-db-4.1.25.9 (x86_64)

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" control-center

control-center-2.8.0.12.rhel4.2 (x86_64)

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" gcc

package gcc is not installed

[root@sumit-linux-10g_server ~]#  rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" gcc-c++

package gcc-c++ is not installed

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" glibc

glibc-2.3.4.2.13 (i686)

glibc-2.3.4.2.13 (x86_64)

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" glibc-common

glibc-common-2.3.4.2.13 (x86_64)

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" gnome-libs

gnome-libs-1.4.1.2.90.44.1 (x86_64)

[root@sumit-linux-10g_server ~]#  rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" libstdc++-devel

package libstdc++-devel is not installed

[root@sumit-linux-10g_server ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" make

make-3.80.5 (x86_64)

[root@sumit-linux-10g_server ~]#  rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" pdksh

pdksh-5.2.14.30.3 (x86_64)

[root@sumit-linux-10g_server ~]#  rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" sysstat

package sysstat is not installed

[root@sumit-linux-10g_server ~]#  rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" xscreensaver

xscreensaver-4.18.5.rhel4.9 (x86_64)

####################################################################################################

Installing the required RPMS:

[root@sumit-linux-10g_server rpm]# rpm -ivh sysstat-5.0.5-19.el4.x86_64.rpm

warning: sysstat-5.0.5-19.el4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 82fd17b2

Preparing...                ########################################### [100%]

   1:sysstat                ########################################### [100%]

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# ls -lrth

total 72M

-rw-r--r--  1 root root 4.4M May  9 14:43 gcc-3.4.3-9.EL4.x86_64.rpm

-rw-r--r--  1 root root 2.7M May  9 14:43 gcc-c++-3.4.3-9.EL4.x86_64.rpm

-rw-r--r--  1 root root 9.6M May  9 14:43 libstdc++-devel-3.4.3-9.EL4.x86_64.rpm

-rw-r--r--  1 root root 2.4M May  9 15:00 glibc-devel-2.3.4-2.13.x86_64.rpm

-rw-r--r--  1 root root 800K May  9 15:08 glibc-kernheaders-2.4-9.1.98.EL.x86_64.rpm

-rw-r--r--  1 root root 1.9M May  9 15:22 cpp-3.4.6-11.el4_8.1.x86_64.rpm

-rw-r--r--  1 root root 9.6M May  9 15:34 libstdc++-devel-3.4.4-2.x86_64.rpm

-rw-r--r--  1 root root 126K May  9 16:20 sysstat-5.0.5-19.el4.x86_64.rpm

-rw-r--r--  1 root root  15M May 11 19:45 glibc-2.3.4-2.39.src.rpm

-rw-r--r--  1 root root 2.0M May 11 20:08 glibc-devel-2.3.4-2.39.i386.rpm

-rwxr--r--  1 root root 588K May 11 20:08 glibc-headers-2.3.4-2.39.i386.rpm

-rw-r--r--  1 root root  16M May 11 20:09 glibc-common-2.3.4-2.39.i386.rpm

-rw-r--r--  1 root root 4.3M May 11 20:11 glibc-2.3.4-2.39.i386.rpm

-rw-r--r--  1 root root 562K May 11 20:17 glibc-headers-2.3.4-2.13.x86_64.rpm

-rw-r--r--  1 root root 3.1M May 12 15:18 binutils-2.15.92.0.2-13.0.0.0.2.x86_64.rpm

-rw-r--r--  1 root root  11K May 12 15:49 libaio-devel-0.3.105-2.x86_64.rpm

-rw-r--r--  1 root root  19K May 12 15:53 libaio-0.3.105-2.x86_64.rpm

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -ivh glibc-kernheaders-2.4-9.1.98.EL.x86_64.rpm

warning: glibc-kernheaders-2.4-9.1.98.EL.x86_64.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:glibc-kernheaders      ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm -ivh glibc-headers-2.3.4-2.13.x86_64.rpm

warning: glibc-headers-2.3.4-2.13.x86_64.rpm: V3 DSA signature: NOKEY, key ID 0c98ff9d

Preparing...                ########################################### [100%]

   1:glibc-headers          ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm -ivh glibc-devel-2.3.4-2.13.x86_64.rpm

warning: glibc-devel-2.3.4-2.13.x86_64.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:glibc-devel            ########################################### [100%]

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -ivh gcc-3.4.3-9.EL4.x86_64.rpm

warning: gcc-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

error: Failed dependencies:

        cpp = 3.4.3-9.EL4 is needed by gcc-3.4.3-9.EL4.x86_64

[root@sumit-linux-10g_server rpm]# rpm -ivh cpp-3.4.3-9.EL4.x86_64.rpm

warning: cpp-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 192a7d7d

Preparing...                ########################################### [100%]

        file /usr/bin/cpp from install of cpp-3.4.3-9.EL4.x86_64.rpm conflicts with file from package cpp-3.4.4-2

        file /usr/libexec/gcc/x86_64-redhat-linux/3.4.3/cc1 from install of cpp-3.4.3-9.EL4.x86_64 conflicts with file from package cpp-3.4.4-2

        file /usr/share/man/man1/cpp.1.gz from install of cpp-3.4.3-9.EL4 conflicts with file from package cpp-3.4.4-2

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -Uvh --force --oldpackage cpp-3.4.3-9.EL4.x86_64.rpm

warning: cpp-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 73307de6

Preparing...                ########################################### [100%]

   1:cpp                    ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" cpp

cpp-3.4.3.9.EL4 (x86_64)

[root@sumit-linux-10g_server rpm]# rpm -ivh gcc-3.4.3-9.EL4.x86_64.rpm

warning: gcc-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:gcc                    ########################################### [100%]

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -ivh --replacefiles libstdc++-devel-3.4.3-9.EL4.x86_64.rpm

warning: libstdc++-devel-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

error: Failed dependencies:

        libstdc++ = 3.4.3-9.EL4 is needed by libstdc++-devel-3.4.3-9.EL4.x86_64

[root@sumit-linux-10g_server rpm]# rpm -ivh --replacefiles libstdc++-3.4.3-9.EL4.x86_64.rpm

warning: libstdc++-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 73307de6

Preparing...                ########################################### [100%]

        package libstdc++-3.4.4-2 (which is newer than libstdc++-3.4.3-9.EL4) is already installed

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -Uvh --force --oldpackage libstdc++-3.4.3-9.EL4.x86_64.rpm

warning: libstdc++-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 73307de6

Preparing...                ########################################### [100%]

   1:libstdc++              ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm -Uvh --force --oldpackage libstdc++-devel-3.4.3-9.EL4.x86_64.rpm

warning: libstdc++-devel-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:libstdc++-devel        ########################################### [100%]

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -ivh gcc-c++-3.4.3-9.EL4.x86_64.rpm

warning: gcc-c++-3.4.3-9.EL4.x86_64.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:gcc-c++                ########################################### [100%]

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -ivh glibc-2.3.4-2.39.i386.rpm

warning: glibc-2.3.4-2.39.i386.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

error: Failed dependencies:

        glibc-common = 2.3.4-2.39 is needed by glibc-2.3.4-2.39.i386

[root@sumit-linux-10g_server rpm]# rpm -ivh  glibc-common-2.3.4-2.39.i386.rpm

warning: glibc-common-2.3.4-2.39.i386.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

        file /etc/default/nss from install of glibc-common-2.3.4-2.39 conflicts with file from package glibc-common-2.3.4-2.13

        file /usr/bin/ldd from install of glibc-common-2.3.4-2.39 conflicts with file from package glibc-common-2.3.4-2.13

        file /usr/bin/tzselect from install of glibc-common-2.3.4-2.39 conflicts with file from package glibc-common-2.3.4-2.13

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -Uvh --force --oldpackage glibc-common-2.3.4-2.39.i386.rpm

warning: glibc-common-2.3.4-2.39.i386.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:glibc-common           ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" glibc-common

glibc-common-2.3.4.2.13 (x86_64)

glibc-common-2.3.4.2.39 (i386)

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -Uvh --force --oldpackage glibc-2.3.4-2.39.i386.rpm

warning: glibc-2.3.4-2.39.i386.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:glibc                  warning: /etc/localtime created as /etc/localtime.rpmnew

########################################### [100%]

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -Uvh --force --oldpackage glibc-headers-2.3.4-2.39.i386.rpm

warning: glibc-headers-2.3.4-2.39.i386.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

error: Failed dependencies:

        glibc-headers = 2.3.4-2.13 is needed by (installed) glibc-devel-2.3.4-2.13.x86_64

[root@sumit-linux-10g_server rpm]# rpm -ivh --force --oldpackage glibc-headers-2.3.4-2.39.i386.rpm

warning: glibc-headers-2.3.4-2.39.i386.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:glibc-headers          ########################################### [100%]

[root@sumit-linux-10g_server rpm]#

[root@sumit-linux-10g_server rpm]# rpm -ivh --force --oldpackage glibc-devel-2.3.4-2.39.i386.rpm

warning: glibc-devel-2.3.4-2.39.i386.rpm: V3 DSA signature: NOKEY, key ID a7048f8d

Preparing...                ########################################### [100%]

   1:glibc-devel            ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm -ivh --force --oldpackage binutils-2.15.92.0.2-13.0.0.0.2.x86_64.rpm

Preparing...                ########################################### [100%]

   1:binutils               ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm -ivh --force --oldpackage binutils-2.15.92.0.2-10.EL4.i386.rpm

warning: binutils-2.15.92.0.2-10.EL4.i386.rpm: V3 DSA signature: NOKEY, key ID 73307de6

Preparing...                ########################################### [100%]

   1:binutils               ########################################### [100%]

[root@sumit-linux-10g_server rpm]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" binutils

binutils-2.15.92.0.2.15 (x86_64)

binutils-2.15.92.0.2.13.0.0.0.2 (x86_64)

binutils-2.15.92.0.2.10.EL4 (i386)

[root@sumit-linux-10g_server rpm]# rpm -ivh --force --oldpackage libaio-0.3.105-2.x86_64.rpm

warning: libaio-0.3.105-2.x86_64.rpm: V3 DSA signature: NOKEY, key ID 9b3c94f4

Preparing...                ########################################### [100%]

   1:libaio                 ########################################### [100%]

[root@sumit-linux-10g_server rpm~]$ rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" libaio

libaio-0.3.103.3 (i386)

libaio-0.3.105.2 (x86_64)

[root@sumit-linux-10g_server rpm~]$

List of all RPMS essential for oracle 10g on RHEL4 (64 bit)

binutils-2.15.92.0.2.15 (x86_64)

binutils-2.15.92.0.2.10.EL4 (i386)

binutils-2.15.92.0.2.13.0.0.0.2 (x86_64)

compat-db-4.1.25.9 (i386)

compat-db-4.1.25.9 (x86_64)

control-center-2.8.0.12.rhel4.2 (x86_64)

cpp-3.4.3.9.EL4 (x86_64)

gcc-3.4.3.9.EL4 (x86_64)

gcc-c++-3.4.3.9.EL4 (x86_64)

glibc-2.3.4.2.13 (i686)

glibc-2.3.4.2.13 (x86_64)

glibc-2.3.4.2.39 (i686)

glibc-common-2.3.4.2.13 (x86_64)

glibc-common-2.3.4.2.39 (i386)

gnome-libs-1.4.1.2.90.44.1 (x86_64)

libstdc++-3.4.4.2 (i386)

libstdc++-3.4.3.9.EL4 (x86_64)

libstdc++-devel-3.4.3.9.EL4 (x86_64)

pdksh-5.2.14.30.3 (x86_64)

sysstat-5.0.5.19.el4 (x86_64)

xscreensaver-4.18.5.rhel4.9 (x86_64)

libaio-0.3.103.3 (i386)

libaio-0.3.105.2 (x86_64)