Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)


如何下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)

文档内容  


目标

脚本来源

解决方案

脚本指导

下载并安装说明

请参阅下表以确定您需要的pre-upgrade脚本的版本。  这将取决于您要从哪个版本升级到哪个版本。

脚本执行步骤

参考


适用于:

Oracle Database - Standard Edition - 版本 9.2.0.4 和更高版本  
Oracle Database - Enterprise Edition - 版本 9.2.0.4 和更高版本  
本文档所含信息适用于所有平台  

目标

在升级前第一步需要做的是判定在升级过程中数据库可能遇到的问题。

Oracle数据库预升级实用程序可以在您数据库正常运行时执行(不需要关闭),并生成一个需要在实际升级前评估的项目列表。在升级前进行评估和调整将有助于减少数据库停机时间和升级过程中面临的问题。

脚本来源

下面可下载的预升级脚本都是从Oracle数据库发行版中获得的。这些脚本也可以在您计划升级到的目标版本新安装的$ORACLE_HOME/rdbms/admin路径下找到。想要得到这个脚本通常意味着您需要下载整个Oracle数据库安装包,解压缩,把它从admin路径放到别的路径下。所以我们通过直接提供下载的方法使您的Oracle数据库升级规划更容易。

解决方案

脚本指导

 

运行预升级脚本无需停止或重启数据库。  它收集数据库配置信息,报告数据库状况,参数,设置等需要在升级前注意的信息。 

您必须具有DBA的权限来成功执行脚本。

如果预升级版本是12.1,数据库不能在只读模式下。 一些registry$表如果不存在,可能会被创建,升级表中可能会被插入相关记录。 对于预升级版本是12.2或者更高版本,只要预升级目录和软件包在把数据库设置成只读模式前已被加载,数据库就可以是只读模式。

您必须记住,相比您oracle home中原来的版本,这是一个新版本,因此您需要备份旧的版本并根据该MOS文档替换这些文件。

下载并安装说明

请参阅下表以确定您需要的pre-upgrade脚本的版本。  这将取决于您要从哪个版本升级到哪个版本。

如果upgrade-to的版本是12.1.*,保存该压缩文件到某个路径,保证在连接upgrade-from的数据库时它仍能被访问,并解压该文件。

如果upgrade-to的版本是12.2或者更高版本, 则   保存该文件到您目标库$ORACLE_HOME/rdbms/admin   目录并解压该文件。

如果upgrade-to的版本是11.2.0.4或者之前的版本,复制下载的所有文件到某个路径,保证在连接upgrade-from的数据库时它仍能被访问。

 

脚本执行步骤

要执行预升级工具本身,请参阅您要upgrade-to版本的Database Upgrade Guide。

11.2 数据库,请参考:   Upgrade guide to 11.2

12.1 数据库,请参考:   Upgrade guide to 12.1

12.2 数据库,请参考:   Upgrade guide to 12.2

18c 数据库,请参考:   Upgrade guide to 18c

 

对于Pre-upgrade(12.1及更高版本)执行的完整清单检查,请参考MOS 文档:   2380601.1


 

upgrade-to目标库版本

原始版本

脚本创建/日期

最新预升级工具及说明

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,应该考虑表空间组

- 将new_time_zones_exist的严重性更改为警告

- 添加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
11gR2 (11.2.0.4)

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" 始终展现,即使没有满足的条件
  • 修复非默认事件决定
