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