Installation guide

The target server has to have the Compression and Partition variables set on their helm charts. Possible values are "TRUE" and "FALSE". The values have to be strings, and also it is mandatory to make them capital.

These variables are:

In order to initiate the update, the new version of the service will have to be deployed. Whenever a new deployment happens a Kubernetes job will be created with the target version of the database, and will initiate the database update.

Whenever the job is executing the pod can be checked to see the logs. After the job ran through the status will be marked as completed:

The job will create a new versioning table, which is initially grabbing information from the MES_VERSION table in case it exists. The new table is called DATABASE_VERSION.

In this table, we can see the version history, the status of the updates, the timestamp, and also the whole log of the install/update. In case there was an unsuccessful update, make sure to check the Log column of this table, copy the content out and verify what failed.

The latest mespkg file has to be downloaded. Then it has to be placed in the Executables folder of the MES installer. A few examples, how it generally looks like:

Then start the installer, and choose install:

Choose the Material Management Database:

Then simply click next & install.

After the installation is complete, go back to the home page of the installer, and click 'Publish Databases':

Now, create a new database instance if the instance you want to install on was not already created in your MES Installer installation. Click 'Add Instance', then select 'Oracle' as Server Type, and provide a name. Fill in the connection details for the database you want to install on. If you want to perform a full install including the tablespaces and schema user, you need to provide the password for the sys user in the corresponding input field.

After adding the new instance, the next step is to create a new schema with the '+' - 'Add Database' button on the instance:

Select the desired one (installing the workflow version is not required), then 'Add':

Fill the credentials, then click next:

Make sure the connection’s state is 'Connected', click next.

On the next 'Configuration' page unselect the unnecessary scripts (if applicable) and provide the neccessary settings depending on the type of installation you are performing.

A full install on the database is only performed if the MES Installer does not detect a previous version of the database on the selected schema. Otherwise the MES Installer will try to perform an update of the existing database version. In order to full install the Material Management Workflow database, you need to provide the password for the sys user in the selected instance. A Full Install will create the Tablespaces, Schema User and all the Schema Objects.

For a full install you have to provide:

If your database already has existing tablespaces and schema user you want to re-use, but no schema objects, you can perform a full install of the schema objects without creating new tablespaces and schema user.

To do this please de-select the Create_tbspace_user_as_sys script as shown in the image below.

In this case you only have to provide:

If the database you selected already has a previous version of the database installed, the MES Installer will perform an update.

In this case you only have to provide:

On the final page, click "Install All" and wait for it to complete:

A successful installation will have all items marked with a green flag on the right side of the screen, or a red mark that means there was an error.