Oracle Database Discussions

Hi Team,

My Oracle 10g Database stopped automatically. When i checked the alert log i found the below Errors:

Errors in file /opt/oracle/admin/DWS/bdump/dws_p000_10374.trc:
ORA-10388: parallel query server interrupt (failure)
Fri Mar 2 18:55:18 2012
SMON: Restarting fast_start parallel rollback
Fri Mar 2 18:55:47 2012
Thread 1 advanced to log sequence 384310 (LGWR switch)
Current log# 3 seq# 384310 mem# 0: +DBDG/dws/onlinelog/group_3.259.733426831
Fri Mar 2 18:57:48 2012
Errors in file /opt/oracle/admin/DWS/bdump/dws_p000_10374.trc:
ORA-10388: parallel query server interrupt (failure)
Fri Mar 2 18:57:49 2012
Errors in file /opt/oracle/admin/DWS/bdump/dws_smon_10337.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Fri Mar 2 19:18:31 2012
Errors in file /opt/oracle/admin/DWS/bdump/dws_pmon_10277.trc:
ORA-00474: SMON process terminated with error
Fri Mar 2 19:18:31 2012
PMON: terminating instance due to error 474
======================================================================
A week before we stopped oracle using "Shutdown abort" command. But two days before we stopped using "shutdown immediate", it went fine and system up and run fine.
But today it stopped with this error message.

Operating system : SOlaris 10

I changed the parameter parameter fast_start_parallel_rollback to HIGH from LOW, but no use

SQL> ALTER SYSTEM SET FAST_START_PARALLEL_ROLLBACK=HIGH SCOPE=BOTH;

System altered.

SQL> show parameter fast_start_parallel_rollback

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_parallel_rollback string HIGH


Usually The dead transaction will be rolled back after raising the Priority from LOW to HIGH. But this time its not rolled back. still etting the same error.

Your answers will help to stop the oracle getting down in the LIVE production server. please share your experience guys.

Thanks and Regards,
Deeban