11gR2 (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_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发行后的新问题
11gR2 (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_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检查(非功能性)
11gR1 (11.1.0.7)

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语句
10gR2 (10.2.0.5)

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
  • 表空间大小更新
  • 无效对象更新

 

 

 

 

 

 

 

 

 

 

 

 

 












































































































































How to Download and Run Oracle's Database Pre-Upgrade Utility (文档 ID 884522.1)


In this Document  


Goal

Origin of Script

Solution

Script Guidelines

Download and installation Instructions

See the table below to determine which version of the pre-upgrade script you need.  It will depend on which version you are upgrading from, and which version you are upgrading to.

Script Execution Steps

References


APPLIES TO:

Oracle Cloud Infrastructure - Database Service - Version N/A and later  
Oracle Database Cloud Exadata Service - Version N/A and later  
Oracle Database Backup Service - Version N/A and later  
Oracle Database Exadata Express Cloud Service - Version N/A and later  
Oracle Database Cloud Service - Version N/A and later  
Information in this document applies to any platform.  

GOAL


One of the first steps that should be taken prior to an Oracle Database Upgrade is determining  any issues the upgrade may present to your database.  

Oracle Database Pre-Upgrade utility is executed on your existing database, while the database is running (no shutdown required) and provides a list of items which should be reviewed prior to the actual upgrade.  Reviewing and making adjustments prior to actual database upgrade will usually reduce down time and can limit problems during the upgrade.

Origin of Script

The pre-upgrade scripts that are available for download below are shipped with each Oracle Database release.  The scripts can also be found in the newly installed $ORACLE_HOME/rdbms/admin directory of the version you are planning to upgrade to.  Getting a hold of the pre-upgrade script used to mean downloading the entire Oracle Database Release kit, unpacking it, and pulling it out of the admin directory.   Allowing access to the script through this method will make the Oracle Database Upgrade planning easier.

SOLUTION

Script Guidelines

 

The pre-upgrade scripts can be executed on a database without the need to shutdown or restart the database.  It gathers information about the database configuration and reports on conditions, parameters and settings which may need attention prior to upgrading to the new version. 

You must have DBA privilege to execute the script successfully.

If the preupgrade version is 12.1, then the Database can not be in read-only mode.  A few registry$ tables may be created, if they do not already exist, and some rows may be inserted into existing Upgrade tables. For preupgrade version 12.2 and upper the Database can be in read-only mode as long as the preupgrade directory and the package has been loaded before to set the database in that mode.

You must remember that this  is a newer version than the one you have in your oracle home, so you need to backup the older version and replace the files from this MOS note.

Download and installation Instructions

See the table below to determine which version of the pre-upgrade script you need.  It will depend on which version you are upgrading from, and which version you are upgrading to.

If the upgrade-to version is 12.1.*, then save the zipfile to a directory that will be accessible when you connect to your upgrade-from database and then unzip the file.

If the upgrade-to version is 12.2 or higher, then   save the file to your target $ORACLE_HOME/rdbms/admin   directory and then unzip the file.

If the upgrade-to version is 11.2.0.4 or earlier, then copy all of the download files to some directory that will be accessible when you connect to your upgrade-from database.

   Note that in versions 12.1 and higher you can determine the c_build  (current build) version of the preupgrade by using [grep|findstr]  c_build to preupgrade_package.sql.

Script Execution Steps

To execute the preupgrade tool itself, see the Database Upgrade Guide for your upgrade-to version:

For 11.2. databases see:   Upgrade guide to 11.2

For 12.1 databases see:   Upgrade guide to 12.1

For 12.2 databases see:   Upgrade guide to 12.2

For 18c database see:   Upgrade guide to 18c

 

For a complete list of checks executed by Pre-upgrade tool (versions 12.1 and higher), please see MOS note   2380601.1   
 


Target Upgrade-To Version

Upgrading From Version

Script Build/Date

Latest Preupgrade Tool and Description

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

Build 18

March 2018

 For Windows -   preupgrade_12.1.0.2.0_18_crlf.zip

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
11gR2 (11.2.0.4)

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
11gR2 (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

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
11gR2 (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

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)
11gR1 (11.1.0.7)

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
10gR2 (10.2.0.5)

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































































































































































































Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)  

  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 12.1.0.1 Windows  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (75.54 KB)

  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 12.1.0.1 Unixes  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (74.99 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 12.1.0.2 Windows  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (103.78 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 12.1.0.2 Unixes  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (103.75 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 12.2.0.1 Windows  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (251.62 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 12.2.0.1 Unixes  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (250.86 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 18.1 Windows  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (288.82 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 18.1 Unixes  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (288.15 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 19 Windows  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (297.48 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 19 Unixes  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (296.79 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 10.2.0.5  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (130.84 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Script for 11.1  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (157.09 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 11.2.0.2  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (229.23 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 11.2.0.3  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (229.23 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 11.2.0.4  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (229.23 KB)
  • Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1)Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) Pre Upgrade Tool for 11.2.0.4 DBUA  Pre-Upgrade Utility---下载并运行Oracle数据库预升级实用程序 (文档 ID 1577379.1) (229.23 KB)



上一篇:kali安装出现的问题和中文输入法搜狗安装


下一篇:利用SCCM完成Windows 10 1909 In-Place Upgrade