Windows+Oracle10G10.2.0.1Upgrade to 10.2.0.5 (二)

2014-11-24 12:11:02 · 作者: · 浏览: 5
ze: 194 MB
.... AUTOEXTEND additional space required: 4 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 58 MB
.... AUTOEXTEND additional space required: 38 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Rule Manager [upgrade] VALID
.

PL/SQL 过程已成功完成。

SQL> SPOOL OFF

可以看到执行这个脚本的作用只是作为升级前的信息收集准备工作:
表空间信息(不是全部表空间,只有:SYSTEM、UNDOTBS1、SYSAUX和TEMP4个表空间),当前大小(DAB_DATA_FILES.BYTES),升级过程中是否需要进行扩张以满足升级操作;参数信息,是否需要进行和更名,是否有作废的参数;最后的升级 组件的清单。
SQL> spool c:\patch.log
SQL> @ /rdbms/admin/catupgrd.sql
......
一大堆的执行日志
......