ORA 600 [6033]
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: ORA 600 [6033]

Hybrid View

  1. #1
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759

    Talking

    This is a good one:
    -
    How about this error showing up in 64-bit 8.1.6.2.0 on HP-UX v11i?? Any ideas??

  2. #2
    Join Date
    Jun 2000
    Posts
    179

    Talking

    ORA 600 ( As I Know ) indicates that the database needs recovery
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    ora-600

    Not neccessarily.....
    It depends on the argument which is followed after the ora-600 error.
    If the args[17000......more] and args[7445] you are right it may need recovery ...It may
    corrupt index (I have faced)....
    I feel arg[6033] is because of the core dump?.If so just bounce the db once.It will work.
    What corresponding trace file says?.can you post that.
    Thanks.
    Thanigaivasan

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    /dss_816/app/oracle/admin/dss/udump/ora_26371_dss.trc
    Oracle8i Enterprise Edition Release 8.1.6.2.0, 64 bit - Production
    With the Partitioning option
    JServer Release 8.1.6.2.0 - Production
    ORACLE_HOME = /dss_816/app/oracle/product/8.1.6
    System name: HP-UX
    Node name: hpn2
    Release: B.11.00
    Version: U
    Machine: 9000/800
    Instance name: dss
    Redo thread mounted by this instance: 1
    Oracle process number: 75
    Unix process pid: 26371, image: oracle@hpn2 (TNS V1-V3)

    *** SESSION ID:(36.4406) 2001-03-29 12:31:20.876
    *** 2001-03-29 12:31:20.876
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []
    Current SQL statement for this session:
    SELECT * FROM CM_CHECK_CLAIM_LOG WHERE CHECK_ID = :b1 AND CHECK_DATE = :b2 FOR UPDATE
    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    c00000014d112bd8 48 procedure CM_LIVE.CM_VOID_CHK
    c00000014b435290 1 anonymous block
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    Cannot find symbol for address: 00000000009b4f97 (631)
    ksedst + 399 ???? skdstinit 8000000100063754 ?
    00000002C ?
    80000001FFFFFFFF ?
    8000000100063790 ?
    ksedmp + 247 ???? ksedst 8000000100063650 ?
    4000000000219650 ?
    5555555555555555 ?
    40000000002C81A0 ?
    ksfdmp + 35 ???? ksedmp 80000001000048B8 ?
    C00000014C202640 ?
    8000000100001791 ?
    000000002 ?
    kgeriv + 159 ???? ksfdmp 8000000100001791 ?
    000000002 ? 04E53DB70 ?
    000000007 ?
    kgeasi + 211 ???? kgeriv 000000007 ?
    8000000100063790 ?
    8000000100098AF0 ?
    0000AB138 ?
    kdifxs + 4391 ???? kgeasi 8000000100098AF0 ?
    40000000003F7678 ?
    -
    -
    and so on. It's a huge trace file.

  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    ora 600[6033]

    Hi friend,
    I have gone thru the file and I could not guess the exact error because the line which shows the error is missing in the trace file..
    I know it is difficult to post all the trace file..
    okay you do this...
    is there any smon trace file created....if yes good it will specify clearly which is giving problem...
    try for file id /mostly it will be there after PROXY in trace file check for that.query the db using the file id../tablespace...
    I am also doing reseach on that I will get back shortly.
    Thanks.
    Thanigaivasan

  6. #6
    Join Date
    Nov 2000
    Posts
    212
    apart from recovery:

    on 816,parch 3 the
    declare
    a boolean;
    begin
    a:=DBMS_SESSION.IS_SESSION_ALIVE(null);
    end;
    gives ORA-00600: internal error code, arguments: [15498], [0], [], [], [], [], [], []
    Reason: null in proc. call.

    Could it be similar issue?

  7. #7
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I'll have to check up on that. This happened on a db that I am not administering. This was reported by another DBA on site.

  8. #8
    Join Date
    Jun 2004
    Location
    Simi Valley, CA, USA
    Posts
    1
    I have encountered "ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []" when executing a cursor loop. The error message was caused probably by an update statement inside the cursor. My Oracle is Oracle9i 9.0.1.4.0 on Linux.

  9. #9
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by vbrover
    I have encountered "ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []" when executing a cursor loop. The error message was caused probably by an update statement inside the cursor. My Oracle is Oracle9i 9.0.1.4.0 on Linux.
    In your honor I hearby do invent the following new acronym
    OAFT! open a friendly tar!
    I'm stmontgo and I approve of this message

  10. #10
    Join Date
    Jan 2001
    Posts
    3,131
    ORA-600, drop the database immediately, it is corrupt!
    I remember when this place was cool.

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