on 05-18-2011 8:29 AM
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
Issue resolved by re organization of table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And can we drop the row also by export and import method
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
SQL> select count(*) from sapr3.tst03;
COUNT(*)
-
738132
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Is there any way to remove only this single spool request.
Either by reorganization or Export or import of table with brtools
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
One more thing I want to update here
- I am able to delete all other spool except one particular spool in SP12 consistency check
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi,
what is written behind ORA-600 (in brackets [12345] )?
Jan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.