History | Log In     View a printable version of the current page.  
ubTools is pleased to announce ubGuard 1.1.3 for Oracle:

  • Change Log
  • Download
  • Product Home
  • Concept and Administration

  • Issue Details (XML | Word | Printable)

    Key: QA-27
    Type: Oracle - Internals Oracle - Internals
    Status: Closed Closed
    Resolution: Answered
    Priority: Major Major
    Assignee: ubTools Support
    Reporter: ubTools Support
    Votes: 0
    Watchers: 0

    If you were logged in you would be able to see more operations.
    Questions & Answers

    ORA-00600 [kcbgcur_1] by PQ operation.

    Created: 15/Jul/07 05:56 PM   Updated: 16/Sep/07 04:25 PM
    Fix Version/s: None

    Product Version:
    Operating System: Linux
    Operating System Version: 2.2.14-5.0

     Description  « Hide
    ORA-00600 [kcbgcur_1] by PQ operation.

     All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
    ubTools Support - 15/Jul/07 05:59 PM

    Error code:

    ORA-00600: internal error code, arguments: [kcbgcur_1], [], [], [], [], [], [], []

    Oracle kernel function from which the problem is raised:

    This function is a function of Oracle Cache Layer.

    Undo block dump:

    UNDO BLK:  
    xid: 0x0005.05e.000000c4  seq: 0x8c  cnt: 0x31  irb: 0x19  icl: 0x0   flg: 0x0000
    Rec Offset      Rec Offset      Rec Offset      Rec Offset      Rec Offset
    0x01 0x1f38     0x02 0x1e88     0x03 0x1de4     0x04 0x1d3c     0x05 0x1c94    
    0x06 0x1bf4     0x07 0x1b54     0x08 0x1ac4     0x09 0x1a20     0x0a 0x1978    
    0x0b 0x18d4     0x0c 0x1820     0x0d 0x1784     0x0e 0x16e0     0x0f 0x1638    
    0x10 0x1598     0x11 0x14e8     0x12 0x1448     0x13 0x13a4     0x14 0x1308    
    0x15 0x126c     0x16 0x11d0     0x17 0x112c     0x18 0x1084     0x19 0x0fe0    
    0x1a 0x0f0c     0x1b 0x0e60     0x1c 0x0db8     0x1d 0x0d28     0x1e 0x0c90    
    0x1f 0x0bf0     0x20 0x0b28     0x21 0x0a88     0x22 0x09ec     0x23 0x0950    
    0x24 0x08ac     0x25 0x0814     0x26 0x077c     0x27 0x06e4     0x28 0x0650    
    0x29 0x05b4     0x2a 0x0524     0x2b 0x0480     0x2c 0x03f4     0x2d 0x035c    
    0x2e 0x02c0     0x2f 0x0230     0x30 0x01a0     0x31 0x0108
    * Rec #0x19  slt: 0x5e  objn: 0(0x00000000)  objd: 0  tblspc: 0(0x00000000)
    *       Layer:  11 (Row)   opc: 1   rci 0x18  
    Undo type:  Regular undo   Last buffer split:  No
    Temp Object:  No
    Tablespace Undo:  No
    rdba: 0x00000000
    KDO undo record:
    KTB Redo
    op: 0x02  ver: 0x01  
    op: C  uba: 0x00c0083d.008c.18
    KDO Op code: IRP  xtype: XA  bdba: 0x0040760a  hdba: 0x004075d9
    itli: 1  ispac: 0  maxfr: 4863
    tabn: 0 slot: 130(0x82) size/delt: 56
    fb: --H-FL-- lb: 0x0 cc: 4
    null: ----
    col  0: [ 3]  37 34 34
    col  1: [20]  45 6c 65 63 74 72 6f 6e 69 63 20 73 74 72 75 63 74 75 72 65
    col  2: [ 0]
    col  3: [ 0]

    Problem explanation:

    irb points the first undo record in undo block to begin rollback. So, the record 0x19 is your first undo record. The object number of the block, and the object number of the block undo applied to are 0. I think this may be your problem. Oracle may not be able to know the real object number during this rollback.


    It looks like: