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

Thread: error : dump of memory from

  1. #1
    Join Date
    Jun 2004
    Location
    ludhiana
    Posts
    15

    error : dump of memory from

    hi

    trace file
    after this database needs restart

    Dump file E:\Oracle\admin\unit3\udump\ORA02080.TRC
    Mon Jun 14 18:53:44 2004
    ORACLE V8.1.5.0.0 - Production vsnsta=0
    vsnsql=d vsnxtr=3
    Windows NT V5.0, OS V8.147, CPU type 586
    Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production
    Windows NT V5.0, OS V8.147, CPU type 586
    Instance name: unit3

    Redo thread mounted by this instance: 1

    Oracle process number: 46

    Windows thread id: 2080, image: ORACLE.EXE


    *** 2004.06.14.18.53.44.812
    *** SESSION ID:(28.423) 2004.06.14.18.53.44.796
    BH #61809 (0x188b5418) file#: 4 rdba: 0x01001ae8 (4/6888) class 1 ba: 0x3cda2000
    set: 1, dbwrid: 0
    hash: [188ec830,18ad2064], lru: [18803d20,187cb138]
    LRU flags:
    ckptq: [NULL] fileq: [NULL]
    use: [18dd4510,18dd4510], wait: [NULL]
    st: XCURRENT, md: EXCL, rsop: 0x0, tch: 0
    flags: buffer_dirty mod_started temp_data gotten_in_current_mode
    change state: ACTIVE
    L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]
    buffer tsn: 3 rdba: 0x01001ae8 (4/6888)
    scn: 0x0000.005b87b1 seq: 0x01 flg: 0x08 tail: 0x87b10801
    frmt: 0x02 chkval: 0x0000 type: 0x08=unknown

    Dump of memory from 0x3CDA2014 to 0x3CDA3FFC
    3CDA2000 4D4D522E 2E4D4D2E 35363033
    3CDA2020 33320003 55000343 16223343 405CA7B0 43490010 522E332D 4D2E4D4D 30332E4D
    3CDA2040 00033638 03433332 33435500 A1C01622 00101B44 312D4349 454D522E 2E4C452E
    3urrent RBA:[0xedd.86.10]
    *** 2004.06.14.18.53.45.953
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [kcblibr_user_fou], [4294967295], [3], [16784103], [15], [], [], []
    ORA-03113: end-of-file on communication channel
    Current SQL statement for this session:
    INSERT INTO MULTI_STOCK ( ITEMCODE,ITEM_REF,SP_REF,UNITCODE ) VALUES ( :b1,:b1,:b3,:b4 )
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    _ksedmp+a5 CALLrel _ksedst+0
    48DB00
    _ksfdmp+e CALLrel _ksedmp+0 3
    _kgerinv+8e CALLreg 00000000
    383868
    3
    _kgeasnmierr+19 CALLrel _kgerinv+0
    1E440
    951219C
    CDEE60
    4
    948DC70
    _kcblibr+8e CALLrel _kgeasnmierr+0
    383868
    951219C
    1
    ===================================================
    PROCESS STATE
    -------------
    Process global information:
    process: 1c11d6c4, call: 18d808b0, xact: 18bf700c, curses: 1c137d24, usrses: 1c137d24
    ----------------------------------------
    SO: 1c11d6c4, type: 1, owner: 0, flag: INIT/-/-/0x00
    (process) Oracle pid=46, calls cur/top: 18d808b0/18d808b0, flag: (0) -
    int error: 0, call error: 0, sess error: 0, txn error 0
    (post info) last post received: 0 0 0
    last post received-location: No post
    last process to post me: none
    last post sent: 0 0 0
    last post sent-location: No post
    last process posted by me: none
    (latch info) wait_event=0 bits=0
    Process Group: DEFAULT, pseudo proc: 1c127578
    O/S info: user: SYSTEM, term: DATASVR, ospid: 2080
    OSD pid info: 2080
    ----------------------------------------
    SO: 1c137d24, type: 3, owner: 1c11d6c4, flag: INIT/-/-/0x00
    (session) trans: 18bf700c, creator: 1c11d6c4, flag: (141) USR/- BSY/-/-/-/-/-
    DID: 0001-002E-00000002, short-term DID: 0000-0000-00000000
    txn branch: 0
    oct: 0, prv: 0, user: 29/ERP
    O/S info: user: store, term: STOREU1, ospid: 280:192, machine: UNIT1\STOREU1
    program: C:\Documents and Settings\store\Desktop\APRIL DATABASE.lnk
    last wait for 'buffer busy waits' seq=2112 wait_time=-2
    file#=4, block#=1ae8, =0
    ----------------------------------------
    SO: 18d0db28, type: 44, owner: 1c137d24, flag: -/-/-/0x00
    ----------------------------------------
    SO: 18d54738, type: 34, owner: 1c137d24, flag: INIT/-/-/0x00
    LIBRARY OBJECT PIN: pin=18d54738 handle=0 lock=18d53148
    user=1c137d24 session=1c137d24 count=0 mask=0000 savepoint=2103 flags=[00]
    ----------------------------------------
    SO: 18d53148, type: 33, owner: 1c137d24, flag: INIT/-/-/0x00
    LIBRARY OBJECT LOCK: lock=18d53148 handle=15254c00 mode=N
    call pin=0 session pin=18d54738
    user=1c137d24 session=1c137d24 count=1 flags=[00] savepoint=2100
    LIBRARY OBJECT HANDLE: handle=15254c00
    namespace=CRSR flags=RON/PN0/[10010000]
    kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
    lwt=15254c18[15254c18,15254c18] ltm=15254c20[15254c20,15254c20]
    pwt=15254c30[15254c30,15254c30] ptm=15254c88[15254c88,15254c88]
    ref=15254c08[15254e4c,15254e4c]
    LIBRARY OBJECT: object=1538d86c
    type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
    DEPENDENCIES: count=1 size=16
    AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
    ACCESSES: count=1 size=16
    TRANSLATIONS: count=1 size=16

    needs ur participation to resolve my problem
    thanks

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Please do some due diligence before posting.

    You are encountering bug#1732852. Look at metalink. You need to upgrade to a supportable version - 8.1.7. Log a TAR for ORA-00600s..but in this case, Oracle will ask you to upgrade.

    PS : You are highlighting a less relevent portion of the trace file. All that you ought to pay attention to is - ORA-000600 and the first/second arguments.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    bhatia_dba,

    Would you please stop bombing us with the same problem over and over again. You've been told in other threads what to do: Metalink or direct contact to Oracle Support.

    Oh' I forgot - you have not paid for Oracle Support! Bad luck...

    Closing.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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