#OOW16, San Francisco

This year, 2016, is turning out to be an amazing year again, with #OOW16 being once again on of the apices!

Looking back

After the discovery of the Oracle community in 2012, as a result of a very first trip to downtown San Francisco in 2010 for #OOW10, an amazing chain of events was set in motion. This very first introduction in the Oracle World was as ‘a mere participant’ in this awe-inspring, large (more...)

Adaptive Cursor Sharing Fail

Here is another example (besides the fact that Adaptive Cursor Sharing only gets evaluated during a PARSE call (still valid in 12c) and supports a maximum of 14 bind variables) I've recently come across at a client site where the default implementation of Adaptive Cursor Sharing fails to create a more suitable execution plan for different bind variable values.Broken down to a bare minimum the query was sometimes executed using non-existing values for a (more...)

Process Timers – Controlling the time in which your process executes by Jose Rodrigues

clip_image002

Following up a series of questions around setting timers in the Oracle Community forums, I decided to write this article to try and guide their use and how these can be used to control process execution.

Let’s start!

The Use Case

We’ll begin by setting up the scenario in which we’ll have to control our process flow.

Imagine that you want to have a part of your process that executes immediately if the current time (more...)

Community and the “Hive Mind”

A really great thing about being part of the Oracle community is the networking and access to information it gives you. In my current job I have to do a number of things that are not really my forte. I know how to learn new stuff, but it’s always nice to get some feedback from people who know more than you. Over the last few years there have been a number of specific cases that (more...)

Business Activity Monitoring videos by Stefan Wörmke

This is a series of 8 short videos explaining how to create a BPM application using Oracle Process Cloud Services. Part 1 will show how to login and create a new application:

clip_image002Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

The tutorial is also available at our Community blog Business Process Modelling and Business Activity Monitoring by Stefan Wörmcke

SOA & BPM Partner Community

For regular information (more...)

Creating an APEX plugin for an Oracle JET component – Part 1

In APEX 5.1 (still Early Adaptor 1 at this moment), Oracle JET - Javascript Extension Toolkit -  is included to facilitate charting.
The APEX Development Team recently mentioned that not only the Data Visualisations part of JET will be included in APEX 5.1, but the complete installation of JET. The whole package. That won't do the size of the downloadable install file any good, but more important is: what can we do with (more...)

Integrating Oracle Fusion Middleware MapViewer with Oracle JET

There are many map components in the world out there—and I have documented how to integrate several of them in an Oracle JET application, e.g., 3DCityDB, Mapbox, Leaflet, and LuciadRIA

However, Oracle has its own map component, as described in detail below, which includes the Oracle Maps Javascript library:

http://www.oracle.com/technetwork/middleware/mapviewer/overview/index.html

Oracle Fusion Middleware MapViewer is a development toolkit for incorporating interactive maps and spatial analyses. It is (more...)

Oracle JET and Mobile Cloud Service Authentication with OAuth

I will describe with practical example, how to authenticate against MCS in Oracle JET using OAuth. This is based on sample app from my previous post - Oracle JET and Application Container Cloud (with MCS Integration) (download sample app from there). It would be useful to read through MCS documentation - Authenticating with OAuth in Individual REST Calls.

Oracle JET sample application provides login form:


If login is successful, REST call is done and MCS (more...)

Meet Us at LinuxCon North America – Toronto

Oracle is a gold sponsor at LinuxCon North America, August 22nd – 24th, 2016. at Westin Harbour Castle, Toronto, Canada this year. Oracle has served on the board of the Linux Foundation since its inception in 2007 and remains steadfast to show its commitment to the open source community and their initiatives.  

We have great sessions lined up, one of these sessions will be presented by Robert Shimp, Product Management Group Vice President, (more...)

Speaking at OOW 2016 on Sunday on Active Session History

Session ID: UGF3110

Advanced Active Session History Analytics
Moscone West—3020
09/18/16, 03:30:00 PM – 04:15:00 PM

 

 

Bulk collect workaround for memory bug

A coworker passed a test script on to me that was failing with the following memory error:

ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)

The error occurred when initializing a PL/SQL table variable with 7500 objects. Here is my sanitized version of the code:

CREATE OR REPLACE TYPE ARRAY_ELEMENT
AS
  OBJECT
  (
    n1 NUMBER,
    n2 NUMBER,
    n3 NUMBER,
    n4 NUMBER );
