Create AVEVA Enterprise Resource Management Administrator Schema on the Database

Prerequisites for AVEVA Enterprise Resource Management schema installation

Before you begin complete the following:

• Configure the default settings.

• Validate the values in the following scripts:

  • General values setup (values independent of AVEVA Enterprise Resource Management Schema, for example: Oracle database directory logical and physical names, AVEVA Enterprise Resource Management system roles naming and AVEVA Enterprise Resource Management table space naming, see the script db\admin\value_general_setup.sql.

  • Schemas depend on value setup, for example, Roles naming setup, see the script db\value_schema_setup.sql.

  • Directory naming value setup, for example, source directory setup, see the script db\admin\value_directory_setup.sql.

    A change is required only if standard directory structure is not used.

  • Configure size of tablespaces, see the script db\admin\script\tablespace_create.sql

    For an AVEVA Enterprise Resource Management demo installation you can use the following sizes for the table.

ERM_SMALL_TABLE 80 MB

ERM_SMALL_INDEX 200 MB

ERM_MEDIUM_TABLE 30 MB

ERM_MEDIUM_INDEX 20 MB

ERM_LARGE_TABLE 20 MB

For an AVEVA Enterprise Resource Management production installation, the size is calculated depending on the expected number of records in the different tables. If the calculation is not possible, use the following space sizes as a starting point:

ERM_SMALL_TABLE 1 GB

ERM_SMALL_INDEX 1 GB

ERM_MEDIUM_TABLE 1 GB

ERM_MEDIUM_INDEX 1 GB

ERM_LARGE_TABLE 1 GB

The AVEVA Enterprise Resource Management requires SYS privileges and grant on SYS objects.

To minimize the access to the SYS account and to perform maintenance of the AVEVA Enterprise Resource Management application schema, an AVEVA Enterprise Resource Management administrator schema is created.

To create a new AVEVA Enterprise Resource Management administrator schema

1. To start AVEVA Enterprise Resource Management deployment manager, in the AVEVA Enterprise Resource Management installation package, from the DeploymentManager folder, below the InstallTools, run Aveva.Erm.DeploymentManager.exe.

   The AVEVA ERM Deployment Manager 1.3.0.0 dialog appears.

2. Select Initialize Database.

   

   The Initialize Database window appears.

   

   An Oracle user with name ERM_ADMIN is created.

3. Enter the relevant details in the fields as required.

   Field	Description
   SYS Privileged User	The ID of the Oracle SYS user.
   Password	The password of the SYS user of the Oracle database. The password is only known to the local database administrator. The valid characters are alphanumeric characters and special characters ! ? + # ^ ~ _ - : , . .
   TNS Alias	The TNS alias of the database. You can view the TNS Alias in the tnsnames.ora file in the Oracle client. The value in the TNS Alias field is also an EZCONNECT string (<host>:<port>/<service-name>).
   ERM Admin Password	The password of the ERMADMIN user. The valid characters are alphanumeric characters and special characters ! ? + # ^ ~ _ - : , . .
   ERM Dump Directory Path	The physical path of the dump directory on the database server. The logical name is ERM_DUMP.

4. Select Initialize.

   A terminal pop-up window will appear processing the command.

5. When the process is completed, in the terminal, enter exit.

   The AVEVA Enterprise Resource Management administrative schema is created.