-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Low
-
None
-
Affects Version/s: 9.6.0, 10.0.0, 11.0.0, 12.0.0, 12.1.0
-
Component/s: Documentation (User)
-
None
-
1
-
Severity 3 - Minor
-
3
Summary
The Connect Bamboo to an Oracle database documentation should mention that the database username cannot contain special characters such as "-" or quotes.
Using a hyphen
in an Oracle 19c username requires the username to be enclosed in double quotes (e.g., "bamboo-user") because the hyphen is not a standard identifier character. Without quotes, it will interpret it as a subtraction operator, causing errors. It is highly recommended to avoid special characters like '-' and use underscores (_) instead to prevent syntax issues
However, while "bamboo-user" would work in Oracle, if you set Bamboo to use that username with double quotes, it will fail to startup because of https://jira.atlassian.com/browse/BAM-26334.
Suggestion
We should mention in the documentation that the database username cannot contain special characters or double quotes.
- relates to
-
BAM-26334 Bamboo fails to startup with ORA-02275 and ORA-00955 when using double quotes for the username
-
- Closed
-