Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

install confluence datacenter sql grammer error

RYF
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 6, 2025

How can I install the confluence using Oracle?

I am installing Confluence Datacenter 9.2.5 and Datacenter 9.2.4, and choose Oracle as the database. When the program is create the database, then the bellow error. 

Setup Database Failed

The following error(s) occurred:

  • Configuring database failed
  • StatementCallback; bad SQL grammar [ALTER TABLE DENORMALISED_SPACE_CHANGE_LOG MODIFY (ID DEFAULT DENORMALISED_SPACE_CHANGE_LOG_SEQ.NEXTVAL)]

wechat_2025-06-08_102600_888.png

wechat_2025-06-08_102404_390.png

It seems like bad SQL, but the right SQL such as "ALTER TABLE DENORMALISED_SPACE_CHANGE_LOG MODIFY ID DEFAULT DENORMALISED_SPACE_CHANGE_LOG_SEQ.NEXTVAL".

1 answer

0 votes
Tinker Fadoua
Community Champion
June 6, 2025

Welcome to the Atlassian Community @RYF !

Did you try to follow the steps o the following doc? It has the steps to set up the DB https://confluence.atlassian.com/doc/confluence-installation-guide-135681.html

Let me know if you have more questions.

Best,

Fadoua

yf r
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 7, 2025

YES,I do.

I encountered the problem at the database settings UI.

When I set the db via Oracle, the installation progam show the bad sql grammar.

I Think the installation progam having a bug which is the bad sql.

Could I Must change my db to Mysql etc.?

Like RYF likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events