--> Oracle Text? ? ? ? ? ? ? ? ? [upgrade]? VALID
--> Oracle XML Database? ? ? ? ? [upgrade]? VALID
--> Oracle Java Packages? ? ? ? [upgrade]? VALID
--> Oracle interMedia? ? ? ? ? ? [upgrade]? VALID
--> Spatial? ? ? ? ? ? ? ? ? ? ? [upgrade]? VALID
--> Data Mining? ? ? ? ? ? ? ? ? [upgrade]? VALID
--> Expression Filter? ? ? ? ? ? [upgrade]? VALID
--> Rule Manager? ? ? ? ? ? ? ? [upgrade]? VALID
--> Oracle OLAP API? ? ? ? ? ? ? [upgrade]? VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 10.2.0.4.0 database timezone version
.... to the latest version which comes with the new release.
WARNING: --> 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: --> Your recycle bin is turned on and currently contains no objects.
.... Because it is REQUIRED that the recycle bin be empty prior to upgrading
.... and your recycle bin is turned on, you may need to execute the command:
? ? ? ? PURGE DBA_RECYCLEBIN
.... prior to executing your upgrade to confirm the recycle bin is empty.
.
**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
? ? EXECUTE dbms_stats.gather_dictionary_stats;
**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.
To view existing non-default events execute the following commands
while connected AS SYSDBA:
? Events:
? ? SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
? ? ? WHERE? UPPER(name) ='EVENT' AND? isdefault='FALSE'
? Trace Events:
? ? ? WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
SQL> spool off;
SQL> create pfile='/home/oracle/pfile.ora' from spfile;
SQL> alter system set sga_target=600M scope=spfile;
SQL>? EXECUTE dbms_stats.gather_dictionary_stats;
===根据以上检查结果，对源库进行调整；
运行 dbupgdiag.sql 脚本来检查源库的一致性
如果 dbupgdiag.sql 脚本有无效对象，则运行 utlrp.sql
$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus "/ as sysdba"
SQL> @utlrp.sql
使无效对象有效之后，再次在数据库中重新运行 dbupgdiag.sql，然后确保一切正常。
SQL> alter tablespace system add datafile '/home/oracle/oradata/orcl/system02.dbf' size 650M;
Tablespace altered.
SQL> alter tablespace UNDOTBS1 add datafile '/home/oracle/oradata/orcl/undotbs02.dbf' size 400m;
Tablespace altered.
SQL> alter tablespace SYSAUX add datafile '/home/oracle/oradata/orcl/sysaux02.dbf' size 500m;
Tablespace altered.
SQL> alter tablespace temp add tempfile '/home/oracle/oradata/orcl/temp02.dbf' size 60m;
Tablespace altered.
SQL> alter tablespace EXAMPLE add datafile '/home/oracle/oradata/orcl/ex.dbf' size 80m;
Tablespace altered.
SQL>
#