0 积分	1 好友	4 主题

发消息

[常规总体性能调优] Instance terminated by MMNL, pid = 1524

1^#

发表于 2012-12-22 18:02:18 | 查看: 4940| 回复: 8

本帖最后由 sunnyihui 于 2012-12-22 18:05 编辑

windows 2008 r2  oracle 10.2.0.5.14
日志先报7445，然后MMNL导致实例当掉！！

下面是alert日志信息，相关trc文件在附件

Sat Dec 22 03:11:23 中国标准时间 2012
Thread 1 advanced to log sequence 3134 (LGWR switch)
  Current log# 2 seq# 3134 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\REDO21.LOG
  Current log# 2 seq# 3134 mem# 1: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\REDO22.LOG
Sat Dec 22 03:14:25 中国标准时间 2012
Thread 1 advanced to log sequence 3135 (LGWR switch)
  Current log# 3 seq# 3135 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\REDO31.LOG
  Current log# 3 seq# 3135 mem# 1: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\REDO32.LOG
Sat Dec 22 06:00:28 中国标准时间 2012
Thread 1 advanced to log sequence 3136 (LGWR switch)
  Current log# 4 seq# 3136 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\REDO41.LOG
  Current log# 4 seq# 3136 mem# 1: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CDW\REDO42.LOG
Sat Dec 22 06:00:31 中国标准时间 2012
Errors in file e:\oracle\product\10.2.0\admin\cdw\bdump\cdw_j001_24836.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kglophup+66] [PC:0x58D4E34] [ADDR:0x127F873133] [UNABLE_TO_WRITE] []

Sat Dec 22 06:00:43 中国标准时间 2012
Errors in file e:\oracle\product\10.2.0\admin\cdw\bdump\cdw_pmon_3696.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [kglophup+66] [PC:0x58D4E34] [ADDR:0x127F873133] [UNABLE_TO_WRITE] []

Sat Dec 22 06:00:58 中国标准时间 2012
MMNL: terminating instance due to error 472
Instance terminated by MMNL, pid = 1524

cdw_j001_24836.txt

6.24 MB, 下载次数: 724

trc

cdw_pmon_3696.txt

3.23 MB, 下载次数: 725

trc

分享0

收藏0 回复只看该作者道具举报

Liu Maclean(刘相兵

2^#

发表于 2012-12-22 20:10:48

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production+ Windows NT Version V6.1 Service Pack 1

*** 2012-12-22 06:00:43.122
ksedmp: internal or fatal error
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [kglophup+66] [PC:0x58D4E34] [ADDR:0x127F873133] [UNABLE_TO_WRITE] []
check trace file e:\oracle\product\10.2.0\db_1\rdbms\trace\cdw_ora_0.trc for preloading .sym file messages
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
kglophup+66 0000000000000000 000000000 000000000 000000000
000000000
kgllccl+731 CALL??? kglophup+66 00519DC40 11D6B0C8B0
000000014 000002580
kgllcu+408 CALL??? kgllccl+731 000000E70 0052E2037 000000540
0000005A0
kslilcr+926 CALL??? kgllcu+408 007BB08A0 1211387D68
003E74F14 11D59D7B68
ksl_cleanup+2010 CALL??? kslilcr+926 11D59D7B68 000000003
000000000 120524E700
ksuxfl+1021 CALL??? ksl_cleanup+2010 007BB08A0 000003CF0 0E9C2BFB4
000000000
ksuxda+66 CALL??? ksuxfl+1021 00000002B 1206250D30
000000001 0006D4A5A
ksucln+2423 CALL??? ksuxda+66 000000E70 0052E2037 000000540
000002000
ksbrdp+988 CALL??? ksucln+2423 004BCD730 004BCD74C 000000002
000000004
opirip+700 CALL??? ksbrdp+988 6F5C3A450000001E 003E481E8
00F1BFA10 000000000
opidrv+856 CALL??? opirip+700 000000032 000000004 00F1BFD50
000000000
sou2o+52 CALL??? opidrv+856 000000032 000000004 00F1BFD50
000000003
opimai_real+268 CALL??? sou2o+52 000000000 000000000 000000000

复制代码

回复只看该作者道具举报

Liu Maclean(刘相兵

3^#

发表于 2012-12-22 20:18:40

ksl_cleanup=>kslilcr=>kgllcu=>kgllccl=>kglophup

Hdr: 6913413 10.2.0.2 RDBMS 10.2.0.2 LIB CACHE PRODID-5 PORTID-23
Abstract: INSTANCE GOT TERMINATED WITH ORA-7445 KGLOPHUP()+52
DIAGNOSTIC ANALYSIS:
--------------------
The PMON STACKS from ibisprd1_pmon_18580.trc shows that possible Bug 5605370.

复制代码

这似乎是一个顽固的BUG ，常发生在PMON清理资源时。考虑通过实例调优或者内存参数调优降低PMON清理dead process资源的概率，可能是一个WORKAROUND。

回复只看该作者道具举报

sunnyihui

4^#

发表于 2012-12-22 21:51:21

该服务器有128g内存，sga 给了70g，pga给了30g
是不是因为sga给了太大内存的缘故呢？！

回复只看该作者道具举报

wxfjordan

5^#

发表于 2012-12-24 09:40:14

Maclean, 跟踪文件 cdw_pmon_3696.txt 中的从下面这段开始, 请再指出问题所在的原因好吗?

谢谢!

----- End of Call Stack Trace -----
===================================================
PROCESS STATE
-------------
Process global information:
process: 000000120524E700, call: 0000001205374BC8, xact: 0000000000000000, curses: 0000001211387D68, usrses: 0000001211387D68
----------------------------------------
SO: 000000120524E700, type: 2, owner: 0000000000000000, flag: INIT/-/-/0x00
(process) Oracle pid=2, calls cur/top: 0000001205374BC8/0000001205374BC8, flag: (e) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 15
last post received-location: ksupsc
last process to post me: 1126c3b8 1 6
last post sent: 0 0 18
last post sent-location: ksuxfd