Re: 18.104.22.168 upgrade - 10g or 11
Date: Wed, 16 Apr 2008 10:38:57 -0700
On Wed, Apr 9, 2008 at 10:27 AM, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> I'd recommend you create a new database and migrate via exp/imp rather
> than doing an in-place upgrade. There is at least one nasty bug with
> upgrades to 10.2.0.3 and last time I checked the only solution was to
> use exp/imp or just stay on 10.2.0.2 instead, although it may be fixed
> in 10.2.0.4 now.
I'll go along with that.
We have SAP databases that we are migrating from 9i to 10g.
We've run into some rather nasty bugs for which there is no fix in 10.2.0.2
We were waiting for a backport of the bug fix from 10.2.0.3, but we are
now going to exp/imp the data into a new database.
(SAP is not certified for 10.2.0.3, and never will be 10.2.0.4 not yet
These particular SAP databases were migrated from 8i to 9i previously. This just complicates problems.
SAP support has documented that databases migrated from 8i to 10g are fraught with problems.
If at all possible, consider building a new database.
We are going to use the SAP utilities for this (forget the name) which are
like unload/load via SQL Loader than exp/imp.
An 800 gig database would take a very long time to export and import with exp/imp.
On other thing to note: if you have created any views in the sys schema on
drop them before the migration.
Here's what can happen:
View created on x$ table in 8i database
migrate db to 9i
some x$ tables no longer exist on the newly migrated db the views on the now defunct $x tables remain attempts to drop the views will result in ORA-600  all attempts to drop the view will fail.
Not fatal, but rather annoying.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 16 2008 - 12:38:57 CDT