While Upgrading From 10.2.0.4.0 To 11.2.0.2.0 Catupgrd.sql=ORA-31061 ORA-19202 LSX-23 (Doc ID 1305561.1)

Last updated on MAY 05, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2.0 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 05-May-2015***

Symptoms


When upgrading from Oracle RDBMS 10.2.0.4.0 to 11.2.0.2.0, catupgrd.sql fails with the following errors:

SQL> @catupgrd.sql

...

SQL> Rem Add the xspublic role
SQL> declare
2 tmp boolean := false;
3 begin
4 if (NOT DBMS_XDB.existsResource('/sys/xs/roles/xspublic.xml'))
5 then
6 tmp := DBMS_XDB.CreateResource('/sys/xs/roles/xspublic.xml',
7 '<role xmlns="http://xmlns.oracle.com/xs"
8 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
9 xsi:schemaLocation="http://xmlns.oracle.com/xs http://xmlns.oracle.com/xs/principal.xsd"
10 xmlns:xlink="http://www.w3.org/1999/xlink"
11 enable="true">
12 <UID>2147483649</UID>
13 <GUID>4B0F192BF5214F9BBF058025E8E23B89</GUID>
14 <name>xspublic</name>
15 </role>');
16 end if;
17 end;
18 /
declare
*
ERROR at line 1:
ORA-31061: XDB error: XML event error
ORA-19202: Error occurred in XML processing
LSX-00023: unknown namespace URI "�"
ORA-06512: at "XDB.DBMS_XDB", line 174
ORA-06512: at line 6


SQL>
SQL> Rem Add the xsauthenticated role
SQL> declare
2 tmp boolean := false;
3 begin
4 if (NOT DBMS_XDB.existsResource('/sys/xs/roles/xsauthenticated.xml'))
5 then
6 tmp := DBMS_XDB.CreateResource('/sys/xs/roles/xsauthenticated.xml',
7 '<dynamicRole xmlns="http://xmlns.oracle.com/xs"
8 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
9 xsi:schemaLocation="http://xmlns.oracle.com/xs http://xmlns.oracle.com/xs/principal.xsd"
10 xmlns:xlink="http://www.w3.org/1999/xlink"
11 enable="false">
12 <UID>2147483650</UID>
13 <GUID>82B7C3CCBF794F2EBFAA4E8ED7A9AF30</GUID>
14 <name>xsauthenticated</name>
15 </dynamicRole>');
16 end if;
17 end;
18 /
declare
*
ERROR at line 1:
ORA-31061: XDB error: XML event error
ORA-19202: Error occurred in XML processing
LSX-00023: unknown namespace URI "�"
ORA-06512: at "XDB.DBMS_XDB", line 174
ORA-06512: at line 6


SQL>
SQL> Rem Add the xsguest user
SQL> declare
2 tmp boolean := false;
3 begin
4 if (NOT DBMS_XDB.existsResource('/sys/xs/users/xsguest.xml'))
5 then
6 tmp := DBMS_XDB.CreateResource('/sys/xs/users/xsguest.xml',
7 '<user xmlns="http://xmlns.oracle.com/xs"
8 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
9 xsi:schemaLocation="http://xmlns.oracle.com/xs http://xmlns.oracle.com/xs/principal.xsd"
10 xmlns:xlink="http://www.w3.org/1999/xlink">
11 <UID>2147483651</UID>
12 <GUID>3ACB6B1172E54FF9BF70497B70C7B733</GUID>
13 <roleGrant xlink:type="simple" xlink:href="/sys/xs/roles/xspublic.xml" />
14 <userName>xsguest</userName>
15 </user>');
16 end if;
17 end;
18 /
declare
*
ERROR at line 1:
ORA-31061: XDB error: XML event error
ORA-19202: Error occurred in XML processing
LSX-00023: unknown namespace URI "�"
ORA-06512: at "XDB.DBMS_XDB", line 174
ORA-06512: at line 6


SQL>

...

.
Oracle Database 11.2 Post-Upgrade Status Tool 01-31-2011 00:06:25
.
Component Status Version HH:MM:SS
...
Oracle XML Database
. ORA-31061: XDB error: XML event error
. ORA-19202: Error occurred in XML processing
. LSX-00023: unknown namespace URI "�"
. ORA-06512: at "XDB.DBMS_XDB", line 174
. ORA-06512: at line 6
. ORA-31061: XDB error: XML event error
. ORA-19202: Error occurred in XML processing
. LSX-00023: unknown namespace URI "�"
. ORA-06512: at "XDB.DBMS_XDB", line 174
. ORA-06512: at line 6
. ORA-31061: XDB error: XML event error
. ORA-19202: Error occurred in XML processing
. LSX-00023: unknown namespace URI "�"
. ORA-06512: at "XDB.DBMS_XDB", line 174
. ORA-06512: at line 6
. ORA-31001: Invalid resource handle or path name "/sys/xs/users/xsguest.xml"
. ORA-06512: at "XDB.DBMS_XDB", line 355
. ORA-06512: at line 2
. ORA-31001: Invalid resource handle or path name
. "/sys/xs/roles/xsauthenticated.xml"
. ORA-06512: at "XDB.DBMS_XDB", line 355
. ORA-06512: at line 2
...


The LSX error number and text may differ somewhat.

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