Bamboo does not install and shows error message ORA-01950
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
Summary
Bamboo installation doesn't finish and gets stuck in the database step. The logs show the error message ORA-01950.
Environment
All supported versions of Bamboo, connected with an Oracle database.
Diagnosis
The following error message can be seen in the Bamboo logs:
1
Caused by: Error : 1950, Position : 12, Sql = insert into CLUSTER_LOCK (LOCK_TIMESTAMP, LOCK_NAME) values(:1 , :2 ), OriginalSql = insert into CLUSTER_LOCK (LOCK_TIMESTAMP, LOCK_NAME) values(?, ?), Error Msg = ORA-01950: no privileges on tablespace 'BAMBOO_DATA'Cause
The user account connecting to the database does not have privileges to allocate an extent in the specified tablespace.
Solution
Grant the user account connecting Bamboo to the database the appropriate system privileges or grant the user space resource on the tablespace.
Oracle SQL commands
1
2
3
ALTER USER <USER> QUOTA UNLIMITED ON <TABLESPACE>
GRANT CONNECT, CREATE TABLE, CREATE SEQUENCE, CREATE TRIGGER TO <TABLESPACE>;Then, restart Bamboo and re-try the setup.
If you need to re-create the database, please make sure it's created in accordance to the requirements for Connecting Bamboo to an Oracle database.
Was this helpful?