Re: upgrades, conversions and ora-600's! oh my!

I am slowly accepting that we may have to recreate the databases. Unfortunately, the additional downtime is an issue for us, but I've just starting hitting the 10.2.0.3 bugs in another test upgrade - the data warehouse this time. These databases support 24x7 global manufacturing, so getting a window will be tough but hitting some later variant of one of these is unacceptable.

My plan (at the moment) is to continue testing in my sandbox and I will probably run the upgrade the real test environments in a few weeks so the developers can start the real testing. (usually the upgrade is the easy part) I've been able to get the database registries valid and clean up enough to stop the ora-600's and call stack traces, but I wouldn't want to do what I've been doing in test to a production database. (although I'm having a blast hacking away in my sandbox)

Next step will be to determine the best method to transfer the data, so I'll check back through the list for suggestions. We have a planned character set conversion following shortly after this effort, so maybe we can combine them and come up with a cut over that the business can live with.

Thanks to all and if anyone has a specific suggestion on rebuilding a 2 TB database with minimal downtime, please drop me a line.

Robyn

On 8/17/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> I prefer to "upgrade" by creating a fresh new 10g database and using
> exp/imp to move the data from the old database to the new one. That's how I
> did my 8.0.6 > 10.2.0.2 upgrade/migration and it was problem-free. As
> long as the extra downtime isn't a concern, this is the best way to go in my
> opinion. We had a big debate on this list a few (maybe several) months ago
> on upgrading vs. exp/imp so you might want to search the archives for that.
> As you've found, there are some big bugs when upgrading so I prefer to avoid
> those and just start with a sparkly clean, fresh smelling, new &
> improved 10g database rather than a bunch of crap left over from versions 8,
> 8i and 9i that might not have been cleaned up properly and are more likely
> to cause problems during the current upgrade, or future upgrades.
>
> Regards,
> Brandon
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Robyn
>
> I'm working on an upgrade from 9.2.0.8 to 10.2.0.2
>
> Just wondering how many others have seen similar issues and how they
> regained confidence in the core structure.
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

--
http://www.freelists.org/webpage/oracle-l