upgrade from 10g to 11g
DBA_1976Feb 21 2012 — edited Feb 21 2012Hi,
I need to upgrade my 10.2.0.3 in RHEL 4 (64 bit) -- Server1 to windows 2003 server (in VM) 32 bit -- Server2. I want it to be upgraded to 11.2 in windows. Is the following steps enough or am I missing something.
1. Install oracle 11gR2 in Server2
2. Export full from Server1
3. Create empty database in Server2
4. Create the tablespaces in Server2 (as in db in Server1).
5. Run the catalog.sql and catproc.sql in Server2
6. import the dump in Server2
7. startup upgrade and run the catupgrd.sql and utlrp.
8. shutdown and then startup
Did I miss anything. Only thing I am concerned is I never migrated from 64 to 32 bit. (But the export and import should take care of it right. Please tell me if I am wrong).
Thanks in advance,