I know you've probably called the consultants everything in the book by now but just out of curiosity would it be possible instead of upgrading to do a fresh install of 9.2.0.6 and just import the schemas? Based on the assumption that the database isn't all that big?
I've got a database that was upgraded from 8.1.6 to 8.1.7.4 to 9.2.0.5 and I've had nothing but problems with it. It's 75 gigs and I'm going to take a weekend here sometime and do a fresh install of 9.2.0.6 and import the schemas. I still have dictionary managed tablespaces for christs sake!
shawd up! Davey I don't want to hear it
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg