ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [], causing the batch schedule program failing.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:     ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [], causing the batch schedule program failing.

Symptoms:

On HP-UX Itanium running 10.2.0.4 in Production

The following error causes the batch schedule program failure.

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

Log files:

trace

*** 2010-07-13 09:52:14.429
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
Current SQL statement for this session:
select case
when o.seq = 1 and o.max_val = 1 then
' <Item'||chr(10)||
' ChangeType="'|| decode(o.change_type,'ADD','UPS',o.change_type)||'"'||chr(10)||
' ID="'||o.item||'"'||chr(10)||
' Type="'||o.item_type||'"'||chr(10)||
.
.
.

and o.vat_region = vd.vat_region (+)
and o.item = vi.item (+)
and o.vat_region = vi.vat_region (+)
and vi.seq (+) = 1
order by o.item, o.seq, o.max_val
----- Call Stack Trace -----

ksedst <- ksedmp <- ksfdmp <- kgeriv <- kgesiv <- ksesic0 <- 
kkoipt kkoqbc apakkoqb apaqbd apaqbd apadrv opitca kksFullTypeCheck rpiswu2

Solution:

Bug:5652086 - OERI[15160] from ANSI join 
Fixed-Releases: A204 B200 
Tags: ANSI OERI Details: A query with a ANSI join can fail with ORA-600 [15160].


Note 5652086.8 - Bug 5652086 - OERI[15160] from ANSI join

This error due to the problem investigated in the following bug
Bug:5652086 - OERI[15160] from ANSI join 

- Upgrade to 10.2.0.5
- No solution for the issue available on top of 10.2.0.3 (No patches available on 10.2.0.3 for HP-UX Itanium)

1. Download and review the readme and pre-requisites ** CAREFULLY** for Patchset 6810189

Patchset 8202632
Description 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE
Product Oracle Database Family
Release 10.2.0.5

2. Ensure that you have taken a backup of your system before applying the patchset

3. Apply the patchset in a test environment. 

4. Retest the issue. 

5. Migrate the solution as appropriate to other environments. 

Workaround:
-------------

he only possible method that's may to stop the error is testing the following values

1) alter session set "_qa_control"=521;
2) alter session set "_qa_control"=64;
3) alter session set "_qa_control"=32;
4) alter session set "_qa_control"=16;
5) alter session set "_qa_control"=8;
6) alter session set "_qa_control"=4;
7) alter session set "_qa_control"=2;
8) alter session set "_qa_control"=1;
9) alter session set "_qa_control"=0;

Test each of the values above in a separate session in the same order.

Get Oracle Certifications for all Exams
Free Online Exams.com