When installing Mantis with Oracle, the automated installation fails, with Fatal error: 401.
So I asked Mantis to generate SQL script which I runned manually. This failed again. I had to do 3 modifications on the script for installation runs to the end:

1. Replace “;;” (on lines “CREATE OR REPLACE TRIGGER … END;;” with “;\n/\nshow errors;” (not sure the show errors is needed). So the lines now look like:
   CREATE OR REPLACE TRIGGER … END;
   /
   show errors;

2. Replace the index name “idx_project_hierarchy_parent_id” with “idx_project_hierarchy_parnt_id”. I removed the last “e” because the identifier was initially too long for Oracle (limit: 30 characters).

3. Change the table name for the last “INSERT INTO mantis_config_table”. The table name is hard-coded. For Oracle, we need to change default table names because mantis prefix and table sufix creates identifiers too long.

Hope this will help doing a clean Oracle installation process…