oracle hang due to ora 600，附件有日志。

whiterain

oracle 10.2.0.5
hpux 11.31

数据库有如下日志：
Tue May 08 21:26:27 EAT 2012
Errors in file /oracle/app/admin/upay/udump/upay2_ora_13976.trc:
ORA-00600: internal error code, arguments: [kghstack_underflow_internal_3], [0x60000000003002F0], [keybuf], [], [], [], [], []
Tue May 08 21:26:28 EAT 2012
Errors in file /oracle/app/admin/upay/udump/upay2_ora_7706.trc:
ORA-07445: exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalid permissions for mapped object] [0x000000000] [] []

Maclean Liu(刘相兵

已上传的 upay2_ora_13976.trc 似乎并不完整

也请上传 alert.log 和 upay2_ora_7706.trc

Maclean Liu(刘相兵

ODM DATA:

10.2.0.5 on HP-UX  JDBC Thin Client


ORA-00600: 内部错误代码, 参数: [kghstack_underflow_internal_3], [0x60000000003002F0], [keybuf], [], [], [], [], []

Current SQL statement for this session:
INSERT INTO TF_B_ORDER_FEE


stack call  :  rpidrv => rpiswu2 => ksmfrs => kghstack_free => cold_kghstack_underflow_internal

KGH kernel generic Heap


    SO: c000002034899958, type: 4, owner: c00000203460c628, flag: INIT/-/-/0x00
    (session) sid: 2379 trans: c000001fede42450, creator: c00000203460c628, flag: (8000041) USR/- BSY/-/-/-/-/-


    last wait for 'gc current request' wait_time=0.004482 sec, seconds since wait started=28
                file#=8f, block#=8a3e7, id#=2010001
                blocking sess=0x0000000000000000 seq=358
    Dumping Session Wait History
     for 'gc current grant busy' count=1 wait_time=0.004482 sec
                =8f, =8a3e7, =2010001
     for 'latch: cache buffers chains' count=1 wait_time=0.550922 sec
                address=c000002015c96718, number=7c, tries=0
     for 'latch: cache buffers chains' count=1 wait_time=0.012656 sec
                address=c000001ffee1a7b0, number=7c, tries=0
     for 'gc current block 2-way' count=1 wait_time=0.000332 sec
                =74, =31b11, =2000001
     for 'latch: cache buffers chains' count=1 wait_time=1.019008 sec
                address=c000002015c96718, number=7c, tries=0
     for 'latch: cache buffers chains' count=1 wait_time=0.460956 sec
                address=c000001ffee1a7b0, number=7c, tries=0
     for 'gc current block 2-way' count=1 wait_time=0.003224 sec
                =ce, =3010f, =2000001
     for 'gc current block 2-way' count=1 wait_time=0.000390 sec
                =ce, =870f8, =2000001
     for 'latch: cache buffers chains' count=1 wait_time=0.000074 sec
                address=c00000201b88df90, number=7c, tries=0
     for 'gc buffer busy' count=1 wait_time=0.120951 sec
                file#=c7, block#=4cb21, id#=10001



NO More info


related bugs:
Bug 13056736: ORA-600 [KGHSTACK_UNDERFLOW_INTERNAL_1], [0X2B288E018000], [KEYBUF]
ORA-600 [kghstack_underflow_internal_3] [ID 337030.1]


action plan:


压缩打包上传 alert.log 和 diag进程在instance crash时的trace   还有upay2_ora_7706.trc