Skip to Main Content
  • Questions

  • Analyzing 27 TB of database for upgrade from (10.2.0.5 to 11.2.0.4)

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Arpit.

Asked: August 30, 2016 - 9:17 am UTC

Last updated: September 01, 2016 - 2:46 am UTC

Version: 10.2.0.5

Viewed 1000+ times

You Asked

Hi,

We are planning to upgrade 27 terabyte of database from 10.2.0.5 to 11.2.0.4. we are not sure things to look before upgrading as this
is very huge database and it is running from many years live for users. Please suggest things and scripts to analyze the database.
We expect if we could get the complete insight of the database .

and Connor said...

The size of the database does not have a bearing on the upgrade.

But we have an awesome library of things to consider when upgrading.

Check out this link:

http://www.oracle.com/technetwork/database/upgrade/overview/index.html

There are videos, presentations and whitepapers all designed to guide you through the process to make upgrade a smooth and low risk process.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Permium support for 11g got ended

Rajeshwaran Jeyabal, August 31, 2016 - 12:52 pm UTC

Any specific reason to go for 11g? why not 12c?

The premier support for 11g got ended a while ago.
https://blogs.oracle.com/UPGRADE/entry/premier_support_for_oracle_11
https://blogs.oracle.com/UPGRADE/entry/premier_support_for_oracle_111
11g is on extended support till Dec-2020
https://blogs.oracle.com/UPGRADE/entry/no_extra_fee_for_extended
Connor McDonald
September 01, 2016 - 2:46 am UTC

Agreed.

Whenever I upgrade a database (which is always a significant undertaking) I can't imagine why you would not jump to as current a release as possible, where "as possible" might be constrained by supported versions by other app vendors etc.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.