Hi,

Can anyone tell me if they have managed to upgrade a 9.2.0.1 database to 10.2.0.1

I am having issues!

I am following the doc http://download-east.oracle.com/docs...4238/intro.htm

I have installed 10g onto the same machine as the 9i install in a seperate home. I have dropped the 9i database service and created the 10g database service

I have run startup upgrade

I then try to run the first thing in the doc, the pre upgrade tool, utlu102i.sql which fails with an ORA-600 [17069],[0X2ABB4A34] error

I have been in contact with oracle support which has not helped, there are loads of invalid sys opjects that give a 600 internal error when trying to compile them.

Oracle support are now telling me I have to upgrade to 9.2.0.4 before I can run the 10g upgrade but he wasn't really sure!! I need to be certain as I have more than 50 databases to upgrade so doing the 9204 upgrade as well will add lots of time to my work.

So if anyone has successfuly upgraded a 9.2.0.1 database to 10.2.0.1 I would love to know!

many thanks
Robert