interMedia Showing up as INVALID in DBA_REGISTRY After Patching from 10.1.x to Higher 10.1 Patchset Level
Last updated on FEBRUARY 08, 2017
Applies to:Oracle interMedia - Version: 10.1.0.2 to 10.1.0.5
This problem can occur on any platform.
- After patching an existing database from 10.1.x to a higher 10.1 patchset level interMedia is showing up as INVALID in the DBA_REGISTRY view.
- The following query brings back two rows, showing that the procedure VALIDATE_ORDIM once exists in the SYS schema and once in the ORDSYS schema. The procedure in the ORDSYS schema is INVALID:
SQL> Select owner, object_name, object_type, status
Where object_NAME = 'VALIDATE_ORDIM';
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------ -------------- ----------- -------
SYS VALIDATE_ORDIM PROCEDURE VALID
ORDSYS VALIDATE_ORDIM PROCEDURE INVALID
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms