?
源库环境检查：
?
[oracle@ora1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 12 15:54:36 2014
Copyright (c) 1982, 2007, Oracle.? All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> spool upgrade_info.log? ? ? ? ? ? ? ? ?
SQL> @utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 12-12-2014 15:55:42
Script Version: 11.2.0.4.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name:? ? ? ? ? ORCL
--> version:? ? ? 10.2.0.4.0
--> compatible:? ? 10.2.0.3.0
--> blocksize:? ? 8192
--> platform:? ? ? Linux x86 64-bit
--> timezone file: V4
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 981 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 722 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
--> 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]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
--> If Target Oracle is 32-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.
--> If Target Oracle is 64-Bit, refer here for Update Parameters:
WARNING: --> "sga_target" needs to be increased to at least 596 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]
**********************************************************************
--> background_dump_dest? ? ? ? 11.1? ? ? DEPRECATED? replaced by? "diagnostic_dest"
--> user_dump_dest? ? ? ? ? ? ? 11.1? ? ? DEPRECATED? replaced by? "diagnostic_dest"
.
**********************************************************************
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 Workspace Manager? ? [upgrade]? VALID
--> OLAP Analytic Workspace? ? ? [upgrade]? VALID
--> OLAP Catalog? ? ? ? ? ? ? ? [upgrade]? VALID
--> EM Reposit