More chaos as an OWSM policy by Jeroen Ninck Blok


imageErrors & failures

So it is very easy to implement a happy flow. However handling errors, rolling back transactions and recovering from errors and failures can be quite challenging. It is not possible to find all the possibilities during development or design. Some errors or failures will only occur when very rare circumstances come into play together. Then all the parts of the application either will handle the error and will ensure that no data (more...)

OUG Ireland 2017 : It’s a Wrap

I guess four blog posts and 3 videos over a two day period is a little excessive, but this is the closing post to make it five. 🙂

Here are the posts I put out during the event. I’ve added in some videos I finished editing today.

This is the first time (more...)

Configuring Amazon RDS as the Oracle SOA Suite Database by Fabio Douek


imageWe are proud to announce that RDS support is fully integrated and certified against MyST 3.8.2, which was released on 15/Jun/2016. To know more about MyST visit: http://myst.rubiconred.com

1. Overview

We started to provision Oracle Fusion Middleware platforms against AWS in anger about three years ago. From the beginning we took advantage of the ability to create the AWS infrastructure within minutes. We could also use MyST to provision complex Oracle (more...)

OUG Ireland 2017 : The Journey Home

I left the hotel bar with Martin, Chris and Neil and after an abortive attempt to get an airbus, we got a taxi to the airport.

I was convinced Dublin Airport was one of the few airports that don’t want you to unpack your laptops from your bag so I didn’t and my bag got flagged. I have no idea where I got that idea from, but I felt like a dick. 🙂

We then went (more...)

OUG Ireland 2017 : Day 2

I got up a little after 08:30, which was a bit of a surprise, and headed down for breakfast, where a met a bunch of other speakers.

By the time I got showered, changed and checked out of the hotel I had missed the first session of the day (sorry). The first session I went to was the wife presenting “PaaS4SaaS”. I know what you are thinking, and yes I could do this presentation as (more...)

SOA Suite Code Quality: SonarQube Quality Gates, XML Plugin and custom XPath rules by Maarten Smeets


imageThere are several ways to do code quality checks in SOA Suite. In this blog post I will describe a minimal effort setup which uses Jenkins 2.9, SonarQube 5.6 and the SonarQube XML Plugin 1.4.1. SonarQube is a popular tool to check and visualize code quality. An XML Plugin is available for SonarQube which allows you to define custom XPath rules. At the end of this post I will shortly describe (more...)

Get ready for the PaaS Partner Community Forum – Cloud Computing & PaaS resources

PaaSCommunityForum

The PaaS Partner Community Forum will be all about Platform as a Service Cloud Computing.

Infographic: 5 Best Practices for Platform as a Service Success

iPaper: Public Platform as a Service for Dummies

IDC Research: Empower Digital Transformation with Platform as a Service

Webcast: Harvard Business Review Research: Cloud Computing Comes of Age

Try it: Register for the Demo.oracle.com system http://tinyurl.com/opndemo and access it here.


Good trip to Split

Jürgen Kress

SOA (more...)

Reminder: Upgrade BPEL 11.1.1.7 to 11.1.1.9 Before December 2018

Oracle Fusion Middleware products get new Patch Set updates.  When a new Patch Set has been released, a 12 month Grace Period for the previous Patch Set begins.  Once that Grace Period ends, no new patches for the previous Patch Set will be released.

For more details, see:

Oracle BPEL Process Manager is part of (more...)

Can I Use Oracle GoldenGate with EBS on Oracle Cloud?

This frequently asked question comes in several variants, including:

  • Can I use Oracle GoldenGate with EBS on-premises to set up an operational reporting environment in Oracle Cloud?
  • Can I use Oracle GoldenGate Cloud Service with EBS?
  • Can I use Oracle GoldenGate to replicate my EBS database to Oracle Cloud?
  • Can I use Oracle GoldenGate to perform a live migration of my EBS database from on-premises to Oracle Cloud?

We will answer each question in turn. (more...)

min/max Upgrade

A question came up on the OTN database forum a little while ago about a very simple query that was taking different execution paths on two databases with the same table and index definitions and similar data. In one database the plan used the “index full scan (min/max)” operation while the other database used a brute force “index fast full scan” operation.

In most circumstances the starting point to address a question like this is (more...)

SOA Suite Unit test with Groovy (11g, 12c) – part 1 by Carlos Giraldo


