Skip to Main Content

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!

ORA-04045: errors during recompilation/revalidation of SYS.ALL_XSC_SECURITY_CLASS

user-4a9djFeb 13 2023

Trying to upgrade database (11.2.0.1 to 11.2.0.4, yes old)

create or replace public synonym DOCUMENT_LINKS2 for XDB.DOCUMENT_LINKS2;

Synonym created.

create or replace view ALL_XSC_SECURITY_CLASS
2 (OWNER, CLASS_NAME, TARGET_NAMESPACE, TITLE, DESCRIPTION,
3 SECURITY_CLASS, ENABLE, PATH)
4 as
5 select
6 extractValue(r.RES,
7 'Resource/Owner'),
8 substr(extractValue(OBJECT_VALUE,
9 '/securityClass/@name'),
10 1, 1024),
11 substr(extractValue(OBJECT_VALUE,
12 '/securityClass/@targetNamespace'),
13 1, 4000),
14 extractValue(OBJECT_VALUE,
15 '/securityClass/title'),
16 extractValue(OBJECT_VALUE,
17 '/securityClass/description'),
18 extract(OBJECT_VALUE, '/securityClass'),
19 substr(extractValue(OBJECT_VALUE,
20 '/securityClass/@enable'),1,5),
21 ANY_PATH
22 from XDB.XS$SECURITYCLASS p,
23 RESOURCE_VIEW r
24 where
25 sys_op_r2o(extractValue(r.RES, '/Resource/XMLRef')) = p.object_id;
from XDB.XS$SECURITYCLASS p,
*
ERROR at line 22:
ORA-64131: XMLIndex Metadata: failure during the looking up of the dictionary
ORA-30966: error detected in the XML Index layer
ORA-31011: XML parsing failed

comment on table ALL_XSC_SECURITY_CLASS is
2 'All security class definitions in the database'
3 /
comment on table ALL_XSC_SECURITY_CLASS is
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.ALL_XSC_SECURITY_CLASS
ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0],
[1], [2], [213], [], [], [], []

Comments
Post Details
Added on Feb 13 2023
2 comments
1,226 views