ORDIM DICOM repository has 0 documents.

While doing an database upgrade from 9.2.0.8 to 11.2.0.4 , oracle intermedia component has become invalid.

while troubleshooting the issue , came across a note id :Oracle Multimedia Component Became INVALID After Upgrade (Doc ID 1497562.1) which addresses this issue.
It suggested to execute below .

SQL> set serveroutput on;

SQL> exec VALIDATE_ORDIM();

ORDIM DICOM repository has 0 documents.

The following default DICOM repository documents are not installed:

ordcman.xml

ordcmcmc.xml

ordcmcmd.xml

ordcmct.xml

ordcmmp.xml

ordcmpf.xml

ordcmpv.xml

ordcmsd.xml

ordcmui.xml

PL/SQL procedure successfully completed.

Result of the validate_ordim procedure gave different output as shown in the note id.

So I searched more on this issue and found that this because DICOM xml schemas have not been loaded.

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

declare
*
ERROR at line 1:
ORA-31050: Access denied
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN_PRV", line 6306
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 125
ORA-06512: at line 67


ORA-31050 "Access denied" during Upgrade of Oracle Multimedia (ORDIM) to 11.2.0.2.0 (Doc ID 1274613.1)

Oracle note suggested the , though XDB compenent is valid, there is an issue during upgrade , look for below in the upgrade log

  11 END;
  12 /
DECLARE
*
ERROR at line 1:
ORA-31061: XDB error : XML event error
ORA-19202: Error occurred in XML processing (
LSX-00023: unknown namespace URI "0/�Â"
)
ORA-06512: at "XDB.DBMS_XDB", line 201
ORA-06512: at line 9

Although dba_registry shows that XDB is VALID, this component was not completely upgraded due to the incorrect setting of the environment variable, LD_LIBRARY_PATH (LIBPATH on AIX, SHLIB_PATH on HP-UX PA-RISC). Solution given was to do the upgrade again.

1. Confirm XML DB is not already installed.
   • SELECT username FROM DBA_USERS where username = 'XDB'; returns 0 rows.
   • DESCRIBE RESOURCE_VIEW fails.
2. As SYS, perform the XML DB installation - Note: this will not be a complete build due to Oracle Bug 9818995:
   • @?/rdbms/admin/catqm.sql xdb <xml db tablespace> <xdb temp tablespace> <use secure files yes|no>
3. As SYS, grant the relevent permissions to the XDB user:
   • GRANT EXECUTE ON utl_file TO xdb;
   • GRANT EXECUTE ON dbms_lob TO xdb;
4. As SYS, ensure their are no invalid objects:
   • @?/rdbms/admin/utlrp.sql
5. Assuming an spfile is in use, as SYS configure the XDB dispatcher:
   • ALTER SYSTEM SET DISPATCHERS="(PROTOCOL=TCP)(SERVICE=<SID>DB)" SCOPE=both;
   • If init.ora is in use, edit the init.ora file instead.
6. As SYS, install the missing contents caused by Oracle Bug 9818995:
   • SHUTDOWN IMMEDIATE;
   • STARTUP UPGRADE
   • @?/rdbms/admin/xsdbmig.sql
   • SHUTDOWN IMMEDIATE;
   • STARTUP
7. As SYS, ensure their are no invalid objects:
   • @?/rdbms/admin/utlrp.sql

After reinstall of XDB , finally ran the below again 


set echo on
spool ord.log
alter session set current_schema="ORDSYS";
@?/ord/im/admin/imxreg.sql;
@?/ord/im/admin/impbs.sql;
@?/ord/im/admin/impvs.sql;
@?/ord/im/admin/imtyb.sql;
@?/ord/im/admin/implb.sql;
@?/ord/im/admin/imxrepos.sql;
spool off


Finally that resolved the issue and Oracle multimedia became VALID