Oracle, ora-00600

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

what is a library cash object?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

here is the offending sql (portion of it..) its an update statement...

FFFFFFFFFFFB140 75706461 74652041 51544954 30312E54 [update AQTIT01.T]
FFFFFFFFFFFB150 51545F49 545F494E 424F554E 445F5345 [QT_IT_INBOUND_SE]
FFFFFFFFFFFB160 51207365 7420494E 424F554E 445F4F55 [Q set INBOUND_OU]
FFFFFFFFFFFB170 54424F55 4E445F49 0FFFFFFF FFFFE1D0 [TBOUND_I........]
FFFFFFFFFFFB180 45515F4E 42523D3A 00000002 4F445F49 [EQ_NBR=:....OD_I]

the process/app processes inbound table and send the processed rows to outbound table and writes an audit row...
so the explanation is that the oracle crashed while loading one of the object required for the process into memory? is something wrong with the object or was it out of memory?
trying to find the cause ...

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

i dont have access to the trace file ...
the dba said...
Someone was doing something that forced the database to crash. This is a test environment so it is not locked down. In other words, it is a free for all. I have no way of knowing what/who caused the crash. We do not apply patches for an event that occurs in test for those reasons. If we were to encounter this in production it would obviously be a concern.

and he gave us the sql which caused the crash...
so trying to find the exact cause and what exactly ora 00600 means..

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

i see..
in the 'test' region, the database crashed after one update statement..
the next thing that happened was: in the 'qa' region my collegue started processing 60000 rows, the 'qa' database crashed after processing for about 7 minutes...

recently some changes were applied to the queries in the app which is a java program which uses hibernate...also a new audit table was created to capture the process audits..
so trying to pinpoint the cause of the 2 crashes...

the new table has a column called - HOST VARCHAR2(100 BYTE),...
is column name 'HOST' a reserved name..? and cannot be used in a create table statement..? could that be the cause..?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

found that trigger is causing the problem...
the trigger is inserting into a audit table..
and the clob field on the audit table is causing the error...
when the clob is set to null, no error, has processed about 25000 rows so far..

is there a problem in inserting a clob column via a trigger..?

ASKER

sorry the trigger has been disabled... so the process is running, no error...

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.