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 and later
Information in this document applies to any platform.


Since upgrading to, 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);

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) -----
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], [], [], [], [], [],[], []


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