实战：Oracle10.2.0.4异机迁移并升级到Oracle11.2.0.4 - 数据库编程

----------------------------------------------------- VERSION STATUS -------------------- ---------------------- OWM Oracle Workspace Manager 11.2.0.4.0 VALID CATALOG Oracle Database Catalog Views COMP_ID ------------------------------ COMP_NAME ------------------------------------------------------------ VERSION STATUS -------------------- ---------------------- 11.2.0.4.0 VALID CATPROC Oracle Database Packages and T 11.2.0.4.0 VALID JAVAVM COMP_ID ------------------------------ COMP_NAME ------------------------------------------------------------ VERSION STATUS -------------------- ---------------------- JServer JAVA Virtual Machine 11.2.0.4.0 VALID XML Oracle XDK 11.2.0.4.0 VALID COMP_ID ------------------------------ COMP_NAME ------------------------------------------------------------ VERSION STATUS -------------------- ---------------------- CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID APS OLAP Analytic Workspace 11.2.0.4.0 VALID COMP_ID ------------------------------ COMP_NAME ------------------------------------------------------------ VERSION STATUS -------------------- ---------------------- XOQ Oracle OLAP API 11.2.0.4.0 VALID 17 rows selected. SQL> select * from v$timezone_file; select * from registry$database; (this shows the old value of the timezone) SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME; FILENAME VERSION -------------------- ---------- timezlrg_14.dat 14 1 row selected. SQL> SQL> 2 SQL> SQL> 2 3 4 PROPERTY_NAME ------------------------------ VALUE ------------------------------------------------------------ DST_PRIMARY_TT_VERSION 14 DST_SECONDARY_TT_VERSION 0 DST_UPGRADE_STATE NONE 3 rows selected. SQL> SQL> select * from registry$database; PLATFORM_ID ----------- PLATFORM_NAME -------------------------------------------------------------------------------- EDITION TZ_VERSION ------------------------------ ---------- 13 Linux x86 64-bit 14 1 row selected. SQL> exit

至此，升级完成。

实战：Oracle10.2.0.4异机迁移并升级到Oracle11.2.0.4(五)