Hi, I have a problem to restart the oracle data on one of my development box.
OS:
[oracle@host db_1]$ more /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 5)
[oracle@host db_1]$ uname -i
x86_64
Oracle:
[oracle@host db_1]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Nov 14 16:53:44 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Problem:
The oracle is running fine on this box until yesterday, I did a "up2date -fu" (For redhat, it will download and install any available patches, including kernel patches). Maybe I shouldn't have done it. Anyway, it downloaded a lot of RPMS and start to patch. During the patch, it complains that the exiting glibc-common-2.3.4-2.36 conflict with downloaded from redhat. So I manual remove the following RPMs by:
rpm -e glibc-common-2.3.4-2.36,
rpm -e glibc-common-2.3.4-2.36
and rpm -e glibc-headers-2.3.4.36.
(I believe that I manually installed these RPMs from somewhere before, when I installed the Oracle 10g R2, which I had to at that time). Then the whole patching things works fine. Since I notified there is a kernel patch installed, I reboot the box after that.
Then the problem comes:
I can't start the oracle anymore. Basically, I can't login as sysdba to start the instance. Here is the output:
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Nov 14 17:00:39 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12157: TNS:internal network communication error
Of course, the ORACLE_HOME and ORACLE_SID are set correctly. Then I found there is sqlnet.log generated under $ORACLE_HOME/, it contains the following log:
Fatal NI connect error 12157, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/oracle/product/10.2.0/db_1/bin/oracle)(ARGV0=oracleDEV1)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=host)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.3.0 - Production
Time: 14-NOV-2007 16:18:47
Tracing not turned on.
That's the only thing I can get. I recheck the Oracle installation document for Redhat Linux x86(64) and try to make sure the following RPMs existing on my box:
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \
binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs \
libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaiobinutils-2.15.92.0.2-22 (x86_64)
compat-db-4.1.25-9 (i386)
compat-db-4.1.25-9 (x86_64)
control-center-2.8.0-12.rhel4.5 (x86_64)
gcc-3.4.6-8 (x86_64)
gcc-c++-3.4.6-8 (x86_64)
glibc-2.3.4-2.36 (x86_64)
glibc-2.3.4-2.36 (i686)
glibc-common-2.3.4-2.36 (x86_64)
gnome-libs-1.4.1.2.90-44.1 (x86_64)
libstdc++-3.4.6-8 (x86_64)
libstdc++-3.4.6-8 (i386)
libstdc++-devel-3.4.6-8 (x86_64)
make-3.80-6.EL4 (x86_64)
pdksh-5.2.14-30.3 (x86_64)
sysstat-5.0.5-15.0.1.el4 (x86_64)
xscreensaver-4.18-5.rhel4.14 (x86_64)
libaio-0.3.105-2 (i386)
libaio-0.3.105-2 (x86_64)
It looks like all the RPMs are there. Please help me how I can fix it? I am sure it maybe just some RPMs' problems, or at least help me to turn on the trace to get more log to find out what is the problem?
Thanks for your kind help!!!