Oracle Internal Error (ORA-0600)

Could some one help us with a production database problem that we are getting. We got an Oracle internal error (ORA-0600.) Here is a clip of the trace file:

• SESSION ID:(31.4434) ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] Current SQL statement for this session: INSERT INTO REVENUE_TRANS(REVENUE_SCHEDULE_ID,PERIOD,TRANS_CODE,RT_AMOUNT,RT_CON VERTED_AMT,RT_TRANS_DATE,RT_ADJUST_AMT,SUBSCRIBER_COUNT,BILL_TO_ID,JOB_ID, RT_ADJ UST_SUB)VALUES(:b1,TO_DATE(:b2,'DD-MON-YYYY'),:b3,ROUND(:b4,2),ROUND(:b5,2), TO_D ATE(:b6,'DD-MON-YYYY'),ROUND(:b7,2),:b8,:b9,:b10,:b11) ----- Calling Stack Trace ----- get_frame0 ( 0x171b0, 0x400, 0x0, 0x0) sdtcs ( 0x49524, 0x1, 0x49000, 0x0) ksedmp ( 0xc006a958, 0x0, 0x0, 0xc0a88014) ksfdmp ( 0x40005b44, 0x40020460, 0x258, 0x0) kgeriv ( 0x0, 0x0, 0x0, 0x0) kgesiv ( 0x400225b8, 0x2, 0x4000a670, 0xc0839bc8) kgesic0 ( 0x40005ae0, 0x40020460, 0x42c2, 0x0) kgerse ( 0x400281d0, 0x2, 0x660, 0x0) opiexe ( 0x7b034ea8, 0x4001c79c, 0x0, 0x0) opiodr ( 0x800, 0x4001cc40, 0x4001f3de, 0x4001cc98) ttcpip ( 0x40005458, 0x4, 0x7b033bf8, 0x0) opitsk ( 0x40005774, 0x4001be48, 0x4001f2c0, 0xd9) opiino ( 0x7b0336e8, 0x0, 0x0, 0x0) opiodr ( 0x7b033538, 0x0, 0x7b0334a4, 0x0) opidrv ( 0x0, 0x0, 0x0, 0x0) sou2o ( 0x0, 0x0, 0x0, 0x0) main ( 0x0, 0x0, 0x0, 0x0) _start ( 0x0, 0x0, 0x0, 0x0) $START_RTN$ ( 0x7b033191, 0x7b033182, 0x7b033162, 0x7b033149)

  ---

  PROCESS STATE

  ---

  Process global information: process: c0042370, call: c006a948, xact: c019dd30, curses: c0052918, usrses : c0052918

  ---

  SO: c0042370, type: 1, owner: 0, flag: INIT/-/-/0x00 (process) Oracle pid=16, calls cur/top: c006a948/c006a948, flag: (0) - int error: 0, call error: 0, sess error: 0 (latch info) wait_event=0 bits=0 O/S info: user: srbusr, term: ?, ospid: 26254 OSD pid info: pid: 668e, image:

  ---

  SO: c0052918, type: 3, owner: c0042370, flag: INIT/-/-/0x00 (session) trans: c019dd30, flag: (41) USR/- BSY/-/-/-/-/- oct: 3, prv: 0, user: 195/SRBDBA O/S info: user: srbusr, term: , ospid: 26253, machine: london program: ? _at_london (TNS interface) last wait for 'db file sequential read' seq=12046 wait_time=-2 file#=1, block#=c57, blocks=1 prv xid: 00.00.00 prv scn: 0.00000000

  ---

  SO: c07e8118, type: 17, owner: c0052918, flag: INIT/-/-/0x00 LIBRARY OBJECT PIN: pin=c07e8118 handle=0 lock=c01bfff8 user=c0052918 session=c0052918 count=0 mask=00 savepoint=381387 flags=[00]

  ---

  SO: c01bfff8, type: 16, owner: c0052918, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=c01bfff8 handle=c03a1198 mode=N call pin=0 session pin=c07e8118 user=c0052918 session=c0052918 count=1 flags=[00] savepoint=380873 LIBRARY OBJECT HANDLE: handle=c03a1198 namespace=CRSR flags=RON/PN0/[10010000] kk-dd-aa-ll=00-41-40-41 lock=N pin=0 lwt=c03a11b0[c03a11b0,c03a11b0] ltm=c03a11b8[c03a11b8,c03a11b8] pwt=c03a11c8[c03a11c8,c03a11c8] ptm=c03a121c[c03a121c,c03a121c] ref=c03a11a0[c06491a0,c06491a0] LIBRARY OBJECT: object=c059ba18 type=CRSR flags=EXS[0001] status=VALD load=0 DEPENDENCIES: count=1 size=16 ACCESSES: count=1 size=16 DATA BLOCKS: data# heap pointer status pins change
  • -------- -------- ------ ---- ------ 0 c05ee390 c059bad8 I/P/A 0 NONE 6 c059ba88 c0648f08 I/-/A 0 NONE

    ---

    SO: c05791e8, type: 16, owner: c0052918, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=c05791e8 handle=c04fc7e0 mode=N call pin=c07e7d98 session pin=0 user=c0052918 session=c0052918 count=1 flags=[00] savepoint=380873 LIBRARY OBJECT HANDLE: handle=c04fc7e0 name=

If any one has any suggestions as to the nature of this problem, I can be reached at Jeffrey.Palmiero_at_turner.com.

Thanks in advance,
Jeff Palmiero Received on Tue Jun 25 1996 - 00:00:00 CEST