Today i was using utl_http package on my 11g db and I encountered the following error:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at line 1
His is the result of the improved security in 11g. When you want to create a connection to a remote server with one of the util packages: TCP,HTTP,SMTP besides the privileges on the package you need to configure the connection in a Access Control List (ACL). In a ACL you can configure in detail the allowed connections by entering the following parameters:
- Server name or IP
- Port number range
- Database user/role
- Start date
- End date
The package DBMS_NETWORK_ACL_ADMIN enables you to create and configure ACL’s.
The ACL is a nice security feature but when migrating applications to 11g it’s something you will encounter.
More information:
Posted December 30th, 2009 by Theo van Arem | No Comments »
The configuration of the fault management Framework for a SCA component has been made more flexible than it was in 10g. We can configure fault policies not only on composite level but also on component level. This enables us to configure retry policies not only on an error type and filter but also on specific components. To do this you just need two files:
You have to enable the fault policy by adding the files to your sca component, or you can add a reference in the sca component to hem, for example when they are placed in the mds.
fault-bindings.xml
Examples of fault-bindings.xml files can be found in oracle’s documentations:
fault-policies.xml
An detailed fault-policies.xml file can be found here.
Mediator
The Fault Management Framework is only applicable for mediators that processes their rules parallel, see documentation Fault Policies Mediator. If an error is matched in the fault policy an possible predefined fault action in the mediator will be ignored. Be aware of this when you are defining your fault policies and error handling.
Example
I have made a simple sca component to show the working of the framework. This sca component has two components {BPEL and Mediator} which are exposed as services to the outside world.
Read the rest of this entry »
Posted December 10th, 2009 by Theo van Arem | 19 Comments »
Today i took a look at the test framework withing the 11g suite. I encountered a strange problem in the test framework of the SOA Suite but before i go into details i will explain the case.
I have made the following sca component that returns a greeting. The input is quite simple a name and a greeting type (‘Hello’ or ‘Bye’). The message is routed depending on the greeting type to a BPEL which response the greeting with a return greeting.
Read the rest of this entry »
Posted December 3rd, 2009 by Theo van Arem | 2 Comments »
