Oracle prompt Troubleshooting ORA-600 [kghstack_alloc] & ORA-600 [kponPurgeUnreachLoc-3]

Env: 11.2.0.3.7 2 nodes RAC on HPux IA. You don't need this environment. You don't know how many bugs there are in this environment ()"!, Simple record.

# Symptom

Adrci> show incident
**************************************** *********************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-----------------------------------------------------------------------------------------------------------------------
...
...
2070973 ORA 600 [kponPurgeUnreachLoc-3] 11:28:11. 986000 + 08: 00
2068044 ORA 600 [kghstack_alloc] 14:28:13. 754000 + 08: 00
2068045 ORA 600 [kponPurgeUnreachLoc-3] 14:28:15. 381000 + 08: 00
2070180 ORA 600 [kghstack_alloc] 17:28:16. 905000 + 08: 00
2070181 ORA 600 [kponPurgeUnreachLoc-3] 17:28:18. 631000 + 08: 00
2068396 ORA 600 [kghstack_alloc] 20:28:17. 894000 + 08: 00
2068397 ORA 600 [kponPurgeUnreachLoc-3] 20:28:19. 515000 + 08: 00
...

SQL> @ p cursor

NAME VALUE
--------------------------------------------------------------------------------
_ Row_cache_cursors 20
_ Cursor_features_enabled 2 <
_ Cursor_runtimeheap_memlimit 5242880
_ Cursor_stats_enabled TRUE
_ Fast_cursor_reexecute FALSE
Cursor_space_for_time FALSE
Session_cached_cursors 200
_ Cursor_obsolete_threshold 100
_ Disable_cursor_sharing FALSE
...
# Analysis

Trace file/oracle/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_q003_17743.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
ORACLE_HOME =/oracle/app/oracle/product/11.2.0.3/dbhome_1
System name: HP-UX
Node name: qdtza1
Release: B .11.31
Version: U
Machine: ia64
Instance name: anbob1
Redo thread mounted by this instance: 1
Oracle process number: 549
Unix process pid: 17743, image: oracle @ qdtza1 (Q003)

* ** 20:28:17. 905
* ** Session id: (1427.19279) 20:28:17. 905
* ** Client id :() 20:28:17. 905
* ** Service name :( SYS $ BACKGROUND) 20:28:17. 905
* ** Module name :( Streams) 20:28:17. 905
* ** Action name: (QMON Slave) 20:28:17. 905

1> ***** Incident 2068396 created, dump file :*****
/Oracle/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_2068396/anbob1_q003_17743_i2068396.trc
1 <****** incident_file ****** 1> ******* Error Stack *****
ORA-00600: internal error code, arguments: [kghstack_alloc], [define handles], [], [], [], [], [], [], [], [], []
1 <***** Error Stack ***** 1> ****** Incident 2068397 created, dump file :*****
/Oracle/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_2068397/anbob1_q003_17743_i2068397.trc
1 <***** incident_file ****** Dump continued from file: /oracle/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_q003_17743.trc 1> ***** Error Stack *****
ORA-00600: internal error code, arguments: [kghstack_alloc], [define handles], [], [], [], [], [], [], [], [], []
1 <***** Error Stack ***** 1> ****** Dump for incident 2068396 (ORA 600 [kghstack_alloc]) *****

* ** 20:28:17. 907
DbkedDefDump (): Starting incident default dumps (flags = 0x2, level = 3, mask = 0x0)
2> ***** Current SQL Statement for this session (SQL _id = 5udxh0ykgshkb )*****
Select location_name, max (r. reg_id) from reg $ r left outer join gv $ subscr_registration_stats v on r. reg_id = v. reg_id where location_name like
'Net8: // (% 'group by location_name having min (current_timestamp-nvl (last_ntfn_sent_time, reg_time)>: 1
2 <***** current_ SQL _statement ****** 2> ****** Call Stack Trace *****
Calling call entry
Location type point
------------------------------------------------
Skdstdst () + 64 calling kgdsdst () 000000002?
Ksedst () + 432 call skdstdst ()
DbkedDefDump () + 1440 call ksedst ()
Ksedmp () + 64 call dbkedDefDump ()
Ksfdmp () + 96 call ksedmp ()
$ Cold_dbgexPhaseII (call ksfdmp ()
) + 576
DbgexProcessError () call $ cold_dbgexPhaseII (
+ 2096)
DbgeExecuteForError call dbgexProcessError ()
() More than 288
DbgePostErrorKGE () + call dbgeExecuteForError
2368 ()
DbkePostKGE_kgsf () + call dbgePostErrorKGE ()
128
Kgeade () + 496 call dbkePostKGE_kgsf ()
Kgeriv_int () + 176 call kgeade ()
Kgeriv () + 48 call kgeriv_int ()
Kgesiv () + 192 call kgeriv ()
Ksesic2 () + 176 call kgesiv ()
$ Cold_ksmapg () + 736 call ksesic2 ()
Kghgex () + 2016 call $ cold_ksmapg ()
Kghalf () + 592 call kghgex ()
Kghstack_overflow_ I call kghalf ()
Nternal () + 672
Kghstack_alloc () + 40 call kghstack_overflow_ I
0 nternal ()
Kpoopq () + 832 call kghstack_alloc ()
Kpoal8 () + 7856 call kpoopq ()
Opiodr () + 2416 call kpoal8 ()
Kpoodr () + 1776 call opiodr ()
...

# Solution

Bug 14601231 ORA-7445 [kpughndlarr]/assorted ORA-600
The call stack des kpoopq ()

Set _ cursor_features_enabled = 514 (I have see 1026 in A product DB)

NOTE: you need change the parameter then restart the instance before changes take effect.