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