1 Reply Latest reply: Dec 17, 2013 10:28 AM by Jason_(A_Non) RSS

    Getting ora-7445 while initiating XMLDB in 11.2.0.3

    johnma1

      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.