PROCESSIT 7.3 R4

SOA Server Installation

©2025 Copyright ReadSoft AG (publ). All rights reserved. The contents of this document are subject to change without notice. ReadSoft is a registered trademark of ReadSoft AB. Other product and company names herein may be the trademarks or registered trademarks of their respective owners.
Questions or comments about this document may be emailed to documentation@readsoft.com.

ReadSoft AB (Head office) | Södra Kyrkogatan 4 | SE-252 23 Helsingborg | Sweden | Phone: +46 42 490 21 00 | Fax: +46 42 490 21 20
ReadSoft AG | Falkstrasse 5 | 60487 Frankfurt | Germany | Phone: +49 69 1539402-0 | Fax: +49 69 1539402-13
info@readsoft.com | www.readsoft.com

IntroductionTypographic conventionsRecommendationsInstall PROCESSIT DatabaseInstallation PackageDownload Installation PackageLoginConfirm Swap spaceMove install package to serverUnzip install packageTest the networkYum installerGet the repository fileEdit the repository fileEnable Oracle UpdatesYum install 1Yum install 2Yum Install 3Yum Install 4XhostDisplay testCreate Oracle user and folderCreate user oracleChange the ownership of the foldersCreate the Oracle folder Oracle folder ownershipChange userStart the Database installationConfigure Security UpdatesEmail address not specifiedSelect Installation OptionSystem ClassNode SelectionSelect Install TypeSelect Product LanguageSelect Database EditionSpecify Installation LocationCreate InventorySelect Configuration TypeSpecify Database IdentifiersSpecify Configuration OptionsSpecify Management OptionsSpecify Database Storage OptionsSpecify Recovery OptionsSpecify Schema PasswordsPrivileged Operating System GroupsSummaryDatabase Configuration AssistantExecute Configuration ScriptsCopy db file and start/stop scriptsOwnership of the db and scripts fileExportCheck the ORACLE_HOMEStart up the databaseSOA Software InstallPrerequisitesSoftware setupDownloadLogin to the serverChange userInstall the new packagesLink libdbChange userExportCopy OJDBC to the jdbc homeirca.sh scriptExecute scriptCopy jar filesOracle Application Server SOA Suite 10.1.3.1.0 InstallationRun the SOA installerWarningSelect Installation TypeOracle Universal Installer Product-specific Prerequisite ChecksWarningOracle Universal Installer Specify Database Connect InformationOracle Universal Installer Specify Database Schema PasswordsOracle Universal Installer Specify Port Configuration OptionsOracle Universal Installer Administration SettingsOracle Universal Installer Cluster Topology ConfigurationOracle Universal Installer SummarySetup PrivilegesChange to the stage directoryUnzip Oracle universal installer updateChange to the OUI install directoryMake installer executableRun the OUI installerWelcome Select Installation TypeSpecify Home DetailsSummaryOPatch updateUnzip patch 8626084Update ORABPEL schemaUpgrade ORAESB schemaSwitch command prompt to 32 bit modeRun Upgrade installerWelcomeSpecify File LocationsEmail notificationsEmail Address Not SpecifiedAdministrator (oc4jadmin) PasswordSpecify Password for OWSM SchemaWarningExecute scripts Setup PrivilegesEnd of InstallationUnzip patch 9841044Stop SOAApply PatchSet the database homeConnect to database as orabpelConnect to database as oraesbPatch 12351139Replace bundled Java with 64bit JavaStart the SOA SuiteInstallation completeAppendixIf DB_HOME and Database are not on the PROCESSIT Server

Introduction

This document covers the installation of Oracle Db11g for ReadSoft PROCESSIT. The installation procedure is chronological, so each step should be performed in the sequence appearing in this document.

For details regarding PROCESSIT workflow installation, please refer to the standard PROCESSIT installation guide.

PROCESSIT uses Oracle BPEL Process Manager (a component of Oracle SOA Suite) 10.1.3.5 patched to the latest MLR2 level.

