0digg

1.       To Install Oracle SOA you need the following to be installed in the order specified. The Oracle SOA suite page can be found here: SOA Suite. Also refer to the link Oracle Fusion Middleware 11gR1 Software Downloads for each of the components detailed below. Please note that the software needs to be installed in the order provided below:

a.       Oracle DB(You can use XE edition). This database would store the schemas for various products that get installed as part of the SOA installation. You can get the latest version of the XE Database here : 

                                                               i.      This is a fairly straightforward process if you are installing XE edition.

                                                             ii.      Once installed ensure that you set the following environment variables:

1.       ORACLE_HOME: I installed this on windows and the value I set for this was: C:\oraclexe\app\oracle\product\10.2.0\server

2.       TNS_ADMIN: This value was set to: C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN

3.       Navigate to the directory $ORACLE_TOP\dbs and modify the file:

a.       SPFILEXE.ora and set the parameters:

b.      Processes to 500

c.       Open_cursors to 500. This is essential when the repository creation utility is run.

b.      Oracle Repository Creation Utility

                                                               i.      This is responsible for creating the various schemas for the products to be installed. The repository creation utility does a check on the database to see if it is the right version . If it finds that the database is not the right version it might fail with an error message. To circumvent this problem you need to modify the ComponentInfo.xml file that is located under : \rcu\config\ComponentInfo.xml

                                   You need to find the following text and modify the pre-req value from 0 to 1. This is a hack to ensure that the installation succeeds on an XE database without requiring a full blown db. The check is merely performed to ensure that this db is not used as a production database. As such databases beyond 10.2.0.4.0 are supported for SOA installation but in a development environment it is not required.

01	<DBPrerequisite PREREQ_TYPE="CustomSQL" DATA_TYPE="NUMBER"COMPARE_OPERATOR="EQ">

02	<ValidIf  DBTYPE="ORACLE" >

03	<CustomQueryFilter DATA_TYPE="NUMBER" COMPARE_OPERATOR="EQ"VALUE="0">

04	select 1 from dual where exists (select column_name from dba_tab_columns where table_name(+) like 'V_$INSTANCE' and column_name(+) = 'EDITION') union select 0 from dual where not exists (select column_name from dba_tab_columns where table_name(+) like 'V_$INSTANCE' and column_name(+) = 'EDITION')

05	CustomQueryFilter>

06

ValidIf>

07	<PrereqIdentifier>select count(*) from product_component_version  where product like 'Oracle%Database%'  AND version BETWEEN '11' AND '11.1.0.6.0' PrereqIdentifier>

08	<PrereqValue>0PrereqValue>

09	<PrereqErrorMsg>

10	The database you are connecting is not a supported version.  Enter Database with version equal to or higher than 10.2.0.4.0 in 10g or version equal to higher than 11.1.0.7.0 in 11g. Refer to the certification matrix for supported DB versions

11	PrereqErrorMsg>

12	DBPrerequisite>

                                    Modify the PreReq value from 0 to 1 and the installation would go through. Ignore the warning message.

c.       Oracle Weblogic webserver : This is the application server that hosts all the applications and plugins that you wish to install and deploy.

d.      Oracle SOA suite. This is the application provided by Oracle to support the Oracle SOA infrastructure.

e.      Oracle Jdeveloper: This is the development tool to develop SOA / FMW applications