Skip to Content
0
Former Member
Mar 14, 2007 at 08:01 AM

ORA-00600: internal error code, arguments

955 Views

Hi All,

Could you please advise how to fix the below issue?

We encounter the oracle exception messages ora-600, please refer to the below:

Database error 600 requires intervention by the database administrator

Database error 600 at INS access to table MONI

> ORA-00600: internal error code, arguments: [ktsgsp5],

> [28043], [28145], [], [], [], [], []#

Perform rollback

Run-time error "DBIF_RTAB_SQL_ERROR" occurred

> Short dump "070314 143416 php1006 DDIC " generated

Transaction termination 00 671 ( DBIF_RTAB_SQL_ERROR 20070314143416php1006 DDIC

4001 )

Perform rollback

The error message appears continually, and many DBIF_RTAB_SQL_ERROR dumps occur:

Information on where termination occurred

The termination occurred in the ABAP/4 program "RSORAVSH " in

START-OF-SELECTION.

The main program was "RSORAVSH ".

The termination occurred in line 41

of the source code of program "RSORAVSH " (when calling the editor 410).

The program "RSORAVSH " was started as a background job.

Source code extract

110 total_waits TYPE p DECIMALS 0,

120 total_timeouts TYPE p DECIMALS 0,

130 time_waited TYPE p DECIMALS 0,

140 average_wait TYPE p DECIMALS 0,

150 END OF v_system_event_struc ,

160 BEGIN OF v_system_event_tab OCCURS 0 ,

170 date LIKE sy-datum,

180 time LIKE sy-uzeit.

190 INCLUDE STRUCTURE v_system_event_struc.

200 DATA: END OF v_system_event_tab .

210

220 check sy-dbsys(3) = 'ORA' .

230 ************************************************************************

240 * Get the new snapshots

250 ************************************************************************

260 PERFORM fill_dbvse TABLES v_system_event_tab.

270

280 ************************************************************************

290 * Get the old snapshots from database table MONI

300 ************************************************************************

310 startday = sy-datum - days_to_keep .

320

330 ************************************************************************

340 * Save new data now (otherwise these data will be selected twice)

350 ************************************************************************

360 CONCATENATE 'SYSEVENT' sy-datum sy-uzeit INTO monikey .

370

380 EXPORT sy-datum

390 sy-uzeit

400 <b> v_system_event_tab

> TO DATABASE moni(db) ID monikey .</b>

420 &----


430 *& Form FILL_DBVSE

440 &----


450 FORM fill_dbvse TABLES v_system_event_tab.

460 date = sy-datum .

470 time = sy-uzeit .

480 EXEC sql performing append_v_system_event .

490 SELECT event,

500 total_waits,

510 total_timeouts,

520 time_waited * 10,

530 average_wait * 10

540 INTO :v_system_event_struc

550 FROM v$system_event

560 ENDEXEC .

570 ENDFORM. " FILL_DBVSE

580

590 &----


600 *& Form APPEND_V_SYSTEM_EVENT

Contents of system fields

SY field contents.....................

-


SY-SUBRC 0

SY-TABIX 27

SY-FDPOS 0

SY-PAGNO 0

SY-COLNO 1

Chosen variables

Name..........................

SY-DBSYS+0(3)

%_PRINT

... + 40

... + 80

... + 120

%_SPACE

V_SYSTEM_EVENT_TAB[]

... + 40

... + 80

... + 120

V_SYSTEM_EVENT_TAB

... + 40

... + 80

SY-DATUM

DAYS_TO_KEEP

STARTDAY

MONIKEY

SY-UZEIT

RSJOBINFO

... + 40

... + 80

MONI

... + 40

... + 80

... + 120

MONI-CLUSTR

SYST

... + 40

... + 80

... + 120

SY

... + 40

... + 80

... + 120

Active calls / events

No.... Type........ Name..........................

Programm

Include Line

1 EVENT START-OF-SELECTION

RSORAVSH

RSORAVSH

<b><sid>_ora_19474.trc</b>

.......................

  • SESSION ID:(14.5) 2007-03-14 14:45:14.904

  • 2007-03-14 14:45:14.904

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [ktsgsp5], [28043], [28145], [], [], [], [], []

Current SQL statement for this session:

INSERT INTO "MONI" ( "RELID" , "SRTFD" , "SRTF2" , "FILLER" , "CLUSTR" , "CLUSTD" ) VALUES ( :A0 , :A1 , :A2 , :A3 , :A4 , :A5

)

-


Call Stack Trace -


calling call entry argument values in hex

location type point (? means dubious value)

-


-


-


-


ksedmp()+184 ? ksedst() 000000000 ?

80000001000CFEB8 ?

000000038 ? 000000000 ?

ksfdmp()+32 ? ksedmp() 80000001001C1F0C ?

800003FFFF80B218 ?

40000000003A05F8 ?

800003FFFF80AC00 ?

kgerinv()+152 ? ksfdmp() 40000000003A05F8 ?

800003FFFF80AC00 ?

800003FFFF80AEEC ?

40000000013CEB2B ?

kgeasnmierr()+88 ? kgerinv() C000000081912398 ?

C0000000817009E0 ?

800003FFFF8088A0 ?

000000000 ?

ktsf_gsp()+5256 ? kgeasnmierr() 800003FFFF80AF88 ?

000000000 ? 000000000 ?

300001FE8 ?

kdisnew()+168 ? ktsf_gsp() 40020000DB410 ? 2FF80ABE0 ?

000000000 ? 000000000 ?

kdisnewle()+148 ? kdisnew() 101000000000001 ?

80000001000CFEB8 ?

800003FFFF80A430 ?

800003FFFF809F70 ?

kdisle()+4032 ? kdisnewle() 80000001000CFEB8 ?

8000000100186530 ?

000000000 ?

800003FFFF7FA158 ?

kdiins0()+15980 ? kdisle() 800003FFFF809750 ?

800003FFFF809A3C ?

000000000 ? 000000000 ?

kdiins()+64 ? kdiins0() 800003FFFF806DC0 ?

000000001 ?

400000000103B5C7 ?

000000000 ?

kauxsin()+1804 ? kdiins() 5555555555555555 ?

000000000 ?

C0000000816E9520 ?

000000000 ?

<b>alert_<SID>.log </b>

Some info maybe helps:

SAP R/3 46C, Oracle 9.2.0.7, kernel 46D, Basis 42, ABAP 42, APPL 43, HR

68, HP-UX 11.00

Any suggestion would be appreciated.

Regards,

Joseph