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

Last updated on JULY 04, 2014

Applies to:

Oracle Multimedia - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Feb-2013***

Symptoms

Oracle Multimedia (ORDIM) is INVALID after upgrading the database to 11.2.0.2.  The upgrade log file shows that errors were generated during the upgrade of ORDIM while inserting DICOM repository documents.

SQL> -- insert the ordcman.xml into the dicom repos
SQL> declare
  2 xt sys.XMLtype;
  3 ex exception;
  4 pragma exception_init(ex, -53002);
  5 ordcmXml varchar2(32767);
  6 ordClob clob;
  7 begin
  8 sys.dbms_lob.createTemporary( ordClob, true, sys.dbms_lob.call );
  ...
  ...
279 end;
280 /
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


Higher in the upgrade log, there are errors generated during the upgrade of Oracle XML Database (XDB).

  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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms