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 3_lf.zip

For Windows:  23_crlf.zip

改進和新的檢查：

• 改進了修復執行報告
• 新增了一些更改來支援新的 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 -  45_lf.zip

For Windows -  45_crlf.zip

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版本中已經更改，詳情請查閱   12.2 Database Upgrade Guide

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 -  preupgrade_12.1.0.2.0_18_crlf.zip

For non-windows platforms -  preupgrade_12.1.0.2.0_18_lf.zip

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 -  preupgrade_12.1.0.1.0_7_crlf.zip

For all other platforms -  preupgrade_12.1.0.1.0_7_lf.zip

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月

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

對於使用DBUA 執行預升級  utlu112x_11204_009.sql

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月

utlu112i_11203_009.sql

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

utlu112i_11202_009.sql

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月

utlu111i.sql

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月

utlu102i_2.sql

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:   preupgrade_192_cbuild_1_lf.zip

For Windows:  preupgrade_12_cbuild_1_crlf.zip

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:  preupgrade_181_cbuild_6_lf.zip

For Windows:  preupgrade_181_cbuild_6_crlf.zip

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 -  preupgrade_12201_cbuild_020_lf.zip

 For Windows -  preupgrade_12201_cbuild_020_crlf..zip

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   12.2 Database Upgrade Guide  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 -  preupgrade_12.1.0.2.0_18_lf.zip

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 -  preupgrade_12.1.0.1.0_7_crlf.zip

For all other platforms -  preupgrade_12.1.0.1.0_7_lf.zip

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  utlu112i_11204_009.sql

For preupgrades executed via DBUA  utlu112x_11204_009.sql

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

utlu112i_11203_009.sql

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

utlu112i_11202_009.sql

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

utlu111i.sql

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

utlu102i_2.sql

Changes since the release of 10.2.0.5

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