Database Software

Where can I find support or e mail the authors of the Oracle X Files demo on the Oracle from the Oracle XML DB homepage:

http://www.oracle.com/technetwork/database/features/xmldb/index.html

I am trying to install this demo (Using 11G release 2 on Win 2008 Server) following instructions from:

http://www.oracle.com/technetwork/testcontent/oracle-xmldb-xfiles-11gr1-129419.pdf?ssSourceSiteId=otnjp

I configured the file and ran the install.bat. The bat file seems to have incorrectly referenced SQL files and the installation was full of errors.
Here is an excerpt from the installation log which shows some of the errors.

I tried to fix the errors manually but there seems to be too many. Any idea where I can obtain a correct script. Or any idea why my installlation does not seem to be working. Thank you very much !


SQL> --
SQL> connect sys/&1 as sysdba
Connected.
SQL> --
SQL> grant AQ_ADMINISTRATOR_ROLE to XFILES
2 /

Grant succeeded.
.
.
.

SQL> -- Create the XFILES_LOG_TABLE
SQL> --
SQL> declare
2 table_exists exception;
3 PRAGMA EXCEPTION_INIT( table_exists , -955 );
4 begin
5 --
6 begin
7 execute immediate 'create table XFILES_LOG_TABLE of XMLType xmltype store as binary xml';
8 exception
9 when table_exists then
10 null;
11 end;
12 end;
13 /

PL/SQL procedure successfully completed.

SQL> /*
SQL> **
SQL> * Cannot use Trigger due to Manifest causing Mutating Table error in create Resource...*SQL> **
.
.
.

SQL> --
SQL> -- Create the Base XML Index - Generates the PATH Table
SQL> --
SQL> create index LOG_RECORD_INDEX on XFILES_LOG_TABLE(OBJECT_VALUE)
2 indextype is XDB.xmlIndex
3 parameters ('PATH TABLE LOG_RECORD_PATH_TABLE')
4 /
indextype is XDB.xmlIndex
*
ERROR at line 2:
ORA-29833: indextype does not exist

SQL> --
SQL> -- Create the Value Index on the PATH Table. The Value index is used to optimize Predicates that contain values
SQL> --
SQL> create INDEX LOG_RECORD_VALUE_INDEX
2 on LOG_RECORD_PATH_TABLE
3 (value)
4 /
on LOG_RECORD_PATH_TABLE
*
ERROR at line 2:
ORA-00942: table or view does not exist

*SQL> --*
SQL> -- Create the Parent Value Index on the PATH Table
*SQL> --*
SQL> CREATE INDEX LOG_RECORD_PARENT_INDEX
*2 ON LOG_RECORD_PATH_TABLE (RID, SYS_ORDERKEY_PARENT(ORDER_KEY))*
*3 /*
ON LOG_RECORD_PATH_TABLE (RID, SYS_ORDERKEY_PARENT(ORDER_KEY))
***
ERROR at line 2:
ORA-00942: table or view does not exist

*SQL> --*
SQL> -- Create Depth Index on the PATH Table
*SQL> --*
SQL> CREATE INDEX LOG_RECORD_DEPTH_INDEX
*2 ON LOG_RECORD_PATH_TABLE (RID, SYS_ORDERKEY_DEPTH(ORDER_KEY),ORDER_KEY)*
*3 /*
ON LOG_RECORD_PATH_TABLE (RID, SYS_ORDERKEY_DEPTH(ORDER_KEY),ORDER_KEY)
***
ERROR at line 2:
ORA-00942: table or view does not exist

SQL> --
SQL> -- *****************************************************************************
SQL> -- * Create AQ to manage process of inserting data into XFILES_LOG_TABLE *
SQL> -- *****************************************************************************

.
.
.
SQL> show errors
No errors.
*SQL> --*
*110 procedure DEQUEUE_LOG_RECORD( context raw,*
*111 reginfo sys.aq$_reg_info,*
*112 descr sys.aq$_descriptor,*
*113 payload raw,*
*114 payloadl number )*
*115 as*
*116 deq_ct dbms_aq.dequeue_options_t;*
*117 msg_prop dbms_aq.message_properties_t;*
*118 enq_msgid raw(16);*
*119 LOG_RECORD XMLType;*
*120 begin*
*121 DBMS_AQ.DEQUEUE('XFILES.LOG_RECORD_Q', deq_ct, msg_prop, LOG_RECORD, enq_msgid);*
*122 -- insert into XFILES.XFILES_LOG_TABLE values(LOG_RECORD);*
*123 folder_log_record(LOG_RECORD);*
*124 commit;*
*125 end;*
*126 --*
*127 end;*
*128 /*

Warning: Package Body created with compilation errors.
SQL> show errors
Errors for PACKAGE BODY XFILES_LOGGING:

LINE/COL ERROR
-------- -----------------------------------------------------------------
50/3 PL/SQL: SQL Statement ignored
50/15 PL/SQL: ORA-00942: table or view does not exist
57/3 PL/SQL: Statement ignored
57/9 PLS-00201: identifier 'DBMS_XDB.EXISTSRESOURCE' must be declared
67/3 PL/SQL: Statement ignored
67/13 PLS-00201: identifier 'DBMS_XDB.CREATERESOURCE' must be declared
83/6 PL/SQL: Statement ignored
83/16 PLS-00201: identifier 'DBMS_XDB.CREATERESOURCE' must be declared
SQL> --
SQL> grant execute on XFILES_LOGGING to public
2 /

Grant succeeded.

.
.
.

SQL> quit