Typographic conventions

Please note that all commands that should be typed are presented like this.

Recommendations

If installing on VMware we recommend that you take snapshots at various points throughout the installations to avoid restarting if something goes wrong.

Install PROCESSIT Database

Installation Package

Download Installation Package

Download linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip from the ReadSoft FTP Server.

Login

Log in to the OEL5 DB server as root with the root password.

Confirm Swap space

cat /proc/swaps 10 GB swap space is required (accumulated on all partitions).

Move install package to server

Move linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip to a directory on the DB server. It is recommended to place them in /stage/db_install

Unzip install package

Unzip the two files:

  • gunzip linux.x64_11gR2_database_1of2.zip
  • gunzip linux.x64_11gR2_database_2of2.zip

Test the network

Ping www.oracle.com

Yum installer

Open a new terminal on the server as root

cd /etc/yum.repos.d

Get the repository file

wget http://public-yum.oracle.com/public-yum-el5.repo

Edit the repository file

vi public-yum-el5.repo

Enable Oracle Updates

Change the enabled setting from 0 to 1 for these products:

  • [el5_u4_base]
  • [el5_u5_base]
  • [el5_addons]
  • [el5_oracle_addons]

Save the settings: :wq!

Yum install 1

yum install oracle-validated

Type Y to Is this ok? The requested packages are downloaded and installed.

Type Y to Is this ok? This allows importing a GPG Key from the Oracle OSS group.

Yum install 2

yum install libaio-devel

Type Y to Is this ok? The requested packages are downloaded and installed.

Yum Install 3

yum install unixODBC-devel

Type Y to Is this ok? The requested packages are downloaded and installed.

Yum Install 4

yum install gdbm-devel

Type Y to Is this ok? The requested packages are downloaded and installed.

Xhost

xhost +

Display test

Test the xclock application to see if the graphical interface is working. Press ctrl+c to stop the clock.

Create Oracle user and folder

Create user oracle

useradd oracle

passwd [password]

Change the ownership of the folders

chown -R oracle:oracle /stage

Create the Oracle folder

mkdir /oracle

Oracle folder ownership

chown -R oracle:oracle /oracle

Change user

su - oracle

Start the Database installation

cd /stage/db_install/database

./runInstaller

The database installer is shown.

Configure Security Updates

Remove the I wish checkmark.

Click Next

Email address not specified

Click Yes

Select Installation Option

Select Create and configure a database

Click Next

System Class

Select Server Class

Click Next

Node Selection

Select Single Instance Database Installation

Click Next

Select Install Type

Select Advanced install

Click Next

Select Product Language

Click Next

Select Database Edition

Select Enterprise Edition

Click Next

Specify Installation Location

Change the oracle base path: Oracle base = /oracle/db/

Click Next

Create Inventory

Change the Inventory Directory: Inventory Directory = /oracle/oraInventory

Click Next

Select Configuration Type

Select General Purpose/Transaction Processing

Click Next

Specify Database Identifiers

Enter the global database name, for instance SOADB.

Ensure that the Oracle Service Identifier is equivalent.

Click Next

Specify Configuration Options

On the memory tab, check Enable Automatic Memory Management.

Change the Allocate Memory value to 2048

On the character sets tab, select Use Unicode

Click Next

Specify Management Options

Select Use Database Control for database management

Click Next

Specify Database Storage Options

Select File System

Change Specify database file location: /oracle/db/oradata

Click Next

Specify Recovery Options

Select Do not enable automatic backups

Click Next

Specify Schema Passwords

Select Use the same password for all accounts

Specify the password. This password is referenced as [password] in this document.

Confirm the password.

Privileged Operating System Groups

Confirm that both the Database Administrator (OSDBA) Group and the Database Operator (OSOPER) Group are set to oracle.

Click Next

Summary

Click Finish. The installation begins.

Database Configuration Assistant

Click Ok.

