Oracle Database Discussions

Hello,

I'm a newbie with doing Oracle Databases.

I want to upgrade my oracle 10.2.0.5 DB with two instance to an new version 11.2.0.2 on the same Windows Server 2003 (x86).

At first, i install the Patchset 11.2.0.2 and use DBUA to upgrade my first database instance and this works. After them I start the DBUA again to upgrade the second instance and this abort with an error. I started again and the upgrade from the second instance finished.
But after the upgrades, no database instance will work.

So I searched with google and find something from Oracle and blogs. And now, i'm little bit confused.
My next Steps are, recover the VM Server from backup and make with the second attempt further.

My next way is to install a single database with patchset 11.2.0.2. I will configure 2 DB instance (ORCL1 and ORCL2) and perform a migrate with data dump from the old DB instances to the new instances.

Can I do this? Can I do a full export from a 10g DB and import this into a 11g DB with all tables and shemas with the user 'SYSTEM'?
Is the no any problem with different System shemas and tables between 10g and 11g?


I think that are my first questions. Thanks for your help :-).

by NOC