The village idiot

If you are not familiar with the term Village Idiot, then Wikipedia provides a sufficient definition from which I can base this blog post.

https://en.wikipedia.org/wiki/Village_idiot

“The village idiot … is a person known for ignorance or stupidity”

Over the past couple of weeks I’ve been flying a bit.  First was OpenWorld and OracleCode in New Delhi in India, and from there, I was heading straight from there to Cleveland, Ohio for the (more...)

255 columns

This is one of my “black hole” articles – I drafted it six months ago, but forgot to publish it.

A recent post on OTN highlighted some of the interesting oddities that appear when you create tables with more than 255 columns. In fact this was a more subtle case than usual because it reminded us that it’s possible to have a partitioned table which appears to have less than the critical 255 columns while (more...)

Grumpy Old Man Having a Moan

This post is just going to be me moaning, so feel free to stop reading now and go about your day. 🙂

I am a regular guy, with a regular job. I don’t wake up every morning wondering how I can selflessly serve the Oracle community. It isn’t my mission to make sure you never have to think when you do your job. It is not my job to respond to your questions in a timescale (more...)

NOLOGGING Bad For Recovery

What doesn’t kill you makes you stronger.
I have gone through NOLOGGING hell and not sure if I am out yet.
Disk was lost from server and database was recovered.

Oracle Standard Edition (SE2) for Microsoft Windows x64 (64-bit).

RMAN> restore database validate preview;

  List of Archived Logs in backup set 4098
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    15209   134553557  26-APR-17 134574622  26-APR-17
  1     (more...)

A Sneak Peek at Oracle’s Chatbot Cloud Service and 5 Key Factors Necessary for Bot ROI

Intro

In early May, I flew out to Oracle HQ in San Francisco for an early look at their yet-to-be released Oracle Intelligent Bots Service.  The training left me ecstatic that the technology to quickly build great chatbots is finally here. However, the question remains, can chatbots provide real value for your business?

What is a chatbot?

A chatbot is a program that simulates a conversation partner over a messaging app. It can integrate with (more...)

Presentation Applying “web scale” patterns in the bol.com back office

Presentation Applying “web scale” patterns in the bol.com back office

Codemotion web scale pattern presentationThis week at Codemotion I gave a presentation on web scale patterns and how we apply them in the bol.com back office services. Codemotion is the biggest tech conference in Italy and one of the most important in Europe.

The presentation shows how we go from business goals to software patterns. The following patterns were covered: CQRS, event sourcing, polyglot persistence (more...)

Oracle JET Hybrid – NavDrawer Template Menu/Header Structure

Oracle JET provides NavDrawer template for Web and for Hybrid. Read how to create JET Hybrid application based on template - Create a Hybrid Mobile Application. There is significant difference in NavDrawer template implementation when we compare Web and Hybrid application.

Hybrid template draws menu structure on top of the form. Web template is pushing form to the right, when menu is opened. Such approach works fine on the Web, but you would see significant (more...)

Oracle EBS User Experience Makeover Contest

Young plant growing in the morning light and green bokeh background  , new life growth ecology concept

As is our tradition, when Spring begins and rebirth is in the air, we like to offer our customers a renewal of their own. This year, we thought it was time to give some love to our Oracle E-business suite (EBS) customers, as we’ve had some incredible success this year modernizing EBS applications. You can read about our digital transformations in Forbes Magazine here.  

We want your pain points!

We are putting it out there to (more...)

Oracle Enterprise Linux 6.6 AMI Available on AWS

We've had a number of requests for versions of our OEL AMI. The version for 6.6 has been released to the AWS Marketplace now, you can access it at this link

We're also planning to align the updates to the AMIs with our own internal updates. This will mean that the AMIs will be updated to the latest security updates for the point release on a quarterly basis. We want to make sure this (more...)

Riga Dev Days 2017, new experiences in many ways.

Riga Dev Days 2017

General

It has been a while since my last blog-post.
One of the reasons is my shift from closed to open source software, databases more specifically. More on that in a later blog-post.

The reason for already mentioning this is this strange hybrid (what a popular word, these days) situation that I am in at the moment.
Thanks to the super enthusiastic, flexible and tenacious organization-team of the Riga Dev Days, (more...)

