# \#oracle **URL:** https://community.sonarsource.com/tag/oracle/56.md [Latest](https://community.sonarsource.com/latest.md) · [Categories](https://community.sonarsource.com/categories.md) · [Tags](https://community.sonarsource.com/tags.md) --- ## [Database Migration from Oracle 12c to 19c](https://community.sonarsource.com/t/database-migration-from-oracle-12c-to-19c/62448)
**Author:** [@vk3536](https://community.sonarsource.com/u/vk3536)\ **Replies:** 2\ **Last updated:** [May 2, 2022, 5:36pm UTC](https://community.sonarsource.com/t/database-migration-from-oracle-12c-to-19c/62448 "2022-05-02T17:36:33Z")
Sonarqube version: 8.9.7 We are planning on database migration from 12c to 19c. I’ve come across DB-copy tool. Is this tool applicable only if we are migrating between different vendors? Apart from changing the db conn… --- ## [Portfolio Recomputation: ORA-01795: maximum number of expressions in a list is 1000](https://community.sonarsource.com/t/portfolio-recomputation-ora-01795-maximum-number-of-expressions-in-a-list-is-1000/140446)
**Author:** [@JonasR](https://community.sonarsource.com/u/JonasR)\ **Replies:** 1\ **Last updated:** [May 5, 2025, 4:39pm UTC](https://community.sonarsource.com/t/portfolio-recomputation-ora-01795-maximum-number-of-expressions-in-a-list-is-1000/140446 "2025-05-05T16:39:32Z")
We are using SonarQube Server Enterprise Edition v2025.2 (105476) and have some large Portfolios. We are using Oracle as the database and now we receive the following error in the recomputations of this portfolios: or… --- ## [SonarQube for Oracle](https://community.sonarsource.com/t/sonarqube-for-oracle/125250)
**Author:** [@nandhakumar.agoram](https://community.sonarsource.com/u/nandhakumar.agoram)\ **Replies:** 4\ **Last updated:** [September 18, 2024, 10:51am UTC](https://community.sonarsource.com/t/sonarqube-for-oracle/125250 "2024-09-18T10:51:41Z")
Dear Community Folks, I’m new to SonarQube. I would like to know how to get started with SonarQube for Oracle. Any suggestions would be really appreciated. Thanks. Regards, Nandha --- ## [Database conection](https://community.sonarsource.com/t/database-conection/94619)
**Author:** [@Pooll\_Carrasco](https://community.sonarsource.com/u/Pooll_Carrasco)\ **Replies:** 8\ **Last updated:** [June 30, 2023, 7:43am UTC](https://community.sonarsource.com/t/database-conection/94619 "2023-06-30T07:43:48Z")
I have an oracle database and I’m trying to connect it to my oracle database in different ways and it doesn’t work, sonarqube continues to use the embedded database, I configured sonar properties and nothing. The command… --- ## [We have sonarqube 8.2 version working currently with Oracle 12C](https://community.sonarsource.com/t/we-have-sonarqube-8-2-version-working-currently-with-oracle-12c/89781)
**Author:** [@sukhbir](https://community.sonarsource.com/u/sukhbir)\ **Replies:** 3\ **Last updated:** [May 31, 2023, 2:35pm UTC](https://community.sonarsource.com/t/we-have-sonarqube-8-2-version-working-currently-with-oracle-12c/89781 "2023-05-31T14:35:57Z")
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 . A… --- ## [Migration from Oracle 19c to PostgreSQL](https://community.sonarsource.com/t/migration-from-oracle-19c-to-postgresql/80658)
**Author:** [@nyk\_14](https://community.sonarsource.com/u/nyk_14)\ **Replies:** 1\ **Last updated:** [January 10, 2023, 9:31am UTC](https://community.sonarsource.com/t/migration-from-oracle-19c-to-postgresql/80658 "2023-01-10T09:31:56Z")
Hi, we are using SonarQube version 9.7. We need to migrate database engine from Oracle (managed by external company) into PostgreSQL 14 (local database). This migration will allow us to make SonarQube more flexible to m… --- ## [Oracle cicd integration possible?](https://community.sonarsource.com/t/oracle-cicd-integration-possible/76223)
**Author:** [@Adarsh\_raj](https://community.sonarsource.com/u/Adarsh_raj)\ **Replies:** 7\ **Last updated:** [November 28, 2022, 5:49pm UTC](https://community.sonarsource.com/t/oracle-cicd-integration-possible/76223 "2022-11-28T17:49:10Z")
Must-share information (formatted with Markdown): which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) what are you trying to achieve what have you tried so far to achieve this Is ther… --- ## [SonarQube 9.6 / 9.6.1 - Oracle ORA-01000 error on startup](https://community.sonarsource.com/t/sonarqube-9-6-9-6-1-oracle-ora-01000-error-on-startup/71037)
**Author:** [@admin.appserver](https://community.sonarsource.com/u/admin.appserver)\ **Replies:** 10\ **Last updated:** [September 19, 2022, 2:40pm UTC](https://community.sonarsource.com/t/sonarqube-9-6-9-6-1-oracle-ora-01000-error-on-startup/71037 "2022-09-19T14:40:32Z")
SonarQube version: 9.6, 9.6.1 Environment: Linux, OpenJDK 11, Oracle 19C database, ojdbc8 driver Plugins: Crowd 2.2 (but have tested without plugin and error still occurs) Upgrading from 9.2.4 to 9.6/9.6.1, startup aft… --- ## [‘rollback segment too old / too small’ during migration to 8.9.7](https://community.sonarsource.com/t/rollback-segment-too-old-too-small-during-migration-to-8-9-7/69455)
**Author:** [@adeebV](https://community.sonarsource.com/u/adeebV)\ **Replies:** 2\ **Last updated:** [August 15, 2022, 1:40pm UTC](https://community.sonarsource.com/t/rollback-segment-too-old-too-small-during-migration-to-8-9-7/69455 "2022-08-15T13:40:15Z")
We are using the community version. I successfully updated SonarQube from version 7.8.0 to version 7.9.6 using Oracle DB 12.1.0.2. But when I went to upgrade from version 7.9.6 to version 8.9.7 I had problems with erro… --- ## [Problem after migrating from mysql to oracle](https://community.sonarsource.com/t/problem-after-migrating-from-mysql-to-oracle/64234)
**Author:** [@ecimen](https://community.sonarsource.com/u/ecimen)\ **Replies:** 3\ **Last updated:** [June 7, 2022, 8:46am UTC](https://community.sonarsource.com/t/problem-after-migrating-from-mysql-to-oracle/64234 "2022-06-07T08:46:50Z")
Hi we are getting the error message " ORA-00932: inconsistent datatypes: expected - got CLOB" while upgrading database manually via http://xxxx:9000/setup link. what we have done so far; we moved all objects from mysql… --- ## [Sonar 8.9.1 - Error while starting](https://community.sonarsource.com/t/sonar-8-9-1-error-while-starting/45370)
**Author:** [@mtyagadurgam](https://community.sonarsource.com/u/mtyagadurgam)\ **Replies:** 3\ **Last updated:** [June 25, 2021, 6:44am UTC](https://community.sonarsource.com/t/sonar-8-9-1-error-while-starting/45370 "2021-06-25T06:44:30Z")
Hello Everyone, We are currently using SonarQube - 6.3.1 \[oracle 11g DB\] and planning for an upgrade to 8.9.1 Instead of upgrading we built a new instance and installed SonarQube 8.9.1 and created a new oracle 19c DB.… --- ## [Migration from Oracle 18c to Oracle 19c would affect Sonarqube Enterprise Edition Version 7.9.1 behavior](https://community.sonarsource.com/t/migration-from-oracle-18c-to-oracle-19c-would-affect-sonarqube-enterprise-edition-version-7-9-1-behavior/43803)
**Author:** [@oramirez](https://community.sonarsource.com/u/oramirez)\ **Replies:** 1\ **Last updated:** [May 28, 2021, 10:19am UTC](https://community.sonarsource.com/t/migration-from-oracle-18c-to-oracle-19c-would-affect-sonarqube-enterprise-edition-version-7-9-1-behavior/43803 "2021-05-28T10:19:32Z")
Must-share information (formatted with Markdown): Our Sonarqube server has installed Enterprise Edition Version 7.9.1 Nowadays we have installed Oracle 18 c in our server. Because a license issue we must to migrate… --- ## [Oracle 19c Multitenant](https://community.sonarsource.com/t/oracle-19c-multitenant/41877)
**Author:** [@morgane\_lu](https://community.sonarsource.com/u/morgane_lu)\ **Replies:** 1\ **Last updated:** [April 19, 2021, 12:41pm UTC](https://community.sonarsource.com/t/oracle-19c-multitenant/41877 "2021-04-19T12:41:13Z")
Hello, We’re running Sonarqube Developer Edition LTS version 7.9. Our database admin would like to upgrade the db from Oracle 12 to Oracle 19c. I read in the documentation it’s compatible with Sonar LTS 7.9 version tha… --- ## [PHP scanning with OCI8 calls?](https://community.sonarsource.com/t/php-scanning-with-oci8-calls/41046)
**Author:** [@Frank\_Gruman](https://community.sonarsource.com/u/Frank_Gruman)\ **Replies:** 2\ **Last updated:** [April 8, 2021, 3:41pm UTC](https://community.sonarsource.com/t/php-scanning-with-oci8-calls/41046 "2021-04-08T15:41:03Z")
We are evaluating SonarQube for a replacement to a much more expensive SAST solution. Our application is using Oracle’s OCI8 calls in our PHP code. The incumbent system detects the OCI calls and will flag some elements… --- ## [Initializing Oracle db for Developer 8.7 fails with numerous errors](https://community.sonarsource.com/t/initializing-oracle-db-for-developer-8-7-fails-with-numerous-errors/39557)
**Author:** [@maksymg](https://community.sonarsource.com/u/maksymg)\ **Replies:** 0\ **Last updated:** [March 3, 2021, 7:47pm UTC](https://community.sonarsource.com/t/initializing-oracle-db-for-developer-8-7-fails-with-numerous-errors/39557 "2021-03-03T19:47:44Z")
8.7.0.41497 - latest docker image sonarqube:8.7-developer Oracle 19c with 19.1 JDBC how to reproduce - make a clean install into empty db schema Once I launch Sonar for the 1st time, it starts initializing db up to #3… --- ## [Install with Oracle autonomous database](https://community.sonarsource.com/t/install-with-oracle-autonomous-database/25137)
**Author:** [@CGarces](https://community.sonarsource.com/u/CGarces)\ **Replies:** 1\ **Last updated:** [May 29, 2020, 6:04pm UTC](https://community.sonarsource.com/t/install-with-oracle-autonomous-database/25137 "2020-05-29T18:04:19Z")
I have configured an Ubuntu 20.04 LTS instance with sonarqube-8.3.1 I’m trying to connect to Oracle autonomous database from OCI free tier. jdbc driver is copied to the folder extensions/jdbc-driver/oracle/ it comes fr… --- ## [Oracle privileges](https://community.sonarsource.com/t/oracle-privileges/23872)
**Author:** [@Aruna\_Gunasekera](https://community.sonarsource.com/u/Aruna_Gunasekera)\ **Replies:** 1\ **Last updated:** [April 29, 2020, 6:43pm UTC](https://community.sonarsource.com/t/oracle-privileges/23872 "2020-04-29T18:43:04Z")
I am trying to install sonarqube 8.2 with oracle database 12c. I cant find any documentation about what privileges to give a database user, so that sonar can function. --- ## [I can't analyse old projects after migration from 6.7.7 to 7.9.1: ORA-00600: internal error code](https://community.sonarsource.com/t/i-cant-analyse-old-projects-after-migration-from-6-7-7-to-7-9-1-ora-00600-internal-error-code/15283)
**Author:** [@omoreno](https://community.sonarsource.com/u/omoreno)\ **Replies:** 5\ **Last updated:** [February 11, 2020, 11:18am UTC](https://community.sonarsource.com/t/i-cant-analyse-old-projects-after-migration-from-6-7-7-to-7-9-1-ora-00600-internal-error-code/15283 "2020-02-11T11:18:54Z")
Hi, I’ve migrated from SQ 6.7.7 to 7.9.1 I try to analyse a project using Jenkins, the job finalize ok, but after SonarQube makes the background tasks, it fails. These are the error details from background tasks sectio… --- ## [Upgrade from 6.7.3 to 7.9 (LTS) -\> Fail to execute CREATE UNIQUE INDEX live\_measures\_component](https://community.sonarsource.com/t/upgrade-from-6-7-3-to-7-9-lts-fail-to-execute-create-unique-index-live-measures-component/11704)
**Author:** [@BrightLight](https://community.sonarsource.com/u/BrightLight)\ **Replies:** 6\ **Last updated:** [November 14, 2019, 6:54pm UTC](https://community.sonarsource.com/t/upgrade-from-6-7-3-to-7-9-lts-fail-to-execute-create-unique-index-live-measures-component/11704 "2019-11-14T18:54:52Z")
Hi, I’m trying to update from SonarQube 6.7.3 to 7.9. I’m on Windows and I use an Oracle database. Sadly, the database migration fails. 2019.07.10 11:34:38 INFO web\[\]\[DbMigrations\] #1941 'Populate table live\_measures… --- ## ['rollback segment too old / too small' during migration to 7.9.1](https://community.sonarsource.com/t/rollback-segment-too-old-too-small-during-migration-to-7-9-1/15795)
**Author:** [@Ruedi](https://community.sonarsource.com/u/Ruedi)\ **Replies:** 1\ **Last updated:** [October 24, 2019, 1:51pm UTC](https://community.sonarsource.com/t/rollback-segment-too-old-too-small-during-migration-to-7-9-1/15795 "2019-10-24T13:51:41Z")
I wanted to update from 6.7.7 to version 7.9.1 with an Oracle DB 12.2.0.1.0 After about two hours, migration on task 2504 ‘Delete useless module and folder level measures’ is aborted with the error: Caused by: java.sql… --- ## [Sonarqube configured with Oracle not working](https://community.sonarsource.com/t/sonarqube-configured-with-oracle-not-working/3829)
**Author:** [@dsvaishal](https://community.sonarsource.com/u/dsvaishal)\ **Replies:** 7\ **Last updated:** [November 29, 2018, 4:32am UTC](https://community.sonarsource.com/t/sonarqube-configured-with-oracle-not-working/3829 "2018-11-29T04:32:11Z")
Sonarqube Version -: 7.3 Cent OS -7.5 Oracle - 12.2.0.1 I am trying to connect Sonarqube with Oracle. In Oracle i have created new user name as sonar and gave all the permissions. with below command. CREATE USER sona… --- ## [Cannot see projects after connecting to Oracle database](https://community.sonarsource.com/t/cannot-see-projects-after-connecting-to-oracle-database/1589)
**Author:** [@Shreedhar\_Dhanawade](https://community.sonarsource.com/u/Shreedhar_Dhanawade)\ **Replies:** 4\ **Last updated:** [August 7, 2018, 8:13am UTC](https://community.sonarsource.com/t/cannot-see-projects-after-connecting-to-oracle-database/1589 "2018-08-07T08:13:38Z")
Dear All, I have SonarQube 6.2 installed with no extra database connected. Now, I have a Oracle PDB and I connected SonarQube with it . It got connected without any errors. Connecting user “sonar” has been created in … --- ## [Migration to sonarqube 6.7.4 - oracle db error ORA-02429](https://community.sonarsource.com/t/migration-to-sonarqube-6-7-4-oracle-db-error-ora-02429/1176)
**Author:** [@Serge](https://community.sonarsource.com/u/Serge)\ **Replies:** 1\ **Last updated:** [July 20, 2018, 2:15pm UTC](https://community.sonarsource.com/t/migration-to-sonarqube-6-7-4-oracle-db-error-ora-02429/1176 "2018-07-20T14:15:28Z")
Hi, I started this sonarqube migration: 5.4 -\> 5.6.7 LTS -\> 6.7.4 LTS -\> 7.2.1 Our Sonarqube is connected to an Oracle 12 database Upgrading from 5.6.7 to 6.7.4 gave me these error messages: ERROR web\[\]\[DbMigrations\]… --- ## [Database usage only growing](https://community.sonarsource.com/t/database-usage-only-growing/417)
**Author:** [@b2s](https://community.sonarsource.com/u/b2s)\ **Replies:** 4\ **Last updated:** [June 25, 2018, 7:00am UTC](https://community.sonarsource.com/t/database-usage-only-growing/417 "2018-06-25T07:00:25Z")
Hello everybody, We are having trouble with a growing Oracle DB after upgrading/ migrating a SonarQube 5.0 installation. We had to double the tablespace size (1 GB -\> 2 GB). A single run of an XL Java project added 160 … --- ## [Can not create new project, ORA-00001: unique constraint (SONAR3.SYS\_C0034944) violated](https://community.sonarsource.com/t/can-not-create-new-project-ora-00001-unique-constraint-sonar3-sys-c0034944-violated/111)
**Author:** [@Stas\_Roshkolts](https://community.sonarsource.com/u/Stas_Roshkolts)\ **Replies:** 1\ **Last updated:** [June 11, 2018, 2:29pm UTC](https://community.sonarsource.com/t/can-not-create-new-project-ora-00001-unique-constraint-sonar3-sys-c0034944-violated/111 "2018-06-11T14:29:23Z")
Hello, We use Sonarqube 5.5 and want to upgrade to the latest one. During the test we created copy of production server by exporting and importing DB to playground. Unfortunately, in playground we can not create new p…