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

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

3 comments
sriram says May 13, 2009

If you are installing SOA 10g on 11g database, first and foremost, install patch 6265268. If not you will not be getting beyond the “Database connection information” screen on the installer.

cheers,
Sriram

Reply
K Maheshwar Rao says November 20, 2009

But what exactly it will do when we typically use basic installation or Advanced installation.

What are features which we get and which we don’t in Basic comparatively to Advanced Installation.

please explain for both the versions 10g and 11g

Reply
Karthikeyan says April 21, 2010

I need to whether BPEL is certified for R12 ??

Reply
Add Your Reply