Mendix Oracle Database Deployment Error: Failed to create database

Issue

When deploying a Mendix application using the Mendix Service Console with Oracle 19 as the database, the following error occurs: 

Failed to create database.
com.mendix.m2ee.api.internal.AdminException: Failed to create database.
Caused by: java.lang.UnsupportedOperationException: A new database cannot be generated automatically for Oracle.

Environment

Applications hosted in On-Premises

Cause

The error occurs due to incorrect configuration of the database connection settings in the Mendix application.  Specifically, when using DBName parameter instead of the correct SERVICE_NAME parameter for Oracle database connections.

Solution/Workaround

To resolve this issue, follow either of the below solutions:

1. Using DatabaseJdbcUrl: Override the default connection behavior by supplying a full JDBC URL:

DatabaseJdbcUrl: jdbc:oracle:thin:@//<host>:<port>/<SERVICE_NAME>

2. Using OracleServiceName Custom Runtime setting parameter to specify the SERVICE_NAME directly without crafting a full JDBC URL.

Additional information

• Mendix documentation
  • Oracle
  • Custom Runtime Setting