Installation: Comarch ERP Enterprise on Oracle Linux

Topic overview

This article describes the installation of Comarch ERP Enterprise system on Oracle Linux and on Oracle DBMS. The installation procedure is the same for both distributions.

Target group

  • System administrators
  • Technical consultants
  • Developers who install Comarch ERP Enterprise

Requirements

The list of required components as well as the supported Linux and Oracle versions can be found in the System requirements article.

A valid installation of Oracle Linux is required as the operating system. The network must be configured so that DNS settings can be managed.

The required database management system (DBMS) is DBMS Oracle referred to in this article. Installation instructions that also take into account ERP-specific settings can be found in the help documentation Installation of database management systems.

The user oracle has to be set up and must be able to log in to the database with the following command:

sqlplus sys/yourpassword@orcl as sysdba

The instance name or the ORCL SID for the identification of the database instance is recorded in the exported Configuration and thus required as the SID for installation and the operation of the installation system.

About 30 GB of free disk space is needed for the installation files and the installed system.

For the installation, the user must be root or another user of the root group.

The following installation order is required.

  1. Check the requirements specified by Oracle Linux and Oracle DBMS.
  2. If necessary, bring up the system to the level certified by Oracle Linux, for instance using YUM.

Conventions

Retain the preset directory structures to ensure unified structure of different systems installed in parallel.

The installation directory used, /opt/comarch/CEE630PA, follows the conventions of the Unix Filesystem Hierarchy Standard.

The system name used in this article, i.e. CEE630PA, is a sample name that should be replaced with the actual system name in accordance with the received license.

The SAS abbreviation used in the article denotes the ERP system application server.

Install AdoptOpenJDK

The Comarch ERP system is developed in JavaTM programming language and therefore requires the Java Development Kit (JDK) as a runtime environment, as well as for further work. At the time of writing this documentation, the supplied version of AdoptOpenJDK is 11.0.10+9. Download the current version of the JDK from https://adoptopenjdk.net/ as tar.gz.

The procedure for installing the Java JDK described below is necessary during the first installation or when changing the version of the supplied JDK.

Procedures: Installation of Java JDK

During the JDK installation, Oracle’s license agreements have to be accepted: newer versions of JDK may be delivered with an installation system in the future. Adapt the specifications to the delivered JDK version.

Create the directory for the JDK installation

mkdir /opt/comarch/java

Open the /opt/comarch/java directory. Copy the downloaded tar file into the /opt/comarch/java directory and open

tar –xzf OpenJDK11U-jdk_x64_linux_hotspot_11.0.10_9.tar.gz .

Rename the JDK directory to

mv jdk-11.0.10+9/ jdk-11.0.10+9-64/ .

Enter the following commands in the shell to verify the automatic installation afterwards:

  • export JAVA_HOME=/opt/comarch/jdk-11.0.10+9-64
  • $JAVA_HOME/bin/java –server –version
    The following information will be displayed:
    openjdk version “11.0.10” 2021-01-19
  • OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.10+9)
  • OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.10+9, mixed mode)
Hint
The JAVA_HOME environment variable is later set to the installed Java JDK’s path every time the start script strsas-localhost.sh is called. This prevents problems with any other JDK versions that are already installed.

Install the ERP system

The user will receive the CEE630PA-Partnersystem.zip archive to download from Comarch FTP server. Calling a script unpacks the archive, creates the necessary Oracle database files and users, imports the data from the export files, and generates statistics for the data.

To install the delivered system from a shell, start the bash shell as the root user.

Create directories

To perform the installation, create the following directory:

  1. mkdir –p /opt/comarch/CEE630PA
  2. Extract the downloaded ZIP file in the created folder.
    unzip CEE630PA-Partnersystem.zip

Prepare the license file

Prepare the license file in the extracted directory /opt/comarch/CIS620PB/install/licence

Prepare Oracle JDBC Connector

Prepare the Oracle JDBC Connector ojdbc8.jar, ojdbc10.jar or a new one in the directory /opt/comarch/CEE630PA/install/lib