Execute Configuration Scripts

  1. Open a new terminal window and log in as root.
  2. Run these scripts:
    • sh /oracle//oraInventory/orainstRoot.sh

    • sh /oracle/db//product/11.2.0/dbhome_1/root.sh

  3. Press Enter to the full path for local bin dir. Or type /usr/local/bin
  4. Return to the execute conf. ass. window.
  5. Click Ok to continue.

Copy db file and start/stop scripts

Copy these scripts from /stage/scripts to /home/oracle/

  • db
  • opmnctlStatus.sh
  • setdbhome.sh
  • setsoahome.sh
  • startall.sh
  • startdb.sh
  • startsoa.sh
  • stopall.sh
  • stopdb.sh
  • stopsoa.sh

Ownership of the db and scripts file

chown oracle:oracle /home/oracle/*

chmod 777 /home/oracle/*

Export

export ORACLE_HOME=/oracle/db/product/11.2.0/dbhome_1

Check the ORACLE_HOME

Echo $ORACLE_HOME

Start up the database

./home/oracle/db start

If any permission issues occur, go to SELinux Administration, select Status and set System Default Enforcing Mode and Current Enforcing Mode to permissive.

SOA Software Install

Prerequisites

Dehydration Store / PROCESSIT Database must be installed and available prior to SOA installation.

Software setup

Download

Download processit_prereqs_x64_without_db.tar from ftp.readsoft.us.com Put the software package on the server, eg in / Unpack the software tar -xvf processit_prereqs_x64_without_db.tar /stage is created Make sure oracle owns the installation software cd /stage chown -R oracle:oracle *

Login to the server

Log in to the server where you wish to install SOA Suite Server software using the user oracle.

Change user

su - root

Install the new packages

cd /stage/misc_files

rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm

rpm -ivh xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

Link libdb

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Change user

su - oracle

Export

export ORACLE_HOME=/oracle/db/product/11.2.0/dbhome_1

Copy OJDBC to the jdbc home

If SOA Database is installed on another host, you must transfer the irca directory and the ojdbc directory to the database host.

cd /stage/soa_install/ojdbc

cp * $ORACLE_HOME/jdbc/lib

If you are not able to edit the ORACLE_HOME/jdbc/lib directory, instead:

Edit the irca.bat (or irca.sh) file to point to ojdbc5.jar file instead of ojdbc14.jar.

REM Set Classpathset
CLASSPATH=lib\bpm-install.jar;%ORACLE_HOME%\jdbc\lib\ojdbc14.jar

replace with:

REM Set Classpathset
CLASSPATH=lib\bpm-install.jar;%ORACLE_HOME%\jdbc\lib\ojdbc5.jar

irca.sh script

Verify that you can connect to the database with sqlplus prior to running irca.sh

cd /stage/soa_install/install/soa_schemas/irca

If irca install files are not edited, orawsm and oraesb get SYSTEM as default tablespace.

Execute script

sh irca.sh

When asked for host port servicename enter the following:

(Example) soa.vm.net 1521 orcl

Enter sys password = [password]

Enter password for ORABPEL = [orabpel password]

Enter password for ORAESB = [oraesb password]

Enter password for ORAWSM = [orawsm password]

These passwords are used later for SOA installation and upgrades. The irca script needs the connection string to the SOA database. The system administrator must provide this. Standard installation places the database on the SOA server so you are already working on the host. Check by writing command hostname. Portnumber defaults to 1521 but can be changed.

Copy jar files

cp /stage/soa_install/DBConnectQueries.jar /stage/soa_install/stage/Queries/DBConnectQueries/8.4/1/

cp /stage/soa_install/IP_DBQueries.jar /stage/soa_install/stage/Queries/IP_DBQueries/3.0/1/

Oracle Application Server SOA Suite 10.1.3.1.0 Installation

You must run the following procedure in a GUI Environment.

Run the SOA installer

You must run this in a GUI console Environment.

cd /stage/soa_install/

./runInstaller -ignoreSysPrereqs

  • The SOA installer is shown.
  • Installation Directory: /oracle/as/product/10.1.3.1/OracleAS_1
  • Select Advanced Install
  • Click Next.

Warning

Click Yes to the warning

Select Installation Type

Select the J2EE Server, Web Server and SOA Suite (872mb).

Click Next.

Oracle Universal Installer Product-specific Prerequisite Checks

Click Next.

Warning

Click Yes.

Oracle Universal Installer Specify Database Connect Information

User with DBA Privileges: sys

Database User password: [sys password]

Hostname and Port: [DB hostname]:[port] - standard port is 1521.

Service name: Standard service name is orcl

Click Next.

Oracle Universal Installer Specify Database Schema Passwords

Type in the passwords created for the orabpel, oraesb, orawsm when running the IRCA script. See step 53 for details.

Click Next.

Oracle Universal Installer Specify Port Configuration Options

Select Automatic under Configure Posts.

Click Next.

Oracle Universal Installer Administration Settings

AS instance name: [instance name] (for instance soa001_inst)

As Administrator Password: [password]

Confirm As Administrator Password: [password]

OC4J Instance name: oc4j_soa

Oracle Universal Installer Cluster Topology Configuration

Click Next.

Oracle Universal Installer Summary

Click Install to begin the installation.

Setup Privileges

Run the script root.sh

Open a new terminal window as root.

sh /oracle/as/product/10.1.3.1/OracleAS_1/root.sh

Click Ok in the setup privileges window.

Oracle Universal Installer End of Installation

Click Exit.

Change to the stage directory

cd /stage/soa_install

Unzip Oracle universal installer update

unzip p6640752_10204_Linux-x86-64.zip

Change to the OUI install directory

cd cd/Disk1/install

Make installer executable

chmod +x runInstaller

chmod +x unzip

Run the OUI installer

./runInstaller -ignoreSysPrereqs

Welcome

Click Next.

Select Installation Type

Select Complete and click Next.

Specify Home Details

Select the Oracle Home that corresponds to the home for SOA Suite (usually oracleas1).

Summary

Click Install.

Oracle Universal Installer End of Installation

Click Exit.

OPatch update

cd /stage/soa_install

unzip p6880880_102000_Linux-x86-64.zip -d /oracle/as/product/10.1.3.1/OracleAS_1/

Confirm overwrite by pressing A.

Unzip patch 8626084

unzip p8626084_101350_LINUX.zip -d 8626084

At this point you may wish to make an environment file.

export SOA_HOME=/oracle/as/product/10.1.3.1/OracleAS_1
export ORACLE_HOME=$SOA_HOME
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=$ORACLE_HOME/OPatch:$PATH

Update ORABPEL schema

cd /stage/soa_install/8626084/Disk1/install/soa_schema_upgrade/bpel/scripts

If database_home is not installed on your PROCESSIT server, instead use SOA_HOME and define tnsnames.ora

sqlplus orabpel@orcl @upgrade_10131_10135_oracle.sql

Enter password for ORABPEL when prompted.

Upgrade ORAESB schema

cd /stage/soa_install/8626084/Disk1/install/soa_schema_upgrade/esb/sql/oracle

sqlplus oraesb@orcl @upgrade_10131_10135_oracle.sql

Switch command prompt to 32 bit mode

cd /stage/soa_install/8626084/Disk1

linux32 bash

Run Upgrade installer

./runInstaller -ignoreSysPrereqs

Welcome

Click Next.

Specify File Locations

Select the Oracle Home that corresponds to the Oracle Home for SOA

Click Next.

Email notifications

Uncheck the I wish checkbox and click Next.

Email Address Not Specified

Click Yes

Administrator (oc4jadmin) Password

Enter the password for the oc4jadmin user and click Next.

Specify Password for OWSM Schema

Enter Hostname, Port, Service Name and Password to access the ORAWSM schema and click Next.

Warning

Click OK in the warning dialog

Execute scripts

Prior to launching Configuration Manager, run these two scripts:

  • /oracle/as/product/10.1.3.1/OracleAS_1/ccr/bin/setupCCR -s -d
  • /oracle/as/product/10.1.3.1/OracleAS_1/OPatch/ocm/bin/emocmrsp

Press Enter at the Email Address/User Name: prompt.

Type Y and press Enter at the Remain uninformed of security issues prompt.

su -

Enter password for the root user and press Enter.

sh /oracle/as/product/10.1.3.1/OracleAS_1/root.sh

Setup Privileges

Click Ok in the setup privileges window.

Installation continues.

End of Installation

Click Exit.

Unzip patch 9841044

cd /stage/soa_install

unzip p9841044_10135_Generic.zip

Stop SOA

/home/oracle/stopsoa.sh

If you have not copied standard shutdown scripts, then run these commands:

cd
../soa.env
export ORACLE_HOME=$SOA_HOME
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=$ORACLE_HOME/OPatch:$PATH
export PATH=$ORACLE_HOME/opmn/bin:$PATH
opmnctl stopall

Apply Patch

cd /stage/soa_install/9841044

$ORACLE_HOME/OPatch/opatch apply

Type y at the Is the local system ready for patching? prompt.

Set the database home

. oraenv

Enter the service name for the soa database at the ORACLE_SID prompt.

Connect to database as orabpel

. /sqlplus orabpel/[password]@orcl

Alter session set nls_numeric_characters=�.,�;

@/oracle/as/product/10.1.3.1/OracleAS_1/bpel/system/database/scripts/upgrade_10135_10135mlr_oracle.sql

exit

Connect to database as oraesb

./sqlplus oraesb/[password]@orcl

@/oracle/as/product/10.1.3.1/OracleAS_1/integration/esb/sql/oracle/upgrade_10135_10135mlr_oracle.sql

exit

Patch 12351139

cd /stage/soa_install

unzip p12351139_101352_Generic.zip

cd 12351139

$ORACLE_HOME/OPatch/opatch apply

Type y at the Is the local system ready for patching? prompt.

Replace bundled Java with 64bit Java

Backup current jdk by renaming folder:

cd $SOA_HOME
mv jdk jdk32

Create symlink to the 64-bit jdk already installed:

cd $SOA_HOME
ln -s /opt/java/jdk1.6.0_32 jdk

Verify that the jdk folder points to the previous 64-bit jdk install: ll jdk

Verify that the jdk loads as expected: jdk/bin/java -version

Start the SOA Suite

sh startsoa.sh

Installation complete

Appendix

If DB_HOME and Database are not on the PROCESSIT Server

If the SOA Database (PROCESSIT Database/Dehydration Store) is installed on separate server/another host, do the following:

On the Database server that holds the Dehydration Store, tnsnames.ora on DB-server should point to EBSDB, and the host file on DB-server should point to readsoft.servers.ebs

Prior to SOA software install, transfer irca.zip and ojdbc.zip to Database Server (DS) and run the scripts using DB_HOME.

The following has to be done in order to be able to run the PROCESSIT Installer:

Entries in the host file for both EBS and DS, for example:

  • 127.0.0.1 localhost.localdomain localhost processit processit.readsoft.local soa soa.vm.net weblogic weblogic.readsoft.local processit_training01
  • 172.20.1.229 processit_training01
  • 172.20.1.184 ica001.readsoft.local abc001
  • 172.20.1.221 readsoft.servers.ebs oracle221

In processit.properteis db.root should point to $SOA_HOME

$SOA_HOME/network/admin/tnsnames.ora should contain entries for both EBS and DS, for example:

UTIL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ica001.readsoft.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = util.readsoft.local)
)
)
EBSDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = readsoft.servers.ebs)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RS221)
)
)

Create directories for the PROCESSIT Repository on PROCESSIT Server:

/oracle/repository/schemas

/oracle/repository/contracts

/oracle /repository/contracts

This should give all green in the Configuration Verification.