Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

9.2.0.7 to 11.2.0.3

edited Nov 19, 2012 3:29AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered
Its a 9i database (Solaris OS) of size 475G. In development environment, i patched it to 9.2.0.8 and later upgraded to 11.2.0.3 with minimal issues. I haven't received any complaints from development folks so far.
We considered "Clone Database" approach in 11g Grid Console as another attempt to clone and upgrade the production database to a different server. 11g Grid control has limitations in identifying 9.2.0.7 oracle software. 

I am considering export/import method as another alternative. The plan is to create complete export dump of schema and directly import into 11.2.0.3 Oracle Home. Is it a proven approach? One of the tablespace with mostly table objects in 9i database is spread among fifty plus data files of size 8G. Going forward into 11g version, are there any recommendations concerning data file sizes (bigfile tablespace vs Normal)? Is it a good approach to have few data files of larger sizes?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center