Chinaunix首页 | 论坛 | 博客
  • 博客访问: 539955
  • 博文数量: 128
  • 博客积分: 4000
  • 博客等级: 上校
  • 技术积分: 1345
  • 用 户 组: 普通用户
  • 注册时间: 2008-01-22 21:43
文章分类

全部博文(128)

文章存档

2009年(30)

2008年(98)

我的朋友

分类: Oracle

2009-07-21 08:38:57

alert警告文件中报:
Tue Jul 21 02:50:30 2009
Immediate Kill Session#: 2186, Serial#: 17945
Immediate Kill Session: sess: 70000042a6faa70  OS pid: 2265390
Tue Jul 21 02:50:30 2009
Process OS id : 2265390 alive after kill
Errors in file
Tue Jul 21 02:50:49 2009
Immediate Kill Session#: 2187, Serial#: 48042
Immediate Kill Session: sess: 7000004296fecf0  OS pid: 2760774
Tue Jul 21 02:50:49 2009
Process OS id : 2760774 alive after kill
Errors in file /oracle/admin/nrms/udump/nrms_ora_2507006.trc
Tue Jul 21 03:11:48 2009
Immediate Kill Session#: 2145, Serial#: 57134
Immediate Kill Session: sess: 7000004296e2b68  OS pid: 2404696
Tue Jul 21 03:11:49 2009
Process OS id : 2404696 alive after kill
Errors in file
Tue Jul 21 03:14:32 2009
Immediate Kill Session#: 2649, Serial#: 34742
Immediate Kill Session: sess: 700000429833dc8  OS pid: 2338998
Tue Jul 21 03:14:32 2009
Process OS id : 2338998 alive after kill
Errors in file /oracle/admin/nrms/udump/nrms_ora_1749396.trc




Metalink中的说明:


Subject:     Getting Trace Files With "Short stack dump: unable to dump stack due to error 72".
      Doc ID:     790393.1     Type:     PROBLEM
      Modified Date :     16-MAR-2009     Status:     MODERATED

In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server Enterprise Edition - Version: 10.2.0.1
This problem can occur on any platform.
Symptoms

When doing a startup or shutdown, you might see the following in the alert log :

Wed Mar 11 05:18:14 2009
Process OS id : 974992 alive after kill
Errors in file /u01/app/oracle/admin/kroprd/udump/kroprd_ora_721366.trc
Wed Mar 11 05:18:15 2009
Process OS id : 1188106 alive after kill
Errors in file /u01/app/oracle/admin/kroprd/udump/kroprd_ora_721366.trc
Wed Mar 11 05:18:17 2009
ALTER DATABASE CLOSE NORMAL

And the trace files will contain the following message :

Process Group: DEFAULT, pseudo proc: 700000057b078f0
O/S info: user: oracle, term: UNKNOWN, ospid: 840160
OSD pid info: Unix process pid: 840160, image: oraclekroprd@hemlock
Short stack dump: unable to dump stack due to error 72
Cause
The "alive after kill" messages in the Job Queue slaves can sometimes be seen if a shutdown immediate is issued during a startup or at least before the Job Queue slaves have completed initializing. It is not a problem and turning off the Job Queue Processes will simply avoid getting these trace files but that would be a severe workaround just to avoid getting 2K trace files.

The Job Queue Process subsystem is separate from the rest of the DB startup/ shutdown process and it's common for the Job Queue Processes to be alive after kill or not to startup for a while after database startup. The "alive after kill" message was removed from the alert log in 11g because too many people wrongly thought this was a big problem.
Solution

1. Ignore the messages.

2. Upgrade to 11g where this message is removed from the alert log.
References
Bug 7233028 - * TRACE FILE BEING GENERATED WHILE SHUTDOWN DATABASE

记录一下
阅读(2429) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~