Hi all ;
Database upgrade ran more than 3 hrs , still .. why it takes long time ?
Before execute catupgrd.sql , Should we gather statistics for entire database or particular schema ?
**************************************************+********************
Miscellaneous Warnings
**********************************************************************
WARNING: --> 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.5.0 database timezone version
.... to the latest version which comes with the new release.
WARNING: --> 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
.... SYSMAN
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 SYS has 2 INVALID objects.
WARNING: --> Database contains schemas with objects dependent on network
packages.
.... Refer to the Upgrade Guide for instructions to configure Network ACLs.
.... USER ORACLE_OCM has dependent 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:--> 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.
>> Yesterday i started my upgrade process , still it is incomplete ..
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ------------------------------
Oracle Enterprise Manager UPGRADING 10.2.0.5.0
Spatial VALID 10.2.0.5.0
Oracle interMedia VALID 10.2.0.5.0
OLAP Catalog VALID 11.2.0.1.0
Oracle XML Database VALID 10.2.0.5.0
Oracle Text VALID 10.2.0.5.0
Oracle Expression Filter VALID 10.2.0.5.0
Oracle Rule Manager VALID 10.2.0.5.0
Oracle Workspace Manager VALID 10.2.0.5.0
Oracle Data Mining VALID 10.2.0.5.0
Oracle Database Catalog Views VALID 11.2.0.1.0
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ------------------------------
Oracle Database Packages and Types VALID 11.2.0.1.0
JServer JAVA Virtual Machine VALID 11.2.0.1.0
Oracle XDK VALID 11.2.0.1.0
Oracle Database Java Packages VALID 10.2.0.5.0
OLAP Analytic Workspace VALID 11.2.0.1.0
Oracle OLAP API VALID 10.2.0.5.0
some components are 11.2.0.1.0 and some are still 10.2.0.5.0.
again i re executed catupgrd.sql;
it ran more than three hours .... still why it takes long time ?