Tuesday, January 11, 2011

My first 11g show stopper: Purging the Recyclebin

I've run into my first issue with 11.2.0.2.  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 10.2.0.5 -> 11.2.0.2 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.

Monday, January 10, 2011

Listener Logging in 11g

By default, the listener logging is not turned on in 11r2.  You have to turn it on by specifying:

LOGGING_listener_name=ON


in your listener.ora file.