cancel
Showing results for 
Search instead for 
Did you mean: 

Spool I/o Eroor..Ora-600

Former Member
0 Kudos

Hi,

OS- Windows server 2003

Databse- Oracle 10.2.0.4.0

1. Run SP12 and start Temse consistency check

2. Got 1 Spool request..When try to delete it Getting ORA-600 error

3. Due to this we are also getting the SPOOL I/o ABAP Dumps

Can you please help me regarding this error.

Regards

Manmohan

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
0 Kudos

Issue resolved by re organization of table

volker_borowski2
Active Contributor
0 Kudos

Hi,

could be TEMP or UNDO overflow as the original cause and

the 600 being a follow up. Had that more than once.

Check the alert log if any other errors preceed this ORA-0600.

Check out the report to delete a single (big) spoolrequest.

Have not got then name right now. Press F4 in

SE38 with "RSPO*" and check the short texts for the description.

Hope this help

Volker

Former Member
0 Kudos

And can we drop the row also by export and import method

Former Member
0 Kudos

Yes, exporting and importing is also supported by BR*tools, but I have no personal experience with that. Export/import requires a downtime and I believe it would be somewhat slower than an online reorg.

http://help.sap.com/saphelp_nw70/helpdata/EN/58/6bec38c9fa7e44b7f2163905863575/content.htm

Former Member
0 Kudos

SQL> select count(*) from sapr3.tst03;

COUNT(*)

-


738132

Former Member
0 Kudos

Whoa! Glad you mention that, so please forget about truncating the table.

Yes of course, you can reorganize the table online via brtools:

brtools -u /

3 (for Segment Management)

1 (for Reorganize Tables)

3 (action: reorg)

6 (table: TST03)

After the reorg finished successfully you have higher chances that the stubborn spool request can be deleted. It sounds like a problem with chained rows, so maybe even the reorganization won't help and you need some Oracle patch against that ORA-00600 error.

Former Member
0 Kudos

Is there any way to remove only this single spool request.

Either by reorganization or Export or import of table with brtools

Former Member
0 Kudos

One more thing I want to update here

- I am able to delete all other spool except one particular spool in SP12 consistency check

Former Member
0 Kudos

Sounds like a bug in 10.2.0.4. Patching this to 10.2.0.5 might help, or even better upgrade to 11.2.0.2.

Anyhow since you want to get rid of all spool requests (and just one doesn't cooperate) then truncating the table would be the fastest option to fix this. Then rerun SP12 just to make sure no other inconsistencies are reported.

Former Member
0 Kudos

Database error text........: "ORA-00600: internal error code, arguments:

[6749], [3], [209936688], [0], [], [], [], []#"

Internal call code.........: "[RSQL/DELE/TST03 ]"

Please check the entries in the system log (Transaction SM21).

System environment

SAP Release.............. "46C"

Application server....... "JACDESHP"

Network address.......... "10.136.128.68"

Operating system......... "Windows NT"

Release.................. "5.2"

Hardware type............ "2x Intel 801586"

Database server.......... "JACDESHP"

Database type............ "ORACLE"

Database name............ "PHR"

ABAP runtime errors DBIF_RSQL_SQL_ERROR

Occurred on 18.05.2011 at 10:18:05

SQL error 600 occurred when accessing table "TST03 ".

What happened?

An exceptional situation has occurred in the ORACLE software,

possibly due to an error.

This is not an error in an application program.

Former Member
0 Kudos

Maybe you have already seen SAP note 154497 which describes this ORA-00600 [[6749]] with older Oracle releases. If you only have one single spool request and you definitely want to get rid of it in TST03, you can also try:

select count(*) from sapr3.tst03;
truncate table sapr3.tst03;

BEWARE: Don't do this if you have more than one spool request because you'll definitely lose all of them.

Edited by: Mark Foerster on May 18, 2011 11:33 AM

former_member182034
Active Contributor
0 Kudos

hi,

please upgrade the Oracle Patch and if you already upgraded then you have to apply interim patch level.

check this SAP Note 365421 - ORA-00600 [1113] when generating statistics

Regards,

janlars_goedtke
Active Participant
0 Kudos

Hi,

what is written behind ORA-600 (in brackets [12345] )?

Jan