--> Data Mining [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle OLAP API [upgrade] INVALID
.
**********************************************************************
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：--> Database contains INVALID objects prior to upgrade.
.... The list of invalid SYS/SYSTEM objects was written to
.... registry$sys_inv_objs.
.... The list of non-SYS/SYSTEM objects was written to
.... registry$nonsys_inv_objs.
.... Use utluiobj.sql after the upgrade to identify any new invalid
.... objects due to the upgrade.
.... USER PUBLIC has 1 INVALID objects.
.... USER DRS has 12 INVALID objects.
.... USER DMSB01 has 29 INVALID objects.
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 contains 298 object(s).
.... 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.
.
**********************************************************************
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：
SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
SP2-0042：unknown command "$" - rest of line ignored.
SQL> spool off
[DMSBHMC] oracle@dmsdbp02：/ora_engine $
4. 应客户要求，停库，进行物理全冷备
-- cp 所有数据文件，controlfile, redo log(tmp除外）
-- tar 包备份10g $ORACLE_HOME
5. 扩展相关的表空间
我这里扩容sysaux和system即可。
6. Remove OLAP组件
EXECUTE：
@ /olap/admin/catnoamd.SQL;
@ /olap/admin/olapidrp.plb;
@ /olap/admin/catnoaps.SQL;
@ /olap/admin/catnoxoq.SQL;
@ /olap/admin/cwm2drop.SQL;
然后进行CHECK：
SQL> Col comp_name FOR a35
SQL> Col STATUS FOR a15
SQL> SET LINES 150
SQL> SELECT comp_name,version,STATUS FROM dba_registry;
COMP_NAME VERSION STATUS
----------------------