Oracle无缘无故卡死解决,oracle的后台进程隔三差五的突然死掉,谁遇到过?

下面3个是alert中的信息

------------------------------------------------------

Wed Nov 22 22:18:01 2006

MMNL: terminating instance due to error 472

Instance terminated by MMNL, pid = 984

Wed Nov 22 23:55:04 2006

-----------------------------------------------------------------------------------------

Fri Nov 24 03:46:01 2006

Errors in file /home/oracle/admin/wdb/bdump/wdb_pmon_17592.trc:

ORA-00822: MMAN process terminated with error

Fri Nov 24 03:46:01 2006

PMON: terminating instance due to error 822

Instance terminated by PMON, pid = 17592

-------------------------------------------------------------------------------------------

Sat Dec  2 14:10:01 2006

Errors in file /home/oracle/admin/wdb/bdump/wdb_pmon_27448.trc:

ORA-00474: SMON process terminated with error

Sat Dec  2 14:10:01 2006

PMON: terminating instance due to error 474

Instance terminated by PMON, pid = 27448

----------------------------------------------------------------------------------

OS:Red hat AS3  DB:10.2.0.2.0

dmesg中有如下信息

application bug: sqlplus(17505) has SIGCHLD set to SIG_IGN but calls wait().

(see the NOTES section of 'man 2 wait'). Workaround activated.

application bug: sqlplus(6462) has SIGCHLD set to SIG_IGN but calls wait().

(see the NOTES section of 'man 2 wait'). Workaround activated.

application bug: sqlplus(31950) has SIGCHLD set to SIG_IGN but calls wait().

(see the NOTES section of 'man 2 wait'). Workaround activated.

application bug: sqlplus(27124) has SIGCHLD set to SIG_IGN but calls wait().

(see the NOTES section of 'man 2 wait'). Workaround activated.

application bug: sqlplus(17973) has SIGCHLD set to SIG_IGN but calls wait().

(see the NOTES section of 'man 2 wait'). Workaround activated.

application bug: sqlplus(17973) has SIGCHLD set to SIG_IGN but calls wait().

(see the NOTES section of 'man 2 wait'). Workaround activated.

----------------------------------------------------------------------------------------------------

Display of wdb_pmon_17592.trc File

Information Taken from /home/oracle/admin/wdb/bdump/wdb_pmon_17592.trc

-rw-r----- 1 oracle oinstall 5065  Nov 23 19:46 2006  Nov 23 19:46 2006  wdb_pmon_17592.trc

/home/oracle/admin/wdb/bdump/wdb_pmon_17592.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

ORACLE_HOME = /home/oracle/app/oracle/OraHome_1

System name:        Linux

Node name:        wzlmst

Release:        2.4.21-37.ELsmp

Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005

Machine:        i686

Instance name: wdb

Redo

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值