install confluence datacenter sql grammer error

Question

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)]

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".

yf r · Answer

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.?

Tinker Fadoua · Answer

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