DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: startup, but got ORA-00600: internal error code, arguments: [3668], [1], [2], [205376

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    startup, but got ORA-00600: internal error code, arguments: [3668], [1], [2], [205376

    hi, i did a startup and then got the below

    ORA-00600: internal error code, arguments: [3668], [1], [2], [205376], [205376], [4], [], []


    from my user trace file as belows

    ORA-00600: internal error code, arguments: [3668], [1], [2], [205376], [205376], [4], [], []
    Current SQL statement for this session:
    alter database open
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    ksedmp+00d4 bl ksedst 1010FD95C ?
    ksfdmp+0018 bl ksedmp 110000730 ?
    kgeriv+0140 ? 00000000
    kgesiv+009c bl kgeriv 110000730 ? 1101FCC50 ? 1 ?
    70000009B800065 ? 0 ?
    ksesic5+0054 bl kgesiv 110000730 ? 1101FCC50 ? 1 ?
    70000009B800065 ? 0 ?
    kcvcrv+0eb8 bl ksesic5 E5400000E54 ? 0 ? 1 ? 0 ? 2 ?
    0 ? 32240 ? 0 ?
    kcfopd+0150 bl kcvcrv FFFFFFFFFFFA1F8 ? 0 ?
    adbdrv+0618 bl kcfopd 9B7F7830 ? 10000558 ?
    opiexe+1658 bl adbdrv
    opiosq+05b8 bl opiexe 400000139 ? 100000001 ? 0 ?
    opiodr+03c0 ? 00000000
    ttcpip+0338 ? 00000000
    opitsk+0298 bl ttcpip 57B0000057B ? 1 ? 11006EEF8 ?
    7FF ? 1A ? 0 ? 110082C38 ?
    0 ?
    opiino+04b8 bl opitsk 200FEA1A ?
    opiodr+03c0 ? 00000000
    opidrv+02d0 bl opiodr 3CFFFFF9D0 ? 41009A6B8 ?
    FFFFFFFFFFFFE00 ? 100D5290 ?
    sou2o+0028 bl opidrv 3C00000007 ? 400000000 ?
    FFFFFFFFFFFFE00 ?
    main+00c8 bl sou2o 90000000022D624 ?
    9FFFFFFF0009EE0 ?
    FFFFFFFFFFFFE10 ?
    9001000A00AE448 ?
    __start+0090 bl main 0 ? 0 ?


    also, i realised that there are no rollback segments at all. could this be the problem

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Theres an Metalink Note for the error:
    http://metalink.oracle.com/metalink/...T&p_id=93665.1

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    hey.. thanks a lot..

    really appreciate...

    also, is there a note in metalink which explains all the first arguments of ora-600

    thanks

  4. #4
    Join Date
    Oct 2002
    Posts
    391
    hey.. fellow dbas....

    my oracle has this "Database opened."

    this is what happened

    SVRMGR> startup
    Database mounted.
    ORA-00600: internal error code, arguments: [3668], [1], [2], [205383], [205383], [4], [], []
    SVRMGR> recover database;
    Media recovery complete.

    okay after this.... i did (1) and (2)

    (1) is the below
    SVRMGR> alter database open;
    alter database open
    *
    ORA-01534: rollback segment 'PRSBIG_1' doesn't exist

    okay, i comment that in my ora file cos i had the other set of rollback segments.

    (2)this is where i got it right. i started all over again
    SVRMGR> shutdown immediate;
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.
    SVRMGR> startup
    Database mounted.
    ORA-00600: internal error code, arguments: [3668], [1], [2], [205383], [205383], [4], [], []
    SVRMGR> recover database;
    Media recovery complete.
    SVRMGR> shutdown immediate;
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.
    SVRMGR> startup
    Database mounted.
    Database opened.

    what i dont understand is why after recover database, i need to shutdown immediate, and an alter dataabse open will fail?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width