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.
- Check the requirements specified by Oracle Linux and Oracle DBMS.
- 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)
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:
- mkdir –p /opt/comarch/CEE630PA
- 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
- Open the script directory.
cd /opt/comarch/CEE630PA/install/scripts/linux
- Change the permissions of the crtsem.sh script
chmod 774 /opt/comarch/CEE630PA/install/scripts/linux/crtsem.sh
- Call up the crtsem.sh installation script with the -help parameter to display help ./crtsem.sh –help.
- 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)
- -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/Password | Database |
---|---|
CEE630PACF | Configuration database |
CEE630PARP | Repository database |
CEE630PA00 | Base OLTP database |
CEE630PA02 | Multi-Site OLTP database |
Run the ERP System Application Server
Proceed as follows to run the ERP system application server (SAS):
- Start the bash shell as the root user. Switch to the working directory of the SAS:
cd /opt/comarch/CEE630PA/semiramis/servers/MESSAGESERVER - 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:
- 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.
- Delete all the database users created during the installation by selecting the cascading option in Enterprise Manager, e.g. CEE630PACF, CEE630PARP, CEE630PA00, CEE630PA02 users.
- Check, for example with the Enterprise Manager Console, whether the tablespaces to be deleted no longer contain data.
- Delete all the tablespaces created during the installation, thus deleting operating system data in Enterprise Manager, e.g. CEE630PACF, CEE630PARP, CEE630PA00, CEE630PA02 tablespaces.
- Delete the following directory and its contents:
/opt/comarch/CEE630PA/semiramis
Comarch ERP Enterprise will now be successfully uninstalled.