XDB is invalid after reinstalling the XDB as per DOC [ID 1297620.1]

Last updated on FEBRUARY 08, 2017

Applies to:

Symptoms

Followed DOC [ID 1297620.1], Although XDB is still invalid.

OBJECT_TYPE OBJECT_NAME OWNER
------------------- ----------------------------------- ------------------------------
PACKAGE BODY DBMS_NETWORK_ACL_ADMIN SYS
PACKAGE BODY DBMS_XS_PRINCIPAL_EVENTS_INT SYS
PACKAGE BODY XS$CATVIEW_UTIL SYS


select comp_name, version, status from dba_registry where comp_id = 'XDB';

COMP_NAME VERSION STATUS
------------------------------ ------------------------------ -----------
Oracle XML Database 11.2.0.3.0 INVALID

XDB installation logfile may have the errors similar to following -

XDB installation is failing due to below errors -

SQL> declare
 2    ACLXSD BFILE := dbms_metadata_hack.get_bfile('acl.xsd.11.2');
 3    ACLURL VARCHAR2(2000) := 'http://xmlns.oracle.com/xdb/acl.xsd';
 4  begin
 5  xdb.dbms_xmlschema.registerSchema(ACLURL, ACLXSD, FALSE, FALSE, FALSE, TRUE,
 6                                    FALSE, 'XDB',
 7                                   options => DBMS_XMLSCHEMA.REGISTER_BINARYXML);
 8  
 9  end;
10  /
declare
*
ERROR at line 1:
ORA-31084: error while creating table "XDB"."XDB$ACL" for element "acl"
ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "XDB"
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136
ORA-06512: at line 5

Cause