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

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Sat, 18 Aug 2007 10:01:53 +1000 (EST)
Message-ID: <342129.57819.qm@web31904.mail.mud.yahoo.com>

Hi,

I have just been through an upgrade of a 2.6 Tb database where the customer moved from 10.1.0.5 to 10.2.0.3 and the customer has had many issues after the upgrade. They have even made it to the news columns.

They had 5 one-off patches on 10.1.0.5 and now have 16 on top of 10.2.0.3. 2 of these patches were specific to the upgrade script which you could potentially hit if your database was ever a 32 bit database.

These I believe are listed in a Metalink alert.. Also if you have temporary tablespace groups 3 indexes in AWR do not get re-created because the data model in 10.2.0.3 has changed. Majority of time in the catupgrd.sql script was spent gathering stats on the AWR tables because they were huge (the customer does 30 min snapshots and stores 6 months data) but this finished in an hour's time.So the total outage time in this case was around 4 hours.

Since the customer has more than 30 RAC services they had to be removed and re-created using the 10.2 srvctl utility.

Thanks
Fairlie

Robyn <robyn.sands_at_gmail.com> wrote:
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.

          Fairlie Rego
Senior Oracle Consultant
  http://el-caro.blogspot.com/
  M: +61 402 792 405

Get the World's number 1 free email service. Find out more.

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

Received on Fri Aug 17 2007 - 19:01:53 CDT