Resolution:
XCD requires the existence of the INDX and USERS tablespaces within Oracle. The standard Oracle install creates these tablespaces, but they may not be available if the Oracle installation has been customized. This can be remedied by creating the INDX tablespace within Oracle and then reinstalling/reconfiguring using a different DB Access Username.  

If you want to use the same DB Access Username (to save space within Oracle), you will first need to clean up some of the changes made during the initial database initialization attempt. If you created a new DB Access Username (recommended) during configuration, then you'll just need to drop this username from Oracle (e.g using SQL*Plus or Toad):

drop user canonuser cascade;

where "canonuser" is the name specified in the "DB Access Username" field specified during configuration.  You can then re-start the configuration by starting a command prompt, changing to the XML Canon directory (\Program Files\TIBCOExtensibility\XML Canon), and typing:

jre\bin\java -jar xcinstaller.jar

My database initialization fails due to “java.sql.SQLException: ORA-00959: tablespace 'INDX' does not exist”.What is the problem?

Product: TIBCO XML Canon Version: 1.2 OS: All --------------------