RE: Migration from 8i to 11g
Date: Tue, 6 Mar 2012 16:13:43 +0000
I recently did an 8i to 11g migration (18.104.22.168 -> 22.214.171.124). I opted to skip going through 10g as it was just too much extra work. Also, I opted to do export/import (yes, imp is still there in 11g) because I wanted to use new 11g features (we had the benefit of doing this in dev, test, and then prod - not sure if you have that luxury). I also used SQL Plan Management and migrated my profiles over from the Test system to production as part of the upgrade to help ensure good performance immediately after the upgrade.
I would definitely not just go to 10g because support won't be as good and won't last as long.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kathryn axelrod Sent: Monday, March 05, 2012 11:17 AM
Cc: 'oracle-l_at_freelists.org' (oracle-l_at_freelists.org) Subject: Re: Migration from 8i to 11g
Someone pointed out that you might be referring to doing an import/export - in which case, I retract my question. (And you're on 8i anyway, so it's not like you're getting loads of support to begin with!)
One other suggestion: It is somewhat tedious, and I don't know if you've looked at them yet, but if you read through all of the 'What's New' documents from 9i on (e.g. http://docs.oracle.com/cd/E11882_01/install.112/e16763/whatsnew.htm) that could help reduce the surprise changes.
On Mon, Mar 5, 2012 at 9:58 AM, kathryn axelrod <kat.axe_at_gmail.com> wrote:
>>any other suggestions or comments we may take care of?
> Probably not at all what you were looking for, but I can't help but ask:
> Oracle doesn't support a direct 8i>11gR2 upgrade (551141.1) so what
> happens if something goes wrong during the upgrade/you encounter a
> completely wonky bug right after?
> On Mon, Mar 5, 2012 at 5:39 AM, David Ramírez Reyes <dramirezr_at_gmail.com> wrote:
>> Hello all!
>> We have some old instances running on Oracle 8i (126.96.36.199) and right
>> now we are planning to migrate those to the latest version of Oracle
>> (11g release 2); I know that this is maybe an insane migration, but
>> we as DBA's, don't have that decision in our hands (this idea comes
>> directly from the CIO, we would like to migrate to 10g first).
>> We have made some tests and the migration seems to be clean, but I
>> must say that this is the first time am using 11g and I would not
>> like to find any "surprise" when moving...
>> Apart from the client upgrade, any other suggestions or comments we
>> may take care of?
>> Any information is appreciated!
>> David Ramírez