Pre-Upgrade Utility---下載並執行Oracle資料庫預升級實用程式 (文件 ID 1577379.1)

18c

12.2.0.1

12.1.0.2

12.1.0.1

11.2.0.4

11.2.0.3

Build 3

2018年6月

For Unix: 2

For Windows: 

改進和新的檢查：

• 改進了修復執行報告
• 新增了一些更改來支援新的 Oracle 發行模型
• 考慮預設臨時表空間是臨時表空間組的情況
• 升級前驗證固定物件的統計資訊
• 顯示CDB上預設數量的pdb並行升級的資訊
• 報告DV 模擬器日誌是否沒有記錄
• 新增ZSeries 日誌管理
• 重新構造preupgrade.jar 的內容以刪除對RU 版本的引用。
• 在日誌檔案中列印build版本資訊
• 修復了BS2000 系統(EBDIC)上的end-of-line問題。
• 新增了改善表空間的查詢
• 新增了一些PL / SQL變數中的更改以避免溢位。

12cR2 (12.2.0.1)

12.1.0.2

12.1.0.1

11.2.0.4

11.2.0.3

Build 15

2018年6月

  For unix - 

For Windows - 

12.2.0.1 Cloud 版本(build 2)開始preupgrade.jar的主要變化:
- 增加了load only 功能.
- 改進了與OS的互動
- 增加了更多過時/廢棄的引數
- 改進了在Windows上的IPC 呼叫
- 增加了aud$unified分割槽表功能.
- 增加了preupgrade和postupgrade自動修復
- 檢查JAVAVM mitigation patch
- 增加了引數檢查，僅當動態引數在spfile中被修改
- 更新引數，比如記憶體限制.

- 增加UTF-8字符集功能。
- 增加一個檢查，檢視當RESOURCE MANAGER關閉時CONCURRENT STATISTICS是否被設定。
- 增加一段程式碼，資料庫升級後如果DEPEND_USR_TABLES檢查被執行，那麼這段新增加的程式碼將會被執行
- 還增加了一個新的自動修復功能，自動由postupgrade_fixups.sql指令碼執行。

- 增加了一個驗證APEX版本的檢查

- 修改檢查tempts_notempfile，應該考慮表空間組

- 新增pga_aggregate_limit檢查

- 新增對非常大的臨時表空間組的支援

- 修復了對檢查TRGOWNER_NO_ADMNDBTRG上的ACTION的推薦查詢

- 在日誌檔案上新增列印預升級版本

- 新增了升級RMAN CATALOG的提醒

- 新增一個檢查來檢測資料庫是否使用2k / 4k db塊大小
- 調整升級到12.2的記憶體要求
- 當資料庫為NON-CDB時，新增一個增加undo空間的檢查

- 修復了BS2000 系統(EBDIC)上的end-of-line問題。
- 新增了改善表空間的查詢
- 新增了一些PL / SQL變數中的更改以避免溢位。

- 包括修復錯誤 ORA-01426：numeric overflow

**注意**

- 12.2版本的下載說明已經更改，詳情請查閱本文中下載部分.

- 使用方法在12.2版本中已經更改，詳情請查閱  

12cR1 (12.1.0.2)

12.1.0.1

11.2.0.4

11.2.0.3

11.2.0.2

11.1.0.7

10.2.0.5

Build 18

2018年3月

For Windows - 

For non-windows platforms - 

12.1.0.2第一個版本後的變化

• 增加了一個驗證APEX版本的檢查
• 增加一個檢查，檢視當RESOURCE MANAGER關閉時CONCURRENT STATISTICS是否被設定。
• 12.1資料庫不推薦pga_aggregate_limit
• 修復升級並行pdb計數的失誤
• 更新build #12中的記憶體大小
• 刪除了手冊中的32位和64位值.
• 增加了pga_aggregate_limit.
• 去掉了non-CDB中Shared_pool_size從472M增加到660M.
• Memory_target演算法更強大，因為加入了pga_aggregate_target.
• 涵蓋了CDB的大小  (並調整catctl.pl的預設值-d和-N).
• 為一些message做了一些微小的更改
• 當底層資料庫具有複雜結構時，防止在各種上下文中出現字串大小溢位
• 當存在大量無效物件時，避免INVALID_USR_TABLEDATA修復程式中的bug
• 為時區message修正MOS文件號
• 如果資料庫是隻讀的，那麼不insert/update表registry$log
• 增加了 JVM mitigation patch 的檢查
• 更改了network ACL檢查
• 更改了引數job_queue_processes的檢查
• 檔案更改需要恢復檢查以排除OFFLINE NORMAL檔案

