Got anyone who needs April Fooling?

Do you have a sql*plus user who really needs an April Fool’s joke played on them? With a little editing to their glogin.sql, every sql*plus session will exit with what appears to be a pseudo-random TNS error.

(Note: assumes a *nix environment that has sed, grep, awk installed and oerr properly working.)

[oracle@localhost ~]$ cd $ORACLE_HOME/sqlplus/admin
[oracle@localhost admin]$ mv  (more...)

Last Chance! 27 Techincal Sessions deliverd by Oracle and Community Experts

| Mar 31, 2016

April 5, 2016 9:30 – 13:30 BST / 10:30 – 14:30 CEST.

Get insights, hands-on and expert views on a wild mix of expert topics across Database, Java Development, Middleware and Systems.
We are looking forward to meet you at the Oracle Technology Network Virtual Technology Summit next Tuesday morning (BST) for a dense mix of technology sessions. View the full agenda and all session abstracts here.

Oracle TNS-12535 and Dead Connection Detection

These days everything goes to the cloud or it has been collocated somewhere in a shared infrastructure. In this post I’ll talk about sessions being disconnected from your databases, firewalls and dead connection detection.


We moved number of 11g databases from one data centre to another.


Now probably many of you have seen the following error in your database alertlog “TNS-12535: TNS:operation timed out” or if you haven’t you will definitely see it (more...)

Save MapR Streams messages into MapR DB JSON

Read this article on my new blog In this article you will learn how to create a MapR Streams Consumer that saves all the messages into a MapR-DB JSON Table. Install and Run the sample MapR Streams application The steps to install and run the applications are the same as the one defined in the following article: MapR Streams application Once you have the default producer and

Full Table Scan not always as low as 0.5% of data!

Based on a reply from Jonathan Lewis to an OTN post on Explain Plans I need to correct some of the claims made in my previous post on Full Table Scans.

I'm going to repeat the inaccurate paragraphs and the Conclusions I posted then [edited here for brevity], and then point out the mistakes in them, and an attempt at a corrected set of paragraphs. I will also edit the original post and replace these (more...)

Bind Variables

This example, tested on Oracle 11, shows how you can define bind variables in SQL*Plus, assign values to them in PL/SQL then display those values afterwards back in SQL*Plus:

SQL> variable bv1 varchar2(3)
SQL> variable bv2 number
SQL> begin
  2  select 'ABC' into :bv1 from dual;
  3  select 123 into :bv2 from dual;
  4  end;
  5  /

PL/SQL procedure successfully completed.

SQL> print bv1


SQL> print bv2


SystemTap Guru Mode and Oracle SQL Parsing

Introduction and motivations

SystemTap and dynamic tracing tools in general give administrators great control on their systems with the relatively little additional effort to learn the new tools. In this post you will see of how SystemTap that can be used to modify data on the fly at runtime. The outcome is a form of "live patching". Examples are provided on how to apply these ideas to Oracle SQL parsing functionality. This type of "guru mode" use (more...)

When should you use Oracle RAC?

Over the past years we've worked on many Oracle projects, some with RAC, some without, some which intended to implement RAC and failed, and some which implemented poorly and ripped it out at the last minute. 

For those new to Oracle, RAC is the Real Application Cluster option for the database which lets you cluster the database servers. The main reason for using for RAC is that it brings resilience to a system, it (more...)

My Demo Application

If you experience a problem accessing My Demo Application (old and new version) at, that means there is a reason for that. One of the users deleted all the applications in my workspace and installed some of his own. I don't think this was intended but it is still a lot of work and I am trying to geta all the important stuff back online. After that I will need to rethink (more...)

Customer Service Thinking

My definition of good customer service is pretty simple:  deliver what you promise.  Period.  You can over-deliver and still make me happy.  But other than that, it's pretty simple.  Tell me what you promise you'll do.  If I sign up for the service, then delivery that service:  on-time, at the price you promised, and make it as easy for me as you promised.  That's it.

