When upgrading JIRA and connect database with Oracle 11g, during the startup, it will show the following error in log file:
2012-10-24 18:56:12,569 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "ManagedConfigurationItem"
2012-10-24 18:56:12,569 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX managedconfigurationitem_id_type_index ON managedconfigurationitem (ITEM_ID, ITEM_TYPE)
Error was: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
JIRA is able to start up, so far all JIRA features seems working fine. Re-index in JIRA UI can be done successfully.