12cR1 (12.1.0.1)

11.2.0.4

11.2.0.3

11.2.0.2

11.1.0.7

10.2.0.5

Build 7

2014年4月

For Windows - 

For all other platforms - 

12.1.0.1版本開始的變化

• 提高了當資料庫中有很多tablespace時的效能
• 重新引入記憶體相關的推薦
• 宣告資訊更新為只有元件 OLAP Catalog 不再支援，而不是整個OLAP

11.2.0.3

11.2.0.2

11.2.0.1

11.1.0

10.2.0

10.1.0

9.2.0.8

Build 9

2014年5月

對於使用命令列手工執行預升級 

對於使用DBUA 執行預升級 

11.2.0.4版本開始的變化

• 把所有 11.2.0.2, 11.2.0.3, 和 11.2.0.4 preupgrade 指令碼升級至11.2.0.4的功能.
• 提高了當資料庫中有很多tablespace時的效能
• 確保"Miscellaneous Warnings" 始終展現，即使沒有滿足的條件
• 修復非預設事件決定

11.2.0.2

11.2.0.1

11.1.0

10.2.0

10.1.0

9.2.0.8

Build 9

2014年5月

11.2.0.3版本開始的變化

• 把所有 11.2.0.2, 11.2.0.3, 和 11.2.0.4 preupgrade 指令碼升級至11.2.0.4的功能.
• 提高了當資料庫中有很多tablespace時的效能
• 確保"Miscellaneous Warnings" 始終展現，即使沒有滿足的條件
• 修復非預設事件決定
• 更新了表空間大小的評估
• 針對11.2.0.3發行後的新問題

11.2.0.1

11.1.0

10.2.0

10.1.0

9.2.0.8

Build 9

11.2.0.2版本開始的變化

• 把所有 11.2.0.2, 11.2.0.3, 和 11.2.0.4 preupgrade 指令碼升級至11.2.0.4的功能.
• 提高了當資料庫中有很多tablespace時的效能
• 確保"Miscellaneous Warnings" 始終展現，即使沒有滿足的條件
• 修復非預設事件決定
• 更新了表空間大小的評估
• 針對11.2.0.3發行後的新問題
• 時區版本更新
• 廢棄cell_partition_large_extents
• 針對112安裝程式的OLS & DV資訊
• 修復connect by語句
• 11.1 到 11.2加入DMSYS推薦
• 使用apex時正確估算表空間大小
• 修復無效物件列表
• 修復元件的STATUS/VERSION 的XML輸出
• 修復xml輸出
• 如果可能，更改drop表為truncate
• 檢查版本檢視
• Linesize降低到100
• 去除對過期統計資訊的檢查
• 加入推薦章節（隱藏引數/event移到這個部分）
• 使用隱含引數的警告資訊
• 非預設event的警告資訊
• ldap依賴關係的警告資訊
• 資料庫處於MOUNT狀態的警告資訊
• 加入UltraSearch相關警告資訊
• 非SYS-DBA執行的警告資訊
• 加入了Recycle bin的警告資訊(從之前的“推薦”改為“必須”purge)
• 加入32/64 bit系統的共享池大小推薦
• 更新統計資訊檢查
• 如果資料庫為只讀模式，允許有限的檢查
• 去除Network ACL檢查
• 去除cursor_space_for_time警告資訊
• 去除auto-extent資訊，之前的詞彙令人迷惑
• 去除ASM檢查(非功能性)

11.1.0

10.2.0

10.1.0

9.2.0.8

9.2.0.7

9.2.0.6

9.2.0.5

9.2.0.4

Build 2

2010年12月

11.1.0.7版本開始的變化

• 時區版本更新
• 最佳化dba_queues的select語句

10.2.0

10.1.0

9.2.0.8

9.2.0.7

9.2.0.6

9.2.0.5

9.2.0.4

Build 2

2010年12月

10.2.0.5版本開始的變化

• 棄用cursor_space_for_time
• 表空間大小更新
• 無效物件更新

19 RU 2

18

12.2.0.1

12.1.0.2

11.2.0.4

Build 1

March 13th 2019

For Unix:  

For Windows: 

Changes included in Build 1:

Improvements:
Support for case sensitive pdb name
Display patch level
Optimize query that review space on tablespaces

New checks added:

• Streams setup
• Inform about upgrade needed for RMAN recovery catalog
• Review if object directory symlinks are in use
• Notify about desupport continuous_mine and EDS
• Review if TDE is in use
• Warn about remove ApplicationPrincipal
• Warn about ORDIM desupport
• Validate existance of jobs defined through DBMS_JOB
• Check for unified audit recs in file
• Warn if utlrp.sql will run serially

