This discussion is archived
1 Reply Latest reply: Dec 17, 2013 8:28 AM by Jason_(A_Non) RSS

Getting ora-7445 while initiating XMLDB in 11.2.0.3

johnma1 Newbie
Currently Being Moderated

Hi, all

 

The db is installed on windows 2008R2. While running catqm in 11.2.0.3, I am getting the following error:

ORA-07445: exception encountered: core dump [kkqvmdrv2()+1410] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x144CA460C] [UNABLE_TO_READ] []

The erroring SQL is:

create or replace view XDS_ACL

  (ACLID, SHARED, DESCRIPTION, SECURITY_CLASS_NS,

       SECURITY_CLASS_NAME, PARENT_ACL_PATH, INHERITANCE_TYPE)

    as

    select a.object_id,

           substr(extractvalue(a.object_value, '/acl/@shared', 'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"'), 1, 5),

           extractvalue(a.object_value, '/acl/@description', 'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"'),

          xmlquery('declare namespace a="http://xmlns.oracle.com/xdb/acl.xsd"; fn:namespace-uri-from-QName(fn:data(/a:acl/a:security-class))' PASSING OBJECT_VALUE returning content),

          xmlquery('declare namespace a="http://xmlns.oracle.com/xdb/acl.xsd"; fn:local-name-from-QName(fn:data(/a:acl/a:security-class))' PASSING OBJECT_VALUE returning content),

          CASE existsNode(a.object_value, '/acl/extends-from',

                          'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"')

          WHEN 1

          THEN extractvalue(a.object_value, '/acl/extends-from/@href',

                            'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"')

          ELSE (CASE existsNode(a.object_value, '/acl/constrained-with',

                                'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"')

                WHEN 1

                THEN extractvalue(a.object_value, '/acl/constrained-with/@href',

                                  'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"')

                ELSE NULL END) END,

          CASE existsNode(a.object_value, '/acl/extends-from',

                          'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"') WHEN 1

          THEN 'extends-from'

          ELSE (CASE existsNode(a.object_value, '/acl/constrained-with',

                                'xmlns="http://xmlns.oracle.com/xdb/acl.xsd"')

                WHEN 1

                THEN 'constrained-with'

                ELSE NULL END) END

   FROM XDB.XDB$ACL a

 

When I run this create view SQL on sqlplus, I can reproduce this error. Has anyone seen this before?

Thanks,

Jonathan.

 


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points