Bamboo does not install and shows error message ORA-01950
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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:
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.
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.