Q

Upgrade OS or database first?

What should be the first step, to upgrade our OS and then upgrade the database, or vice versa?

We are planning to upgrade our OS from AIX 5.2 to AIX 5.3 and at the same time, we want to upgrade our Oracle 8i databases to Oracle 9.2.0.6. Here is my question: What should be the first step, to upgrade the OS and then upgrade the database, or would it be the reverse way? Thank you.
According to Oracle's Certification Matrix, it would appear that Oracle8i on AIX 5.2 is not supported or certified. In this case, I would be inclined to first upgrade the database to Oracle9i release 2 (9.2.0.8 is the latest release). Upgrading the operating system to yet a newer release might be asking for trouble with the existing Oracle8i database.

After the database is upgraded to 9.2 and has been stable for some time, I would then consider upgrading the operating system to AIX 5.3. Remember to take a full system backup, if possible, before you perform either of these upgrades. Also, after upgrading your operating system, remember to relink the Oracle9i binaries. Of essential importance is testing this upgrade in a non-production environment. This testing does not just include...

the actual upgrade, but also thoroughly testing all applications that rely on this Oracle database.

This was first published in December 2006
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close