18c

12.2.0.1

12.1.0.2

12.1.0.1

11.2.0.4

11.2.0.3

Build 6

December 10th. 2018

For Unix:

For Windows: 

Improvements and new checks:

• Improved the fixups execution reporting
• Added changes to support new Oracle release model
• Consider cases when default temporary tablespace is a temporary tablespace group
• Validate statistics on fixed objects before upgrade
• Display information on default number pdbs upgrading in parallel on a CDB
• Report whether DV simulation log has no records
• Adds ZSeries log management
• Restructured content of preupgrade.jar to remove references to RU versions.
• Prints build version in the log file.
• Fixes end-of-line for BS2000 systems (EBDIC).
• Adds query improvements for tablespaces
• Adds changes in some PL/SQL variables to avoid overflow.
• Adds a new check to validate if public xmlconcat synonym is present in the database.
• Adds a recycle bin management when dictionary statistics autofixup is run.
• Updates DV_AUDIT_CLEANUP to 11.2.0.4

Changes included in Build 6

•  Adds a properly reference gsm_pooladmin_role role.
•  Enhance mv_refresh check.

12cR2 (12.2.0.1)

12.1.0.2

12.1.0.1

11.2.0.4

11.2.0.3

Build 20

February 2019

 For unix - 

 For Windows -

Major changes for this preupgrade.jar version since 12.2.0.1 Cloud release (build 2):

- Added load only capabilities.
- Improved the interaction with OS
- Added more obsolete/deprecated parameters
- Improved IPC calls on Windows
- Added functionality for aud$unified table partitions.
- Added preupgrade and postupgrade automatic fixups
- Check for JAVAVM mitigation patch
- Added parameters checking when a dynamic parameter has been changed at spfile only
- Update parameter such as memory limits.

- Adds UTF-8 characterset capabilities.

- Adds a check to see if CONCURRENT STATISTICS are set when RESOURCE MANAGER IS OFF.
- Adds a block of code which will be run if the DEPEND_USR_TABLES check is run after the database has been upgraded.
- A new autofixup function is also added, which will automatically be run by the postupgrade_fixups.sql script.

- Adds a check to validate APEX version.

- Modifies check tempts_notempfile, it should also consider tablespace groups

- Changes severity of new_time_zones_exist to warning

- Adds pga_aggregate_limit check

-  Adds support for very large temporary tablespace groups.

- Fixed recommended query for ACTION on check TRGOWNER_NO_ADMNDBTRG

-  Adds print preupgrade build version on log files.

-  Adds a reminder to upgrade RMAN CATALOG.

- Adds a check to detect if a database is using 2k/4k db block size
- Adjusts memory requirements for an upgrade to 12.2
- Adds a check to increase undo space when a database is NON-CDB

- Fixes end-of-line for BS2000 systems (EBDIC).
- Adds query improvements for tablespaces
- Adds changes in some PL/SQL variables to avoid overflow.

- Adds a fix for  ORA-01426: numeric overflow

- Adds a new check to validate if public xmlconcat synonym is present in the database.

- Adds a recycle bin management when dictionary statistics autofixup is run.
Updates DV_AUDIT_CLEANUP to 11.2.0.4

- Adds a fix to properly report tablespaces with autoextensible on

- Adds a properly reference gsm_pooladmin_role role.
- Enhance mv_refresh check.
- Change xml parser functions to return CLOB instead of VARCHAR2.

February 2019:

- Optimize query for depend_usr_tables and invalid_usr_tabledata checks

- Limit the number of processes used by catcon on CDB

- Fix issue when using -u and -p options

**NOTE**

- The download instructions for this 12.2 release have changed, please see the Downloading section in this document above for details.

- The usage model has changed in 12.2 since previous releases, please see the    for details.

12cR1 (12.1.0.2)

12.1.0.1

11.2.0.4

11.2.0.3

11.2.0.2

11.1.0.7

10.2.0.5

March 2018

For non-windows platforms - 

Changes since initial release of 12.1.0.2

