Introduction:

This is my first post under Fusion Middleware technology. In this post we will see how to install SOA and carry out the basic validation (sanity check) for the installed components.

Pre-Installation Steps

You can download SOA software from OTN. This software version available for download is 10.1.3.1. Once we install SOA 10.1.3.1, we will upgrade the same to 10.1.3.4 using patchset. SOA 10.1.3.4 patch set can be downloaded from metalink. The patchset checkin number is 7272722.

Before starting the SOA installation we need to do some pre-installation task. Every SOA suite installation needs a database (Oracle). Also we need to create 3 schemas in that database before we proceed with runInstaller of SOA suite.

Please carry out a installation of Oracle database server software and create a simple database. Also you need to have database version 10g R2 (10.2.0.2) for SOA installation.

Once the database is created you need to run irca.sh shell script. This script will be present in the software dump downloaded from OTN.

After unzipping the software in a directory, you can navigate to the following location

base_dir/install/soa_schemas/irca

Here you will find irca.sh.Before running this script, make sure that you set ORACLE_HOME and ORACLE_SID of the database you have installed. If the database is not installed on the same host, then you need to login to the server where database is installed and then run this script.

Run this script as shown below. You need to provide hostname, port # and database SID of the database you have installed.

-bash-3.00$ sh irca.sh
Integration Repository Creation Assistant (IRCA) 10.1.3.1.0
(c) Copyright 2006 Oracle Corporation. All rights reserved.

Enter database “host port serviceName” [localhost 1521 orcl]: rws60066rems 1618  obieebam
Enter sys password:
Enter sys password: Running IRCA for all product(s):
connection=”rws60066rems 1618  obieebam”, , orabpelUser=ORABPEL, esbUser=ORAESB, orawsmUser=ORAWSM

Validating database …
Validating database character set …
WARNING: The target database character set is WE8ISO8859P1
For multi-byte support, the AL32UTF8 character set is recommended.

Running prerequisite checks for ORABPEL …
Enter password for ORABPEL:
Loading ORABPEL schema (this may take a few minutes) …

Running prerequisite checks for ORAESB …
Enter password for ORAESB:
Enter password for ORAESB: Loading ORAESB schema (this may take a few minutes) …

Running prerequisite checks for ORAWSM …
Enter password for ORAWSM:
Loading ORAWSM schema (this may take a few minutes) …

INFO: ORABPEL schema contains 225 valid objects.

INFO: ORAESB schema contains 180 valid objects.

INFO: ORAWSM schema contains 90 valid objects.

IRCA completed.
Please check for any ERROR message above and also check the log file
/tmp/irca2008-12-31_01-54-01AM.log for any error or other information.

Also while running the script you need to provide password for sys, orabpel, oraesb and orawsm. It will set the password for orabpel, oraesb and orawsm.

Once this is down, you can start with the installation task of installing SOA.

Installation Step

From the SOA software dump, start the runInstaller using following command.

-bash-3.00$ ./runInstaller -invPtrLoc $HOME/oraInst.loc

Screen 1) Advanced Installation (For more option and flexibility go for Advanced installation)

Screen 2) Provide the path for inventory location

Screen 3) select “J2EE Server, Web Server and SOA Suite” for complete installation.

Screen 4) Verifying the system requirements

Screen 5) Database connection Information – You need to provide the connection information for the database you have installed before starting the SOA installation

Screen 6) Database Schema Passwords – Provide the database schema passwords for ORABPEL, ORAESB and ORAWSM. These will be same as what provided while running irca.sh script in  pre-installation step.

Screen 7) You can provide the file staticports.ini for custom ports, or you can accept the default ports.

Screen 8) Administration Settings – Provide the name for AS Instance and OC4J instance. You also need to set the password for administrator.

Screen 9) Cluster Topology Configuration – This is requrired for advanced installation in case if we have to configure a standby or a load balancing site. For this installation we are ignoring this step.

Screen 10) This screen will show the installation summary. You can click on Install.

At the end of installation it will ask you to run root.sh as a root user. After you run root.sh, you can click on OK on that dialog box. Configuration assistants will start, which will install all the components.

SOA gets installed in $HOME/product/10.1.3.1/OracleAS_1 direcory

Following are the different URLs that will be available

Enterprise Service Bus : http://rws60076rems.us.oracle.com:7777/esb

Enterprise Manger : http://rws60076rems.us.oracle.com:7777/em

BPEL Console : http://rws60076rems.us.oracle.com:7777/BPELConsole

Worklist Application : http://rws60076rems.us.oracle.com:7777/integration/worklistapp/Login

OWSM Control : http://rws60076rems.us.oracle.com:7777/ccore

Where 7777 is your HTTP port.

This version for SOA is 10.1.3.1 Now we need to upgrade the same to 10.1.3.4. Following are the steps for the same.

Upgrading the SOA to 10.1.3.4

Download and unzip the patch 7272722. After unziping you will get Disk1 and Disk2.

Before running runInstaller you need to carryout some pre-installation task.

Pre-Installation Step

Step 1) From the base directory where the patch was unziped, navigate to following directory

cd /base_dir/Disk1/install/soa_schema_upgrade/bpel/scripts

and run script upgrade_10131_10134_oracle.sql by connecting to SOA database as orabpel user

Step 2) From the base directory where the patch was unziped, navigate to following directory

cd /base_dir/Disk1/install/soa_schema_upgrade/esb/sql/oracle

and run script upgrade_10133_10134_oracle.sql by connecting to SOA database as oraesb user

Installation Task

Go to Disk1 and start the runInstaller.

./runInstaller  -invPtrLoc $HOME/oraInst.loc

Screen 1) Make sure you select the correct ORACLE_HOME here. This should be your SOA 10.1.3.1 Oracle Home.

Screen 2) Provide the oc4jadmin password you selected during SOA 10.1.3.1 installation

Installer will shutdown the SOA services. Click on OK and wait for some time.

Screen 3) After shutting down all services, you will see the summary screen. Click on Install.

At the end of installation it will ask you to run root.sh as a root user. Once that is done, it will start with configuration assistants.

After the installation you can bring up all the services. This completed SOA 10.1.3.4 installation.

Hope this helps !!