Setup tracing in database

When you encounter the DB issues in any scenario, turn on the tracing in the database and then check the trace log files. For this, run the following command:

SQL> alter system set events ‘2074 trace name errorstack level 3’;

Check the alert log file for the similar lines:

Mon Apr 08 1:31:34 2010 Errors in file <InstanceName>_ora_00600.trc
Mon Apr 08 1:31:36 2010 Errors in file <InstanceName>_ora_11335.trc

Then you can go through the trace files to know the exact error. More information can be found here.