ORA-600 [15160] 错误

*** SERVICE NAME:(ora10g) 2009-10-16 14:53:42.246
*** SESSION ID:(130.40343) 2009-10-16 14:53:42.246
*** 2009-10-16 14:53:42.246
ksedmp: internal or fatal error
ORA-00600: 内部错误代码, 参数: [15160], [], [], [], [], [], [], []
Current SQL statement for this session:
INSERT INTO TMPZWKMYEBE341_09001(F_DWBH,F_KMBH,F_NCJFJEYE,F_JFJELJ,F_DFJELJ,F_DQJFJEYE,F_JFJEFS,F_DFJEFS )SELECT LSDWCN_DWBH,ZWKMYE_KMBH, Round(Sum(Round(ZWKMYE_NCYE,2)),2), Round(Sum(Round(ZWKMYE_JFLJ,2)),2), Round(Sum(Round(ZWKMYE_DFLJ,2)),2), Round(Sum(Round(ZWKMYE_DQYE,2)),2), case when LSDWCN_KJQJ>='01' then Round(Sum(Round(ZWKMYE_JFFS,2)),2) else 0 end, case when LSDWCN_KJQJ>='01' then Round(Sum(Round(ZWKMYE_DFFS,2)),2) else 0 end FROM ZWKMYE2009,ZWKMZD2009,TMPZWYEDW1E341_09001 WHERE ZWKMYE_KJND='2009' AND ZWKMYE_KJQJ=LSDWCN_KJQJ AND ZWKMYE_DWBH=LSDWCN_DWBH AND LSDWCN_KMTX='01' AND LSDWCN_BWB='01' AND LSDWCN_KJRL='01' AND ZWKMYE_KMBH=ZWKMZD_KMBH AND ZWKMZD_TX='01' AND ZWKMZD_KMBH>='1002010201' AND ZWKMZD_KMBH <='1002010201z' AND (ZWKMZD_KMLX='1' or ZWKMZD_DWBH=LSDWCN_DWBH) AND ZWKMZD_JS>='4' AND ZWKMZD_JS <='5' GROUP BY LSDWCN_DWBH,ZWKMYE_KMBH,LSDWCN_KJQJ
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedst+38 CALLrel _ksedst1+0 0 1
_ksedmp+898 CALLrel _ksedst+0 0
_ksfdmp+14 CALLrel _ksedmp+0 3
_kgeriv+146 CALLreg 00000000 37AE1ED0 3
_kgesiv+85 CALLrel _kgeriv+0 37AE1ED0 10311F60 3B38 0
32A2A070
_ksesic0+59 CALLrel _kgesiv+0 37AE1ED0 10311F60 3B38 0
32A2A070 3B38 0 32A2A070
__VInfreq__kkotap+2 CALLrel _ksesic0+0 3B38
8190
_kkoqbc+3521 CALLrel _kkoipt+0 8C8B8DC
_apakkoqb+151 CALLrel _kkoqbc+0 9A64CF8 1
_apaqbd+383 CALLrel _apakkoqb+0 32A2BD38 101D6208 664AD72C
_apaqbd+171 CALLrel _apaqbd+0
_apadrv+459 CALLrel _apaqbd+0
_opitca+1445 CALLrel _apadrv+0 664AD72C
__PGOSF359__kksFull CALLrel _opitca+0 3209AB18 664AD72C
TypeCheck+15
_rpiswu2+426 CALLreg 00000000 32A2C5BC
_kksLoadChild+5883 CALLrel _rpiswu2+0 7EB5025C 3D 7241FE88 13
72420054 3D 7241FEB4 0 5B4E9C
0 32A2C5BC 0
_kkslod+98 CALLrel _kksLoadChild+0 37AE1ED0 1546694C 32A2D3C8
_kglobld+837 CALLreg 00000000 37AE1ED0 1546694C 32A2D3C8
_kglobpn+1224 CALLrel _kglobld+0 37AE1ED0 7241FCFC 32A2D3C8
642A17B0 0
_kglpim+264 CALLrel _kglobpn+0 37AE1ED0 642A17B0 32A2D3C8 1
_kglpin+1078 CALLrel _kglpim+0 37AE1ED0 32A2D3C8 642A17B0
_kxsGetRuntimeLock+ CALLrel _kglpin+0 37AE1ED0 32A2D3C8 DD6E004
1936 1546694C 3 3 3209AB40
_kksfbc+7232 CALLrel _kxsGetRuntimeLock+ 37AE1ED0 3209AB18 32A2D3C8 3
0 1
_kkspsc0+2094 CALLrel _kksfbc+0 3209AB18 3 108 7EEE500 372 0
0 0
_kksParseCursor+143 CALLrel _kkspsc0+0
_opiosq0+1965 CALLrel _kksParseCursor+0 32A2D8A4
_kpooprx+232 CALLrel _opiosq0+0 3 E 32A2D9DC A4
_kpoal8+775 CALLrel _kpooprx+0 32A2F6FC 7EEE500 371 1 0 A4
_opiodr+1099 CALLreg 00000000 5E 17 32A2F6F8
_ttcpip+1273 CALLreg 00000000 5E 17 32A2F6F8 0
_opitsk+1017 CALL??? 00000000
_opiino+1087 CALLrel _opitsk+0 0 0
_opiodr+1099 CALLreg 00000000 3C 4 32A2FC90
_opidrv+819 CALLrel _opiodr+0 3C 4 32A2FC90 0
_sou2o+45 CALLrel _opidrv+0 3C 4 32A2FC90
_opimai_real+112 CALLrel _sou2o+0 32A2FC84 3C 4 32A2FC90
_opimai+92 CALLrel _opimai_real+0 2 32A2FCBC
_OracleThreadStart@ CALLrel _opimai+0
4+708
7C826060 CALLreg 00000000

 

