ORA-00600: internal error code, arguments

[Former Member]

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

[Former Member · Accepted solution]

Thanks Viond,

I checked the optimizer statistics of table MONI and index MONI___0:

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

BR001I *************_____________________________________

BR280I Time stamp 2007-03-14 19.38.23

BR301E SQL error -1410 at location stats_ind_collect-2

ORA-01410: invalid ROWID

BR886E Checking/collecting statistics failed for table/index SAPR3.MONI___0

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

Oracle Analyze Function

analyze table "MONI" estimate statistics sample 20 percent; failed with ORA-01410

Oracle Analyze Function

analyze index "MONI___0" estimate statistics sample 20 percent; failed with ORA-01410

Not sure if i should re create the statistics of them.

Thanks again for your help.

[Former Member · Accepted solution]

Hi

Rebuild indexes for that table.And look for any block corruption.

Vinod

[Former Member]

Thanks!

It is okey after i reorganize the table MONI.

[Former Member]

alert_<SID>.log:

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

[Former Member]

Hi

This hapens becoz of attempting to find some free space in a segment.

causes and impact are PROCESS FAILUREor POSSIBLE BLOCK CORRUPTION.

Any upgrade u did recently?

usually u need to contact Support for internal errors.

vinod

[Former Member]

Hi

try this I dont know will it solve 600 error but try no problem

from sqlplus run this

SELECT object_type, owner, substr(object_name,1,30) object_name,

subobject_name, created

FROM dba_objects o, sys.clu$ c

WHERE object_id!=data_object_id

AND data_object_id=c.dataobj#(+)

AND ( c.dataobj# is null /* Not in a CLUSTER */

OR c.obj# = object_id /* OR is the cluster itself */ )

ORDER BY 1,2,3

;

For each of these objects rebuild its freelists using the DBMS_REPAIR.REBUILD_FREELISTS procedure

like

execute dbms_repair.rebuild_freelists('SCOTT','EMP',null,dbms_repair.table_object);

Let us see how it goes

vinod