File movement in and out of Azure

After a busy couple of weeks i finally got round to writing something new up - not strictly directly database related but If you're doing any work with Azure - getting files in and out of it is a key point of understanding. In my case i wanted to copy over some tarred up oracle software trees from on premise that we have fully patched up to date and then put onto azure servers using (more...)

Log Buffer #505: A Carnival of the Vanities for DBAs

This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.


Comma separated search and search with check-boxes in Oracle APEX

Once you have defined your users for your Express Cloud Service, all users with the role of Database Developer or higher can access the database Service Console.

Big Data Lite 4.7.0 is now available on OTN!

Install and configure Oracle HTTP Server (more...)

Reminder: Upgrade Workshops in March!

Hi Folks! While Mike is out in Vancouver and Calgary this week, I will be delivering upgrade workshops for our public sector customers in Harrisburg and Trenton. But this seemed like a good time to remind everyone about the "Upcoming Events" list in the right sidebar of the blog. You might need to scroll down... [Read More]

Last week in Stream Processing & Analytics – 20.02.2017

This is the 54th 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. This week I have included the presentation from the Spark Summit East 2017 which seem to talk about the topic:

News (more...)

Recovering an Asynchronous Callback in Oracle BPMN by Mark Petersen

imageWhen creating asynchronous services, you don't normally worry about what happens if the service fails to callback to the parent process.  However, if the callback does fails, it can create major problems for the parent process, making it stall without an easy way to recover. 

Take, for example, the following process, called SubmitCreditCheck. The asynchronous Call: Perform Credit Check service blocks until the Receive: Perform Credit Check callback message is received. If, for (more...)

Flipkart and the Executive Revolving Door

he contrast could not have been more striking, or poignant.
2017 began on a sombre note for Flipkart, when it announced on the 9th of Jan that Kalyan Krishnamurthy had been named CEO, and its current CEO Binny Bansal would become group CEO. It was the Indian e-commerce startup's third CEO in less than one year.
Three days later, on the 12th, Amazon let it be known via a press release that it (more...)

Backup Oracle Databases to AWS S3

There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take backups into AWS S3 is one of the most efficient methods in terms of costs and backup/restore performance.

In this post I will show you how to install, configure and use Oracle Secure Backup to take your Oracle database backups to AWS S3. This method can be used for Oracle database version 9.2 or higher.


Available Now ! Korea Cumulative Release Patch – KR.83

The following Korea Cumulative Release Patches - KR.83 have been released via My Oracle Support:

    Release 12.1 : Patch 25546910:R12.PER.B
   Release 12.2 : Patch 25546910:R12.PER.C

Post Install Steps must be run after patch installation.

The following Documents have been updated:

Introducing Advanced Analytics Training from Rittman Mead!


Rittman Mead is proud to release our new training course: Advanced Analytics with Oracle's R Technologies.

Oracle has made significant investments in the R language with Oracle R, ROracle and Oracle R Enterprise. Using these tools, data scientists and business intelligence practitioners can work together more efficiently and can transition between their roles more easily.

Rittman Mead has developed a three-day course that tackles R's notoriously steep learning curve. It builds on Oracle professionals' existing (more...)

Enable DDL logging

Enable DDL Logging:

ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log.

SQL> show parameter enable_ddl_logging

———————————— ———– ——————————
enable_ddl_logging boolean FALSE

SQL> alter system set enable_ddl_logging=TRUE scope=both;

System altered.

SQL> show parameter enable_ddl_logging

———————————— ———– ——————————
enable_ddl_logging boolean TRUE

SQL> select value from v$diag_info where name=’ADR Home’;



SQL> select value from v$diag_info where name=’ADR (more...)

Mobile Cloud Service & Chat Bots Webcast live on February 28th at 16:00 CET

Attend our February edition of the SOA & BPM Partner Community Webcast live on February 28th at 16:00 CET.


Mobile is the technology which is literally at everyone's finger tips.  Whether you are taking first steps with mobile, or full embracing a Mobile-first strategy, what you can't do is ignore mobile.
In this session will focus around Oracle Mobile Cloud Service (MCS) and give a firsthand look at how Oracle customers are embracing (more...)

Webcast: “Simplified and Touch-Friendly User Interface in EBS”

OAF WebcastOracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for the latest updates on our rapidly-evolving OA Framework (OAF) user interface capabilities, see:

Senthilkumar Ramalingam, Group Manager Product Development, shares the latest Oracle Applications Framework (OAF) which includes the Oracle Alta UI, a redesigned home page and a set of new components optimized for display on mobile (more...)

A New Wave of Mobile Engagement

Recently, we talked about the ascension of chatbots and how to engage mobile customers in both a timely and personalized, manner.  However, we have yet to address why either of these topics is, and will continue to be, a driving success factor for both enterprises and small businesses. To say that these advancements are a result of living in a Mobile-First world would be only a partial answer.  Mobile phones have been around (more...)

APEX 5.1 New Features – neuer Termin

APEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !

Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit (more...)

Listener Exception : Could not create listener: TNS-04414: File error

When I tried to add listner using netca for my test database, I am getting below issue

“Listener Exception : Could not create listener: TNS-04414: File error’

It could be possible ” Listener file having some wrong entries, so you need to check” or renaming current listener and tried to add (Here Please be note, your current listener configuration will be removed).

AMIS Tools Showroom – The Sequel – Donderdag 16 maart 2017

Donderdag 16 maart

17.00-21.00 uur

AMIS, Nieuwegein

Aanmelden via:

Op donderdag 16 maart vindt de tweede AMIS Tools Showroom Sessie plaats. De eerste sessie was op 13 december: hierin hebben 16 AMIS-ers in korte en hele korte presentaties en demonstraties allerlei handige tools en hulpmiddelen laten zien. De nadruk in deze sessie lag op tools voor monitoring, communicatie en collaboration.

In deze tweede sessie gaan we op zoek naar nog (more...)

Database Star Academy Membership is Now Open

The Database Star Academy membership is now open! Here’s what you need to know. What Is the Database Star Academy Membership? It’s a membership site with a monthly fee, that gives you access to many different online video courses and PDF guides related to Oracle database development. What’s Included? As part of your membership, you […]

AWS Quirks and Fake News to the Delphix Admin Console

We’ve been working hard to create an incredible new trial version of Delphix that uses AWS, which is built with the open source product Terraform.  Terraform is a tool that anyone can use to build, version and manage a product effectively and seamlessly in a number of clouds.  We are currently using it to implement to AWS, but there is a bright future for these types of open source (more...)

Building a Hyper-V Environment for SharePoint / Cyberinc Entitlements Server Prototype – Part 3

In my previous post, I covered the installation of SQL Server 2016 SP1 for our Hyper-V environment. After that is completed, we are ready to install SharePoint Server 2016. That’s what I’ll be covering here. Firstly, you need to download a copy of the software. At the time of writing this post, SharePoint Server 2016 is available from Microsoft. That’s the version I’ve downloaded for installation on the VM.

Installing the Prerequisites

To start the (more...)

Spark based Microservice- Deployment Automation in the Oracle Cloud

Spark is a Java based framework supporting development of micro applications/services. This blog will give an understanding of deploying a simple Spark based REST service project on Oracle Application Container Cloud using Oracle Developer Cloud. This post will show the essential capabilities for Spark framework based projects management, build automation and streamlined deployment in the Oracle Cloud, using Developer Cloud Service and deploying to Application Container Cloud.


Tech Stack Usage

Eclipse: IDE for Spark (more...)