April 15, 2013 by Arik Lalo
You might get the bellow erros during Oracle DB installation, or, when trying to connect Oracle DB:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
One of the main causes of this error is due to a wrong setting in the hosts file under /etc folder.
To solve this error, first check what is the server IP address, by running the command:
# ifconfig
From the output, copy the value of the “inet addr” parameter (for example: 10.0.0.1).
Edit the hosts file under /etc folder. Add a new line, and set the host and IP, for example:
arik 10.0.0.1
Save and try again.
Good Luck
Posted in DB, Installation | Tagged 11g, db, Installation, Oracle Database Express Edition, Oracle Linux, Oracle SOA Suite, SOA | Leave a Comment »
April 14, 2013 by Arik Lalo
Oracle Database 11g Express Edition is free and can be download from here:
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html
I’ve installed the DB on Oracle linux 6, but the explanation is good for other Linux x86-64 platform as well.
After you’ve downloaded the DB’s .rpm file, follow the next steps, in order to install the DB:
Continue Reading »
Posted in DB, Installation | Tagged 11g, 64bit, db, Installation, Oracle Database Express Edition, Oracle Linux, Oracle SOA Suite, SOA | Leave a Comment »
February 27, 2013 by Arik Lalo
The following steps describes how to create a JNDI location so you can use it later on your DbAdapter
(The configuration is done on Oracle EM 10g(10.1.3.1) Application Server Control):
1. Create a Connection Pool
In the EM click on your OC4J server (where Bpel PM exists in):
Continue Reading »
Posted in Adapters, DB Adapter, Enterprise Manager | Tagged 10.1.3.1, application server, connection pool, datasource, db connection, em, jndi, Oracle SOA Suite, SOA | 1 Comment »
January 21, 2013 by Arik Lalo
As promised in my previous post – Adding HTML Attachment To An Email Activity On Bpel 10g, in this post I will explain how to poll a file from the local OS and send it as an attachment.
For my example, I’ve created a simple WORD (.doc) file and put it under my Linux server.
So here also, create a new Bpel process and drag the Email activity into the process flow. Fill in the required information:
Continue Reading »
Posted in Activities, Bpel, Email | Tagged 10g, bpel, email, email activity, JDeveloper, Oracle SOA Suite, SOA | Leave a Comment »
January 15, 2013 by Arik Lalo
In this post I will show one way to send Email notification with attachments.
This example will explain how to assign a string message that will appear on the mail as a HTML attachment.
In my next post I will explain how to read a file from your OS and send it as an attachment.
Start with creating a new bpel process. Create a new string variable and assign to it the required message that will appear later on in the HTML
(notice that you don’t need to add header/body tags):
Continue Reading »
Posted in Activities, Bpel, Email | Tagged 10g, bpel, email, email activity, JDeveloper, Oracle SOA Suite, SOA | Leave a Comment »
January 10, 2013 by Arik Lalo
In this post I will explain how to add a variable into a XSL code. I will also explain why do we need it at all.
(This option exists on both Oracle SOA Suite 10g and 11g versions. Some of the screens might be a little bit different. Below I’ve attached print screens from 11g)
If you are using a transformation activity in your process, you probably need to do some mapping for multiple records data.
Like in other developing languages, there are cases where you want to declare a variable once, assign to it a value, and use it later on in your code.
When using xsl for mapping source to target, it is the same behavior.
Let’s take 2 scenarios:
Continue Reading »
Posted in Bpel, Development | Tagged 10g, 11g, bpel, JDeveloper, Oracle SOA Suite, SOA Suite, transformation activity, xsl | Leave a Comment »
December 10, 2012 by Arik Lalo
When dealing with large amount of instances (on one composite application or more), you can end up with slow performance
on the instances load.
I will describe, how a simple configuration can increase the performance for this issue.
Before, I would like to emphasize: performance issues on EM, can be caused from many reasons, like – wrong process plan, DB growth, lack of infra structure resources etc.
When planning processes, there is a need to take in a consideration, all of the parameters.
So, how to set those parameters – very simple:
Continue Reading »
Posted in Bpel, Enterprise Manager | Tagged bpel, composites, em, instances, Oracle SOA Suite, SOA, SOA Suite | Leave a Comment »
November 3, 2012 by Arik Lalo
When creating and planning bpel processes, you must always consider using Fault Management.
Bpel process management provides many options and ways to handle and manage fault.
Sometimes, there can be a requirement to throw a custom fault – one that does not exist in the built in system fault that is being provided in the Throw Activity list.
In this post I will describe how to do it, in the most simple way.
I created my example in SOA suite 11g (11.1.1.6), but that’s the way to go on all bpel versions.
Continue Reading »
Posted in Activities, Bpel, Development | Tagged 10g, 11g, bpel, fault management, oracle, Oracle SOA Suite, SOA Suite, Throw Activity | 4 Comments »
October 13, 2012 by Arik Lalo
While developing on JDeveloper 11.1.1.6 I’ve noticed a strange behavior, that I consider as a bug.
(I could find this problem also on 11.1.1.5 version, but not on previous versions)
When I tried to add another message type to my bpel component, I got a compilation error:
XML-20190: (Fatal Error) Whitespace required.
The above error was the main error, followed by other errors like:
Error(15,84): Cannot find Port Type “{http://xmlns.oracle.com/MyWorkBpel/Project3/BpelProcess1” for “project_client_ep” in WSDL Manager
The error was generated because my main bpel wsdl was corrupted.
The question now is what happened?!
Continue Reading »
Posted in Bpel, Development, JDeveloper | Tagged 11.1.1.5, 11.1.1.6.0, bpel, JDeveloper, message, message part, Oracle SOA Suite, SOA, SOA Suite, wsdl | 1 Comment »
October 2, 2012 by Arik Lalo
When you are using one of the following Adapters – Database/Oracle Application/AQ, sometimes (randomly) you might get an error like:
“Exception occured when binding was invoked. Exception occured during invocation of JCA binding: “JCA Binding execute of Reference operation ‘GetData’ failed due to: Stored procedure invocation error. Error while trying to prepare and execute the BPEL_GETDATA.PROCEDURE$GET_ DATA API. An error occurred while preparing and executing the BPEL_GETDATA.PROCEDURE$GET_ DATA API. Cause: java.sql.SQLTimeoutException: ORA-03111: break received on communication channel Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value “1013” to your deployment descriptor (i.e. weblogic-ra.xml). “. The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.”
Continue Reading »
Posted in Adapters, DB Adapter | Tagged bpel, db, dbadapter, Oracle SOA Suite, weblogic | 2 Comments »
« Newer Posts - Older Posts »
Oracle Fusion Middleware 