手动升级oracle,oracle各版本手动升级任我行-升级矩阵

从今天开始，全面整理oracle低版本到高版本的手动升级方法，针对的平台是unix。

从低版本到高版本可能的升级组合如下(以下内容将持续更新)：

--------------------------------------------------------------

8.x升级到8.X

Complete Upgrade Checklist for Manual Upgrades from 8.x to 8.x [ID 133920.1]

升级脚本如下(startup restrict)

From        To                     Only Script to Run

====        ===                    ==================

8.0.3       8.0.4 or higher        @u0800030.sql

8.0.4       8.0.5 or higher        @u0800040.sql

8.0.5       8.0.6 or higher        @u0800050.sql

8.0.6       8.1.5 or higher        @u0800060.sql

8.1.3       8.1.5 or higher        @u0801030.sql

8.1.4       8.1.5 or higher        @u0801040.sql

8.1.5       8.1.6 or higher        @u0801050.sql

8.1.6       8.1.7                  @u0801060.sql

--------------------------------------------------------------

8.0.X/8.1.X/9.0.1升级到9.0.1/9.2

Complete upgrade checklist for manual upgrades from 8.X to Oracle9i(incl. 9.2) [notes 159657.1]

升级脚本如下(startup migrate)

From       To:           Only Script to Run

====       ===         ==================

8.0.6      9.0.1         u0800060.sql

8.0.6      9.2           u0800060.sql

8.1.5      9.0.1         u0801050.sql

8.1.5      9.2           Not Supported

8.1.6      9.0.1         u0801060.sql

8.1.6      9.2           Not Supported

8.1.7      9.0.1         u0801070.sql

8.1.7      9.2           u0801070.sql

9.0.1      9.2           u0900010.sql

升级矩阵如下

8.0.3  --> 8.0.6 --> 9.0.1

8.0.3  --> 8.0.6 --> 9.2

8.0.4  --> 8.0.6 --> 9.0.1

8.0.4  --> 8.0.6 --> 9.2

8.0.5  --> 8.0.6 --> 9.0.1

8.0.5  --> 8.0.6 --> 9.2

8.1.5  --> 9.0.1

8.1.5  --> 8.1.7 --> 9.2

8.1.6  --> 9.0.1

8.1.6  --> 8.1.7 --> 9.2

8.1.7  --> 9.0.1

8.1.7  --> 9.2

9.0.1  --> 9.2

--------------------------------------------------------------

8.0/8i/9i升级到10gR1

Complete upgrade checklist for manual upgrades from 8.X to Oracle9i(incl. 9.2) [notes 159657.1]

升级脚本如下(startup upgrade)

From       To:         Only Script to Run

====       ===         ==================

7.x.x      10.1          Not supported

8.0.5      10.1          Not supported

8.0.6      10.1          u0800060.sql

8.1.5      10.1          Not Supported

8.1.6      10.1          Not Supported

8.1.7      10.1          u0801070.sql

9.0.1      10.1          u0900010.sql

9.2        10.1          u0902000.sql

升级矩阵如下

8.0.4  --> 8.0.6 --> 10gR1

8.0.5  --> 8.0.6 --> 10gR1

8.0.6  --> 10gR1

8.1.5  --> 8.1.7 --> 10gR1

8.1.6  --> 8.1.7 --> 10gR1

8.1.7  --> 10gR1

9.0.1 --> 10gR1

9.2   --> 10gR1--------------------------------------------------------------

8.0/8i/9i/10gR1升级到10gR2

Complete checklist for manual upgrades to 10gR2 [notes 316889.1]

升级脚本如下(startup upgrade)

@catupgrd.sql

The catupgrd.sql script determines which upgrade scripts need to be run and then runs each necessary script.升级矩阵如下8.1.7.4 --> 10.2.X.X.X

9.0.1.4 or 9.0.1.5 --> 10.2.X.X.X

9.2.0.4 or higher --> 10.2.X.X.X

10.1.0.2 or higher --> 10.2.X.X.X

The following database version will require an indirect upgrade path.

7.3.3 (or lower) --> 7.3.4 --> 8.1.7 --> 8.1.7.4 --> 10.2.X.X.X

7.3.4 -> 8.1.7 --> 8.1.7.4 --> 10.2.X.X.X

8.0.n -> 8.1.7 --> 8.1.7.4 --> 10.2.X.X.X

8.1.n -> 8.1.7 --> 8.1.7.4 --> 10.2.X.X.X--------------------------------------------------------------

升级到11.2.x的步骤(ID 837570.1)

7.3.3 or lower   --> 7.3.4   --> 9.2.0.8  --> 11.2.x

8.0.5 or lower   --> 8.0.6   --> 9.2.0.8  --> 11.2.x

8.1.7 or lower   --> 8.1.7.4 --> 10.2.0.4 --> 11.2.x

9.0.1.3 or lower --> 8.1.7.4 --> 10.2.0.4 --> 11.2.x

9.2.0.1 or lower --> 9.2.0.8 -->              11.2.x

9.2.0.8  or higher --> 11.2.x

10.1.0.5 or higher --> 11.2.x

10.2.0.2 or higher --> 11.2.x

11.1.0.6 or higher --> 11.2.x