Datascape Podcast Episode 9 – What’s Up with Oracle These Days?

On today’s episode of the Datascape Podcast we are going to talk about the Oracle Database. With the hype around cloud and cloud first initiatives, automation, DevOps, and very specialized cloud-based databases, I wondered what was going on with one of the datascape’s old faithful technologies, Oracle Database.

Joining us is Simon Pane, who is an Oracle consultant and expert. Simon is very much immersed in the community and truly has his feet on (more...)

LEAP#300 The Matrix LED Test

The LRAS1130 Arduino library from @luckyresistor is an easy way to get started with the BoldportClub Matrix and an Arduino. I’m using a slightly modified version of the LedTest sketch from the library here. LED test = all passing! As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo on GitHub hero_image

Sequential Asynchronous calls in Node.JS – using callbacks, async and ES6 Promises

One of the challenges with programming in JavaScript (ECMA Script) in general and Node.JS in particular is having to deal with asynchronous operations. Whenever a call is made to a function that will handle the request asynchronously, care has to be taken to be prepared to receive the result from the function in an asynchronous fashion. Additionally, we have to ensure that the program flow does not continue prematurely – only those steps that (more...)

My 5 favorite sessions at ODTUG Kscope17

In a few weeks this years ODTUG Kscope conference will take placed in San Antonio, Texas, US.

Time to share my 5 favorite sessions at this awesome and inspiring conference.

By know it should be common knowledge that I attend conferences not only for the technical sessions and the exhibition, but most importantly to meet and talk to others. As I recently pointed out, it is very inspiring to meet others and get to (more...)

Forms Application shows a ‘FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508’ after upgrade to 11.1.2.2.0

Situation:

After an upgrade from 11.1.2.1.0 to 11.1.2.2.0 and a patch apply of patch 19933795 (see post Forms Application does not run anymore after java upgrade to 1.8_131 on client), the application shows an 'FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508':



Solution:

I had to recreate the webutil repository (create_webutil_db.sql) and to recompile webutil.pll. After that, the application runs fine again ...

Windows Oracle Services Using PowerShell

Lately, I have been getting feet wet with Windows.
I know GUI can be used but not very good to reproduce.

Here is now to find Stopped Oracle Windows Services and start them.

And if you want to use GUI, run Services.msc from command line.

Windows PowerShell
Copyright (C) 2012 Microsoft Corporation. All rights reserved.

PS C:\Users\oracle> hostname
minions

PS C:\Users\oracle> Get-Service -Name *oracle* | Where Status -eq "Stopped" | Format-List
Name                : Oracleagent12c1Agent
DisplayName          (more...)

Last week in Stream Processing & Analytics – 17.5.2017

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

As every week I was 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

General

Pesentations at Great Lakes Oracle Conference 2017

Uncategorized
| May 17, 2017
For those who came to my sessions at GLOC 2017 in Cleveland, thank you for giving me your time. I hope you found them useful. As always, I love to hear your feedback. You can add a comment here, email me at arup@proligence.com, tweet at @ArupNanda or at www.Facebook.com/ArupKNanda.

All about Deadlocks The Presentation The Tracefile Used as an Example
How Buffer Cache Works The Presentation The Scripts
Big Data for Oracle (more...)

Smart Database Architecture for Software Development


We are incredibly excited to announce that the amazing Toon Koppelaars from Oracle Real World Performance Team is hosting our next webinar: Smart Database Architecture for Software Development. Register at this link.





About the Webinar

Is the database a processing engine or a persistence layer? In this presentation we'll first go through a bit of history demonstrating how the database has been used in the past 30 years: at times it was a processing engine, (more...)

LEAP#299 The Boldport Club Matrix

The Matrix is an I²C-controlled 24x5 LED matrix display, powered by an AMS AS1130 LED driver. It’s made of 0.2mm thick circuit board so it can slightly bend. A few can be chained together for a larger display. With 120 0805 LEDs and an SSOP-28 AS1130, this kit is another great excuse to fire up the hot-air and get a stencil from OSHStencils. As always, all notes, schematics and code are in the Little (more...)