=============================== One-off Patch for Bug: 12979133 =============================== Date: Sep 15, 2011 ---------------------------------- Platform Patch for : Generic Product Patched : Oracle SOA Platform Product Version : 11.1.1.5.0 -auto enabled : No ****************************************************************************** ** NOTE: THIS PATCH IS INTENDED FOR SOA HEALTHCARE CUSTOMERS ONLY. IF YOU ARE ** JUST USING SOA SUITE OR SOA SUITE AND BPM - PLEASE CONTACT ORACLE ** SUPPORT TO CONFIRM THAT THIS IS RELEVANT FOR YOU. ****************************************************************************** Bugs Fixed by this patch: ------------------------- Bug 12413651 - soa 11.1.1.5.0 feature pack Bug 12319055 - soa 11.1.1.5.0 feature pack - em support Files included in this patch: ------------------------------ p12413651_ORACOMMON_111150_Generic.zip - Oracle SOA Suite Feature Pack Part 1 p12413651_SOA_111150_Generic.zip - Oracle SOA Suite Feature Pack Part 2 p12319055_111150_Generic.zip - Oracle SOA Suite Feature Pack Part 3 soa-jdev-extension.zip - Oracle JDeveloper Extension for SOA Certification : --------------- This patch has been certified for Windows and Linux platforms. Prerequisites: -------------- 1. SOA PS4 (11.1.1.5.0) and JDeveloper PS4 (11.1.1.5.0) should be installed and configured 2. Review and download the latest version of OPatch 11.1.x via Bug 6880880. (OPatch version 11.1.0.8.2 or higher) Oracle recommends that all customers be on the latest version of OPatch. Please review the following My Oracle Support note and follow the instructions to update to the latest version if needed: Note 224346.1 - Opatch - Where Can I Find the Latest Version of Opatch? For FMW Opatch usage, please refer to the doc at : http://download.oracle.com/docs/cd/E21764_01/doc.1111/e16793/opatch.htm#CBHGHAFA 3. Verify the OUI Inventory. OPatch needs access to a valid OUI inventory to apply patches. Validate the OUI inventory with the following command: - opatch lsinventory If the command errors out, contact Oracle Support and work to validate and verify the inventory setup before proceeding. 4. Confirm executables appear in your system PATH. The patching process will use the unzip and the opatch executables. After setting the ORACLE_HOME environment, confirm both of these exist before continuing: - "which opatch" - "which unzip" If either of these executables do not show in the PATH, correct the problem before proceeding. Pre-Install Instructions: ------------------------- - Stop all servers (AdminServer and all Managed server(s)) - IMPORTANT : Backup your database and middleware home. Install Instructions: --------------------- NOTE: ALL STEPS OUTLINED BELOW MUST BE FOLLOWED TO COMPLETELY INSTALL THE PATCH. Applying the Patches to the Common Oracle Home: ----------------------------------------------- 1. Set the ORACLE_HOME environment variable to the Oracle Common Home, for example "[MW_HOME]/oracle_common" directory. 2. cd /tmp PATCH_TOP sub-directory will be created by the next steps 3. Unzip the SOA Oracle Common patch zip file into the PATCH_TOP. unzip -d PATCH_TOP p12413651_ORACOMMON_111150_Generic.zip 4. Unzip the EM Oracle Common patch zip file into the PATCH_TOP. unzip -d PATCH_TOP p12319055_111150_Generic.zip 5. Set your current directory to the directory where the patch is located. cd PATCH_TOP 6. Run OPatch to apply the patches supplied. Run following command: $ORACLE_HOME/OPatch/opatch napply -invPtrLoc $ORACLE_HOME/oraInst.loc When OPatch starts, it will validate the patch and make sure there are no conflicts with the software already installed in the ORACLE_HOME. OPatch categorizes two types of conflicts: (a) Conflicts with a patch already applied to the ORACLE_HOME In this case, please stop the patch installation and contact Oracle Support Services. (b) Conflicts with subset patch already applied to the ORACLE_HOME In this case, please continue the install, as the new patch contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch. Applying the Patches to the SOA Oracle Home: -------------------------------------------- 1. Set the ORACLE_HOME environment variable to the SOA Oracle Home, for example "[MW_HOME]/Oracle_SOA1" directory. 2. cd /tmp PATCH_TOP sub-directory will be created by the next steps 3. Unzip the SOA Oracle patch zip file into the PATCH_TOP_SOA. unzip -d PATCH_TOP_SOA p12413651_SOA_111150_Generic.zip 4. Set your current directory to the directory where the patch is located. cd PATCH_TOP_SOA 5. Run OPatch to apply the patches supplied. Run following command: $ORACLE_HOME/OPatch/opatch napply -invPtrLoc $ORACLE_HOME/oraInst.loc When OPatch starts, it will validate the patch and make sure there are no conflicts with the software already installed in the ORACLE_HOME. OPatch categorizes two types of conflicts: (a) Conflicts with a patch already applied to the ORACLE_HOME In this case, please stop the patch installation and contact Oracle Support Services. (b) Conflicts with subset patch already applied to the ORACLE_HOME In this case, please continue the install, as the new patch contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch. Updating the Schemas using PSA: ------------------------------- 1. Set the ORACLE_HOME environment variable to the SOA Oracle Home, for example "[MW_HOME]/Oracle_SOA1" directory. 2. cd $ORACLE_HOME/bin 3. Run PSA to update your schemas $ psa -dbType -dbConnectString -dbaUserName -schemaUserName -invPtrLoc Example: psa -dbType Oracle -dbConnectString //host:port/service_name -dbaUserName sys -schemaUserName PFX_SOAINFRA -invPtrLoc $ORACLE_HOME/oraInst.loc Post Install Instructions: -------------------------- 1. Please refer to the Post Install Instructions for specific areas in the documentation - Health Care Integration Documentation http://www.oracle.com/technetwork/middleware/soasuite/documentation/healthcare-postinstall-ps4fp-487860.pdf NOTE: THESE POST INSTALL INSTRUCTIONS MUST BE COMPLETED BEFORE RESTARTING YOUR SERVERS. Documentation: -------------- 1. Updated Documentation for features included in this update can be found at: - Oracle Health Care Integration http://www.oracle.com/technetwork/middleware/soasuite/documentation/11gr1ps4featurepackdoc-462677.html#healthcare Deinstallation Instructions: ---------------------------- - Please contact Oracle Support.