11r2升級準備utlu112i.sql的使用以及dbtimezone

把11g rdbms/admin下的utlu112i.sql  拿到要升級的庫上
SQL> spool upgrade.txt
SQL> @?/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool    12-14-2013 07:03:10
.
**********************************************************************
Database:
**********************************************************************
--&gt name:          YWS
--&gt version:       10.2.0.1.0
--&gt compatible:    10.2.0.1.0
--&gt blocksize:     8192
--&gt platform:      Linux IA (32-bit)
--&gt timezone file: V2
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--&gt SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 728 MB
.... AUTOEXTEND additional space required: 248 MB
--&gt UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 450 MB
.... AUTOEXTEND additional space required: 420 MB
--&gt SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 446 MB
.... AUTOEXTEND additional space required: 206 MB
--&gt TEMP tablespace is adequate for the upgrade.
.... minimum required size: 61 MB
.... AUTOEXTEND additional space required: 41 MB
--&gt EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 69 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
WARNING: --&gt "sga_target" needs to be increased to at least 336 MB
WARNING: --&gt "java_pool_size" needs to be increased to at least 64 MB
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
--&gt background_dump_dest         11.1       DEPRECATED   replaced by
"diagnostic_dest"
--&gt user_dump_dest               11.1       DEPRECATED   replaced by
"diagnostic_dest"
--&gt core_dump_dest               11.1       DEPRECATED   replaced by
"diagnostic_dest"
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--&gt Oracle Catalog Views         [upgrade]  VALID
--&gt Oracle Packages and Types    [upgrade]  VALID
--&gt JServer JAVA Virtual Machine [upgrade]  VALID
--&gt Oracle XDK for Java          [upgrade]  VALID
--&gt Oracle Workspace Manager     [upgrade]  VALID
--&gt OLAP Analytic Workspace      [upgrade]  VALID
--&gt OLAP Catalog                 [upgrade]  VALID
--&gt EM Repository                [upgrade]  VALID
--&gt Oracle Text                  [upgrade]  VALID
--&gt Oracle XML Database          [upgrade]  VALID
--&gt Oracle Java Packages         [upgrade]  VALID
--&gt Oracle interMedia            [upgrade]  VALID
--&gt Spatial                      [upgrade]  VALID
--&gt Data Mining                  [upgrade]  VALID
--&gt Expression Filter            [upgrade]  VALID
--&gt Rule Manager                 [upgrade]  VALID
--&gt Oracle OLAP API              [upgrade]  VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --&gt Database is using a timezone file older than version 11.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 10.2.0.1.0 database timezone version
.... to the latest version which comes with the new release.
WARNING: --&gt Database contains schemas with stale optimizer statistics.
.... Refer to the Upgrade Guide for instructions to update
.... schema statistics prior to upgrading the database.
.... Component Schemas with stale statistics:
....   SYS
....   WMSYS
....   OLAPSYS
....   SYSMAN
....   CTXSYS
....   XDB
WARNING: --&gt Database contains schemas with objects dependent on network
packages.
.... Refer to the Upgrade Guide for instructions to configure Network ACLs.
.... USER SYSMAN has dependent objects.
WARNING: --&gt EM Database Control Repository exists in the database.
.... Direct downgrade of EM Database Control is not supported. Refer to the
.... Upgrade Guide for instructions to save the EM data prior to upgrade.
WARNING:--&gt recycle bin in use.
.... Your recycle bin turned on.
.... It is REQUIRED
.... that the recycle bin is empty prior to upgrading
.... your database.
.... The command:  PURGE DBA_RECYCLEBIN
.... must be executed immediately prior to executing your upgrade.
.


PL/SQL procedure successfully completed.






WARNING: --&gt Database is using a timezone file older than version 11.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 10.2.0.1.0 database timezone version
.... to the latest version which comes with the new release.






當前是是2
select * from v$timezone_file;


FILENAME        VERSION
------------ ----------
timezlrg.dat          2




If time zone file version is lessthan 4 then apply time zone patch  5632264 manually for 10.2.0.1database。
10.2.0.1 不能直接升級到11gR2，透過這段文字，這個不能升級的原因可能就是與Time zone 相關。
10.2.0.5的Time zone 值是4，滿足條件。對於timezone 值小於4的，要打Patch 5632264。