Tuesday, June 12, 2012

Installation In WIN 7

SOA 10g versions are not certified with Windows 7. However WIN 7 in 64 bits and here Oracle don't have direct compatible installer for this operating system.Here we can do couple of workaround steps to make successful installation of SOA in windows 7.

Installation Summary:
  • Make sure you downloaded all the SOA suite software from oracle partner link.
  • JAVA Installation.
  • Install XE database.
  • Install SOA 10.1.3.1 
  • Upgrade to SOA 10.1.3.5


JDK Installation

Note - Ignore this step if the proper JDK already been installed.

1. Download JDK 1.6v (jdk1.6.0_31) with 64 bits compatible one and Install the same.

2. Set the JAVA_HOME. 


Oracle XE 11g Database Installation:


  1.   Before installation check the oraparam.ini (\disk\install) file and find out for the following stuff and if you don't find 6.1 & 7.0 then add the same as follows :
[Certified Versions]
#You can customise error message shown for failure, provide value for CERTIFIED_VERSION_FAILURE_MESSAGE
Windows=5.0,5.1,5.2,6.0,6.1,7.0

2. Install XE database.

 SOA 10.1.3.1 Installation:


1Copy the ojdbc14.jar file and place this file in XE Database folder location.  
     Ex: OracleXE11\app\oracle\product\11.2.0\server\jdbc\lib      

Note: You can find this jar file in Jdeveloper 10135 folder location.

2. As explained in above step here also need to check & modify the oraparam.ini (\disk\install\) file.

3. Run irca.bat and provide the Database details to create the required schemas.

4Unzip the 10.1.3.5 patch (ias_windows_x86_101350) and check the following folders to fix the couple of bugs -
  • bug_6258398_071004 
ü Copy ContentServicesQueries.jar  from this folder  and replace this file in  10.1.3.1 installation folder (Disk1/stage/Queries/ContentServicesQueries/58.0.0.0.0/1/)
  • bug_6265268_071004 : 
ü Copy  DBConnectQueries.jar from this folder and replace this file in 10.1.3.1 installation folder (Disk1/stage/Queries/DBConnectQueries/8.5/1/)

ü Copy  IP_DBQueries.jar from this folder and replace this file in 10.1.3.1 installation folder (Disk1/stage/Queries/IP_DBQueries/3.0/1/)

 5. Now we can start the SOA installation without any issues.


SOA 10.1.3.5 Patch Installation:


1. As explained in above step here also need to check & modify the oraparam.ini (\disk\install\) file.

2. Run upgrade_10131_10135_oracle.sql (\10135\ias_windows_x86_101350\Disk1\install\soa_schema_upgrade\bpel\scripts
) à connect to the SOA database with BPEL schema and execute this sql script.

3.  Run upgrade_10131_10135_oracle.sql (\10135\ias_windows_x86_101350\Disk1\install\soa_schema_upgrade\esb\sql\oracle
) à connect to the SOA database with ESB schema and execute this sql script.

4Unzip the 10.1.3.5 patch (ias_windows_x86_101350) and check the following folders to fix the couple of bugs -

  • bug_6258398_071004 
ü Copy ContentServicesQueries.jar  from this folder  and replace this file in  10.1.3.5 installation folder (Disk1/stage/Queries/ContentServicesQueries/59.0.0.0.0/1/)
  • bug_6265268_071004 : 
ü Copy  DBConnectQueries.jar from this folder and replace this file in 10.1.3.5 installation folder (Disk1/stage/Queries/DBConnectQueries/8.5/1/)

ü Copy  IP_DBQueries.jar from this folder and replace this file in 10.1.3.5 installation folder (Disk1/stage/Queries/IP_DBQueries/3.0/1/)

 4. Now we can start the SOA patch installation without any issues.