蓝森林首页 | 返回主页 | 本站地图 | 站内搜索 | 联系信箱 |
 您目前的位置:首页 > 自由软件 > 技术交流 > 数 据 库


    

蓝森林 http://www.lslnet.com 2006年8月26日 15:18


[求助]关于udump的一个报错

最近数据库老是并住,用户无法使用,而这个时候udump下会有很多trc而且内容都一样,如下
/oracle7/app/oracle/admin/FOX/udump/ora_89734_bsl3.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
With the Partitioning, Objects and Parallel Server options
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /oracle7/app/oracle/product/8.0.5
System name:    AIX
Node name:      LDHOST
Release:        2
Version:        4
Machine:        00064746A100
Instance name: FOX
Redo thread mounted by this instance: 1
Oracle process number: 77
Unix process pid: 89734, image:

*** 2005.12.14.15.50.20.000
*** SESSION ID:(34.24103) 2005.12.14.15.50.20.000
[b]DLM caught error 3113 in kjusuc - resignalling[/b]


有人回答没

将ALTER_SID。LOG也贴出来吧

出问题的时间里alert日志没有报错就是类似于下面的记录
Mon Dec 19 11:35:38 2005
Beginning log switch checkpoint up to RBA [0x1d181.2.10], SCN: 0x00cb.2ac90cd3
Thread 1 advanced to log sequence 119169
  Current log# 8 seq# 119169 mem# 0: /dev/rBSL3_redoa5
  Current log# 8 seq# 119169 mem# 1: /dev/rBSL3_redoa51
Mon Dec 19 11:35:51 2005
Completed checkpoint up to RBA [0x1d181.2.10], SCN: 0x00cb.2ac90cd3
Mon Dec 19 11:55:32 2005
Beginning log switch checkpoint up to RBA [0x1d182.2.10], SCN: 0x00cb.2ac92216
Thread 1 advanced to log sequence 119170
  Current log# 1 seq# 119170 mem# 0: /dev/rBSL3_redoa1
  Current log# 1 seq# 119170 mem# 1: /dev/rBSL3_redoa11
Mon Dec 19 11:55:43 2005
Completed checkpoint up to RBA [0x1d182.2.10], SCN: 0x00cb.2ac92216
Mon Dec 19 12:22:05 2005
Beginning log switch checkpoint up to RBA [0x1d183.2.10], SCN: 0x00cb.2ac93a92
Thread 1 advanced to log sequence 119171
  Current log# 2 seq# 119171 mem# 0: /dev/rBSL3_redoa2
  Current log# 2 seq# 119171 mem# 1: /dev/rBSL3_redoa21
Mon Dec 19 12:22:16 2005
Completed checkpoint up to RBA [0x1d183.2.10], SCN: 0x00cb.2ac93a92
Mon Dec 19 12:27:38 2005
Beginning log switch checkpoint up to RBA [0x1d184.2.10], SCN: 0x00cb.2ac93f47
Thread 1 advanced to log sequence 119172
  Current log# 3 seq# 119172 mem# 0: /dev/rBSL3_redoa3
  Current log# 3 seq# 119172 mem# 1: /dev/rBSL3_redoa31
Mon Dec 19 12:27:44 2005
Completed checkpoint up to RBA [0x1d184.2.10], SCN: 0x00cb.2ac93f47
Mon Dec 19 12:52:17 2005
Beginning log switch checkpoint up to RBA [0x1d185.2.10], SCN: 0x00cb.2ac9578f
Thread 1 advanced to log sequence 119173
  Current log# 7 seq# 119173 mem# 0: /dev/rBSL3_redoa4
  Current log# 7 seq# 119173 mem# 1: /dev/rBSL3_redoa41
Mon Dec 19 12:52:30 2005
Completed checkpoint up to RBA [0x1d185.2.10], SCN: 0x00cb.2ac9578f
Mon Dec 19 13:12:50 2005
Beginning log switch checkpoint up to RBA [0x1d186.2.10], SCN: 0x00cb.2ac96cd3
Thread 1 advanced to log sequence 119174
  Current log# 8 seq# 119174 mem# 0: /dev/rBSL3_redoa5
  Current log# 8 seq# 119174 mem# 1: /dev/rBSL3_redoa51
Mon Dec 19 13:13:03 2005
Completed checkpoint up to RBA [0x1d186.2.10], SCN: 0x00cb.2ac96cd3



Copyright © 1999-2000 LSLNET.COM. All rights reserved. 蓝森林网站 版权所有。 E-mail : webmaster@lslnet.com