File Adaptor and Database Adaptor

Reading a file using file adaptor and inserting into database using DB Adaptor

configuring Database Adaptor in Application server

Login to em console ->cluster toplogy->oc4j_soa->Administration->JDBC Resources
connection pools->
create Name - filedbconn
Connection Factory Class oracle.jdbc.pool.OracleDataSource
URL : jdbc:oracle:thin:@//localhost:1521/xe
Username : system
Password : oracle

creating Datasource connections

login in to em console ->cluster toplogy->oc4j_soa->Administration->JDBC Resources
Datasources->create ->select Manage Datasource -> continue

Application Name : default
JNDI Location : jdbc/localdbtest
Type : Manage Datasource
Connection Pool : filedbconn(select existing connection pool name)
Transaction Level : Global & Local Transactions
Name : LocalDBDatasource

configuring Database Adaptor

go to em console ->cluster toplogy->oc4j_soa->Applications->default ->DBAdaptor
Connection Factory Interface - javax.resource.cci.ConnectionFactory
JNDI Location - eis/apps/LocalDatabase
xADataSourceName - jdbc/localdbtest (is the name of JNDI Location in Datasource)

Create BPEL Process



select empty BPEL process



Configure file adaptor



Enter Service Name



select Readfile

Connecting to Oracle SOA Server 10g from Jdev 10g

Here I would like to show how to connect Jdeveloper to Oracle SOA Suite servers.
This includes connecting to Oracle XE Database, Oracle Application Server and Integration Server


1) Establish Connection from Jdeveloper to Oracle Database

Start Jdeveloper open the Connections Navigator tab, and double-click Database to launch the Create Database Connection wizard



Right click on Database Server and select New Connection a Connection wizard appears click next

Connection Name: DBDemoConn
Connection Type: Oracle (JDBC)



Click next and enter Database Username/Password system/welcome1



Click next and give Host Name, JDBC Port and SID



Click on Next, and Test Connection



2) Establish Connection from Jdeveloper to Application Server
Open the Connections Navigator tab, and double-click Application Server. Create Application Server Connection wizard appears



I have given Connection Name, Connection Type as SOA_Appserver, Oracle Application Server 10g 10.1.3



Click next and type Username/Password oc4jadmin/admin123

Specify Host Name, OPMN Port, oc4j Instance name
OPMN Port can be found from Runtime Ports in Application Server console






Click on Next, and Test Connection



3) Establish Connection from Jdeveloper to Integration Server (BPEL)
Open the Connections Navigator tab, and double-click Integration Server. Create Integration Server Connection wizard appears



I have given connection name as SOA_Intserver and click next



Once you select Application Server the details will be populated automatically in the Integration Server.



Click next and Test Connection the status of Application Server, BPEL, ESB Servers should be OK

"An unknown OPMN error has occurred""Error connecting to OPMN (is it running?): Connection refused: connect"

Stop all opmn and related process forcefully if does not stop from "stop SOA suite" script

Rename persistence to persistence.old in \SOA_HOME\OracleAS_1\j2ee\oc4j_soa\persistence

we will not be able to rename the folder if opmn or any related process is still running.

Use the following command to start SOA suite

opmnctl start
opmnctl startproc process-type=HTTP_Server
opmnctl startproc process-type=${oc4j_instance_name}
opmnctl startproc process-type=oc4j_soa

Upgrading Oracle SOA Suite 10.1.3.1 to 10.1.3.5

To Upgrade Oracle SOA Suite to 10.1.3.5 Oracle Application Server 10g patch 8626084 is available.

we can apply this Patch to existing versions of Oracle SOA Suite(10.1.3.x)

I have upgraded OracleSOA 10.1.3.1 to 10.1.3.5 on windows wanted to share it

Upgrading SOA 10.1.3.1 to 10.1.3.5

1)Upgragde ORABPEL and ORAESB schemas before applying patch

Run ORABPEL Schemas
Connect to Database as ORABPEL User and run upgrade_10131_10135_oracle.sql located in
\10.1.3.5\ias_windows_x86_101350\Disk1\install\soa_schema_upgrade\bpel\scripts


Run ORAESB Schemas
Connect to Database as ORAESB User and run upgrade_10131_10135_oracle.sql located in
\10.1.3.5\ias_windows_x86_101350\Disk1\install\soa_schema_upgrade\esb\sql\other

2)Install SOA Suite
click setup.exe from \soa10.1.3.5\ias_windows_x86_101350\Disk1

3)specify existing SOA Suite Path and oc4jadmin Password
oc4jadmin password : welcome1

4)we need to give OWSM Database Password for SOA 10.1.3.5 Patch
Host Name,Port,ServiceName,OWSM Password.

5)click Configure Assistances.It will try to install

Installation of Oracle SOA Suite 10.1.3.1

Before Installing SOA Suite we must check the following

Install Oracle Database Installation of Oracle SOA Suite requires the availability of an Oracle database. This database must be up and running, and does not have to be on the same system where you are installing the products.
Memory Requirements Minimum physical memory 2GB and available memory 1GB
JDK 1.4 or 1.5 and set ORACLE_HOME and JAVA_HOME path

Create Schemas for Oracle SOA Suite

Oracle SOA Suite require that certain schemas exist in the database prior to installation (advanced)

Load ORABPEL,ORAESB,ORAWSM Schemas into Database

Navigate to \SOA Suite\install\soa_schemas\irca
set JAVA_HOME,ORACLE_HOME path in irca file

Run irca with following options

irca all|orabpel|oraesb|orawsm "db_host db_port db_service_name" sys_password -overwrite ORABPEL ORABPEL_PASSWD ORAESB ORAESB_PASSWD ORAWSM AWSM_PASSWD>

ex: irca all " localhost 1521 XE" welcome1 -overwrite ORABPEL oracle ORAESB oracle ORAWSM oracle

go to \SOA Suite\ setup and install

select Advance installation

specify Database configurations

username
Password
host:port
servicename

Enter Application Server Instance name,username,password:welcome1

Instance name : oc4j_soa and click install it will take some time for installation