We have sonarqube 8.2 version working currently with Oracle 12C

SonarQube Server / Community Build
1

We have sonarqube 8.2 version working currently with Oracle 12C in production and we are planning to upgrade db upgrade from 12C to 19C , in our pre-prod env.
When we are trying to connect non-prod env with 19C db .
After starting application , the process is automatically stopping.

Question —Is sonarqube 8.2 compatible with oracle 19C?

2

Hi,

Welcome to the community!

Your version is past EOL. You should upgrade to either the latest version or the current LTS at your earliest convenience. Your upgrade path is:

8.2 → 8.9.10 → 9.9 → 10.0 (last step optional)

You may find the Upgrade Guide and the LTS-to-LTS Upgrade Notes for 7.9 to 8.9, as well as the LTS to LTS release upgrade notes for 8.9 to 9.9 helpful. If you have questions about upgrading, feel free to open a new thread for that here.

Once you’ve updated to a modern version, you should find that it’s compatible with Oracle 19C.

 
HTH,
Ann

3

I have copied data from prod db (oracle 12c ) to QA db (oracle 19C)
But when I am starting sonarqube 8.9.10 followed by migrating/upgrading the database on the UI .
The db upgrade is failing with logs below–

oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00955: name is already used by an existing object

        ... 9 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

 

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
4

Hi,

On the face of it, that’s an Oracle error. Can you give the last few log lines before the error and the full error stacktrace?

 
Ann