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

Thread: Internal error code

  1. #1
    Join Date
    May 2009
    Posts
    24

    Internal error code

    Hi,

    i am getting following error in alert log file ahen user run long query with table joining. how to resolve this issue? and the following is the part of trace file.

    ORA-00600: internal error code, arguments: [20084], [184559691], [10], [180363385], [6], [], [], []


    *** 2009-07-26 16:52:49.000
    *** SESSION ID:(128.4236) 2009-07-26 16:52:49.000
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2009-07-26 16:52:49.000
    ksedmp: internal or fatal error
    Current SQL statement for this session:
    UPDATE OT_JOB_HEAD SET JH_DT=:1,JH_DOC_SRC_LOCN_CODE=:2,JH_TXN_CODE=:3,JH_NO=:4,JH_AMD_NO=:5,JH_AMD_DT=:6,JH_AMD_RES_CODE=: 7,JH_REF_FROM=:8,JH_REF_TXN_CODE=:9,JH_REF_NO=:10,JH_REF_FROM_NUM=:11,JH_JOB_NO=:12,JH_DESC_1=:13,JH _JOB_TYPE=:14,JH_SERVICE_TYPE=:15,JH_SERVICE_CENTER=:16,JH_CHASSIS_NO=:17,JH_REG_NO=:18,JH_GATE_PASS =:19,JH_IN_TIME=:20,JH_OUT_TIME=:21,JH_MILEAGE=:22,JH_LPO_NO=:23,JH_ROUTING_NO=:24,JH_BAY_NO=:25,JH_ SERVICE_ADVISOR=:26,JH_BOOKED_BY=:27,JH_CUST_CODE=:28,JH_CUST_NAME=:29,JH_ADDR_CODE=:30,

    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    _ksedmp+147 CALLrel _ksedst+0
    __VInfreq__opitsk+3 CALLrel _ksedmp+0 2 25C34D4 311B
    eb


    any help is appreciated.

    thanks in advance

    regards,

    Rashad

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    call oracle support and use their 0ra-600 lookup tool

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Something does not adds up here.

    Poster states "query with table joining"...
    Trace shows "UPDATE OT_JOB_HEAD SET..."
    ORA-600 [20084] usually refers to indexing related issues; see Metalink 138678.1
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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