Went to work this morning, to find this error in my E-Mail. Environment is SUN, using 10.2.0.2.

PURPOSE:
This article discusses the internal error "ORA-600 [15160]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance.

ERROR:
ORA-600 [15160]

VERSIONS:
versions 7.0 to 10.1

DESCRIPTION:

We are attempting to find a suitable table as the starting point in a complex join operation. This error is reported when a suitable table can not be indentified.

FUNCTIONALITY:
Kernel Kompile Optimizer

IMPACT:
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

If the Known Issues section below does not help in terms of identifying a solution, please submit the trace files and alert.log to Oracle Support Services for further analysis.

What i did was the following SQL:

1 Select o.object_name, o.object_type, o.status, t.typecode,
2 t.attributes,
3 t.methods
4 from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
5 where o.owner = 'SYSTEM'
6 and o.owner = t.owner
7 and o.object_type = 'TYPE'
8 and o.object_name = t.type_name
9* and o.subobject_name is null
SQL> /
from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
*
ERROR at line 4:
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

According to BUG 4648181 the case or problem is in the join so if you worked around like below

1 select o.object_name, o.object_type, o.status, t.typecode,
2 t.attributes,
3 t.methods
4 from SYS.DBA_OBJECTS o, SYS.DBA_TYPES t
5 where o.owner = 'SYSTEM'
6 and o.owner = t.owner
7 and o.object_type = 'TYPE'
8 and o.object_name = t.type_name
9* and o.subobject_name is null
SQL> /

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS TYPECODE ATTRIBUTES METHODS
------------------- ------- ------------------------------ ---------- ----------
REPCAT$_OBJECT_NULL_VECTOR
TYPE VALID OBJECT 4 0

 

详见http://inthirties.com:90/thread-284-3-1.html

 

 

• 提供Oracle管理/故障处理/优化/安装/RAC/备份恢复技术服务,提供专业的Oracle培训和咨询服务。
• 邮件: inthirties@gmail.com
• MSN: inthirties@hotmail.com
• QQ: inthirties@qq.com
• 专业论坛 http://www.inthirties.com
• 技术博客 http://blog.csdn.net/inthirties
• 个人站点 http://blog.inthirties.com