Oracle Database 11gR2的升级路径与升级思考

« 试用新浪微博 - 后Twitter时代 | Blog首页 | 来自Oracle公司的职位机会：Principal Consultant »

在上次参加Oracle的访谈活动时，我就升级的观点做过一点陈述，再记录一下：
如果客户还在使用Oracle9i，那么从9i直接升级到11gR2将是一个非常好的选择。
--这是因为，10g较9i来说是一个划时代的产品，其自动化特性是Oracle新一代产品的发展目标
--而Oracle Database 11g则是10g的改进版本，是其10g产品特性的延续，较10g更为成熟
--从9i到11g，避免了10g诸多不成熟特性的折磨(当然11g也不一定是那么可靠的）
--CBO经过10g的多年测试和验证，在11g中应该更加成熟，这是非常重要的。

而对于Oracle 10g的用户，可以再等一两个PatchSet再做考虑，比较Oracle 10g还有一个较长的支持期，11gR2的到来无疑加快了Oracle9i退出市场的步伐。

在Oracle的文档中，表明9.2.0.8是可以直接升级到11gR2的，不过对于使用了裸设备的RAC集群，升级显然要复杂的多。

以下链接是Oracle的升级指导站点：
http://www.oracle.com/technology/products/database/oracle11g/upgrade/index.html

Oracle还专门为11g运营了如下站点：
http://www.oracledatabase11g.com/Main/Home/Home_w.html

Oracle各版本到Oracle 11GR2的升级路径如下：

Current Release	Upgrade Path
7.3.3 and lower 7.3.4 8.0.3 8.0.4 8.0.5 8.0.6 8.1.5 8.1.6 8.1.7.4 9.0.1.4	Direct upgrade is not supported. Upgrade to an intermediate Oracle Database release before you can upgrade to the new Oracle Database 11g release, as follows: 7.3.3 (or lower) -> 7.3.4 -> 9.2.0.8 -> 11.2 8.0.5 (or lower) -> 8.0.6 -> 9.2.0.8 -> 11.2 8.1.7 (or lower) -> 8.1.7.4 -> 10.2.0.4 -> 11.2 9.0.1.3 (or lower) -> 9.0.1.4 -> 10.2.0.4 -> 11.2 When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release's documentation. Then, upgrade the intermediate release database to the new Oracle Database 11g release using the instructions in Chapter 3, "Upgrading to the New Release".
9.2.0.8 10.1.0.5 10.2.0.2 11.1.0.6	Direct upgrade to the new Oracle Database 11g release is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher, and 11.1.0.6 or higher. Note that Oracle Clusterware release 10.2.0.x must be at release 10.2.0.3 (or higher), before you attempt to upgrade it to Oracle Clusterware 11g. See "Upgrading an Oracle Real Application Clusters (Oracle RAC) Database". For release 9.2.0.3, you must first upgrade to an intermediate Oracle Database release, as follows: 9.2.0.3 (or lower) -> 9.2.0.8 -> 11.2 To upgrade to the new Oracle Database 11g release, follow the instructions in Chapter 3, "Upgrading to the New Release".

Current Release

Upgrade Path

7.3.3 and lower

7.3.4

8.0.3

8.0.4

8.0.5

8.0.6

8.1.5

8.1.6

8.1.7.4

9.0.1.4

Direct upgrade is not supported. Upgrade to an intermediate Oracle Database release before you can upgrade to the new Oracle Database 11g release, as follows:

7.3.3 (or lower) -> 7.3.4 -> 9.2.0.8 -> 11.2
8.0.5 (or lower) -> 8.0.6 -> 9.2.0.8 -> 11.2
8.1.7 (or lower) -> 8.1.7.4 -> 10.2.0.4 -> 11.2
9.0.1.3 (or lower) -> 9.0.1.4 -> 10.2.0.4 -> 11.2

When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release's documentation. Then, upgrade the intermediate release database to the new Oracle Database 11g release using the instructions in Chapter 3, "Upgrading to the New Release".

9.2.0.8

10.1.0.5

10.2.0.2

11.1.0.6

Direct upgrade to the new Oracle Database 11g release is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher, and 11.1.0.6 or higher. Note that Oracle Clusterware release 10.2.0.x must be at release 10.2.0.3 (or higher), before you attempt to upgrade it to Oracle Clusterware 11g. See "Upgrading an Oracle Real Application Clusters (Oracle RAC) Database".

For release 9.2.0.3, you must first upgrade to an intermediate Oracle Database release, as follows:

9.2.0.3 (or lower) -> 9.2.0.8 -> 11.2

To upgrade to the new Oracle Database 11g release, follow the instructions in Chapter 3, "Upgrading to the New Release".

-The End-

历史上的今天...
>> 2018-09-04文章:

邹建在这里，云和恩墨 SQL Server 咨询，服务火力全开！

>> 2017-09-04文章:

恩墨学院DBA实战培训全新启航

>> 2008-09-04文章:

香港的旺角梦幻的城市

>> 2007-09-04文章:

Oracle 11g新特性:Result Cache之一