This discussion is archived
10 Replies Latest reply: Feb 28, 2013 3:03 AM by user346213 RSS

database stopped with Error:ORA-10388: parallel query server interrupt (fai

user448486 Newbie
Currently Being Moderated
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
  • 1. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    user448486 Newbie
    Currently Being Moderated
    Hi,

    Here im pasting the Trace file content for the error "ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []".

    [10:20pm] root@dws41: # cat /opt/oracle/admin/DWS/bdump/dws_pmon_10277.trc
    /opt/oracle/admin/DWS/bdump/dws_pmon_10277.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORACLE_HOME = /opt/oracle/product/10.2.0
    System name: SunOS
    Node name: dws41
    Release: 5.10
    Version: Generic_138888-06
    Machine: sun4u
    Instance name: DWS
    Redo thread mounted by this instance: 1
    Oracle process number: 3
    Unix process pid: 10277, image: oracle@dws41 (PMON)

    **** 2012-03-02 19:18:31.509*
    **** SERVICE NAME:(SYS$BACKGROUND) 2012-03-02 19:18:31.504*
    **** SESSION ID:(1511.1) 2012-03-02 19:18:31.504*
    Background process SMON found dead
    Oracle pid = 8
    OS pid (from detached process) = 10337
    OS pid (from process state) = 10337
    dtp = 380017a10, proc = 7fd001048
    Dump of memory from 0x0000000380017A10 to 0x0000000380017A58
    380017A10 0000007C 00000000 00000007 FD001048 [...|...........H]
    380017A20 00000000 00000000 00000000 534D4F4E [............SMON]
    380017A30 00020000 00000000 00002861 00000000 [..........(a....]
    380017A40 00000000 4F507D38 00000001 327FA838 [....OP}8....2..8]
    380017A50 00040081 00000000 [........]
    Dump of memory from 0x00000007FD001048 to 0x00000007FD001830
    7FD001040 02010000 00000000 [........]
    7FD001050 00000000 00000000 00000000 00000000 [................]
    7FD001060 00000000 00000000 00000007 FD6D0CD0 [.............m..]
    7FD001070 00000007 FD700328 00000007 FD546D78 [.....p.(.....Tmx]
    7FD001080 00000005 3C6FD110 00000000 00000000 [....<o..........]
    7FD001090 00000005 3C6FD198 00000005 3C6FD198 [....<o......<o..]
    7FD0010A0 00000007 FD700318 01160800 00000000 [.....p..........]
    7FD0010B0 00000007 FD53FF88 00000007 FD544698 [.....S.......TF.]
    7FD0010C0 00000008 00000000 00000000 00000000 [................]
    7FD0010D0 00000000 00000000 00000000 00000000 [................]
    7FD0010E0 00000007 FD6CE770 00000007 FD6D0D00 [.....l.p.....m..]
    7FD0010F0 00000000 00000000 00000000 00000000 [................]
    Repeat 3 times
    7FD001130 00000000 00000000 00000012 00000000 [................]
    7FD001140 00000000 00000000 0000000F 00000000 [................]
    7FD001150 00000000 00000000 00000012 00000000 [................]
    Repeat 1 times
    7FD001170 00000000 00000000 0000000F 00000000 [................]
    Repeat 1 times
    7FD001190 00000000 00000000 00000012 00000000 [................]
    Repeat 1 times
    7FD0011B0 00000000 00000000 0000000E 00000000 [................]
    7FD0011C0 00000000 00000000 00000008 00000000 [................]
    7FD0011D0 00000000 00000000 00000012 00000000 [................]
    7FD0011E0 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    7FD001210 00000000 00000000 00000004 00000000 [................]
    7FD001220 00000000 00000000 00000000 00000000 [................]
    7FD001230 4F50FF9A 00000000 00000000 00000000 [OP..............]
    7FD001240 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    7FD001260 00000007 FD001260 00000007 FD001260 [.......`.......`]
    7FD001270 00000000 00000000 00000000 FFFFFFFF [................]
    7FD001280 00000007 FD001280 00000007 FD001280 [................]
    7FD001290 00000000 00000000 00000005 00000000 [................]
    7FD0012A0 00000000 00000000 00000000 00000000 [................]
    7FD0012B0 000000AB BABCDEFA 00000000 00000000 [................]
    7FD0012C0 00000000 00000000 000000FF 7FFFC971 [...............q]
    7FD0012D0 00000021 00000026 0008CBAA 00039976 [...!...&.......v]
    7FD0012E0 00000005 3C003FB8 00000006 7E0037D0 [....<.?.....~.7.]
    7FD0012F0 00000001 00000000 00000000 00000000 [................]
    7FD001300 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    7FD001320 00000000 00000000 00002861 00000000 [..........(a....]
    7FD001330 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    7FD001360 00000000 00000000 00000007 FD001048 [...............H]
    7FD001370 00000000 00000000 00000000 00000000 [................]
    Repeat 4 times
    7FD0013C0 00000000 00000000 00000001 00000000 [................]
    7FD0013D0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    7FD0013F0 4F50FF9A 00000000 00000007 FD0013F8 [OP..............]
    7FD001400 00000007 FD0013F8 00000000 00000000 [................]
    7FD001410 00010000 00000000 00000000 01000057 [...............W]
    7FD001420 0000000C 00000000 00002861 00000000 [..........(a....]
    7FD001430 00000000 4F507D38 00000001 00000000 [....OP}8........]
    7FD001440 00000000 00000000 00000000 00000000 [................]
    Repeat 3 times
    7FD001480 0000000F FFFFFFFF 00000000 00000000 [................]
    7FD001490 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    7FD0014C0 00000000 00000000 00000020 00000000 [........... ....]
    7FD0014D0 00000000 00000000 00000000 00000000 [................]
    Repeat 8 times
    7FD001560 00000000 00000000 6F726163 6C650000 [........oracle..]
    7FD001570 00000000 00000000 00000000 00000000 [................]
    7FD001580 00000000 00000000 00000000 00000006 [................]
    7FD001590 64777334 31000000 00000000 00000000 [dws41...........]
    7FD0015A0 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    7FD0015D0 00000000 00000005 554E4B4E 4F574E00 [........UNKNOWN.]
    7FD0015E0 00000000 00000000 00000000 00000000 [................]
    7FD0015F0 00000000 00000000 00000000 00000008 [................]
    7FD001600 31303333 37000000 00000000 00000000 [10337...........]
    7FD001610 00000000 00000000 00000000 00000005 [................]
    7FD001620 6F726163 6C654064 77733431 2028534D [oracle@dws41 (SM]
    7FD001630 4F4E2900 00000000 00000000 00000000 [ON).............]
    7FD001640 00000000 00000000 00000000 00000000 [................]
    7FD001650 00000000 00000013 00000000 00000002 [................]
    7FD001660 00000000 00000000 00000000 00000000 [................]
    Repeat 9 times
    7FD001700 00000000 00020000 00000000 00000000 [................]
    7FD001710 00000000 00000000 00000000 00000000 [................]
    7FD001720 00000003 BD4FFA28 00000005 3C0026F8 [.....O.(....<.&.]
    7FD001730 00000006 7E000F40 00000000 00000000 [....~..@........]
    7FD001740 00000003 BC691FD8 00000000 00000000 [.....i..........]
    7FD001750 00000000 00000000 00000000 00000000 [................]
    7FD001760 00000000 00000000 00000007 FD001768 [...............h]
    7FD001770 00000007 FD001768 00000000 09EF0000 [.......h........]
    7FD001780 00000000 086F0000 00000000 017A17D9 [.....o.......z..]
    7FD001790 00000000 00273A49 00000000 13B817D9 [.....':I........]
    7FD0017A0 00000000 00015030 00000000 0000A848 [......P0.......H]
    7FD0017B0 00000000 001350A0 00000000 00000828 [......P........(]
    7FD0017C0 00000000 000000E0 00000000 00000828 [...............(]
    7FD0017D0 00000000 00000000 00000000 00000000 [................]
    Repeat 4 times
    7FD001820 32B310E7 000152FB 00000003 00000000 [2.....R.........]
    error 474 detected in background process
    ORA-00474: SMON process terminated with error
    [10:20pm] root@dws41: #
  • 2. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    sb92075 Guru
    Currently Being Moderated
    ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
  • 3. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    Lubiez Jean-Valentin Guru
    Currently Being Moderated
    Hello,

    ORA-00600: internal error code, arguments: [6006], [1],
    May be the following note of MOS can give some solution:

    *ORA-600 [6006] ORA-600 [6856] During Startup Instance, Followed by Termination by SMON [ID 549000.1]*

    Anyway, as previously advised, open a SR and send them the Alert.log and Trace files (dws_p000_10374.trc, dws_smon_10337.trc and dws_pmon_10277.trc).


    Hope this help.
    Best regards,
    Jean-Valentin
  • 4. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    813964 Newbie
    Currently Being Moderated
    for the below Error , we should work with Oracle support .

    ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []

    please raise a SR with Oracle support .
  • 5. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    user448486 Newbie
    Currently Being Moderated
    Hi Guys, Thanks a lot for your responses. Iam surprised with Quick responses and Active work. Iam gonna raise this to Oracle support and i will inform you all in this thread if i got patch/workaround. Thanks to everyone. I wish to actively participate in the forum from now onwards.

    Regards,
    Deeban
  • 6. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    user448486 Newbie
    Currently Being Moderated
    Hi,

    We raised SR to Oracle and we got the below response:

    DUe to power failure Oracle database shutdown abnormally and Storage disks failed, in this problem, few blocks corrupted on database.

    Since SMON is trying to recover the corrupted block and cant able to recover , we are getting this errror message.

    So Oracle recommended us to do Database restore to recover the corrupted block.

    There is no other way to recover the corrupted block.
  • 7. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    rp0428 Guru
    Currently Being Moderated
    Thanks for the update. We appreciate you letting everyone know what the problem was so that others that come across this thread will know.
  • 8. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    user448486 Newbie
    Currently Being Moderated
    Hi All,

    We cant able to restore from backup as well, so we installed the database from scratch. We lost all the datas.

    Regards,
    C.DEEBAN
  • 9. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    Mark Malakanov (user11181920) Expert
    Currently Being Moderated
    We lost all the datas.
    you probably could start Oracle with some event that allows to ignore corrupted blocks (ask from support)
    then you could try export your data. Usually block corruption is very local, and may hit index, and most of the data can be extracted.

    Edited by: user11181920 on May 20, 2012 12:50 PM
  • 10. Re: database stopped with Error:ORA-10388: parallel query server interrupt (fai
    user346213 Newbie
    Currently Being Moderated
    I am also getting this

    ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []

    error on my 10g database

    First thing I did was take a copy of the disk onto a separate external disk.

    If I obtain a new disk and copy back from my external disk, is that likely to resolve the corrupted blocks problem?

    TIA

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points