Tuesday, January 11, 2011

My first 11g show stopper: Purging the Recyclebin

I've run into my first issue with  After one of my dbs was upgraded, every time I try to purge the recyclebin, I get an ORA-00600 error:

SQL> purge dba_recyclebin;
purge dba_recyclebin
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktcdso-1], [], [], [], [], [], [], [], [], [], [], []

It doesn't matter if the recyclebin is on or off.

I have done about six upgrades and this is the only db with the problem.  I can backup this db using RMAN and restore it on another host and the error still gets generated.

I have about 43 objects owned by SYS and named WRH$* left in the recyclebin after the upgrade, but these are normal after the upgrade. Or, at least, I have these objects in the recyclebin after every -> upgrade I've done so far.

I can purge the objects individually to get rid of the immediate problem, but I am most concerned that this will show up again in another db.

I couldn't find anything on metalink.  I've had a TAR open with Oracle Support for well over a month and it's going nowhere.


Rakesh said...

Hi Jeff,

Per Oracle® Database Upgrade Guide 11g Release 2 (11.2) manual, Pre-Upgrade tasks list.


The database recycle bin must be empty during the upgrade process to avoid possible ORA-00600 errors as well as to minimize the upgrade time.

I assume purge need to be done before the upgrade.


Taral said...

Bug 10427260: ORA-00600 [KTCDSO-1], [], [], [] WHEN PURGE RECYCLE BIN

Jeff Hunter said...

Taral: Yup, that's my bug!

Rakesh: The recyclebin was empty when I upgraded.

Lazer epilasyon Adana said...

When I did some work out on the west coast, the company I worked with really supported the idea of public communication with things like blogs. I like this concept. While I may agree that more information is not always better, the idea that organizations want their employees to share ideas in a public forum is great. It allows all kinds of people to contribute to the dialog, no matter who they are. And you never know where the next great idea may come from.