Let’s Encrypt : Free Certificates on Oracle Linux (CertBot)

My website has been using HTTPS for over 18 months now. A couple of months ago I came across Let’s Encrypt and thought, “Free Certificates? That’s interesting!”, so I gave it a shot for some other stuff I look after, just to see how I got on with it.

The certificates only last 3 months, but you can automate their renewal using CertBot. You set it up to check every day, and the certificates get renewed (more...)

ACA, New Patch Released for Authoritative ACA 1094-C XML (AIRSH100 XML schema) validation

For those reporting for Affordable Care Act, a new patch released
for Authoritative ACA 1094-C XML (AIRSH100 XML schema) validation.

The Patch Numbers:

  • For release 12.1:  Patch 25653693:R12.BEN.B - ACA : 2016 : AIRSH100 - XML SCHEMA VALIDATION FAILED - NOT WELL FORMED OR MISSIN
  • For release 12.2:  Patch 25653693:R12.BEN.C - ACA : 2016 : AIRSH100 - XML SCHEMA VALIDATION FAILED - NOT WELL FORMED OR MISSIN

Review the (more...)

Starting an instance with sqlplus and running into ORA-27302: failure occurred at: skgpwinit6

Recently I was applying the data dictionary part from an (exadata bundle) patch and ran into the following errors:

ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 1001 (oinstall), current egid = 1002 (dba)

This was very weird, I had just (more...)

Online Table Moves and Partitioning in Oracle Database 12c Release 2 (12.2)

A couple of articles have crept out over the last few days that relate to online operations on Oracle Database 12c Release 2 (12.2). Both of them are pretty small in terms of what you have to do, but are pretty awesome in terms of impact, so I’m giving them the official thumbs-up! 🙂

The first one is about moving tables online.

I (more...)

Inroducing NoSQL and MongoDB to Relational Database professionals

Most enterprises have a lot of variety in the data they deal with. Some data is highly structured and other is very unstructured, some data is bound by strict integrity rules and quality constraints and other is free of any restrictions, some data is “hot” – currently very much in demand – and other data can be stone cold. Some data needs to extremely accurate, down to a prescribed number of fractional digits and other (more...)

Oracle Public Cloud – Invoking ICS endpoints from SOA CS – configure SSL certificate and basic authentication

As part of the Soaring through the Clouds demo of 17 Oracle Public Cloud services, I had to integrate SOA CS with both ACCS (Application Container Cloud) and ICS (Integration Cloud Service).


Calls from Service Bus and SOA Composites running in SOA Suite 12c on SOA CS to endpoints on ACCS (Node.js Express applications) and ICS (REST connector endpoint) were required in this demo. These calls are over SSL (to https endpoints) and for (more...)

Why API Management Matters


Why does Application Programming Interface (API) Management matter? This short overview video introduces the challenges of poorly managed APIs and how Oracle API Platform Cloud Service uniquely simplifies, secures, and monetizes your APIs. Share this video with you customers!

API Platform Cloud Service makes it easy to manage, secure, and publicize APIs by offering innovative solutions for these concepts:


         Ensure that only the right consumer can access the right resources

         Prepare a (more...)

Building Custom EBS Mobile Apps with REST

EBS Approval mobile app screenshotOver 20 EBS mobile apps are available today for E-Business Suite 12.1 and 12.2.  These apps are available for iOS and Android and cover functional areas such as Approvals, Expenses, Timecards, iProcurement, Sales Orders, Inventory, and much more.  These apps are documented here:

What's New

Our mobile apps have just gone through a refresh cycle (more...)

12.2 Moving Tables Online (Real Cool World)

One of the really cool new features introduced in Oracle Database 12c Release 2 is the capability to MOVE tables ONLINE, while maintaining all the associated index structures. This was possible for table partitions in Oracle Database 12c Release 1 but only for Indexed Organized Tables before then. Rather than show a demo that just moves a table, […]

Best Way to Write SQL in Java

Many of us struggle writing SQL in Java. ORM tools such as Hibernate often generate SQL statements that result in poor application performance. Surely, there must be a better way to write SQL in Java.

