dbms_xdb.Sethttpport(8080) fails with ORA-00604, ORA-29881 (Doc ID 1271525.1)

Last updated on OCTOBER 26, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Since upgrading to 11.2.0.1, DBMS_XDB.SETHTTPPORT fails with errors:

SQL> execute dbms_xdb.sethttpport(8080);
BEGIN dbms_xdb.sethttpport(8080); END;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-29881: failed to validate indextype
ORA-06512: at "XDB.DBMS_XDB", line 528
ORA-06512: at "XDB.DBMS_XDB", line 667
ORA-06512: at line 1


Gathering an errorstack trace:

connect / as sysdba
alter session set tracefile_identifier='TRACE';
alter session set max_dump_file_size = unlimited;
alter session set events '29881 {occurence:end_after 1} errorstack(3)';
-- Run the sql to reproduce the error
execute dbms_xdb.sethttpport(8080);
exit


Shows that the failing sql is an UPDATE on "XDB"."XDB$RESOURCE":

----- Error Stack Dump -----
ORA-29881: failed to validate indextype
----- Current SQL Statement for this session (sql_id=0p43jwfw8r85c) -----
UPDATE /*+ NO_REF_CASCADE */ "XDB"."XDB$RESOURCE" e
SET e.XMLEXTRA= SYS.XMLTYPEEXTRA("SYS"."XMLTYPEPI"(),"SYS"."XMLTYPEPI"()),e.XMLDATA=:1
WHERE ref(e) = :2 returning sys_row_delta() into :3


Running catproc.sql generated an ORA-600 [kkmpre:kkmpre] while rebuilding the XDB.XDBHI_IDX index:

SQL> alter index xdb.xdbhi_idx rebuild;
alter index xdb.xdbhi_idx rebuild
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkmpre:kkmpre], [], [], [], [], [],[], []

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