Chinaunix

标题: [求助]关于udump的一个报错 [打印本页]

作者: bluejerryu 时间: 2005-12-14 17:10
标题: [求助]关于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
DLM caught error 3113 in kjusuc - resignalling

[ 本帖最后由 bluejerryu 于 2005-12-14 17:37 编辑 ]

作者: bluejerryu 时间: 2005-12-15 08:50
有人回答没

作者: bitao 时间: 2005-12-15 12:07
将ALTER_SID。LOG也贴出来吧

作者: bluejerryu 时间: 2005-12-19 13:29
出问题的时间里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

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)