Attend the free webinar by Java Champion Lukas Eder to learn the best way to write SQL in Java. Find out how you can use SQL as a type safe domain specific language in Java.

Sign up for the free webinar.

12c Release 2, set feedback enhancement in SQL PLus

There’s a nice little touch to the “set feedback” command in SQL PLus in 12.2. There is a new “only” clause in the SET FEEDBACK command, so you can run queries but the resulting rows are not shown in the display. They are still queried, fetched and “returned”, but just rendered to the screen. Here’s an example

$ sqlplus hr/hr

SQL*Plus: Release Production on Tue Mar 14 22:59:15 2017


Pi Day, March 14

Geeks around the world will be celebrating Pi day, a shameless excuse to put the month before the day like the Americans do so we can talk Mathematics on “3.14” day Smile

So what better way to show how cool SQL can be with some expressions to approach Pi with continuous series

All we really need to know by way of background is the CONNECT BY LEVEL trick to generate arbirtary sequences of row, eg

Iceland, Iceland, Baby

Alright, stop!  Collaborate and listen!  Ok, I’ll be the one to take my own advice here and stop...

Later this month, I’ll be heading to Reykjavík, Iceland to deliver our 3-day training class “Developing Desktop APEX Applications”.  This class will be open to the public and costs about $2500 per student, so anyone is welcome to sign up. You’ll have to make your way to Iceland, of course.

Miracle logo1

Here’s a brief overview of what we’re going (more...)

Reducing fetch time

Database query tuning is mostly about getting better plans. Mostly, but not always. Sometimes, the problem has nothing to do with the plan, and you might need to get a bit creative to find a solution. In this recent case a query was showing a decent performance when running from SQL Developer, but it took about 5 times longer to complete when running from R. The plan was the same, so I knew that it (more...)

Taste of KScope 2017 Webinars

This Thursday, I’ll be participating in the Taste of KScope 2017 webinar series by presenting GET POST ORDS JSON: Web Services for APEX Decoded.  The webinar will begin at noon EDT on Thursday, March 16th.  The webinar is completely free, and you don’t need to be an ODTUG member to attend.

Here’s a summary of the abstract:

Web Services in the APEX world are becoming more and more popular.  However, there is still a lot of (more...)

Using the Financial Inquiry Tool in Fixed Assets

question If you have questions about using Financial Inquiry in Fixed Assets, there is a new document that might be helpful - FAQ: Using Financial Inquiry Tool (Doc ID 2225072.1).  In this document, you can find answers to frequently-asked questions about the form, its use, and errors you may have encountered when using the inquiry.

Perhaps you have encountered an error in the Financial Inquiry form (FAXOLFIN) or maybe the form hangs (more...)

AI Technologies & Bots – The Future World of Work & Opportunities

In recent computing, "Automation" is the most commonly used word.

This word often has a negative connotation, as it brings up worries related to job loss and job replacement, but here's the reality.

To analyze what we're trying to automate and how humans will evolve to create new forms of work, we need to:

  • Collaborate with robots/bots
  • Build new patterns of productivity 
  • Create differentiated opportunities and markets

This is the best time to participate in (more...)

Last week in Stream Processing & Analytics – 13.03.2017

This is the 57th edition of my blog series blog series around Stream Processing and Analytics!

Every week I’m also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts


It’s A Matter Of Perspective

So I suppose that if I'm going to blow the trumpet and announce the resurrection of this blog, I'd better write something meaningful...

I'm in Northern California at Oracle HQ this week. It's always fun to observe what's happening here in Silicon Valley.  For example, I can see the tech market is still good...lots of employment ads on billboards between the San Jose and San Francisco airports.  And the highly-publicized drought is clearly broken: (more...)

Default Password Hashes for 11g Oracle Database

I often get Oracle Security related questions from people randomly sent to my inbox or occasionally on Social media and less on on this sites forum. I get questions on average probably 4 times per week in these ways. I....[Read More]

Posted by Pete On 14/03/17 At 06:16 PM