Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Upgrade/Migration Dilemma

RE: Database Upgrade/Migration Dilemma

From: Ray Feighery <>
Date: Sat, 28 Oct 2006 08:57:17 +1000 (EST)
Message-ID: <>

A few months ago I did a migration from Oracle 8.0.6 to Oracle on Solaris. I basically used your plan outlined in your third paragraph except I used user export/import (why canít you use this? How big is the database?). Everything worked well Ö

Ö because we had tested it.

A trivial example; parameter types defined in a package header and body have to match on 10g; they didnít on 8. So PL/SQL packages that compiled on Oracle 8 will not necessarily compile on 10g. Production downtime during a migration is not the time to hit these problems for the first time.

Put it in writing that you are totally against migrating without testing and make sure a copy goes to the business owner of the data. If the system is so mission critical that it canít be shut down during a migration (Iím against this too) then think about what the ramifications will be if you canít start the application after the migration.


From: [] On Behalf Of Rick Weiss Sent: Thursday, October 26, 2006 3:13 PM To:
Subject: Database Upgrade/Migration Dilemma

I just had an interesting and disturbing discussion with damagement and wanted to run this by the DBA Gods that read this list.

We are planning to migrate out production environment from Oracle 8i (8.1.6) on AIX to Oracle 10g (10.2) on Linux.† My current plant is to do the data moves (about 150 tables) as CTAS via database links. (are there better options? exp/imp won't go back that far)† The biggest kicker came in this afternoon - our Java head wants to do the migration with the application up and accessible.

This just seems to me to be courting disaster.† My suggestion was to take everything down, back up the entire environment and then do the moves prior to repointing the applications and bringing them up.

Another kicker is they don't want to test prior to pulling the trigger.† The worst thing is they made the decision while I was out of town @ OOW.

Should I get my resume' ready?

Thank you for any insights you may have.

Rick Weiss
Oracle Database Administrator

Student Assistance Foundation
P.O.Box 203101
2500 Broadway
Helena, MT 59620-3101 ( (406) 495-7356

Received on Fri Oct 27 2006 - 17:57:17 CDT

Original text of this message