• Adds a check to validate APEX version.
• Adds a check to see if CONCURRENT STATISTICS are set when RESOURCE MANAGER IS OFF.
• Do not recommend pga_aggregate_limit for 12.1 databases
• Fix miscalculation of upgrade parallel pdb count
• Updates to the memory sizing uploaded in build #12
• Removed the 32-bit and 64-bit values in the manual display.
• Added a pga_aggregate_limit.
• Shared_pool_size has gone from 472M to 660M for non-CDB.
• Memory_target algorithm is more robust now that we've added a pga_aggregate_target to its sizing.
• Cdb sizing also in (And is sizing for default -d and -N of catctl.pl.
• Make minor text changes to a few messages
• Prevent string size overflows in a variety of contexts when underlying database has complex structure
• Avert bug in INVALID_USR_TABLEDATA fixup routine when a large number of invalid objects exist
• Correct MOS note number for timezone message
• Do not insert/update registry$log if db is read only
• Addition of JVM mitigation patch checks
• Changes network ACL’s check
• Changes to job_queue_processes check
• Changes to Files need recovery check to exclude OFFLINE NORMAL files

12cR1 (12.1.0.1)

11.2.0.4

11.2.0.3

11.2.0.2

11.1.0.7

10.2.0.5

Build 7

April 2014

For Windows - 

For all other platforms - 

Changes since the release of 12.1.0.1

• Improve performance when many tablespaces are present
• Reintroduce memory related recommendations
• Clarify message that OLAP Catalog Component is desupported, not the entirety of OLAP

11.2.0.3

11.2.0.2

11.2.0.1

11.1.0

10.2.0

10.1.0

9.2.0.8

Build 9

May 2014

For preupgrades executed manually on command line 

For preupgrades executed via DBUA 

Changes since the release of 11.2.0.4

• Brought all 11.2.0.2, 11.2.0.3, and 11.2.0.4 preupgrade scripts up to the latest functionality of 11.2.0.4.
• Improve performance when many tablespaces are present
• Make sure the "Miscellaneous Warnings" section is always displayed, even if no such conditions exist
• Fix determination of non-default events

11.2.0.2

11.2.0.1

11.1.0

10.2.0

10.1.0

9.2.0.8

Build 9

Changes since the release of 11.2.0.3

• Brought all 11.2.0.2, 11.2.0.3, and 11.2.0.4 preupgrade scripts up to the latest functionality of 11.2.0.4.
• Improve performance when many tablespaces are present
• Make sure the "Miscellaneous Warnings" section is always displayed, even if no such conditions exist
• Fix determination of non-default events
• Tablespace sizing estimates have been updated
• Several other problems reported since 11.2.0.3 has shipped

11.2.0.1

11.1.0

10.2.0

10.1.0

9.2.0.8

Build 9

Changes since the release of 11.2.0.2

• Brought all 11.2.0.2, 11.2.0.3, and 11.2.0.4 preupgrade scripts up to the latest functionality of 11.2.0.4.
• Improve performance when many tablespaces are present
• Make sure the "Miscellaneous Warnings" section is always displayed, even if no such conditions exist
• Fix determination of non-default events
• Tablespace sizing estimates have been updated
• Several other problems reported since 11.2.0.3 has shipped
• Timezone version updates
• Obsolete cell_partition_large_extents
• OLS & DV msgs to reflect 112 installer
• Fix connect by statement
• Add DMSYS recommendation coming from 11.1 to 11.2
• Size tablespace with apex correctly
• Fix invalid object list
• Fix XML output for STATUS/VERSION of components
• Fix for xml output
• Change drop table to truncate if possible
• Check for editioning views
• Linesize decreased to 100
• Check for Stale Statistics removed
• Recommendation section added (Hidden parameter/events moved to this section)
• Warning issued about hidden parameters that are in use
• Warning issued about non-default events
• Warning issued about ldap dependencies
• Warning issued if database in MOUNT state
• Warning added relating to UltraSearch
• Warning issued if run by non SYS-DBA
• Warning for Recycle bin added (changed from recommend to MUST be purged)
• Recommendations added on shared pool size for both 32/64 bit target systems
• Stats check updated
• Allow limited set of checks if database in read-only mode
• Removed Network ACL check
• Removed cursor_space_for_time warning
• Removed text relating to auto-extent. Wording was too confusing
• Removed ASM check (non-functioning)

11.1.0

10.2.0

10.1.0

9.2.0.8

9.2.0.7

9.2.0.6

9.2.0.5

9.2.0.4

Build 2

December 2010

Changes since the release of 11.1.0.7

• Timezone version updates
• Optimize select statements for dba_queues

10.2.0

10.1.0

9.2.0.8

9.2.0.7

9.2.0.6

9.2.0.5

9.2.0.4

Build 2

December 2010

Changes since the release of 10.2.0.5

• cursor_space_for_time is deprecated
• Tablespace size updates
• Invalid Object update