kettle教程学习 2020-05-28 16:41 采纳率: 0%
浏览 1307

ORACLE运行一段时间,报ORA-00600: 内部错误代码, 参数: [2252]

oracle运行一段时间,就报2252错误,重启服务器问题解决

这是alert日志:
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_2664.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:104856M/130965M, Ph+PgF:235753M/261929M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 55
Windows thread id: 2664, image: ORACLE.EXE (SHAD)

*** 2020-05-27 19:50:04.324
*** SESSION ID:(345.5) 2020-05-27 19:50:04.324
*** CLIENT ID:() 2020-05-27 19:50:04.324
*** SERVICE NAME:(SYS$USERS) 2020-05-27 19:50:04.324
*** MODULE NAME:(JDBC Thin Client) 2020-05-27 19:50:04.324
*** ACTION NAME:() 2020-05-27 19:50:04.324

Incident 101603 created, dump file: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_101603\orcl_ora_2664_i101603.trc
ORA-00600: 内部错误代码, 参数: [2252], [3973], [637190145], [], [], [], [], [], [], [], [], []


这个是incident日志:
Dump file d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_101603\orcl_ora_2664_i101603.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:104856M/130965M, Ph+PgF:235753M/261929M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 55
Windows thread id: 2664, image: ORACLE.EXE (SHAD)

*** 2020-05-27 19:50:04.324
*** SESSION ID:(345.5) 2020-05-27 19:50:04.324
*** CLIENT ID:() 2020-05-27 19:50:04.324
*** SERVICE NAME:(SYS$USERS) 2020-05-27 19:50:04.324
*** MODULE NAME:(JDBC Thin Client) 2020-05-27 19:50:04.324
*** ACTION NAME:() 2020-05-27 19:50:04.324

Dump continued from file: d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_2664.trc
ORA-00600: 内部错误代码, 参数: [2252], [3973], [637190145], [], [], [], [], [], [], [], [], []

========= Dump for incident 101603 (ORA 600 [2252]) ========

*** 2020-05-27 19:50:04.339
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=gkt6rq77wc4pg) -----
select baqsyqkdj0_.id as id1_37_, baqsyqkdj0_.ajbh as ajbh2_37_, baqsyqkdj0_.ajid as ajid3_37_, baqsyqkdj0_.ajlx as ajlx4_37_, baqsyqkdj0_.ajmc as ajmc5_37_, baqsyqkdj0_.bamjqm as bamjqm6_37_, baqsyqkdj0_.baqcsid as baqcsid7_37_, baqsyqkdj0_.baqcsmc as baqcsmc8_37_, baqsyqkdj0_.baqcssylx as baqcssylx9_37_, baqsyqkdj0_.baqdddm as baqdddm10_37_, baqsyqkdj0_.baqddmc as baqddmc11_37_, baqsyqkdj0_.batchid as batchid12_37_, baqsyqkdj0_.bh as bh13_37_, baqsyqkdj0_.blmbid as blmbid14_37_, baqsyqkdj0_.cjrid as cjrid15_37_, baqsyqkdj0_.cjsj as cjsj16_37_, baqsyqkdj0_.companyid as companyid17_37_, baqsyqkdj0_.djjs as djjs18_37_, baqsyqkdj0_.foreignid as foreignid19_37_, baqsyqkdj0_.glyqm as glyqm20_37_, baqsyqkdj0_.jqbh as jqbh21_37_, baqsyqkdj0_.jrbaqsj as jrbaqsj22_37_, baqsyqkdj0_.jrbaqyy as jrbaqyy23_37_, baqsyqkdj0_.kpzt as kpzt24_37_, baqsyqkdj0_.qtsm as qtsm25_37_, baqsyqkdj0_.ry_id as ry_id26_37_, baqsyqkdj0_.sasy as sasy27_37_, baqsyqkdj0_.sfyx as sfyx28_37_, baqsyqkdj0_.sxcs as sxcs29_37_, baqsyqkdj0_.sxjs as sxjs30_37_, baqsyqkdj0_.sydwdm as sydwdm31_37_, baqsyqkdj0_.sydwmc as sydwmc32_37_, baqsyqkdj0_.syjssj as syjssj33_37_, baqsyqkdj0_.sykssj as sykssj34_37_, baqsyqkdj0_.tbdwdm as tbdwdm35_37_, baqsyqkdj0_.tbdwmc as tbdwmc36_37_, baqsyqkdj0_.ws_bh as ws_bh37_37_, baqsyqkdj0_.xbdwdm as xbdwdm38_37_, baqsyqkdj0_.xbdwmc as xbdwmc39_37_, baqsyqkdj0_.xbmj as xbmj40_37_, baqsyqkdj0_.xbmjid as xbmjid41_37_, baqsyqkdj0_.zbmj as zbmj42_37_, baqsyqkdj0_.zbmjid as zbmjid43_37_, baqsyqkdj0_.zhxgrid as zhxgrid44_37_, baqsyqkdj0_.zhxgsj as zhxgsj45_37_, (SELECT A.DMMC FROM ZFGCGL_DM A,ZFGCGL_DMLX B WHERE A.DMLX=B.ID AND B.LXDM='AJLX' AND A.DM=baqsyqkdj0_.AJLX) as formula31_, (SELECT A.DMMC FROM ZFGCGL_DM A,ZFGCGL_DMLX B WHERE A.DMLX=B.ID AND B.LXDM='SYLX' AND A.DM=baqsyqkdj0_.BAQCSSYLX) as formula32_ from zfgcgl_baqsyqkdj baqsyqkdj0_ where baqsyqkdj0_.foreignid=:1 and baqsyqkdj0_.companyid=:2 and baqsyqkdj0_.sfyx='1'

----- Call Stack Trace -----
calling call entry argument values in hex

location type point (? means dubious value)


ksedst1()+129 CALL??? skdstdst() 009183DA2 000000000 000000000
000000000
ksedst()+69 CALL??? ksedst1() 000000002 000000000 006F605E0
000000000
dbkedDefDump()+4536 CALL??? ksedst() 000000287 000000000 000000000
000000000
ksedmp()+43 CALL??? dbkedDefDump() 000000003 000000002 000000000
000468E71

  • 写回答

1条回答 默认 最新

  • 脑子进水养啥鱼? 2020-05-29 09:03
    关注

    数据库版本是多少?可能是bug需要升级数据库补丁图片说明

    评论

报告相同问题?

悬赏问题

  • ¥35 平滑拟合曲线该如何生成
  • ¥100 c语言,请帮蒟蒻写一个题的范例作参考
  • ¥15 名为“Product”的列已属于此 DataTable
  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 自己瞎改改,结果现在又运行不了了
  • ¥15 链式存储应该如何解决
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站