Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

158

积分

1

好友

8

主题
1#
发表于 2012-4-12 14:58:36 | 查看: 8437| 回复: 7
环境9i rac 节点2的环境:/oracle/app/admin/edw/udump/edw2_ora_5537.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning and Real Application Clusters options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /oracle/app/product/10.2.0
System name:    HP-UX
Node name:      yndxedw2
Release:        B.11.31
Version:        U
Machine:        ia64
Instance name: edw2


节点2的alert里面报错:
Fri Feb 24 09:40:32 2012
Errors in file /oracle/app/admin/edw/udump/edw2_ora_5537.trc:
ORA-00600: internal error code, arguments: [rworupo.2], [128], [40], [], [], [], [], []
Thread 2 advanced to log sequence 10367
  Current log# 3 seq# 10367 mem# 0: /dev/vg32_07/rvg32_07_239
Fri Feb 24 09:40:32 2012
Errors in file /oracle/app/admin/edw/udump/edw2_ora_5537.trc:
ORA-00600: internal error code, arguments: [rworupo.2], [128], [40], [], [], [], [], []
Fri Feb 24 09:40:33 2012
Trace dumping is performing id=[cdmp_20120224094033]
Fri Feb 24 09:42:14 2012
Thread 2 advanced to log sequence 10368
  Current log# 4 seq# 10368 mem# 0: /dev/vg32_08/rvg32_08_239
Fri Feb 24 10:03:27 2012
Thread 2 advanced to log sequence 10369
  Current log# 3 seq# 10369 mem# 0: /dev/vg32_07/rvg32_07_239
Fri Feb 24 10:11:03 2012
Thread 2 advanced to log sequence 10370
  Current log# 4 seq# 10370 mem# 0: /dev/vg32_08/rvg32_08_239
Fri Feb 24 11:16:15 2012
Trace dumping is performing id=[cdmp_20120224111615]
Fri Feb 24 11:17:47 2012
Trace dumping is performing id=[cdmp_20120224111746]
Fri Feb 24 11:19:06 2012
Trace dumping is performing id=[cdmp_20120224111906]
Fri Feb 24 11:20:41 2012
Trace dumping is performing id=[cdmp_20120224112041]
Fri Feb 24 11:22:00 2012
Trace dumping is performing id=[cdmp_20120224112200]
Fri Feb 24 15:46:03 2012
Thread 2 advanced to log sequence 10371


trace文件里面信息:

*** SESSION ID:(64.50178) 2012-02-24 09:40:32.320
*** 2012-02-24 09:40:32.320
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [rworupo.2], [128], [40], [], [], [], [], []
Current SQL statement for this session:
select STD_AREA_ID,STD_AREA_NAME,col5,col6,col2,col3,col4,cc,cc2,cc3, decode(cc4, -999999999, null, cc4) cc4, decode(STD_AREA_ID, '1205', null, dense_rank() over(order
by cc4 desc)) cc5 from (select STD_AREA_ID,STD_AREA_NAME,col5,col6,col2,col3,col4,cc,cc2,cc3, decode(STD_AREA_ID,'1205',-999999999,nvl(round(decode(col3,0,0,decode(col6
, 0, 1, col3 /  col6)),2),0)) cc4 from (select STD_AREA_ID, STD_AREA_NAME, col5, col6, col2, col3, col4, nvl(round(decode(col2,0,0,col2 /  to_number(substr(:1, 7, 2))),
0),0) cc, nvl(round(decode(col3,0,0,col3 / to_number(substr(:2, 7, 2))),0),0) cc2, nvl(round(decode(col4,0,0,col4 / to_number(substr(:3, 7, 2))),0),0) cc3 from (select
distinct D.STD_AREA_ID,D.STD_AREA_NAME,col2,col3,col4,col5,col6 from (select nvl(case when std_area_id in ('12011801', '12031301', '12022001', '12041201','12053801') th
en  '1206' else substr(std_area_id, 1, 8)end, '1205') std_area_id, nvl(sum(user_num), 0) col2, sum(case when is_3g = '1' then user_num else 0 end) col3, sum(case when i
s_bi = '1' then user_num else 0 end) col4, 0 col5, /*3GM-JM-VM-;M-zM-VM-UM-6M-KM-SM-CM-;M-'M-VM-8M-1M-j(M-;M-') M-IM-hM-NM-*M-?M-U*/ 0 col6 /*3GM-JM-VM-;M-zM-VM-UM-6M-K
M-SM-CM-;M-'M-HM-UM->M-yM-VM-8M-1M-j(M-;M-') M-IM-hM-NM-*M-?M-U*/ from DA.TALDM_REG_PHONE_DEV_DH@DL_CTBILM_YN t where t.std_area_id like '1205%'  and std_area_id not in
('12011801', '12031301', '12022001', '12041201', '12053801') and t.time_cd between  :4  and :5 group by rollup(case when std_area_id in ('12011801', '12031301', '12022
001', '12041201','12053801') then  '1206' else substr(std_area_id, 1, 8)end)) A, (select std_area_id, std_area_name from (select Area_Id std_area_id, Name std_area_name
from PUB.TPREL_AREA_LEV5 where area_id like '1205%' and area_id not in ('12011801', '12031301', '12022001', '12041201', '12053801') union all select Std_Area_Id, Std_A
rea_Name from pub.tpdim_std_area where Std_Area_Id like '1205%'  ) B where length(B.Std_Area_Id) < 2 * length(1205) + 1) D where A.STD_AREA_ID(+) = D.STD_AREA_ID))) ord
er by STD_AREA_ID
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
Cannot find symbol in .
Cannot find symbol in .
Cannot find symbol in .
Cannot find symbol in .
Cannot find symbol in .
Cannot find symbol in .
ksedmp()+528         call     0000000000000000     000000000 ?
                                                   C000000000000996 ?

[ 本帖最后由 ricky 于 2012-4-12 15:02 编辑 ]
2#
发表于 2012-4-12 15:01:18
日志贴的有问题, 把完整的TRACE和alert.log  压缩后上传

回复 只看该作者 道具 举报

3#
发表于 2012-4-12 15:04:18
我重新编辑了一下,不好意思啊~~~刘大,辛苦啦~~
话说,你能读懂trace文件???

回复 只看该作者 道具 举报

4#
发表于 2012-4-12 15:06:37
edw2_ora_5537.rar (266.21 KB, 下载次数: 949) 文件在此,帮忙看看

回复 只看该作者 道具 举报

5#
发表于 2012-4-12 15:16:21
9.2.0.8 HP-UX ia64 RAC

ORA-00600: internal error code, arguments: [rworupo.2], [128], [40], [], [], [], [], []

stack call kpofrws=> qersoFetch => $cold_rworupo


      SO: c000001d013c5b40, type: 6, owner: c000001d002eb100, flag: INIT/-/-/0x00
      (enqueue) DX-00000128-00000000    DID: 0002-0095-0000F83D
      lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
      res: c000001d0042dcf8, mode: S, prv: c000001d0042dd08, sess: c000001d002eb100, proc: c000001cff3138f0


DA.TALDM_REG_PHONE_DEV_DH@DL_CTBILM_YN

DBLINK & DX enqueue indicate        Complex query wih dblink

回复 只看该作者 道具 举报

6#
发表于 2012-4-12 15:22:42
ODM FINDING:


Note FROM MOS


Hdr: 5854027 9.2.0.8 RDBMS 9.2.0.8 UNKNOWN PRODID-5 PORTID-23
Abstract: ORA-600 [RWORUPO.2] OR ORA-600[RWORUPO.1] WHEN QUERYING WITH DBLINK



1. 确认DBLINK 所在实例的  版本 V$VERSION

2. 改写原始SQL 绕过该问题

回复 只看该作者 道具 举报

7#
发表于 2012-4-12 15:35:38
好的!谢谢你啊~你怎么看出来是dblink的?牛哦,我没有看出来

回复 只看该作者 道具 举报

8#
发表于 2012-4-12 15:37:19
拿 128这个magic number去 trace里搜索 就找到了 DX-00000128-00000000 这个enqueue , 看到这个enqueue 自然而然想到 应当有 DBLINK

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-24 09:39 , Processed in 0.050423 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569