客户端版本导致ORA-00600[kssadd_stage: null parent]

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:客户端版本导致ORA-00600[kssadd_stage: null parent]

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

有客户一台应用不能正常工作,报ORA-00600[kssadd_stage: null parent]错误,重启中间件后工作正常.
alert日志

ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []
Tue Jul 17 14:57:37 2012
Trace dumping is performing id=[cdmp_20120717145742]
Tue Jul 17 14:57:39 2012
Errors in file /oracle/10g/admin/fdjdb/udump/fdjdb2_ora_307720.trc:
ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []
Tue Jul 17 14:57:45 2012
Errors in file /oracle/10g/admin/fdjdb/udump/fdjdb2_ora_357344.trc:
ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []

trace文件

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/10g/db
System name:    AIX
Node name:      ora2
Release:        1
Version:        6
Machine:        00CCFD354C00
Instance name: fdjdb2
Redo thread mounted by this instance: 2
Oracle process number: 89
Unix process pid: 111068, image: oracle@ora2

*** ACTION NAME:() 2012-07-17 15:08:42.043
*** MODULE NAME:(gsrvr.exe) 2012-07-17 15:08:42.043
*** SERVICE NAME:(fdjdb) 2012-07-17 15:08:42.043
*** SESSION ID:(991.44140) 2012-07-17 15:08:42.043
*** 2012-07-17 15:08:42.043
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []
No current SQL statement being executed.
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+001c          bl       ksedst1              40D1A9663F9E7ABB ?
                                                   6ED89E14D59386B5 ?
ksedmp+0290          bl       ksedst               104A2CDB0 ?
ksfdmp+0018          bl       03F2735C
kgerinv+00dc         bl       _ptrgl
kgeasnmierr+004c     bl       kgerinv              11041D938 ? 700000220FFBFC8 ?
                                                   110000770 ? 7000004FDF0C700 ?
                                                   FFFFFFFFFFF89C0 ?
kssadd_stage+0080    bl       kgeasnmierr          110195490 ? 110450040 ?
                                                   104AC46B8 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 7000004F0FA9208 ?
kqreqa+0058          bl       kssadd_stage         105670038 ? 104CF7BA0 ?
                                                   000000000 ? 000000000 ?
kqrpre1+0850         bl       kqreqa               100203514 ? 1101A2B20 ?
kqrpre+001c          bl       kqrpre1              710000770 ? 000000009 ?
                                                   FFFFFFFFFFF9088 ?
                                                   28A4202200000000 ?
                                                   10012AEE4 ? FFFFFFFFFFF9080 ?
                                                   000000000 ? 11022A3E0 ?
opiosq0+009c         bl       kqrpre               000000000 ? 000000000 ?
                                                   000000000 ? 1101A2B20 ?
                                                   FFFFFFFFFFF9198 ? 1104B7C60 ?
                                                   FFFFFFFFFFF9458 ?
kpooprx+0168         bl       opiosq0              4A00000001 ? 000000001 ?
                                                   000000000 ? A40000000000FF ?
kpoal8+0400          bl       kpooprx              FFFFFFFFFFFB964 ?
                                                   FFFFFFFFFFFB680 ?
                                                   5000000050 ? 100000001 ?
                                                   000000000 ? A40000000000A4 ?
                                                   000000000 ? 1103A1AD8 ?
opiodr+0ae0          bl       _ptrgl
ttcpip+1020          bl       _ptrgl
opitsk+1124          bl       01F971E8
opiino+0990          bl       opitsk               000000000 ? 000000000 ?
opiodr+0ae0          bl       _ptrgl
opidrv+0484          bl       01F96034
sou2o+0090           bl       opidrv               3C02D9A29C ? 4A006E298 ?
                                                   FFFFFFFFFFFF8A0 ?
opimai_real+01bc     bl       01F939B4
main+0098            bl       opimai_real          000000000 ? 000000000 ?
__start+0070         bl       main                 000000000 ? 000000000 ?

--------------------- Binary Stack Dump ---------------------

咨询客户得知访问该数据库的是通过中间件(OCI)+10g Release 1 (10.1) for Windows访问数据库,然后查询MOS[ID 752149.1]发现stack trace
kssadd_stage <- kqreqa <- kqrpre1 <- kqrpre <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- main <- start 和客户端版本和访问环境都和unpublished Bug 4937225相似
处理建议
客户端升级到10.2.0.3或者更高版本

此条目发表在 ORA-xxxxx 分类目录,贴了 , , 标签。将固定链接加入收藏夹。

客户端版本导致ORA-00600[kssadd_stage: null parent]》有 1 条评论

  1. 惜分飞 说:

    SQLPLUS V1020 connection to V102 Server Failing with ORA-00600[kssadd_stage: null parent]

    Applies to:
    Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.2 - Release: 10.2 to 10.2
    
    Symptoms
    The following symptoms have been attributed to this issue :-
    
    a) V10201/V10202 Client connection reports :-
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 23 12:47:07 2008  ---> [or 10.2.0.2.0]
    
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    
    Enter password:
    ERROR:
    ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], []
    Error accessing PRODUCT_USER_PROFILE
    Warning: Product user profile information not loaded!
    You may need to run PUPBLD.SQL as SYSTEM
    ERROR:
    ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], []
    
    b) Queries on V$ views show the same problems :-
    
    SQL> select * from v$database;
    select * from v$database
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], []
    
    c) Alert log reports :-
    
    ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], []
    
    
    d) ORA-600 trace file reports :-
    
    ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], []
    No current SQL statement being executed.
    
    e) The call stack trace will be similar to :-
    
    Function List (to Full stack) (to Summary stack)
    kssadd_stage <- kqreqa <- kqrpre1 <- kqrpre <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip 
    <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- main <- start
    
    The key function for this article to be considered is 'kssadd_stage', if this is not seen
    in the stack the note is unlikely to provide a resolution.
    
    Cause
    If facing the above symptoms there is no exact match to known issues but in 
    unpublished Bug 4937225 where it is reported :-
    
    Details: 
    ORA-22 can occur on OCIStmtExecute after OCISessionBegin 
    This problem can also show as ORA-600 [kssadd_stage: null parent]
    errors after the ORA-22 errors to the client.
    Note: The fix for this issue is a CLIENT SIDE fix.
    
    This note is written in addition to Note 419992.1 as it might be possible not to see ORA-22
    
    Solution
    The identified bug can be resolved via :-
    
    a) Use a V102 client >=V10203
    
    b)  Already available oneoff fixes can be located from :
    Patch 4937225
    
    
    If this note does not resolve or the reader is not sure if applicable equally a new SR should
    be raised to ORACLE Support.