Can't connect to Oracle database - ORA-00955
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
Migrate database to Oracle will have the following in the atlassian-fisheye-<date>.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
2012-06-01 11:35:25,170 ERROR [ThreadPool2 ] fisheye.app DBEditHelper-doGet - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script E:\fecru\sql\ORACLE\schema\tables_76.sql
com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script E:\fecru\sql\ORACLE\schema\tables_76.sql
at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:292)
at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:138)
at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:91)
at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:73)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
...
Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cru_base_star_model (cru_star_id number(10,0) not null, cru_item_type varchar2(80 char) not null, cru_string_key1 varchar2(255 char), cru_string_key2 varchar2(255 char), cru_string_key3 varchar2(255 char), cru_string_key4 varchar2(255 char), cru_string_key5 varchar2(255 char), cru_int_key1 number(10,0), cru_int_key2 number(10,0), cru_int_key3 number(10,0), cru_int_key4 number(10,0), cru_int_key5 number(10,0), cru_text_key1 clob, cru_text_key2 clob, cru_user_name varchar2(255 char), cru_date_created number(19,0), cru_label varchar2(255 char), primary key (cru_star_id));"
(ORA-00955: name is already used by an existing object), please contact http://www.atlassian.com/support/
...
Caused by: java.sql.SQLException: ORA-00955: name is already used by an existing objectCause
The database user does not have correct table space permission.
The database already has a pre-existing sequence in it which needs to be removed, which often occurs in Active Objects tables. You may need to drop the sequence from the database.
Resolution
Resolution for Cause #1
Stop Fisheye/Crucible.
Ensure that the database has been correctly configured, as in our Database Setup for Oracle documentation.
Start Fisheye/Crucible.
Please ensure you are looking at the document corresponding to your Fisheye/Crucible version.
Resolution for Cause #2
Identify the sequence that is causing the error - this can be done by reviewing the error in the logs, it will display an error such as the below
1<CREATE SEQUENCE "AO_60DB71_ISSUERANKING_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1>Stop Fisheye/Crucible.
Have your Oracle DBA delete the existing sequence.
There may be more than one Oracle sequence causing errors. Using the steps above, locate all sequences causing errors within the log files and remove them.
Start Fisheye/Crucible.
Was this helpful?