Deploy AVEVA Enterprise Resource Management Application Server components for Application Server environment

AVEVA Enterprise Resource Management Deployment Manager is the graphical user interface (GUI) for installing and handling other types of technical administration tasks.

Before upgrading, ensure that you have a backup of the database. If you already have other backup strategies then exporting the database schema is not required.

(Optional) To export database 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 Export Database Schema.

   

   The Export Database Schema window appears.

   

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

   Field	Description
   ERM Admin Password	The password of the ERMADMIN user, as defined in the Initialize Database procedure.
   TNS Alias / EZ Connect	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 / EZ Connect field is also an EZCONNECT string (<host>:<port>/<service-name>).
   Oracle Data Pump Directory	The name of the AVEVA Enterprise Resource Management datapump directory. Directories are available in the database.
   Dump File	The file name of the dump without suffix.
   Schema Name	The name of the application custom database schema, as defined in the Create Database Schema procedure.
   Custom Schema Name	The name of the new application custom application database schema. The ID is pre-filled with the value in the Schema Name field and the value in the Custom Schema Name field is added after an underscore.
   Overwrite Dump	Indicates you can overwrite the dumpname.
   Consistent Export	Indicates the export of the database is consistent. Disable it only if the database is large and takes longer to export. The database recovery is handled using Oracle Flashback technology.

4. Select Export.

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

   

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

   The database schema is exported.