從今天開始，全面整理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

轉載于:https://blog.51cto.com/happyland/742134

總結

以上是生活随笔為你收集整理的oracle各版本手动升级任我行-升级矩阵的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。