crtsem.sh installation script

  1. Open the script directory.
    cd /opt/comarch/CEE630PA/install/scripts/linux
  1. Change the permissions of the crtsem.sh script
    chmod 774 /opt/comarch/CEE630PA/install/scripts/linux/crtsem.sh
  1. Call up the crtsem.sh installation script with the -help parameter to display help ./crtsem.sh –help.
  2. The script expects the following parameters:
    • -systemname: according to the license (eg. CEE630PA)
    • -java: Java Home directory /opt/comarch/java/jdk-11.0.10+9-64
    • -licencefile: license file name (eg. 300-CEE630PA-01-CEE630PA.lic)
    • -licencepassword: license password
    • -database_type: ORACLE
    • -filedestination_dir: Destination folder where the CEE directory is to be created. If the folder does not exist, the script will create it along with all the parent folders (e.g. /opt/comarch/CEE630PA)
    • -configuration_database: configuration database’s name according to the license (e.g. CEE630PACF)
Hint
According to the CEE system conventions, the configuration database’s name must end with CF letters.
  • -database_dir: path to the Oracle database directory, usually oradata
  • -password: DMS Oracle system user password.

A sample command may look as follows:

./crtsem.sh -systemname CEE630PA -java /opt/comarch/java/jdk- 11.0.10+9-64 -licencefile 300-CEE630PA-01-CEE630PA.lic -licence- password <password> -database_type ORACLE -filedestination_dir

/opt/comarch/CEE630PA -configuration_database CEE630PACF –data- base_dir /opt/oracle/oradata/orcl –password <password>

The semiramis.zip file will be extracted in the specified folder.

/opt/comarch/CEE630PA/semiramis.

Next, Oracle database files and users are created. Afterwards, the import of delivered Comarch ERP Enterprise databases starts. Finally, the optimizer statistics are built.

Log files and SQL scripts generated for the import can be viewed in the directories

/tmp/CEE630PA-log or ${TMPDIR}/CEE630PA-log. They provide information about a successful import operation. The database user names and passwords that are created for Comarch ERP Enterprise are:

Username/PasswordDatabase
CEE630PACFConfiguration database
CEE630PARPRepository database
CEE630PA00Base OLTP database
CEE630PA02Multi-Site OLTP database

Run the ERP System Application Server

Proceed as follows to run the ERP system application server (SAS):

  1. Start the bash shell as the root user. Switch to the working directory of the SAS:
    cd /opt/comarch/CEE630PA/semiramis/servers/MESSAGESERVER
  2. Execute the following script to run the SAS: strsas-messageserver.sh

The SAS stores log files in the directory /opt/co- march/CEE630PA/semiramis/servers/MESSAGESERVER/log ab.

Create database information

Before logging into the system for the first time, generate database information.

To do this, run the following commands on the running SAS:

crtdbinf –configuration –repository

crtdbinf –oltp –nlsAutomatic

restart

Log in to the ERP system

The first login to the system is via the URL http://localhost using the ADMINISTRATOR username and 12345 password.

Generate certificates

Certificates must be created to use a secure connection when logging in.

More information may be found in the article Generate certificates.

Next steps

After installation, several further steps are necessary to continue the system setup. The installed system is licensed for a limited range of functions. To be able to use the full range of Comarch ERP Enterprise functions, it is first necessary to install a license for a new system and set up this system.

The system creation process is discussed in the Create a new System article. Additionally, further information on launching the system can be found in the Installation guide.

ERP System Application Server as a service

Run the ERP System Application Server (SAS) as a Linux service. Step-by-step instructions may be found in the article Installation: Comarch ERP Enterprise As Service under Linux or Windows.

Uninstall the ERP system

There are several steps involved in uninstalling Comarch ERP Enterprise installation system. Proceed as follows:

  1. Stop all the SASs that access the database through the database users to be deleted. User data cannot be deleted while the user is still connected to the database.
  2. Delete all the database users created during the installation by selecting the cascading option in Enterprise Manager, e.g. CEE630PACF, CEE630PARP, CEE630PA00, CEE630PA02 users.
Hint
It is critical that the tablespaces to be deleted no longer contain data and that no other database user has saved one of the tablespaces as a default tablespace.
  1. Check, for example with the Enterprise Manager Console, whether the tablespaces to be deleted no longer contain data.
  2. Delete all the tablespaces created during the installation, thus deleting operating system data in Enterprise Manager, e.g. CEE630PACF, CEE630PARP, CEE630PA00, CEE630PA02 tablespaces.
  3. Delete the following directory and its contents:
    /opt/comarch/CEE630PA/semiramis

Comarch ERP Enterprise will now be successfully uninstalled.

Czy ten artykuł był pomocny?