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...)

OUG Ireland : The Journey Begins

There is something about early starts that get me so nervous I can’t sleep properly. As a result I was awake before my 05:00 alarm, which gave me plenty of time to get ready. That was good because I hadn’t packed up laptop bag, which was also acting as my overnight bag. 🙂

The taxi ride to the airport was pretty standard, but I did have a conversation about Roza Bal in Kashmir.

I only had hand (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...)

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12.2

Since its release in 10gR1, Oracle have consistently added neat functionality to the “new” scheduler with every database release. Yes, I still call it the new scheduler and you would be surprised how many people still insist on using DBMS_JOB rather than switching to DBMS_SCHEDULER.

Oracle Database 12c Release 2 (12.2) is no exception to this pattern, as once again we have some new stuff to play with.

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...)

Publishing Oracle SOA Maven plugin by Maarten Tijhof

image


When setting up a continuous integration solution for Oracle SOA Suite code, it is best to work with mavenized projects, and thus rely on Oracle-provided maven plugins to do the tough job of compiling and deploying artifacts.

This way of working has been introduced by Oracle in the 12c range of products. There are no Maven plugins available for 11g Oracle products.
This post describes how to set up the plugin in a Binary Repository (more...)

adrci purging

I did not know this.

Is there a way to control Auto_Purge Frequency done by the MMON ? (Doc ID 1446242.1)

The automatic purge cycle is designed as follows.
(1) The first actual purge action will be 2 days after instance startup time
(2) The next automatic purge actions following this first purge is done once every 7 days

If you like to purge more often, then it will need to be done manually.

The (more...)

ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases

|GREP ORA

As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).

adr1

ADR Structure

View original post 349 more words


Oracle HCM Cloud Extensibility – The Easiest Win

I've been doing quite a bit of work lately with Oracle HCM Cloud user experience extensibility...presenting, helping partners and customers, etc.  Seems like a hot subject of late, with lots of folks wanting to know more.  So let's get into it a bit.

Working in the Oracle HCM Cloud Center of Excellence, I see quite a few opportunities for wins that come up repeatedly.  You know what kind of win I mean: something that's easy (more...)