Migrating database to new server and upgrade Oracle 8.0.5 to Oracle 9i

[mvital]

Good Morning All,

We just go a "new" server and I will need to migrate the Oracle 8.0.5 database to the new server and upgrade Oracle to 9i. I have created a fullexport of the database. I need to now create the 9i database on the new server (Windows), tablespaces, recreate the users...I'm just worried that I will miss something or not allocate enough space etc. I am fairly new at this. What do I need to make sure I do when upgrading an existing database?

thank you in advance,

Maribel

 

[SantaMufasa]

Maribel,

If you have already created the new 9i database, then you also need to create the tablespace(s) to accommodate the incoming objects from the 8.0.5 database. Since we use disk arrays that are fully striped (to avoid head contention) and mirrored (for safety) disk arrays, I, personally, create one tablespace per application. Again, my personal preference is to create enough 10MB-inital-sized files that grow in 10MB increments to 2GB-maximums to accommodate the incoming objects from the 8.0.5 database. You must also pre-create the target users that will hold your incoming export dumps from the 8.0.5 database.

You should be fine with a full-database-export dumpfile, but in the future, I recommend separate, schema-level exports so that you can initiate schema imports in parallel, plus you don't waste time exporting all of the database overhead that you won't need for the 9i database.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.