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.zipgunzip 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
- Open a new terminal window and log in as root.
- Run these scripts:
sh /oracle//oraInventory/orainstRoot.shsh /oracle/db//product/11.2.0/dbhome_1/root.sh
- Press Enter to the full path for local bin dir. Or type
/usr/local/bin - Return to the execute conf. ass. window.
- 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.