Wednesday, July 07, 2010

Install (BPM)Business Process Management in SOA Suite 11.1.1.3

BPM was a separate installer till SOA Suite 11.1.1.2

but with SOA suite 11.1.1.3 BPM comes as a part of SOA Suite .So if you are upgrading yourself to SOA Suite 11.1.1.3 you will get BPM also as a product installed with SOA Suite.

For this document i believe you already have installed

database
RCU 11.1.1.3
Weblogic server 10.3.3
SOA Suite 11.1.1.3

In this document i will just show how to configure a domain for BPM and the issues that you may face while creating a domain.

First of all go to SOA_HOME\common\bin folder and double click on config.cmd it will start a configuration wizard as shown



Please check what all things we need to select for BPM














While testing the configuration i got some error as shown below




Don't know the exact reason of this isssue but i did following to overcome this issue.

The installer was just looking for a table schema_version_registry ,i verified with other schemas and they were just returning a result of 1 so i did the following

i logged in to database using DEV_SOAINFRA as user as this was the schema which is getting failed and i ran the following command


CREATE TABLE schema_version_registry(owner VARCHAR2(20), mr_type VARCHAR2(10), version VARCHAR2(50));


INSERT INTO schema_version_registry VALUES ('DEV_SOAINFRA','SOAINFRA','11.1.1.3.0');




and surprisingly it went fine when i re ran the test.


so it will be applicable to all these type of issues which you get during installation

schema_version_registry there is no mr_type='MDS' . do v need to run any scripts for it.
following is the problem while configuring soa 11g
Component Schema=SOA MDS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521/oracle11
User=DEV_MDS
Password=*******
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='MDS' and version='11.1.1.2.0'

There is one more workaround which has worked for me that is run rcu again and create a new prefix,by default the prefix in dev so the next time when you will run the rcu it will create a schema with dev1 prefix ,Now while creating the domain use dev1 prefix instead of dev and this should too work fine.







REmove all the managed server as the minimum space required for BPM is 3gb so i am not creating any managed server.
















Now if you try to start the server you migh face an issue that the command console itself will vanish this is beacause your available RAM size is very less.

I would reommend to make available atleast 4gb of RAM to make it work properly.However there is a workaround for this issue.

GO to bea_home\user_projects\domains\base_domain\bin

and open setSOADomainEnv.cmd

there change the

set DEFAULT_MEM_ARGS=-Xms512m -Xmx1024m

parameter as per your requirement

i changed it to

set DEFAULT_MEM_ARGS=-Xms512m -Xmx512m

as i have only 2gb of memory available and it worked for me.

1 comment:

Anonymous said...

Thanks - today I was struggling with same error and your solution helped me :-)