400+ Invalid objects prior to apply 10.2.0.5
Greetings !
If you have see 400+ database INVALID objects Including Invalid Database Objects Owned by SYS / SYSTEM -
Owner Object type # of Invalid Objects
SYS PACKAGE 1
SYS PACKAGE BODY 16
SYS SYNONYM 1
SYS VIEW 9
SYSTEM PACKAGE BODY 1
We need to upgrade this database from 10.2.0.1 to 11.2.0.4, right now ... need to apply 10.2.0.5 patchset.
Although :-
SQL> select COMP_ID,VERSION,status from dba_registry order by status;
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
CATALOG 10.2.0.1.0 VALID
EM 10.2.0.1.0 VALID
OWM 10.2.0.1.0 VALID
JAVAVM 10.2.0.1.0 VALID
XML 10.2.0.1.0 VALID
CATJAVA 10.2.0.1.0 VALID
EXF 10.2.0.1.0 VALID
ODM 10.2.0.1.0 VALID
CONTEXT 10.2.0.1.0 VALID
XDB 10.2.0.1.0 VALID
RUL 10.2.0.1.0 VALID
ORDIM 10.2.0.1.0 VALID
APS 10.2.0.1.0 VALID
XOQ 10.2.0.1.0 VALID
AMD 10.2.0.1.0 VALID
SDO 10.2.0.1.0 VALID