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...)
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...)
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...)
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.
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...)
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 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...)
Over 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:
Our mobile apps have just gone through a refresh cycle (more...)
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, […]
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.
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 22.214.171.124.0 Production on Tue Mar 14 22:59:15 2017
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
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
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.
Here’s a brief overview of what we’re going (more...)
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...)
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...)
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...)
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.
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
- Create differentiated opportunities and markets
This is the
best time to participate in (more...)
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
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...)
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