RE: Migration from 8i to 11g
Date: Tue, 6 Mar 2012 16:13:43 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C562FF8CC_at_COPDCEXMB08.cable.comcast.com>
I recently did an 8i to 11g migration (8.1.7.4 -> 11.2.0.2). 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.
-----Original Message-----
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
To: dramirezr_at_gmail.com
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 (8.1.7.1) 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!
>>
>> Regards
>>
>>
>> David Ramírez
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 06 2012 - 10:13:43 CST