Install AVEVA Enterprise Resource Management on the database server
- Last UpdatedMay 07, 2026
- 1 minute read
Prerequisites
Before you begin, complete the following:
-
Ensure the Oracle RDBMS is installed and running.
-
Ensure the minimum version of the RDBMS is Oracle Standard Edition RDBMS 19.18.0.0.0 and patch number 34765931.
-
Ensure the default Oracle granting of various system objects to public is used.
All the files required to create an AVEVA Enterprise Resource Management application schema are available in the db.zip archive. Unzip it to a directory named db.
Note: Name the directory as db.
In the extracted db folder, the following sub directories exists:
|
Name |
Contents |
|---|---|
|
admin |
Files required to create users, create roles, granting roles and users, and so on. |
|
data_default |
Default data for creating a new AVEVA Enterprise Resource Management schema. |
|
data_optional |
Optional data for creating a new AVEVA Enterprise Resource Management schema. |
|
ddl |
All tables, views, constraints and sequences. |
|
Plsql |
Database package headers and bodies, database triggers. |
Parameters required for AVEVA Enterprise Resource Management
Note: The settings are included in the database template. However, if you configure the database manually, ensure the parameters are set.
-
Ensure the value in the JOB_QUEUE_PROCESSES variable is 1000. If the value is lowered from the Oracle default value of 1000, use the command alter system set job_queue_processes = 1000 as a database user with the DBA-rights.
-
Before creating the Oracle instance, set the MAX_STRING_SIZE to EXTENDED, since AVEVA Enterprise Resource Management requires 32K VARCHAR2 support.
Note: All scripts are developed for the enterprise using the Oracle supplied tools, Oracle SQL Developer or SQL*Plus.