Search does not support Oracle on 5.2. The first version that will support Oracle search will be 5.3 (with a version backported for 5.1 and 5.2) so there won't be any upgrade scripts just yet.
I'll look at rss-support. I suspect it's database specific, but you never know.
