Database rehost and upgrade

[BenLoosli]

I would like to do a database upgrade independent of any Windchill upgrade.

I have Oracle 10g on Windows 2003 32bit for my Windchill 9.1 m060 system.
I want to move this to Oracle 11gR2 on Windows 2008r2 64bit.
No Windchill upgrade at this time, just the database server.

Does anyone have any hints, tips or suggestions for doing this.

Long term, this will become the database system when I upgrade to 10 or 10.1 in a few weeks.
I want to get the database portion done as a separate step.

10g is not supported on Windows 2008r2 64bit.
11gR2 is supported on Windows 2003 32bit, but I don't have the image to install it there.

10g is not supported on Windchill 10 or higher.
11gR2 is supported on Windows 2008r2 64bit for Windchill 9.1, 10.0 and 10.1.


Thank you,

Ben H. Loosli

USEC, INC.

[ZacharyAlexande]

Ben,

Unless there are custom configurations to the database, you can load a 10g
database into an 11gR2 database without needing to update the data. The 10g
database export should be compatible with the 11gR2 database. Make sure
that all there is plenty of space in the tablespaces before loading and
they are set to AUTOEXTEND ON.

Thanks,
Zack


Zachary D. Alexander
Operations Manager - RAPiDS
ProductSpace Solutions Inc.
Phone: 630-495-2999 Ex. 8104
Cell: 630-460-4905

[ZacharyAlexande]

Ben,

Those steps look correct.

One important thing to keep in mind is that database exports are very
easily corrupted during a copy. Make sure to zip them first, copy in Binary
(if using a copy utility and this is an option) and unzip them again on the
target system. It's easy to tell when a zip file is corrupted (won't unzip)
but often hard to tell when a database export has been corrupted (load
eventually fails or won't start)

Tablespaces can be set to AUTOEXTEND on using sql statements. Please see
the following link for instructions (actual tablespace and datafile names
will be different):