Global Temporary Tables – Change in Oracle 12c

A few weeks back I was copied on an email conversation about a important change with Global Temporary Tables (GTT) in Oracle Database 12c.  Something you need to be aware of when using GTTs in Oracle Database 12.1.0.2:Prior to this release GTTs shared statistics between sessions. Statistics were SHARED between... [Read More]

Outer Join with OR and Lateral View Decorrelation

Use of ANSI SQL is a personal thing.

Historically I have not been a fan apart from where it makes things easier/possible.

This reticence was mainly due to optimizer bugs and limitations in the earlier days.

Recently I have been using it much more because I find that the developers I interact with prefer it / understand it better.

You might/should be aware that Oracle will rewrite ANSI SQL to an Oracle syntax representation, this (more...)

Pharma and Automotive BPM Solutions by OpRiskSolutions International Ltd

clip_image002


Our partner OpRiskSolutions developed two solutions based on BPM Suite 12c:

Aria4Automotive Aria4Automotive is a comprehensive solution, designed to address the specific requirements of Project Schedule Management in the Automotive Industry. The solution supports specific automotive industry planning concepts, such as enterprise-wide scheduling.
Aria4Pharma Aria4Pharma is a comprehensive enterprise solution that addresses the specific needs, planning concepts and processes of drug development in the pharmaceutical industry.

For more information about the Solutions Catalog & Cloud (more...)

Speed up Upgrade Phase 65 with a new catuposb.sql

Credits to Chris Smids from Proximus in Belgium Thanks, Chris!!! Upgrade to Oracle 12.1.0.2 is slow in phase: #65 ? You are wondering why phase: #65 of the database upgrade to Oracle Database 12.1.0.2 takes quite a while. You dig down into the catupgrd0.log and recognized this statement taking a... [Read More]

Middleware Summer Camps free virtual training SOA Suite 12c, BPM Suite 12c & WebLogic 12c: August & September 2016

VirtualSummerCamps2016small

You are working on large Fusion Middleware & PaaS opportunities & projects? Oracle is pleased to invite you to the  Middleware Summer Camps 2016. For technical experts we offer live virtual classes:

SOA Suite 12c Training On Demand

BPM Suite 12c Training On Demand

WebLogic 12c Training On Demand

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit (more...)

Increase speed to deployment of SOA with FlexDeploy by Dan Reynebeau

clip_image002With SOA, you can have hundreds of composites that need to be setup for deployment and this can be a challenge.  With FlexDeploy, we have a way to mass load and create projects from a csv file. Through the use of a template (a groovy script along with inputs) in conjunction with the csv file, projects can be created within a few minutes.

So now that I have your interest.  Let’s get started (more...)

Custom Transports in Service Bus 12.2.1 by Ricardo Ferreira

clip_image002Oracle Service Bus (or Service Bus for short) provides a very powerful set of APIs that allow experienced Java developers to create custom transport providers. This is called Service Bus Transport SDK. By using this SDK, it is possible to create custom transport providers to handle both inbound and outbound message handling for specific protocols, without having to worry with the internal details of Service Bus.

The objective of this post is not about how (more...)

Handling inbound Attachments by Service Bus by Apostolos Varsamis

clip_image002Introduction

Oracle Service Bus message context is a set of properties, so called context variables, that hold message content as well as information about messages as they are routed through Oracle Service Bus (OSB). The Message Context Schema specifies the element types for the predefined message context variables.

Such a predefined context variable is the variable attachments.

Fig. 1 shows in an excerpt of the Message Context Schema the definition of the element attachmens.

(more...)

Error Resilient Adapters – SOA 12.2.1 Resiliency Feature by Kevin King

clip_image001New to SOA 12.2.1 is the concept of Resiliency.  Oracle has introduced functionality that shuts down adapters when their composite failure meets a certain threshold. In effect, an error circuit breaker!  This is extremely helpful to prevent filling up the error hospital with an abundance of errors.  When suspended, the failed composite will retry the composite at a defined interval in an attempt to un-suspend the service adapter.  The (more...)

