Skip to content

Database Requirements

The supported versions are Oracle 12c, 18c, 19c and 23ai - 64 bit

Oracle Real Application Clusters (RAC) is only supported in failover mode but not the server side load balancing. So the application would need to connect to a single node.

  • The character set of the database must be AL32UTF8 (UTF8).

  • In order to find out what exact Oracle edition/version is actually installed: ** **sqlplus.exe SYS@<DB-NAME> as SYSDBA select banner from v$version where BANNER like '%Edition%';

  • In order to find out how much memory is actually available to the Oracle database, it is important to first understand how Oracle's memory is configuration and used:

  • The actual available System Global Area (SGA) memory can be found using: ** **sqlplus.exe SYS@<DB-NAME> as SYSDBA show sga; select * from v$sga; select * from v$sgainfo;

  • The actual available Program Global Area (PGA) memory can be found using: ** **sqlplus.exe SYS@<DB-NAME> as SYSDBA select * from v$pgastat;

  • In order to find out how much processing CPU/Cores is actually available to the Oracle database, query the table v$parameter for the value of cpu_count, or query the table v$license as follows: ** **sqlplus.exe SYS@<DB-NAME> as SYSDBA select * from v$license;

Database Setup

Create a user MM and a database MM with the following privileges:

sqlplus.exe SYS@<DB-NAME> as SYSDBA   -- Delete previous user and database if needed -- DROP USER MM CASCADE;   CREATE USER MM IDENTIFIED BY MM123!;   GRANT CONNECT TO MM;   GRANT CREATE TABLE TO MM; GRANT CREATE VIEW TO MM; GRANT CREATE SEQUENCE TO MM; GRANT CREATE TRIGGER TO MM; GRANT CREATE PROCEDURE TO MM; GRANT CREATE TYPE TO MM;   GRANT EXECUTE ON DBMS_LOB TO MM;   -- If you get the error "Database exception occurred: ORA-01950: no privileges on tablespace 'USERS'" -- ALTER USER MM QUOTA UNLIMITED ON USERS;