Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Invalid components in dba_registry

user12148579Mar 3 2016 — edited Mar 3 2016

Hi, I have invalid components in dba_registry.

DB version=11.2.0.4.0

SQL> select comp_id,comp_name,status from dba_registry where status='INVALID';

COMP_ID COMP_NAME STATUS

--------------- ------------------------------ --------------------------------------------

ORDIM Oracle Multimedia INVALID

XOQ Oracle OLAP API INVALID

XDB Oracle XML Database INVALID

OID Oracle Internet Directory INVALID

I tried to reload catalog.

shutdown immedite

startup upgrade

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

@?/rdbms/admin/utlrp.sql

shutdown immediate

startup

But they are still INVALID.

I followed the instructions from

How To Reload Oracle Multimedia Related Information when XML Database (=XDB) Has Been Reinstalled (Doc ID 965892.1)

Operations on ORDDATA Tables with Binary XMLType Column Fail with OCI-21500, ORA-00600 [qmcxdGetQNameInfo2] or [qmcxdEvtNextPPP] After XDB Reinstallation (Doc ID 1968673.1)

In the last step in (Doc ID 1968673.1) I get the following errors and components in dba_registry are still invalid

SQL> @?/ord/im/admin/imxrepos.sql

BEGIN ordsys.ord_dicom_admin.editdatamodel; END;

ERROR at line 1:

ORA-04067: not executed, package body "ORDSYS.DBMS_LOCK" does not exist

ORA-06508: PL/SQL: could not find program unit being called: "ORDSYS.DBMS_LOCK"

ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN_PRV", line 6945

ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 276

ORA-06512: at line 1

declare

ERROR at line 1: