Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Tuesday, November 20, 2007

ORA-600 errors after upgrade from 9.2.0.8 to 10.2.0.3

1.ORA-00600: internal error code, arguments: [16203], [], [], [], [], [], [], []
2.ORA-00600: internal error code, arguments: [17281], [1001], [0x3AE64C028], [], [], [], [], []
3.ORA-00600: internal error code, arguments: [kcbzwb_4], [], [], [], [], [], [], []

1. Possibly bug 5108130:
Making a reference in a PL/SQL block to a synonym at a remote site R1 when
the referent of the synonym was on yet another site R2 could have resulted
in an ORA-600 [16203] error. The PL/SQL block must have been compiled by
a 9.2.0.X or earlier compiler.

2. Possibly bug 5482174:
Deinstantiation of a large number of PLSQL objects that have opened cursors
when session_cached_cursors is non-zero might hit an ORA-600 [17281] [36]
with a call stack of the form
'ksupop->kgiCallStateCleanUp->kgiLRUResize'
repeated within it a number of times.

Workaround:
Set session_cached_cursors to zero.

3. Possibly bug 5028099:
ORA-600 [kcbzwb_4] can occur when using in memory undo (IMU)
for private buffers.

Workaround:
Set "_in_memory_undo"=FALSE

No comments: