ORA-00600[17114] Error Due To Memory Corruption That Comes From SQL Tuning Advisor

(Doc ID 1911334.1)

Last updated on JULY 30, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

1. Follwing errors are seen in the alert.log:

Errors in file /proddb/oraprod/PROD/db/tech_st/11.2.0.3/admin/PROD_injprd01/diag/rdbms/prod/PROD/trace/PROD_j003_6602.trc (incident=897028):
ORA-00600: internal error code, arguments: [17114], [0x2ADCC6B31FC0], [], [], [], [], [], [], [], [], [], []
Incident details in: /proddb/oraprod/PROD/db/tech_st/11.2.0.3/admin/PROD_injprd01/diag/rdbms/prod/PROD/incident/incdir_897028/PROD_j003_6602_i897028.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Jul 02 09:01:55 2014
Dumping diagnostic data in directory=[cdmp_20140702090155], requested by (instance=1, osid=6602 (J003)), summary=[incident=897028].
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x24DB073, kxhfSync()+255] [flags: 0x0, count: 1]
Errors in file /proddb/oraprod/PROD/db/tech_st/11.2.0.3/admin/PROD_injprd01/diag/rdbms/prod/PROD/trace/PROD_j003_6602.trc (incident=897029):
ORA-07445: exception encountered: core dump [kxhfSync()+255] [SIGSEGV] [ADDR:0x0] [PC:0x24DB073] [Address not mapped to object] []
ORA-00600: internal error code, arguments: [17114], [0x2ADCC6B31FC0], [], [], [], [], [], [], [], [], [], []
Incident details in: /proddb/oraprod/PROD/db/tech_st/11.2.0.3/admin/PROD_injprd01/diag/rdbms/prod/PROD/incident/incdir_897029/PROD_j003_6602_i897029.trc
Use ADRCI or Support Workbench to package the incident.

 2. Call stack in trace file:

kghrcdepth kghrcappl kghfrempty_ex qesmmIPgaFreeCb ksu_dispatch_tac krr_thread_read krr_read_buffer krr_parse_redo kcra_scan_redo kcra_dump_redo

 

3. Trace files shows BAD MAGIC NUMBER:

 EXTENT 29 addr=0x2adcc6b31ea0
 Chunk     2adcc6b31eb0 sz=      136    perm      "perm           "  alo=136
 Chunk     2adcc6b31f38 sz=      136  BAD MAGIC NUMBER IN NEXT CHUNK (C0B38F0000000738)  ------------------>Memory corruption
 perm      "perm           "  alo=136
.....
Bucket 5 size=1048
 Chunk     2adcc6cb9e80 sz=     3824    free      "               "
 Chunk     2adcc6b31fc0 sz=     1848  ERROR, BAD MAGIC NUMBER (C0B38F0000000738)

 

4. The current SQL in trace file comes form SQL Tuning Advisor:

----- Current SQL Statement for this session (sql_id=85fy1sjzcvkn9) -----
/* SQL Analyze(1024,1) */ select rpad ( 'a' , 50 , '-' ) short_cust_name , 0 cust_id , rpad ( 'a' , 30 , '-' ) cust_no , rpad ( 'a' , 500 , '-' ) sort_field1 , rpad ( 'a' , 40 , '-' ) sort_field2 , 0 payment_sched_id , rpad ( 'a' , 32 , '-' ) class , sysdate due_date , 0 amt_due_remaining , 0 days_past_due , 0 amount_adjusted , 0 amount_applied , 0 amount_credited , sysdate gl_date , 'x' data_converted , 0 ps_exchange_rate , 0 b0 , 0 b1 , 0 b2 , 0 b3 , 0 b4 , 0 b5 , 0 b6 , rpad ( 'a' , 25 , '-' ) bal_segment_value , rpad ( 'a' , 500 , '-' ) inv_tid , rpad ( 'a' , 32 , '-' ) invoice_type from dual   where 1 = 2 UNION ALL select /*+ ORDERED */
        substrb(party.party_name,1,50) short_cust_name,
        cust_acct.cust_account_id cust_id,
        cust_acct.account_number cust_no,decode(types.post_to_gl, 'Y', c.SEGMENT1||'
...
...

  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms