Top Reason I’ve Learned Everyone Should Use Delphix- Week 2

I’ve been going through some SERIOUS training in just over a week.  This training has successfully navigated the “Three I’s”, as in its been Interesting, Interactive and Informative.  The offerings are very complete and the knowledge gained is limitless.

I’d also like to send a shout out to Steve Karam, Leighton Nelson and everyone else at Delphix who’s had a hand in designing the training, (more...)

My New Book!

After what seems like eons since we first started on it, I’m excited to announce a new book I co-authored is finally out. The book is called “Building Database Clouds in Oracle 12c” and is available on Amazon. Of course, it really isn’t that long ago that we started writing the book, but there’s been a lot happening between then and now!

The book was co-authored with Tariq Farooq and Sridhar Avantsa. Tariq asked me (more...)

Canberra Event – Next Let’s Talk Database presentation by Richard Foote

Let’s Talk Database – Thursday, 28 July 2016

The next in Richard Foote’s popular Let’s Talk Database series – Let’s Talk Database: Oracle Database 12c – Built for Data Warehousing – is on in Canberra on July 28th. These are free events but due to limited places have often “sold out” in the past, so booking early is recommended to avoid disappointment.

Session Details

The Oracle Database is the leading database in market but it (more...)

clckwrk Design Blueprint: Peoplesoft Campus Solutions on AWS

Higher eduction establishments around the world use Peoplesoft Campus Solutions from Oracle to manage their key business processes. 

In this reference architecture we look at the key requirements for Campus Solutions and the technical solutions that can be deployed on the Amazon Web Services Cloud. 

Availability: Campus solutions needs a high availability infrastructure to ensure that both the administrative and student users can access data at all times. This solution uses multiple web and (more...)

clckwrk Quick Guide: Run your DR solution for the cost of a backup – ERP in the AWS Cloud

In this blog we're looking at a cost effective method for disaster recovery in the AWS cloud. The key here is that the cloud gives you on-demand infrastructure so there is no need to have any servers, storage or networking kit patiently waiting for the DR button to be pushed, instead you can hold just the definition of the technology and a recent backup of your data and build the necessary infrastructure just when it is needed. 


Slashing the costs of your databases … choosing your PaaS or Next Gen Database Platform

Do you want to lower the costs of your database estate? Are you trying to stay inside the license purchases you’ve made? Maybe looking to simplify the admin across servers, storage, networks and DBA?

It’s a question we get asked over and over in a world where there are great advantages in adopting the next generation of Platform as a Service (PaaS) and Next Generation database platforms. Seeing AWS park its tanks on Oracles lawn (more...)

#DBADev (Ops), who knows what is going on…

I have been considering writing this article for quite some time now.
APEX Connect 2016 in Germany’s capital Berlin and the DOAG Database days have finally persuaded me to talk more about #DBADev, let me explain why…

Whenever in the stone age…

During my career as DBA, I was always working closely together with Oracle Forms & Reports developers. In retrospect, the cooperation in that time was remarkable.
These Forms & Reports developers had always (more...)

clckwrk Quick Guide: Backing up Oracle databases on AWS using snapshots

Did you take a backup first? Of course you did.

In this post we look at one way to simply back up your Oracle database in the AWS cloud. We're planning on making this the first in a series of Quick Guides for working with Oracle and public cloud. We hope you like it, please follow, comment or like if we're hitting the spot!

This example uses a self managed database, rather than RDS, so (more...)

Protecting your data in Oracle – now you see it, now you don’t!

In this article Peter Berry from clckwrk shows how smart use of Oracle and AWS functionality can secure sensitive data in production and and automatically obfuscate when that data leaves the server.

Data security is a key concern for all businesses. Ensuring your data is secure in your production system and that data leakage is controlled is typically addressed by encryption and obfuscation respectively. Encryption can be difficult to deploy and costly while obfuscation can (more...)

New Installation Cookbook: Oracle Linux 6.7 with Oracle RAC

cookbookI’ve updated my install cookbooks page to include a new cookbook for installation of Oracle Real Application Clusters on Oracle Linux 6.7.

This is also the first one I’ve published since I left the employment of Violin Memory to work for Kaminario, so this install uses a Kaminario K2 All Flash Array. However, it applies very well to any Oracle RAC installation which uses relatively capable storage.


Filed (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...)

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...)

#Javaland 2016 conference day 2


This was my second day:

Michael Tamm (optivo GmbH): Feature Toggles on Steroids

Very good summary off all topic’s covering feature toggles. Wish I had this summary 2 years before, were we have evaluated this. Unfortunately furthermore no solutions for declarative frameworks like Oracle ADF with it’s wizards and xml configurations, which later generated code. Ironic answer to my question: “Don’t use frameworks – use Java”

Alexander Casall (Saxonia Systems AG): User Experience for techies

Now (more...)

Configuring VNCR for Oracle RAC

By default on an Oracle RAC installation, the listeners are configured to allow any database to register with them.  There is no security out of the box to determine which databases may register.  While this makes it easy to create new databases without worrying about listener registration, this can cause potential problems in a real environment.

This can be dangerous working with RAC environments where the database registers with both a local and remote listener.  The (more...)

Recover from ORA-01172 & ORA-01151

This morning I was working on an Oracle Management Repository (OMR) for a test Enterprise Manager that is used by a few consultants I work with. When I logged into the box, I found that the OMR was down. When I went to start the database, I was greeted with ORA-01172 and ORA-01151.

These errors basically say:

ORA-01172 – recovery of thread % stuck at block % of file %
ORA-01151 – use media recovery (more...)

Oracle Apex 5.0 and APEX_JSON

How many lines of code does it take to make a web service call? Answer: 39

That is how many lines of PL/SQL I had to write in Oracle Apex 5.0 to make a web service call to an external API.

I used Adzuna's REST API to retrieve the latitude and longitude and the price of 2 bed properties for rent in a specific location in UK. The API returns JSON which the APEX_JSON (more...)


This blog post is inspired on work I have been doing on Standard Edition databases and the returning confusion about what is and what is not part of Standard Edition.

DBA_FEATURE_USAGE_STATISTICS is a tool in determining license usage for the Oracle database. It is good to understand the implications of each entry, know what is happening in your database and thus be able to have a substantial conversation about the usage of your license, being (more...)

@HrOUG_2015 in Rovinj, Croatia

In a hectic year it is good to attend and contribute to Oracle user group sessions. This adds an element of a ‘Working Holiday’ to someones schedule. I can promise you, the vacation isle of Rovinj is a perfect venue for this and especially since it is the last week of the opening of the Hotel for this season.
Of course you can find all information about contributing to these events right here!!

@HrOUG_2015, (more...)

Restoring a Database to a New Diskgroup

I had the pleasure of rebuilding an Exadata rack for a customer a while back, and it provided a pretty good refresher in backup and recovery for me.  As DBAs, we back up databases all the time, but the restores are performed much less frequently.  In the case of this rack, there were several databases across multiple ASM diskgroups.  One of the goals of the rebuild was to consolidate all of the databases into a (more...)

MRP process on standby stops with ORA-00600

A rather not so great post about an ORA-00600 error i faced on a standby database. Environement was on Sun Super Cluster machine. MRP process was hitting ORA-00600 while trying to apply a specific archive log.

The error message was something like this

MRP0: Background Media Recovery terminated with error 600
Errors in file /u01/app/oracle/product/
ORA-00600: internal error code, arguments: [2619], [539], [], [], [], [], [],  (more...)