Bamboo does not install and shows error message ORA-01950
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
Bamboo installation doesn't finish and gets stuck in the database step. The logs show the error message ORA-01950.
環境
All supported versions of Bamboo, connected with an Oracle database.
診断
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'
原因
The user account connecting to the database does not have privileges to allocate an extent in the specified tablespace.
ソリューション
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.