7.2 从上面我们可以看到有些组件的状态是不对的，这是老版本的组件，不能直接通过升级上SQL进行删除
SQL> @$ORACLE_HOME/rdbms/admin/emremove.sql SQL> @$ORACLE_HOME/olap/admin/catnoamd.sql SQL> EXECUTE dbms_stats.gather_dictionary_stats;
7.3 再次查看就没有问题了:
SQL> select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS ----------------------------------- --------------- ------- Oracle Application Express 4.2.0.00.27 VALID OWB 11.2.0.3.0 VALID Spatial 12.1.0.1.0 VALID Oracle Multimedia 12.1.0.1.0 VALID Oracle XML Database 12.1.0.1.0 VALID Oracle Text 12.1.0.1.0 VALID Oracle Workspace Manager 12.1.0.1.0 VALID Oracle Database Catalog Views 12.1.0.1.0 VALID Oracle Database Packages and Types 12.1.0.1.0 VALID JServer JAVA Virtual Machine 12.1.0.1.0 VALID Oracle XDK 12.1.0.1.0 VALID Oracle Database Java Packages 12.1.0.1.0 VALID OLAP Analytic Workspace 12.1.0.1.0 VALID Oracle OLAP API 12.1.0.1.0 VALID 14 rows selected.
7.4 /etc/oratab信息对比
---升级前 [root@db01 ~]# grep DBSoft /etc/oratab woo:/DBSoft/Product/11.2.0/db_1:N ---升级后 [root@db01 ~]# grep DBSoft /etc/oratab woo:/DBSoft/Product/12.1.0/db_1:N
注意：这部分不需要我们手工去修改/etc/oratab记录，执行升级会自动完成修改。
7.5 升级后执行postupgrade_fixups.sql检查
SQL> @/DBSoft/cfgtoollogs/woo/preupgrade/postupgrade_fixups.sql
Post Upgrade Fixup Script Generated on 2014-11-20 05:18:29 Version: 12.1.0.1 Build: 007
Beginning Post-Upgrade Fixups...
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
**********************************************************************
Check Tag: OLD_TIME_ZONES_EXIST
Check Summary: Check for use of older timezone data file
Fix Summary: Update the timezone using the DBMS_DST package after upgrade is complete.
**********************************************************************
Fixup Returned Information:
INFORMATION: --> Older Timezone in use
Database is using a time zone file older than version 18.
After the upgrade, it is recommended that DBMS_DST package
be used to upgrade the 12.1.0.1.0 database time zone version
to the latest version which comes with the new release.
Please refer to My Oracle Support note number 977512.1 for details.
**********************************************************************
PL/SQL procedure successfully completed.
**********************************************************************
[Post-Upgrade Recommendations]
************