SOA 12.2.1 New Feature – End to End JSON and Javascript Example by Krishna Hanumantharao

clip_image002SOA 12.2.1 provides support for end-to-end JSON and Javascript. We don’t have do internal mapping between XML and JSON as in 12.1.3.

As part of this post, let us implement a simple REST service to demonstrate this new feature – End to End JSON with Javascript.

Let us create a very simple SOA Composite which exposes a JSON based REST interface, manipulates the values using Javascript and calls an external JSON (more...)

Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

Full Transportable Export/Import - one of the coolest features in Oracle Database 12c  We blogged about Full Transportable Export/Import a while back. It is - no doubt - one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab - Upgrade,... [Read More]

Processing large XML files in the SOA Suite by Emiel Paasschens

clip_image002Read large XML files in chunks

Introduction

At my current project, XML files are uploaded by the end-user to be processed in the Oracle SOA Suite. The XML files contain information about employers and their employees. Because an employer can have hundreds and even thousands of employees, these XML files can be quite large.
Processing such large XML files consumes a lot of memory and can be a bottleneck especially when multiple end users are (more...)

SOA & BPM 12.2.1 Installation and Configuration Workshop by John VanSant


clip_image002Overview of Workshop

This workshop will guide the participant through the installation of a non-development environment for SOA and BPM Suite v12.2.1. This workshop won’t cover the installation of the SOA Quickstart install, but the installation of the production software. Some notable differences between the Quickstart install and production bits are:

  • The Quickstart installer doesn’t require an Oracle Database but uses a Java Database. In order to use BAM, an Oracle Database is (more...)

Updates to Big Data Lite 4.5

There are some updates to Big Data Lite 4.5 that you will want to take advantage of: Updated Big Data SQL configuration enables predicate pushdown to engage - which can have pretty dramatic performance benefits Update to the Big Data Spatial framework (fixes a configuration issue) New... [Read More]

Master Oracle SOA Suite 12c by Lucas Jellema

clip_image002

Design, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this (more...)

How To Avoid Exadata Cell Node Reboot While Modifying NTP Service

Recently, we had a hardware failure on our NTP server which caused its crash. Due to this, the ntpd daemon on compute nodes and cell nodes went offline. After fixing the hardware issue on NTP server, starting ntpd service using "service ntpd start" on compute nodes was successful but when I started the ntp service…

Storing Date Values As Numbers (The Numbers)

In my last couple of posts, I’ve been discussing how storing date data in a character based column is a really really bad idea. In a follow-up question, I was asked if storing dates in NUMBER format was a better option. The answer is that it’s probably an improvement from storing dates as strings but it’s […]

EM Express Login – Get Flash

I have 12c setup on OEL 6.7 on my VM and while trying to access EM express, I was receiving the error

em_express_error

Just for the notes, a user can log into EM Express using URL

https://<hostname>:<port>/em

and port details can be found using

lsnrctl status | grep HTTP
or  
select dbms_xdb_config.getHttpsPort() from dual;

Clicking on the “Get Flash” takes you to abode flash page from where you can download the rpm for flash.

 (more...)

PREDICTION_DETAILS function in Oracle

When building predictive models the data scientist can spend a large amount of time examining the models produced and how they work and perform on their hold out sample data sets. They do this to understand is the model gives a good general representation of the data and can identify/predict many different scenarios. When the "best" model has been selected then this is typically deployed is some sort of reporting environment, where a list is (more...)

Storing Date Values As Characters Part II (A Better Future)

In the previous post, I discussed how storing date values within a character data type is a really really bad idea and illustrated how the CBO can easily get its costings totally wrong as a result. A function-based date index helped the CBO get the correct costings and protect the integrity of the date data. During […]