Oracle® SOA Suite Installation Guide for SQL Server 2005 as BPEL Dehydration Store 10g Release 3 (10.1.3.3) for UNIX and Microsoft Windows Part Number E12015-01 |
|
|
View PDF |
This chapter provides the requirements and procedures for installing Oracle SOA Suite with SQL Server 2005 as BPEL dehydration store.
This chapter contains the following topics:
You can install and use Oracle SOA Suite with the SQL Server 2005 as BPEL dehydration store.
Oracle SOA Suite provides a complete set of service infrastructure components for designing, deploying, and managing composite applications. Oracle SOA Suite enables services to be created, managed, and orchestrated into composite applications and business processes. Composites enable you to easily assemble multiple technology components into one SOA composite application. Oracle SOA Suite plugs into heterogeneous IT infrastructures and enables enterprises to incrementally adopt SOA.
Oracle Business Rules (Business Rules) and Oracle Adapters plug into the Service Infrastructure, a normalized transport infrastructure, make up the Enterprise Service Bus (ESB). With the addition of the Oracle BPEL Process Manager (BPEL) and Human Task service components, the suite forms a complete Business Process Management (BPM) platform.
The following components comprise Oracle SOA Suite:
Oracle Enterprise Service Bus (ESB)
Oracle BPEL Process Manager (BPEL)
Human Task
Oracle Web Services Manager (OWSM)
Oracle Business Rules
Note:
In the Oracle SOA Suite components, only BPEL and Human Task will use SQL Server 2005 as the database.Oracle SOA Console is the monitoring environment for Oracle SOA Suite. You can run, manage, and test your deployed SOA process using the Oracle SOA Console. Oracle SOA Console provides a Web-based interface for management, administration, and debugging of processes deployed to Oracle SOA Server.
Table 1-1 describes the system requirements for using Oracle SOA Suite with SQL Server 2005 as BPEL dehydration store.
Table 1-1 Oracle SOA Suite System Requirements
Element | Requirement |
---|---|
Oracle SOA Suite for OC4J |
Apply SOA Suite patchset 10.1.3.3 on Oracle SOA Suite 10.1.3.1 Note: Refer to Step 1: Install Oracle SOA Suite Basic 10.1.3.1.0 for OC4J for installing Oracle SOA Suite for OC4J. |
Web browsers |
Internet Explorer 6.0 or Mozilla Firefox 2.0 |
Operating systems |
Microsoft Windows 2003 Server (for Oracle SOA Suite and Microsoft SQL Server DB), Red Hat Enterprise Linux release 3, and Red Hat Enterprise Linux release 4 (for Oracle SOA Suite) |
BPEL dehydration store database |
Microsoft SQL Server 2005 SP2 |
This section describes the steps involved in installing and configuring the Oracle Database, creating a schema in the database, and installing and configuring Microsoft SQL Server.
This section contains the following topics:
Step A: Install Oracle Express Edition (XE) Database (For Linux Operating System)
Step B: Create the Oracle SOA Suite Schema in the Oracle XE Database (For Linux Operating System)
Step 6: Configure Oracle SOA Suite and Create SQL Server Database IRCA schema
Note:
Installation of Oracle SOA Suite Basic 10.1.3.1.0 for OC4J on Linux requires an Oracle Database with Oracle SOA Suite Schema as a prerequisite. This installation cannot be performed connecting directly to the SQL Server 2005 database. Hence, if you are installing on Linux, you need to follow the additional (UNKNOWN STEP NUMBER) Step A: Install Oracle Express Edition (XE) Database (For Linux Operating System) and Step B: Create the Oracle SOA Suite Schema in the Oracle XE Database (For Linux Operating System) prior to proceeding with Step 1: Install Oracle SOA Suite Basic 10.1.3.1.0 for OC4J.If you are installing on Windows, then you can directly start with Step 1: Install Oracle SOA Suite Basic 10.1.3.1.0 for OC4J.
Perform the following steps:
Download the Oracle Database 10g Express Edition for Linux from the Oracle Database 10g Express Edition Downloads Web site at
http://www.oracle.com/technology/software/products/database/xe/index.html
Install the Oracle XE Database on Linux following the instructions provided in the Oracle Database Express Edition Installation Guide available at
http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25144/toc.html
Perform the following steps:
Navigate to the Disk1\install\soa_schemas\irca
folder in the Oracle SOA Suite installation setup files directory.
Set ORACLE_HOME
to point to the Oracle XE Database installation location. For example, set ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
.
Enter ./irca.sh
.
This runs the irca
script to create the schemas required for BPEL, ESB, and OWSM.
Enter the host, port, and SID values when prompted. The default SID created on XE database is "XE".
Enter the sys password when prompted.
The orabpel, oraesb, and orawsm schemas are loaded into the Oracle XE Database.
The install instructions to install basic Oracle SOA Suite 10.1.3.1 for OC4J are available from the Oracle SOA Suite 10g Software Downloads Web site at
http://www.oracle.com/technology/software/tech/soa/index.html
Note:
In this step, you are required to install only the basic installation of Oracle SOA Suite 10.1.3.1, and not the advanced.You must download the Oracle SOA Suite patchset 10.1.3.3 from OracleMetaLink and then apply the patchset on Oracle SOA Suite 10.1.3.1. Perform the following steps:
Log in to OracleMetaLink at http://metalink.oracle.com. The OracleMetaLink home page is displayed.
Click Patches & Updates. The Patches & Updates page is displayed.
Click Simple Search.
In the Search By field, enter 6148874
. The details of the patchset 6148874 are displayed.
Follow the instructions in the patchset to install the patchset on the Oracle SOA Suite 10.1.3.1.
Shut down the Oracle SOA Suite Post patch upgrade as follows:
For... | Run... |
---|---|
Windows XP | SOA_HOME\opmn\bin> opmnctl stopall |
Linux | SOA_HOME\opmn\bin> ./opmnctl stopall |
You must download the 6729033 patchset from OracleMetaLink and then apply the patchset on Oracle SOA Suite 10.1.3.3.
Log in to OracleMetaLink at http://metalink.oracle.com/. The OracleMetaLink home page is displayed.
Click Patches & Updates. The Patches & Updates page is displayed.
Click Simple Search.
In the Search By field, enter 6729033. The details of the patch 6729033 are displayed.
Download the p6729033_101330_Generic.zip
file for bug 6729033.
Follow the instructions given in the Readme.txt
file of patch 6729033 and apply the patch on Oracle SOA Suite 10.1.3.3.
To install SQL Server 2005, follow the instructions given in the Microsoft SQL Server Web site at
http://www.microsoft.com/sql/default.mspx
To apply Service Pack 2 on SQL Server 2005, follow the instructions given in the Microsoft SQL Server 2005 Service Pack 2 Web site at
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
Extract the Config_BPELPM_SQLServer2005.zip
file to the Config_BPELPM_SQLServer2005
folder.
Download Microsoft SQL Server 2005 JDBC Driver 1.2 from the Microsoft SQL Server 2005 JDBC Driver 1.2 Web site at
http://www.microsoft.com/downloads/details.aspx?FamilyID=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en
Copy the sqljdbc.jar
file from the downloaded driver pack found in the sqljdbc_1.2\enu\sqljdbc.jar
directory into the Config_BPELPM_SQLServer2005\lib
directory.
Create SQL Server database IRCA schema.
Edit the Config_BPELPM_SQLServer2005\irca_sqlserver.properties
file and supply the following SQL Server database parameters:
Parameter | Description |
---|---|
Db_url |
Database URL for the SQL Server database |
DB_SA_USER |
System Admin UserId having grants to create new database |
DB_SA_PASSWORD |
Password for System Admin UserId |
DB_ORABPEL_PASSWORD |
Password for orabpel Dbuser used for BPEL dehydration |
For Windows, run the Config_BPELPM_SQLServer2005\irca_sqlserver.bat
script, and for Linux, run Config_BPELPM_SQLServer2005/irca_sqlserver.sh
.
Verify the output log file at Config_BPELPM_SQLServer2005\logs\irca_sqlserver.out
and check for any failures.
The above script creates an ORCL
database, ORABPEL
schema, ORABPEL
user and creates all the database objects required for BPEL dehydration store in the SQL Server database.
Configure Oracle SOA Suite Server for SQL Server dehydration.
Edit the Config_BPELPM_SQLServer2005\config.properties
file and supply the following SQL Server database parameters:
Parameter | Description |
---|---|
SOA_HOME | ORACLE_HOME of the Oracle SOA Suite installation |
DB_URL |
Database URL for the SQL Server database that you created in Step a |
DB_ORABPEL_PASSWORD |
Password for orabpel Dbuser used for BPEL dehydration |
For Windows, run the Config_BPELPM_SQLServer2005\config.bat
script, and for Linux, run Config_BPELPM_SQLServer2005/config.sh
.
Verify the output log file at Config_BPELPM_SQLServer2005\logs\config.out
and check for any failures.
The above script configures the data sources, necessary drivers, and system properties in Oracle SOA Suite to connect to SQL Server database for BPEL dehydration.
This section describes the postinstallation verification tasks to be performed:
Start SOA Suite from Start -> Programs -> Oracle-SOASuite -> Start SOA Suite.
Access Enterprise Manager console from http://<hostname>:<port>/em.
Navigate to OC4J_HOME -> Administration -> JDBC Resources.
Verify that the BPELPM_CONNECTION_POOL
connection pool points to the SQL Server database, as shown in Figure 1-1.
This section describes the limitations for Oracle SOA Suite 10.1.3.1 on SQL Server 2005:
Only the BPEL dehydration store is configured to use SQL Server as the database. If the basic version of Oracle SOA Suite has been installed on Windows, then ESB and OWSM will continue to run with OLite as the database.
Due to syntax differences between Oracle and SQL Server database, particularly for OUTER JOIN
statements, the dehydration database instance on SQL Server will be set to a database compatibility level of 80. Future versions of SQL Server database may not continue to support this compatibility.
Troubleshooting Tips
If the TaskManager
and TaskActionHandler
BPEL processes are not deployed in the default domain, then stop Oracle SOA Suite, copy the following bpel jars from SOA_HOME\bpel\install\extensions
to SOA_HOME\bpel\domains\default\deploy
, and start Oracle SOA Suite again.