Patch 10.2.0.4 installation on 10.2.0.3 has made Oracle InterMedia invalid.
After upgrade, SQL query
select comp_id, comp_name, status from dba_registry where comp_id='ORDIM' returns:
COMP_ID COMP_NAME STATUS
---------------------------------------------------------
ORDIM Oracle interMedia INVALID
SQL query
SELECT dbms_registry_sys.time_stamp('ORDIM') AS timestamp FROM DUAL;
returns:
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP ORDIM 2008-11-13 20:46:33
DBUA_TIMESTAMP ORDIM INVALID 2008-11-13 20:46:33
In database I have only the following invalid objects:
select owner, object_name, object_type, status from all_objects where status='INVALID';
OWNER OBJECT_NAME OBJECT_TYPE STATUS
----------------------------------------------------------------
DSGATEWAY OSS_SCH PACKAGE BODY INVALID
ORDSYS ORDIMGB TYPE BODY INVALID