ORA-00600:[kdtdelrow-2], [45], [45]

[Former Member]

Hi,

On our SCM Production server, while extraction job was running we got ORA:00600 error.

ST04 log:

ORA-00600: internal error code, arguments: [kdtdelrow-2], [45], [45], [], [], [], [], []

ORA-01683: unable to extend index SAPMPS./BIC/B0000191000~0 partition /BIC/B00001910000000000076 by 1024 in tablespace

Sat May 23 00:54:00 2009

ORA-1683: unable to extend index SAPMPS./BIC/B0000191000~0 partition /BIC/B00001910000000000076 by 1024 in # tabl

Sat May 23 00:54:00 2009

Errors in file /oracle/MPS/saptrace/usertrace/mps_ora_761986.trc:

SM21 log:

[45], [45], [], [], [], [], []#ORA-01683: unable to extend

index SAPMPS./BIC/B0000191000~0 partition

/BIC/B00001910000000000076 by 1024 in tablespace PSAPMPS

Run-time error "DBIF_RSQL_SQL_ERROR" occurred

Short dump "090523 015918 mmscmsap MPSREMOTE " generated

Database error 600 requires intervention by the database administrator

Database error 600 at INS access to table /BIC/B0000

ORA-00600: internal error code, arguments: [kdtdelrow-2],

[45], [45], [], [], [], [], []#ORA-01683: unable to extend

index SAPMPS./BIC/B0000191000~0 partition

/BIC/B00001910000000000076 by 1024 in tablespace PSAPMPS

Run-time error "DBIF_RSQL_SQL_ERROR" occurred

Short dump "090523 015926 mmscmsap MPSREMOTE " generated

Database error 600 requires intervention by the database administrator

Database error 600 at INS access to table /BIC/B0000

at db02: tablespace PSAPMPS was full, i did add a datafile to tablespace;

my question is:

Is the ORA:00600 was only due to the tablespace full issue?

plaese suggest.

-regards,

Gokul

Edited by: Gokul Chitode on May 24, 2009 12:32 PM

[Former Member · Accepted solution]

Gokul,

From the logs its cleary visible that tablespace PSAPMPS is full. You should increase it first.

You should set all the tablespaces to be in autoextend mode, hence there are less chances of a tablespace getting full.

There are three ways to extend the tablespaces;

1. Adding a data file to a tablespace

2. Resize a datafiles

3. Change the Auto extend sizes

SAP recommendation of the datafile size for production server

Expected database size Data file size

Up to 200 GB 2 GB

200 to 400 GB 4 GB

400 to 800 GB 8 GB

Larger than 800 GB 16 GB

Check below links for details.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/29/581630f72011d2952900a0c930df15/content.htm

http://help.sap.com/erp2005_ehp_04/helpdata/DE/a7/8db6c2ebc5384eb82e5f99e49600d6/frameset.htm

For ORA 600 error refer below link:-

https://metalink.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bm...

Note 376755 - ORA-00600 - what to do?

Note 605011 - ORA-600 [17182] ORA-600 [kghasp1] ORA-7445 [11].

Thanks,

Sushil

Thanks

Sushil

Edited by: Sushil Suryawanshi on May 25, 2009 1:52 AM

[Former Member]

Hi Gokul,

Its oracle internal error.You can fix it .I faced same problem and it resolved.

see below link u can repair or skip

http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/repair.htm#8282

Also check tablespace

SurendraJain

[Former Member]

Hi,

On ECC 6.0 am getting the Same Error but my Table Space not full

ORA-00600: internal error code, arguments: [kdtdelrow-2], [1], [1], [], [], [], [], []

awaiting for reply

Regards

Sreekar

[former_member204746]

sreekar, you should not hijack old topics, especially if your problem is not exactly thwe same.

please start a new topic.

[Former Member]

Yes Gokul,

Here in your situation, that is the exact reason. Here it is trying for next extent where actual space is not available.

Regards

Nick Loy