RE: 9i to 10g Upgrade

I didn't see anything about reading the documentation in your steps. For some of us, it might be safe to assume we're going to read the documentation, but others I'm not so sure about ;-) Make sure you read it thoroughly, including the 10g concepts & new features (if you're not already familiar with them - there is a LOT of new stuff), the upgrade/migration guide, release/patchset notes, latest metalink updates, etc. Other than that, your plan looks good to me. Some on this list would recommend that you don't use the default gather_stats_job or automatic shared memory management (sga_target) features of 10g and I would partiall agree, but as with everything - it depends. Jonathan Lewis made an excellent post to the list earlier today summarizing the most common CBO-related problems when upgrading from 8i to 10g - you might want to take a look at that if you haven't already. Good luck!  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandra Becker Sent: Thursday, July 20, 2006 2:31 PM
To: oracle-l_at_freelists.org
Subject: 9i to 10g Upgrade

I'm preparing to do my first 9i to 10g upgrade and would like to have a solid plan in place before I start. I've prepared an implementation plan with the following steps and would like to know if anyone sees steps I might have missed. We also are moving from a 32-bit to 64-bit platform. The 10gR2 upgrade guide says this will be handled automatically going from 9i to 10g.

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