/

CREATE OR REPLACE TYPE MY_ARRAY
IS
   (more...)

Virtual Development Server: Add swapfile to VirtualBox as requirement for installing Oracle or build Oracle docker images

As I want later build Oracle docker images, some of this need a swapfile.

Per default my used Vagrantbox, does not have one, so later steps will fail.

As in the last blog I use a Vagrant shell provider.

...
  # add swapfile to the box
  config.vm.provision :shell, :path => "add_swap.sh"
...

This calls the script add_swap.sh in the created VirtualBox machine.
Make sure, that you create your swapfile on a supported (more...)

The Rosetta Stone of Database Platforms

This is a living document that I will continue to update and will add new database platforms to as I go along in my career.  I spend a lot of time translating database platforms I’ve worked in for all tiers of the technical business.  It just seems natural that we might need a location on the web where that information is kept.

alive

I’ll add some diagrams at a (more...)

Oracle PartnerNetwork Community – Get Certified FREE at Oracle OpenWorld

Written by Iulia Pantelimon, OPN


Partners can take certification exams during Oracle OpenWorld at no cost, only at the OPN Test Fest.

The OPN Test Fest runs from Monday, September 19 - Thursday, September 22 at the Courtyard San Francisco Downtown Hotel.

It’s an exceptional opportunity for partners to take Oracle PartnerNetwork exams for FREE!

Experience the benefits when achieving certification successfully. Candidates earn an OPN Certified Specialist credential, a digital badge to promote across (more...)

Translating Oracle JET Applications

The Oracle JET MOOC starts on Monday. When we talk about Oracle JET we always say that it solves "enterprise challenges". One of these is internationalization/localization/translation of JavaScript applications. Recently I started playing with the translation features of Oracle JET and they're pretty impressive. Really, if you want to create JavaScript applications that need to be translated, you should look no further than Oracle JET.

Let's start by looking at the result of a small (more...)

Digging into ADD SCHEMATRANDATA … what is #GoldenGate doing?

In my post on the differences between ADD TRANDATA and ADD SCHEMATRANDATA, I highlighted the differences between the two ways of adding supplemental logging to tables. One of the things I pointed out was that ADD SCHEMATRANDATA doesn’t add any supplemental log groups (SLG). Without SLGs then how does ADD SCHEMATRANDATA work? That was the question I was left with. So I started digging around to find the answer and I think you may be (more...)

Variable substitution for a manifest.yml for Cloud Foundry

Pushed applications to CF or PCF you would of most likely used a manifest.yml file and at some point wanted to use variable substitution. manifest.yml files don't support that and a feature request has been asked for this as follows

https://github.com/cloudfoundry/cli/issues/820

With a recent customer we scripted the creation of a manifest.yml file from a Jenkins job  which would inject the required ROUTE to the application by creating the manifest.yml (more...)

Announcing the New Oracle Education & Research 2016 Industry Enablement!

We are glad to announce the release of a new Education & Research 2016 Industry Specialist Training Guided Learning Path targeted at your sales and sales consulting teams so that they can understand Oracle’s key messages within the industry, articulate Oracle’s key solutions for the sector and be able to position our products to their respective customers and prospects.

Gain proficiency in positioning and selling the Oracle Education and Research Industry solutions and contribute towards (more...)

MySQL Partner Webcast: MySQL Enterprise Edition Jump-start


Jump-start your MySQL knowledge with this in-depth webinar that will assist you in learning the building blocks for creating a centralized service offering with MySQL Enterprise Edition.

This webcast will be offered in 3 languages: English (9/13), Spanish (9/14), and Portuguese (Brazil) (9/14).

Register today! 

TimeClock Plus Achieves Oracle Validated Integration with Oracle’s PeopleSoft Time and Labor – August 2016

TimeClock Plus (TCP), a Gold level member of Oracle PartnerNetwork (OPN), announced it has achieved Oracle Validated Integration of TCP Direct with Oracle's PeopleSoft Time and Labor 9.2. This validation is a major milestone in the evolution of TCP and its relationship with Oracle. The company continues to grow its presence in the Enterprise Resource Planning (ERP) space and with Oracle Validated Integration for PeopleSoft Time and Labor, the company is even better positioned (more...)