Troubleshooting ora-600 [18194] and ora-600 [1265] error

Troubleshooting ora-600 [18194] and ora-600 [1265] error

A few days I check the DB alert log,I found the ora-600 [1265] error , recording the reasons here

#alert

Mon Dec 06 22:00:15 EAT 2014
Errors in file /opt/oracle/app/admin/anbob/udump/anbob1_ora_10082.trc:
ORA-00600: 内部错误代码, 参数: [1265], [0xC0000002FF7EF3D8], [], [], [], [], [], []
Mon Dec 06 22:00:16 EAT 2014
Trace dumping is performing id=[cdmp_20140106220016]
Mon Dec 06 22:00:16 EAT 2014
Errors in file /opt/oracle/app/admin/anbob/udump/anbob1_ora_10082.trc:
ORA-00600: 内部错误代码, 参数: [18194], [0xC0000002EE1E77E8], [0x000000000], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [1265], [0xC0000002FF7EF3D8], [], [], [], [], [], []
Mon Dec 06 22:00:18 EAT 2014
Errors in file /opt/oracle/app/admin/anbob/udump/anbob1_ora_10082.trc:
ORA-00600: 内部错误代码, 参数: [opiodr: call 2], [], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [18194], [0xC0000002EE1E77E8], [0x000000000], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [1265], [0xC0000002FF7EF3D8], [], [], [], [], [], []
Wed Dec 08 09:55:03 EAT 2014

# trace

/opt/oracle/app/admin/anbob/udump/anbob1_ora_10082.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/oracle/app/product/10.2.0/db_1
System name:    HP-UX
Node name:      anbob1
Release:        B.11.31
Version:        U
Machine:        ia64
Instance name: anbob1
Redo thread mounted by this instance: 1
Oracle process number: 107
Unix process pid: 10082, image: oracle@anbob1

*** ACTION NAME:() 2014-01-06 22:00:15.504
*** MODULE NAME:(oracle@itsmdb1 (TNS V1-V3)) 2014-01-06 22:00:15.504
*** SERVICE NAME:(anbob) 2014-01-06 22:00:15.504
*** SESSION ID:(697.29383) 2014-01-06 22:00:15.504
*** 2014-01-06 22:00:15.504
ksedmp: internal or fatal error
ORA-00600: 内部错误代码, 参数: [1265], [0xC0000002FF7EF3D8], [], [], [], [], [], []
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+64          call     ksedst1()            000000000 ? 000000001 ?
ksedmp()+2176        call     ksedst()             000000000 ?
ksfdmp()+112         call     ksedmp()             000000003 ?
                                                   4000000004071F90 ?
kgeriv()+336         call     ksfdmp()             9FFFFFFFFFFF6500 ?

kgeasi()+416         call     kgeriv()             60000000000318D0 ?

$cold_ksuprc()+544   call     kgeasi()             60000000000318D0 ?

k2send()+720         call     $cold_ksuprc()       C0000002FC7F75B0 ?

k2serv()+1296        call     k2send()             9FFFFFFFFFFF7860 ?
                                                 60000000000BA268 ?
opiodr()+2144        call     k2serv()             C0000000000018B7 ?

ttcpip()+1680        call     opiodr()             000000043 ? 000000011 ?

opitsk()+2368        call     ttcpip()             600000000003DF40 ?
                                                   000000000 ?
                                                   000000000 ?
opiino()+1664        call     opitsk()             000000000 ? 000000000 ?

opiodr()+2144        call     opiino()             00000003C ?

opidrv()+1248        call     opiodr()             00000003C ? 000000004 ?

sou2o()+240          call     opidrv()             00000003C ?

opimai_real()+496    call     sou2o()              9FFFFFFFFFFFF190 ?
                                                   00000003C ? 000000004 ?
                                                   9FFFFFFFFFFFF170 ?
main()+240           call     opimai_real()        000000000 ?
                                                   9FFFFFFFFFFFF1C0 ?
main_opd_entry()+80  call     main()               000000002 ?
                                                   9FFFFFFFFFFFF678 ?
                                                   60000000000BA268 ?
                                                   C000000000000004 ?

Search from MOS found a bug matching problem of this case.

Cause
The error ORA-600 [1265] relates to the distributed transactional area or remote SQL involving dblinks.

This is
Bug 8209133 – ORA-600 [1265] WHEN QUERYING A REMOTE VIEW
closed as duplicate of unpublished Base
Bug 5655419 – AQ: ORA-00600[K2SCHKSESS_1] AND [K2SCHKSESS_2] DURING AW2 TEST
which is fixed in Oracle RDBMS release 11.1.
Solution
Upgrade to RDBMS release 11.1 or higher in which unpublished Bug 5655419 is fixed
– OR –
apply Patch 5655419 if available for your platform and RDBMS release