imageIt's going to be a little long but if you stay until the last line, you are going to know what i did to create dynamic xml requests and responses usign the unit test framework of the Soa Suite with groovy. (yes, groovy!)
I'm going to give some background of the problem and later my own personal solution. Lets begin :D
[Update 30/06/2016] Wrote a second blog about subject with more functionality for the (more...)

12cR2 tightens up ORA-01841 for zero year ANSI dates, but not for Oracle SQL syntax

In moving some more code from an 11gR2 database to a 12cR2 database, I found another change where a piece of code that works in 11gR2 doesn’t compile in 12cR2.

In this instance a view was being created with a projected date column which used the ANSI DATE syntax. Here is a simplified test script:

CREATE OR REPLACE VIEW test1 AS
SELECT date '0000-01-01' date_col
FROM dual
/
DROP VIEW test
/

CREATE OR REPLACE  (more...)

Webcast: “Installation, Cloning and Configuration of EBS 12.2”

Install EBS 12.2Oracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for an overview of how to install, clone, and configure EBS 12.2, see:

Max Arderius, Senior Principal Product Manager covers the technology stack for Oracle E-Business Suite 12.2, including the use of Oracle WebLogic Server (Oracle Fusion Middleware 11g) and Oracle Database functionality. Topics include (more...)

SOA & BPM Community Newsletter March 2017

Dear SOA & BPM Partner Community,

We are excited to announce the keynote presentations during our PaaS Partner Community Forum 2017. Ed Zou will start the conference with an overview of the PaaS platform including live demos. API Cloud Service & Integration and Process Cloud Service is part of Vikas Anand demo. For all Developers Mike Lehmann will highlight the Cloud-Native / Microservice programming model for application development and How Oracle fits here with its (more...)

Iceland is Awesome….and Colder than Utah

I ended up speaking at two events this last week.  Now if timezones and flights weren’t enough to confuse someone, I was speaking at both an Oracle AND a SQL Server event- yeah, that’s how I roll these days.

Utah Oracle User Group, (UTOUG)

I arrived last Sunday in Salt Lake, which is just a slightly milder weather and more conservative version of Colorado, to speak at UTOUG’s (more...)

Manage Data Driven Applications, Develop Cloud Applications & More with Oracle PaaS Cloud Learning Solutions

“Platform as a Service (PaaS) to be adopted by 72% of companies by 2017.”
-Deepti Sharma, CRMIT Solutions

Leverage a broad portfolio (more...)

Using Job Role Separation with ASM and EBS 12.2

A job role separation configuration of Oracle Database and Oracle Automatic Storage Management (ASM) is a configuration with groups and users to provide separate groups for operating system authentication.

This is now a certified option for E-Business Suite 12.2 environments. The EBS Rapid Install now supports the use of job role separation to manage operating system permissions for ASM, Oracle Grid Infrastructure, and Oracle software installations.

Job Role separation table for ASM in EBS environments

The following guides have been updated to reflect this (more...)

Deception

One of the difficulties with trouble-shooting is that’s it very easy to overlook, or forget to go hunting for, the little details that turn a puzzle into a simple problem. Here’s an example showing how you can read a bit of an AWR report and think you’ve found an unpleasant anomaly. I’ve created a little model and taken a couple of AWR snapshots a few seconds apart so the numbers involved are going to be (more...)

EECS – Oracle Exadate Express Cloud Service, Step 4 : APEX !

So what are my experiences using EECS doing some APEX work?

First of all, it is not blazing fast. Probably caused by the latency (as mentioned in my previous post). It is not slow, it is just ok('ish). 

Second, and way more important, it runs APEX 5.0.4! So whatever Oracle advertises about "Cloud first" ... it doesn't seem to apply to APEX (or APEX on EECS). So this fact alone makes (more...)

Using VS Code for PL/SQL development

I've been using Sublime Text as my main editor for PL/SQL development for many years, but I'm now in the process of switching to Visual Studio Code (VS Code).



Some good reasons to use VS Code:
  • Multi-platform (Windows, OS X, Linux)
  • Free, open source
  • Lightweight, fast
  • Large ecosystem of extensions
  • Built-in Git support
  • Can be adapted to PL/SQL coding via a plsql language extension (syntax highlighting, go to/peek definition, go to symbol) and PL/SQL compilation (more...)