Install/Configure SOA Repository (Dehydration Store – ORABPEL, ORAESB, ORAWSM) in 11g Database
As per Oracle SOA Suite (10.1.3.1 or 10g AS R3 Patchset 1) Installation document, You can use Oracle Database 9i or 10g (XE – Express Edition, SE – Standard Edition or EE – Enterprise Edition) as repository for SOA Suite (dehydration store) schema i.e. ORAESB, ORABPEL and ORAWSM.
As per new certification Matrix for Oracle Fusion Middleware (SOA Suite, WebCenter, Oracle AS 10g R3) here , Oracle 11g Release 1 and higher (11.1.0.6 +) is supported with SOA Suite.
To use 11g R1 (11.1.0.6+) as SOA suite repository copy ojdbc14.jar from 10g ORACLE_HOME/jdbc/lib/ TO 11g ORACLE_HOME/jdbc/lib/
.
Things good to know about Oracle SOA Suite Database :
1. If you are installing SOA suite on Windows (Basic Installation) SOA suite installation automatically installs Oracle 10g Express Edition Database (XE).
2.If you are installing SOA suite on Windows (Advanced Installation), you first have to install Oracle Database 9i/10g/11g and then populate SOA Schema (ORABPEL, ORAESB, ORAWSM) using irca.sh
3.If you are installing SOA suite on Unix/Linux (Basic or Advanced Installation), you first have to install Oracle Database 9i/10g/11g and then populate SOA Schema (ORABPEL, ORAESB, ORAWSM) using irca.sh
Issue with 11g Database with SOA Suite: while running irca.sh (Integration Repository Creation Assistance Tool with 11g Database fails with ojdbc14.jar not found)
./irca.sh
Integration Repository Creation Assistant (IRCA) 10.1.3.1.0
(c) Copyright 2006 Oracle Corporation. All rights reserved.
ERROR: Cannot find library – $11g_ORACLE_HOME/jdbc/lib/ojdbc14.jar
Please verify that the ORACLE_HOME is set correctly.
Fix :copy ojdbc14.jar from <10g_oracle_home>/jdbc/lib and place them in <11g_oracle_home>/jdbc/lib