Translate

How to create a Large Profile SOA 12c Repository running RCU in Silent Mode

One of the really nice features of SOA 12c is the ability to automatically create partitioned instance tables in the SOA repository. To do this you need to specify a LARGE "Database Profile" in RCU when you install the system:

Specifying Custom Variables in SOA 12c

(see http://docs.oracle.com/middleware/1213/core/RCUUG/rcu_screens.htm#RCUUG381)

Unfortunately none of the documentation that I found (even now, a year after SOA 12c was released) tells you how to do this when running RCU in silent mode. This might have been the obvious place to mention 
it:
 https://docs.oracle.com/middleware/1213/core/INSOA/planning.htm#INSOA524

On the RCU command line what you need to do is specify the SOA_PROFILE_TYPE variable (which sounds obvious once you know!), e.g.:
$ORACLE_HOME/oracle_common/bin/rcu -silent -createRepository -connectString <db_connect_string> -dbUser <db_user> -dbRole <db_role> -useSamePasswordForAllSchemaUsers true -schemaPrefix <schema_prefix> -variables SOA_PROFILE_TYPE=LARGE <components> -f < <password_file>

The valid values, as the screen-shot above suggests, are LARGE, MED (not medium) and SMALL. LARGE is the only option to produce partitioned tables. Both MED and SMALL produce an identical SOAINFRA schema in the current release but I assume Oracle might be thinking of more optimisation options later.
Note: the O-box SOA appliance uses partitioned tables for the SOA repository by default - the Partitioning Option for the Oracle Database is relatively inexpensive and, even with the built-in repository purging scripts in 12c, setting up partitioning from the start is much easier than migrating later when a system is very busy or has grown dramatically in size.

No comments:

Post a Comment