故障现象:数据库使用一段时间后,客户端无法连接数据库,本地连接数据库也不行。(sqlplus/ as sysdba没反应),无奈,手工kill 掉oracle监听进程。再输命令: lsnrctl start。显现:
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-SEP-2007 15:05:54
Copyright (c) 1991, 2005, Oracle.All rights reserved.
Starting /home/oracle/product/10g/bin/tnslsnr: please wait...
长时间无反应。
此时cpu使用率很高
top - 15:06:38 up 283 days, 51 min,2 users,load average: 0.54, 0.15, 0.04
Tasks:59 total, 3 running,56 sleeping, 0 stopped, 0 zombie
Cpu0: 39.7% us, 60.3% sy,0.0% ni,0.0% id,0.0% wa,0.0% hi,0.0% si
Cpu1:0.0% us,0.0% sy,0.0% ni, 99.3% id,0.7% wa,0.0% hi,0.0% si
Mem: 4147280k total,1840436k used,2306844k free, 294012k buffers
Swap:4096532k total,272k used,4096260k free,1357560k cached
PID USERPRNIVIRTRESSHR S %CPU %MEMTIME+COMMAND
30173 oracle25 0 42756 5472 3784 R 99.90.1 0:44.30 tnslsnr
只要重启机器就一切正常了。
环境:
linux as4;oracle10.2.0.1 x86版,intel cpu的pc server
$PRACLE_HOME/network/admin和//etc/下都无listener.ora文件
listener.log无异常信息
该故障已经在多台机器多次发生了.请问可能是什么问题造成的?
谢谢了!
|