COMP_TIMESTAMP UPGRD_END 2012-02-15 10:07:20
.
Oracle Database 10.2 Upgrade Status Utility 02-15-2012 10:07:20
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.5.0 00:12:00
JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:09:48
Oracle XDK VALID 10.2.0.5.0 00:00:32
Oracle Database Java Packages VALID 10.2.0.5.0 00:00:20
Oracle XML Database VALID 10.2.0.5.0 00:01:57
Oracle Workspace Manager VALID 10.2.0.5.0 00:00:48
Oracle interMedia VALID 10.2.0.5.0 00:05:42
Oracle Expression Filter VALID 10.2.0.5.0 00:00:18
Oracle Enterprise Manager VALID 10.2.0.5.0 00:01:40
Oracle Rule Manager VALID 10.2.0.5.0 00:00:09
.
Total Upgrade Time: 00:34:42
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL>
检查下c:\patch.log看看是否有错误发生；上面最后的输出显示了本次升级耗时34分43秒，接下来重启数据库，执行下utlrp.sql编译无效对象，最后查看下升级结果：
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 1258291200 bytes
Variable Size 385879504 bytes
Database Buffers 855638016 bytes
Redo Buffers 14696448 bytes
数据库装载完毕。
数据库已经打开。
SQL> @ /rdbms/admin/utlrp.sql
......
一大堆执行日志
......
SQL> select count(*) from dba_objects where status='VALID';
COUNT(*)
----------
46642
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ ----------------------
Oracle Enterprise Manager
10.2.0.5.0 VALID
Oracle interMedia
10.2.0.5.0 VALID
Oracle XML Database
10.2.0.5.0 VALID
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ ----------------------
Oracle Expression Filter
10.2.0.5.0 VALI