Earlier this week, I encountered back-to-back customer service failures with (more...)

Quorum disks in Exadata

An Exadata quarter rack has two database servers and three storage cells. In a typical setup, such a system would have three ASM disk groups, say DATA, RECO and DBFS_DG. Usually the disk group DATA would be high redundancy and the other two disk groups would be normal redundancy. The high redundancy disk group guards against the simultaneous failure of two partner disks or the complete failure of two storage cells.

There is a high (more...)

More Animals in Big Data Zoo – Big Data Landscape for 2016

| Mar 25, 2016

Hi All

While surfing net stumbled upon Big Data Landscape for 2016 image and it was very impressive to see many more new Animals in Big Data Zoo.


New Animals

Hope This Helps

Sunil S Ranka

Free Mini Book about Reactive Microservices

Working with and talking about microservices has been my focus for a while already. And since I started working at Lightbend I already had the pleasure to work with some amazing people. One of them is Jonas Bonér and it has been a real pleasure helping with the creation of this little mini book about reactive microservices. Many of the concepts described in this book are the foundation for our newly open source microservices framework Lagom. It makes (more...)

Oracle BPM 11g: Mapping Empty Elements

In this blog article I explain what happens with mappings for which the source is empty, and you map it to an optional or mandatory element. The scenarios described in this article are based on SOA / BPEL 11g. In some next article I will describe what happens when you do the same in SOA 12c (which is not the same).

Let's assume we have a data structure like this:

And let's assume we have (more...)

Tools vs Products

I have a garage full of neat tools.  Drill press, miter saw, band saw, table saw, power sander, Dremel, several Milwaukee power drills and portable hand saws, gauges, clamps, vise grips...yeah, the works. But I've learned something over the years; other than other people with a shared interest in nifty tools, nobody cares about the tools I have.  What they care about is the speed, quality and cost involved in making things with those (more...)

Enterprise Manager 13c And Database Backup Cloud Service

The Oracle Database Cloud Service allows for backup of an Oracle Database to the Oracle Cloud using Rman. Enterprise Manager 13c provides a very easy way to configure Oracle Database Backup Cloud Service. This post will walk you thru setup of the Oracle Database Backup Cloud service as well as running backups from EM.

There is a new menu Item to configure the Database Backup Cloud Service (DBCS) in the Backup & Recovery Drop down.


What DBAs need to know about Amazon RDS

We’re looking at many customers who are considering moving from on-premise  databases to cloud hosted  instances running Oracle. This is a pretty well trodden path in cloud terms and also in Oracle terms - you go through the same process with Oracle as you would have if you moved from one piece of hardware to another in the past - it’s a platform migration and sometimes you’ll upgrade the database as you go. After that (more...)

Creeping Slow Performance

A recent OTN post requesting help for a slow performing update where Oracle was doing a full table scan, also revealed that the update was getting slower and slower each month, and that new data was loaded into the table each month to be "processed" i.e. updated. Unfortunately this kind of design suffers from a natural creeping slowdown in the elapsed time of the update process. Each month it will take longer and longer (more...)

Oracle AppsUnlimited – Building your Own Machine on IaaS with EBS

Oracle Public Cloud gives multiple options to create a base image. There are options available from the market place which I will cover later. Here I will cover building your own machine image on IaaS with your own EBS Installation. If you are a customer running 12.1.3 this should interest you. This procedure can be used to build multiple development single node EBS images of your choice.

I will make the document generic (more...)

I have a great idea!

- Hello Developer.
- Hello... you..
- Listen, I have this great idea for an App.
- Really?
- yeah!
- what's it about?
- can't tell you.
- OK...
- So Developer, will you write the code for the App?
- OK, but what should I write? What will the App do?
- Cant tell you.
- Why?
- You haven't signed a NDA yet.
- I see. so where is it?
- I (more...)