说明：
系统是从2003年底开始启用的，我最近才接手，对于系统的历史情况不了解，但从alert.log文件知道，ORA-00600 [17069]错误去年就有了，一直没有得到解决。现在把系统的基本情况和ORA-00600的错误信息贴出来，希望能得到大家的帮助：
1.系统环境：
OS Version:AIX-5.2
CPU-NUM:4
MEMORY: 8192MB(8G)
Hostname(Node_Name): serv_dxsq
Oracle Version: Oracle8i Enterprise Edition Release 8.1.7.4.0
ORACLE_BASE: ORACLE/APP/ORACLE
ORACLE_HOME: ORACLE/APP/ORACLE/PRODUCT/8.1.7
Global_DBName:db_dxsq
DB_NAME: db_dxsq
SID(INSTANCE_NAME): dxsq
open_cursors = 500
processes = 600
log_archive_start = true
log_archive_dest = "/arc_oracle/arch"
log_archive_format = arch_%t_%s.arc
2.错误信息
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17069], [2414478604], [], [], [], [], [], []
Current SQL statement for this session:
BEGIN p_main_day_crm; END;
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17069], [2318353484], [], [], [], [], [], []
Current SQL statement for this session:
begin DW.P_STAT_RP_NWK_MDSE_SPEC_PRI('20081019'); end;
Mon Sep 22 19:25:13 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_149892_dxsq.trc:
ORA-00600: internal error code, arguments: [17069], [2318286600], [], [], [], [], [], []
Mon Sep8 14:13:58 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_159292_dxsq.trc:
ORA-00600: internal error code, arguments: [17069], [2317686156], [], [], [], [], [], []
Wed Aug 20 20:20:40 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_133362_dxsq.trc:
ORA-00600: internal error code, arguments: [17069], [2255896180], [], [], [], [], [], []
Mon Aug 11 17:24:02 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_130692_dxsq.trc:
ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], []
Mon Aug 11 17:34:21 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_130692_dxsq.trc:
ORA-00600: internal error code, arguments: [18260], [0], [], [], [], [], [], []
Error 600 trapped in 2PC on transaction 23.93.1404. Cleaning up.
Error stack returned to user:
ORA-00600: internal error code, arguments: [18260], [0], [], [], [], [], [], []
Thu Aug7 14:11:05 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_127694_dxsq.trc:
ORA-00600: internal error code, arguments: [15212], [15], [], [], [], [], [], []
Thu Jul 31 17:54:00 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_163158_dxsq.trc:
ORA-00600: internal error code, arguments: [17069], [2260022540], [], [], [], [], [], []
Wed Jul 30 14:23:59 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_133288_dxsq.trc:
ORA-00600: internal error code, arguments: [17069], [2303889760], [], [], [], [], [], []
Tue Jul 29 16:09:34 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_108566_dxsq.trc:
ORA-00600: internal error code, arguments: [kcblibr_user_found], [4294967295], [7], [41945602], [2560], [], [], []
Fri Jul 25 10:27:30 2008
Errors in file /oracle/app/oracle/admin/db_dxsq/udump/ora_156322_dxsq.trc:
ORA-00600: internal error code, arguments: [17069], [2120972772], [], [], [], [], [], []
... ...
还有很多600的错误，但主要是[17069]的
3.trc文件
我把最近的一个trc文件贴出来，
/oracle/app/oracle/admin/db_dxsq/udump/ora_147802_dxsq.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /oracle/app/oracle/product/8.1.7
System name: AIX
Node name: serv_dxsq
Release: 2
Version: 5
Machine: 000213FA4C00
Instance name: dxsq
Redo thread mounted by this instance: 1
Oracle process number: 26
Unix process pid: 147802, image: [email=oracle@serv_dxsq]oracle@serv_dxsq[/email] (TNS V1-V3)
*** SESSION ID
89.5427) 2008-10-20 14:04:07.717
*** 2008-10-20 14:04:07.717
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17069], [2414478604], [], [], [], [], [], []
Current SQL statement for this session:
BEGIN p_main_day_crm; END;
----- Call Stack Trace -----
calling
call entry
argument values in hex
location
type point
(? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+00cc
bl ksedst
1 ?
ksfdmp+0018
bl ksedmp
1 ?
kgeriv+0104
bl _ptrgl
kgesiv+0078
bl kgeriv
0 ? 0 ? 0 ? 0 ? 0 ?
kgesic1+0038 bl kgesiv
0 ? 200AF558 ? 2FF1C2A4 ?
2FF1C2A0 ? 0 ?
kglgob+0298
bl kgesic1
20009470 ? 2013A344 ? 42AD ?
0 ? 8FEA050C ? 6 ? 89718234 ?
8CEC04D0 ?
kgldpo+0394
bl kglgob
20009470 ? 2FF1C3D0 ? 2 ? 2 ?
2 ? 2 ? 2FF1C0B0 ? 2FF1C2A4 ?
kgldon+0134
bl kgldpo
0 ? 2FF1C200 ? 80E3F3C0 ?
53595300 ? 20008398 ? 328 ?
328 ? 80000329 ?
pkldon+0120
bl kgldon
8364C358 ? 20008398 ?
2FF1C790 ? 200CE0D8 ?
80E3F3C0 ? 0 ? 2FF1C380 ?
8F824478 ?
pkloud+00e8
bl pkldon
0 ? 0 ? 2000 ? 2FF1C440 ?
20009470 ? 2000AE18 ?
2FF1C400 ? 84282040 ?
phnnrl_name_re+0168bl pkloud
20009470 ? 2FF1C810 ?
2FF1C4A0 ? 48884040 ?
10B4004C ? 2FF1C810 ?
2FF1C4A0 ? 0 ?
phngdl_get_def+00acbl phnnrl_name_re 1001AEA4 ? 2FF1C688 ?
2FF1C8B0 ? 0 ? 0 ? 2014E410 ?
117A81D0 ? 0 ?
phnrpls_resolv+0020bl phngdl_get_def B ? 0 ? 0 ?
phnrp_resolve_+0078bl phnrpls_resolv 10AF5558 ? 20002 ?
phnr_resolve+0058bl phnrp_resolve_ 20002 ? 20002 ?
ph2ogc+013c
bl phnr_resolve 8EAD3B98 ? 0 ?
ph2orc+0090
bl ph2ogc
0 ? 2FF1EE70 ? 0 ? 20009470 ?
ph2osc+03dc
bl ph2orc
2FF1D590 ? 20003 ? 2 ? 0 ?
C ? 2 ? 116DDC18 ? 0 ?
ph2op1+00f8
bl ph2osc
0 ? 2FF1F420 ? 2FF1D0F0 ?
ph2stm+1314
bl ph2op1
0 ? 0 ?
ph2sms+0128
bl ph2stm
0 ? 200094E4 ?
ph2blo+0224
bl ph2sms
2FF1D590 ? 7B59202C ? E ? 0 ?
0 ? 0 ? 4000000 ? 7FFF ?
ph2stm+0488
bl ph2blo
0 ? 200AF558 ?
ph2uni+0a34
bl ph2stm
0 ? 200AF558 ?
ph2dr2+01b8
bl ph2uni
2FF1DDB0 ? 2000A ? 2FF1D530 ?
ph2drv+00cc
bl ph2dr2
2FF1DA80 ? 20009470 ?
82242040 ?
phpsem+03d8
bl ph2drv
2FF1DDB0 ? 896F3700 ?
2FF1DD60 ?
phpcmp+0590
bl phpsem
0 ? 0 ? 0 ?
pcisem2+0100 bl phpcmp
2FF1DDB0 ? 896F3700 ? 0 ? 0 ?
2009470 ? 40C ? 0 ?
2FF1DD60 ?
kkxsem+0154
bl pcisem2
2FF1DDB0 ? 896F3700 ?
2FF1DD88 ? 2FF1DD60 ?
opitca+0494
bl kkxsem
201324E8 ?
kksctca+0018 bl opitca
2014BCD8 ? 8EAD32B4 ?
rpiswu2+0210 bl _ptrgl
kkslod+0dd0
bl rpiswu2
902FAB60 ? 0 ? 2FF1E6F0 ?
88FCDBEC ? 90 ? 31 ?
8CEA9658 ? 0 ?
kglobld+02f8 bl _ptrgl
kglobpn+03f8 bl kglobld
20009470 ? 7002F220 ?
2FF1EF70 ? 7EA975EC ? 0 ?
kglpim+014c
bl kglobpn
20138ECC ? 20009470 ?
2FF1EA70 ? 12C ?
kglpin+0898
bl kglpim
20009470 ? 2FF1EF70 ?
7EA975EC ?
kksfbc+1724
bl kglpin
20009470 ? 2FF1EF70 ?
8CEAD3DC ? 896F3700 ? 3 ?
31 ? 2014BD2C ?
kkspsc0+05b8 bl kksfbc
2014BCD8 ? 3 ? 8 ? 2FF2081C ?
1D ? 8CEA9658 ? 0 ? 0 ?
opiosq0+07f8 bl kkspsc0
2013DF88 ? 2FF2081C ? 1D ?
3 ? 6 ? 4000000 ? 0 ?
opiall0+01f0 bl opiosq0
3 ? 2FF20440 ? 0 ? 4000328 ?
kpoal8+0678
bl opiall0
5E ? 22 ? 2FF1FC78 ? 0 ?
2FF1FC20 ? 20131B40 ? 1C ?
4422023 ?
opiodr+0668
bl _ptrgl
ttcpip+09d8
bl _ptrgl
opitsk+066c
bl ttcpip
57B ? 200AF4A0 ? 2FF21458 ?
7FF ? 0 ? 0 ? 0 ? 0 ?
opiino+061c
bl opitsk
2000CE80 ?
opiodr+0668
bl _ptrgl
opidrv+0450
bl opiodr
3C ? 4 ? 2FF22B98 ? 0 ?
sou2o+0028 bl opidrv
3C ? 4 ? 2FF22B98 ?
main+0130
bl sou2o
20000A74 ? F0374E80 ?
2FF22A60 ? F037586C ?
__start+0088 bl main
2 ? 2FF22C0C ?
----- Argument/Register Address Dump -----
Argument/Register addr=1.
Dump of memory from 0x0 to 0x101
000 00000000 00000000 00000000 00000000[................]
Repeat 15 times
100 60000000
[`...]
Argument/Register addr=200af558.
Dump of memory from 0x200AF518 to 0x200AF658
200AF510
200CA758 200CA764
[ ..X ..d]
200AF520 200CA770 20025458 00000150 200AF480[ ..p .TX...P ...]
200AF530 00000000 00000000 000001A8 000000A4[................]
200AF540 00000070 00000034 00000024 200CA77C[...p...4...$ ..|]
200AF550 00000068 200CA788 200CA794 200CA7A0[...h ... ... ...]
200AF560 200CA7A0 200CA7A0 200CA7A0 200CA7A0[ ... ... ... ...]
200AF570 200CA7A0 200CA7AC 200CA7A0 200CA7A0[ ... ... ... ...]
200AF580 200CA7A0 200CA7B8 200CA7C4 200CA7A0[ ... ... ... ...]
200AF590 200CA7A0 00000000 200CA7D0 200CA7DC[ ....... ... ...]
200AF5A0 200CA7E8 200CA7A0 200CA7A0 200CA7A0[ ... ... ... ...]
200AF5B0 200CA7F4 200CA7A0 200CA7A0 200CA800[ ... ... ... ...]
200AF5C0 200CA80C 200CA818 200CA824 200CA830[ ... ... ..$ ..0]
200AF5D0 200CA83C 200CA848 200CA7A0 00000000[ ..< ..H .......]
200AF5E0 00000000 00000000 00000000 00000000[................]
Repeat 6 times
200AF650 00000000 00000000
[........]
Argument/Register addr=2ff1c2a4.
Dump of memory from 0x2FF1C264 to 0x2FF1C3A4
2FF1C260
84084820 1009A030 00000000[..H ...0....]
2FF1C270 00000000 200094E4 00000000 2FF1C200[.... ......./...]
2FF1C280 80E3F3C0 53595300 20008398 00000328[....SYS. ......(]
。。。 。。。//太长了，没法全部都贴出来
201418E0 200C8BE0 200C8BC8 00000000 00000000[ ... ...........]
201418F0 00000000 00000190 200C8BBC 200C8BD4[........ ... ...]
20141900 00000000 00000019 201418C0 [........ ...]
ub1 * kwqit_p [2013F9C4, 2013F9C8) = 00000000
ub1 * kwqin_p [2013F9C8, 2013F9CC) = 00000000
ub1 kwqiz_p [2013F9CC, 2013F9D0) = 00000000
ub4 kwqis_p [2013F9D0, 2013F9D4) = 00000000
ub4 kwqil_p [2013F9D4, 2013F9D8) = 00000000
kwqpoidnd * kwqpo_p [2013F9D8, 2013F9DC) = 00000000
kwqpsctx * kwqps_p [2013F9DC, 2013F9E0) = 00000000
kwqprctx * kwqpr_p [2013F9E0, 2013F9E4) = 00000000
kgghst * kwqma_p [2013F9E4, 2013F9E8) = 20140200
Dump of memory from 0x20140200 to 0x20140240
20140200 201401E8 00000003 00000000 40000000[ ...........@...]
20140210 40400000 200B4F00 200B4EE8 00000000[@@.. .O. .N.....]
20140220 00000000 00000000 00000058 200B4EDC[...........X .N.]
20140230 200B4EF4 00000000 0000040D 201401F4[ .N......... ...]
kwqjw * kwqjwh_p [2013F9E8, 2013F9EC) = 00000000
knceug * kncem_p [2013F9EC, 2013F9F0) = 00000000
ub1 kkziu_p [2013F9F0, 2013F9F4) = 09000000
hogxdef* hogcu_p [2013F9F4, 2013F9F8) = 00000000
ub4 ksmugmg2 [2013F9F8, 2013F9FC) = 0000CDCD
我已将trc文件以附件的形式上传了，见如下附件。
4.希望能得到大家的帮助，小弟感激不尽！！！ |
