Upgrade Of Xdb From 10.2.0.3 To 11.2.0.2 Fails With Ora-7445 [Qmxgetdatabytype()+40] (Doc ID 1312157.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2012***

Symptoms


Upgrading the database from 10.2.0.3 to 11.2.0.2 fails with the following
error:

ORA-07445: exception encountered: core dump [qmxGetDataByType()+40] [SIGSEGV]
[ADDR:0x50] [PC:0x2B79792] [Address not mapped to object] []


The trace file shows:

----- Current SQL Statement for this session (sql_id=7rzsm9wrzan5p) -----
declare
isCreatedBln boolean := false;
roleset_ResConfig VARCHAR2(2048) :=
'<ResConfig
xmlns="http://xmlns.oracle.com/xdb/XDBResConfig.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.oracle.com/xdb/XDBResConfig.xsd
http://xmlns.oracle.com/xdb/XDBResConfig.xsd">
<event-listeners>
<listener>
<description>Register event handlers for role sets.</description>
<schema>SYS</schema>
<source>DBMS_XS_ROLESET_EVENTS_INT</source>
<language>PL/SQL</language>
<events>
<Pre-Create/>
<Post-Create/>
<Pre-Update/>
<Pre-Delete/>
</events>
<pre-condition>
<existsNode>

<XPath>/r:Resource[r:SchemaElement="http://xmlns.oracle.com/xs/roleset.xsd#roleSet"]</XPath>
<namespace>xmlns:p="http://xmlns.oracle.com/xs"
xmlns:r="http://xmlns.oracle.com/xdb/XDBResource.xsd"
</namespace>
</existsNode>
</pre-condition>
</listener>
</event-listeners>
</ResConfig>';
begin
if (NOT DBMS_XDB.existsResource('/sys/xs/rolesetrc.xml')) then
isCreatedBln := DBMS_XDB.CreateResource('/sys/xs/rolesetrc.xml',
roleset_ResConfig);
DBMS_ResConfig.AddRepositoryResConfig('/sys/xs/rolesetrc.xml');
else
update resource_view r
set r.res =
updateXML(r.res,
'/r:Resource/r:Contents/rc:ResConfig',
XMLType(roleset_ResConfig),
'xmlns:r="http://xmlns.oracle.com/xdb/XDBResource.xsd"
xmlns:rc=http://xmlns.oracle.com/xdb/XDBResConfig.xsd"')
where equals_path(r.res, '/sys/xs/rolesetrc.xml') = 1;
end if;
end;



Note: <Patch 10368698> and <Patch 10419629> are already applied.

From the upgrade log:

SQL> create or replace view XDB.DOCUMENT_LINKS
2 (source_id,
3 target_id,
4 target_path,
5 link_type,
6 link_form,
7 source_type) as
8 SELECT
9 dl.source_id,
10 dl.target_id,
11 dl.target_path,
12 decode(bitand(sys_op_rawtonum(dl.flags),1),1, 'Weak',
13 decode(bitand(sys_op_rawtonum(dl.flags),2),2,'Symbolic','Hard')),
14 decode(bitand(sys_op_rawtonum(dl.flags),4),4, 'XInclude', 'XLink'),
15 decode(bitand(sys_op_rawtonum(dl.flags),8),8, 'Resource Metadata',
16 'Resource Content')
17 from xdb.xdb$d_link dl, xdb.xdb$resource r
18 where dl.source_id = r.object_id
19 and sys_checkacl(r.xmldata.acloid, r.xmldata.ownerid,
20 xmltype('<privilege
21 xmlns="http://xmlns.oracle.com/xdb/acl.xsd"
22 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
23 xsi:schemaLocation="http://xmlns.oracle.com/xdb/acl.xsd
24 http://xmlns.oracle.com/xdb/acl.xsd
25 DAV: http://xmlns.oracle.com/xdb/dav.xsd">
26 <read-properties/>
27 <read-contents/>
28 </privilege>')) = 1;
xmltype('<privilege
*
ERROR at line 20:
ORA-31093: null or invalid value specified for parameter : privilege


SQL> grant select on xdb.document_links to public ;
grant select on xdb.document_links to public
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> alter procedure xdb.XDB_DATASTORE_PROC compile;
alter procedure xdb.XDB_DATASTORE_PROC compile
*
ERROR at line 1:
ORA-04043: object XDB_DATASTORE_PROC does not exist


SQL> declare
2 isCreatedBln boolean := false;
3 roleset_ResConfig VARCHAR2(2048) :=
4 '<ResConfig
5 xmlns="http://xmlns.oracle.com/xdb/XDBResConfig.xsd"
6 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
7 xsi:schemaLocation="http://xmlns.oracle.com/xdb/XDBResConfig.xsd
8 http://xmlns.oracle.com/xdb/XDBResConfig.xsd">



48 where equals_path(r.res, '/sys/xs/rolesetrc.xml') = 1;
49 end if;
50 end;
51 /
declare
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE


SP2-1519: Unable to write to the error log table sys.registry$error
Process ID: 29486
Session ID: 477 Serial number: 5


SQL> commit;
ERROR:
ORA-03114: not connected to ORACLE

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