11g OSB Installation separately with Derby Server

11g OSB Installation separately with Derby Server:-

OSB 11g Installationn with Derby Server:-

Required Softwares:

wls1033_oepe111150_win32.exe

ofm_osb_generic_11.1.1.3.0_disk1_1of1.zip

--------

First, Install WLS with OEPE

wls1033_oepe111150_win32.exe

then Install OSB 11g

C:\Siva\Softwares\11g OSB with Derby server\ofm_osb_generic_11.1.1.3.0_disk1_1of1\osb\Disk1>setup.exe -jreLoc C:\Siva\Installations\11gOSB\Oracle\Middleware\jdk160_18

-----------

Then configure the OSB domain

C:\Siva\Installations\11gOSB\Oracle\Middleware\oracle_common\common\bin> config.cmd

Even if it fails with 1527 connection to the Derby Server, please move ahead

------------

Starting and Stopping the OSB Server

C:\Siva\Installations\11gOSB\Oracle\Middleware\user_projects\domains\base_domain>startWebLogic.cmd

URLs:

http://localhost:7001/sbconsole

http://localhost:7001/console
----------------

 

Retrieving or Selecting key/values from Array list without using while loop in BPEL

Retrieving or Selecting key/values from Array list without using while loop

We usually make use of while loop to select indexed key/value pair in the middle of execution of BPEL and this is too cumbersome and performance not good. Hence, use the below xpath syntax to get value for the respective key from the array list of key/value pairs.

/client:ArrayTestProcessRequest/client:cust[contains(client:Name,'Siva')]/client:Value

/client:ArrayTestProcessRequest/client:cust[client:Name='Siva']/client:Value

Respective schema would be like:

 

 

  

   

    

     

      

      

     

    

   

  

 

  

   

    

     

      

      

     

    

   

  

 

Step by Step Installation of SOA Suite 11g with OSB - 11gPS3

I had installed SOA Suite 11g many times on various environments and jotted down the steps I had followed and felt like this would be useful to all of us and posting the same here.

If you are going to install the SOA Suite 11g, kindly have a look at the steps below for clear understanding:


SOA PS3 11.1.1.4 Installationn with OSB:-

Installing the Oracle XE:

OracleXEUniv.exe

sys/manager

and then tune the DB by using the below SQLs

connect sys/manager@XE as sysdba
show parameter session
show parameter processes
alter system reset sessions scope=spfile sid='*';
alter system set processes=300 scope=spfile;
shutdown immediate
startup
show parameter session
show parameter processes

--
Installing the WLS:

the installable should contais the WLS + Coherence + OEPE

wls1034_oepe111161_win32.exe

--
Creating the schemas using RCU:

ofm_rcu_win_11.1.1.4.0_disk1_1of1.zip

pre-check before running RCU

set RCU_JDBC_TRIM_BLOCKS=TRUE
echo %RCU_JDBC_TRIM_BLOCKS%

D:\Softwares\PS311114\ofm_rcu_win_11.1.1.4.0_disk1_1of1\rcuHome\BIN>rcu.bat

Password for the schema users: welcome1

--
Installing the SOA Suite:

ofm_soa_generic_11.1.1.4.0_disk1_1of2.zip
ofm_soa_generic_11.1.1.4.0_disk1_2of2.zip

D:\Softwares\PS311114\ofm_soa_generic_11.1.1.4.0_disk1_1of2\Disk1>setup.exe -jreLoc D:\ICE\Oracle\Middleware\jdk160_21

--
Installing the OSB:

V24316-01.zip

D:\Softwares\PS311114\osb\V24316-01\Disk1>setup.exe -jreLoc D:\ICE\Oracle\Middleware\jdk160_21

--

Configuring the OSB and SOA:

D:\ICE\Oracle\Middleware\oracle_common\common\bin>config.cmd
--

Installing the JDeveloper:

jdevstudio11114install.exe

and then SOA Compositor extension.

soa-jdev-extension.zip

Finally, Happy SOA Development!!!
----------------------------------------------------------------------------