Title
Applying Oracle SOA Suite 10g Patch Set 4 (10.1.3.4.0)

Date
2008-08-28

Summary
The Oracle SOA Suite 10g Patch Set 4 (10.1.3.4.0) for Windows is released in patch p7272722_101340_WINNT.zip (775,256,010 bytes).

These instructions assume the prerequisites described below.

Prerequisites
Oracle SOA Suite 10g (10.1.3.3.1) with:     
  • Windows version     
  • Non-clustered     
  • Advanced install     
  • Oracle Database 10g (10.2.0.3) (not OLITE)

    • Details
    1. Extract the software. 

    unzip p7272722_101340_WINNT.zip

    2. Run all prerequisite steps.

    a. Execute required SQL upgrade scripts: 
    sqlplus orabpel/password123 @e:\Disk1\install\soa_schema_upgrade\bpel\scripts\upgrade_10133_10134_oracle.sql
sqlplus oraesb/password123 @e:\Disk1\install\soa_schema_upgrade\esb\sql\oracle\upgrade_10133_10134_oracle.sql

    b. If you have configured adapters, then back up the oc4j-ra.xml files as they will be overwritten during patch application.
    They are located in: %ORACLE_HOME%\j2ee\oc4j_soa\application-deployments\default\<adaptername>\oc4j-ra.xml

    c. Edit %ORACLE_HOME%\owsm\bin\install.properties and confirm and/or set the following values: 
    install.http.host=myhostname
install.http.port=7777

    d. Ensure the OC4J instances are running: 
    opmnctl startall

    3. Run the patchset setup and click through the screens. 

    cd Disk1
setup.exe

    4. Run required post-installation steps.

    a. Edit %ORACLE_HOME%\Apache\Apache\conf\httpd.conf and ensure that the following configuration is identical to: 
    #LoadModule php4_module modules/php4apache.dll
#AddModule mod_php4.c
LoadModule php5_module modules/php5apache.dll
AddModule mod_php5.c
AddType application/x-httpd-php .php .php5
AddType application/x-httpd-php-source .phps

    b. Edit %ORACLE_HOME%\j2ee\oc4j_soa\config\data-sources.xml and set all factory-class attributes similar to below: 
    <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" url="jdbc:oracle:thin:scott/tiger@stadd14:1521:db5617"/>

    Applicable Versions
    Oracle SOA Suite 10g (10.1.3.3.1)

    References
    Oracle Application Server Patch Set Notes 10g Release 3 (10.1.3) Patch Set 4 (10.1.3.4.0) for Linux x86 and Microsoft Windows (32-Bit)
    Ahmed Aboulnaga
    .com .com