Default Changes SPFILE Parameters – Oracle 12.2

Parameters in Oracle Database - part 4 of the series: New SPFILE Parameters in Oracle Database Obsolete SPFILE Parameters in Oracle Database Deprecated SPFILE Parameters in Oracle Database Default SPFILE Parameter changes between Oracle Database,... [Read More]

Serial database backups using Oracle Enterprise Manager

For several years now, I’ve been a fan of backups controlled by Enterprise Manager (of Grid Control, or Cloud Control, call it what you want). It is relatively easy to configure backups for your databases and it is well known in our DBA world. Only one thing bothered me though, until I found out the solution had been at hand for years and years already…


Parallel versus serial backup.

The brochure looks nice: create (more...)


In Oracle Database 12.2 (available in the Oracle DBaaS Cloud) there's a new functionality called "PDB LOCKDOWN PROFILES". Actually the parameter came already in undocumented and not functional in Oracle Database (see here). PDB Lockdown Profiles PDB Lockdown Profiles are meant as a granular... [Read More]

GoldenGate 12c Certified with E-Business Suite 12.2

Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems.  The GoldenGate Administrator's Guide shows six supported topologies for generic databases.  Oracle GoldenGate 12c is now certified for a subset of three of those methods in Oracle E-Business Suite Release 12.2 environments:

  1. Unidirectional (Reporting Instance):  From the E-Business Suite to a reporting instance
  2. Broadcast (Data Distribution): From the E-Business Suite to multiple external databases
  3. Consolidation (Data Warehouse/Mart/Store): (more...)

European Information and Communications Technology (ICT) Jobs are Booming, but…

The technical skills gap is widening.   As ICT graduate numbers fail to meet demand, companies must look to reskill and certify business staff. 

ICT job numbers in Europe have been growing at a tremendous pace since the start of the millennium, now totalling 7.7 million and accounting for 3.5% of the continent’s total workforce. But demand for ICT workers is growing even faster and, if current trends continue, there are likely (more...)

Oracle GoldenGate for MySQL is Certified on Amazon Aurora Database

Oracle GoldenGate for MySQL 12.2 is now certified on delivering to Amazon Aurora database. With this certification, Oracle GoldenGate users can use Oracle GoldenGate to deliver data to Amazon Aurora databases, including Aurora DB Cluster. 

The supported configuration is remote apply with a connection to Aurora database endpoints. 

Easily Migrate Workloads to the Cloud with Oracle Database 12c R2 New Features Training

With so much happening in the cloud these days, you don’t want to miss the Oracle Database 12c R2: New Features for 12c R1 Administrators Training

Why Take Oracle Database 12c R2 New Features Training?

Oracle Has the Worlds #1 Database for Cloud Scale Simplicity

New data management capabilities enable companies of all sizes to confidently and easily migrate workloads to the cloud. Its massive cloud (more...)

How to get started with Oracle Database 12c Release 2 (12.2) today?

If you follow my website or the blog, you will know I’ve been putting out some articles about Oracle Database 12c Release 2 (12.2) recently. They are often followed by a question asking when it will be available for download. The answer is…


Even though we don’t currently have a downloadable version of 12cR2, that doesn’t stop you learning it. You can start today! There are two easy ways.

  1. Get a (more...)

#Oracle cutting in inspiration and new business?

Over the many years Oracle has been leading the database world, I guess they are now taking something of a wrong turn.
Let me briefly fill you in on my thoughts.

Basically I see two “minor” shifts that are significantly indicative of this:

  1. Oracle Standard Edition 2
  2. Oracle ACE Program

Okay, so you might think I am crazy, but let me try to explain.

Oracle Standard Edition 2

Sometime last year, the long expected, (more...)

Multitenant Enhancements in Oracle Database 12.2

I’ve started playing with some of the new multitenant functionality in Oracle Database 12c Release 2 (12.2). There’s a lot of really cool stuff in there, which makes the multitenant architecture even more interesting. You can get a free trial of the Oracle Database Cloud Service and check it out if you like. 🙂

Here’s what I’ve been doing over the holidays.

Creating a RAC cluster using Ansible (part 2)

In my previous 2 blogposts i explained how to setup a Vagrantfile that deploys 2 virtualbox machines that can be used as a basis for a RAC cluster and how you could use Ansible to deploy RAC on those VM’s. In this post i want to dive a bit deeper into how i setup Ansible and why, keep in mind that this just one way of doing this.

The Github repository containing all the files (more...)

12.2 DBaaS (Extreme Edition) possible bug/issue with the DB install/setup

A few weeks ago the 12.2 Oracle Database was released on the cloud. I immediately set an account and got my 12.2 DBaaS setup. This was a relatively painless process and quick.

For me I wanted to test out all the new Oracle Advanced Analytics new features and the new features in SQL Developer 4.2 that only become visible when you are using the 12.2 Database.

When you are go to (more...)

#DOAG2016, definitely a crazy week.

#DOAG2016, the largest Oracle Community gathering in Europe. Taking place in Nuremberg, at the Nuremberg Convention Center NCC, one of the more impressive places to hold such a conference, towering 4 stories high, with a big central atrium!!
It is a huge effort to get all of this together!

In this blog-post I want to highlight some of the crazy things I experienced this week… And… I did try to follow my own schedule (more...)

Associating Oracle Database 12c Databases with Compliance Standards

In my last post, I walked you through the first part of installing the Oracle Database 12c STIG compliance standards sample code. The next step to using these compliance standards is to associate your Oracle Database 12c databases with these standards. You may recall there are two separate standards in the sample code, one for multitenant databases and the other for conventional architecture databases. The process of associating the databases is the same in (more...)

OTN Appreciation Day: PL/SQL

We are posting these blog posts today as part of the OTN Appreciation Day, a celebration for the Oracle Technology Network as suggested by Tim Hall, inspired by Debra Lilley.

The mission was not too hard: write about your favorite bit of Oracle Technology.

As a developer and a core-tech DBA and APEX enthusiast… the choice was easy! PL/SQL (apart from how it is pronounced or even written ;-)!

Why? Easy!

Not just because (more...)

#OOW16, San Francisco, looking back

In this post I just wanted to highlight a few things that have lingered with me since the 2016 Oracle Open World Experience.

Persistent DRAM
Now, here, being at home, I must admit that I cannot find very much documentation about this, but it got me thinking… A little paradigm-shift, where computers actually wouldn’t need moving parts anymore (ie. disks of any kind). Create devices that use these memory structures, quite possibly combined with flash-disks, (more...)

#doag2016 my picks and suggestions

As many conferences evolve over the years, the number of sessions on offer can easily be overwhelming. I have overheard many conference attendees wrestling with their choices for what to see and which sessions to attend.

For DOAG 2016 I have a short overview with my picks and with one or two tip-sessions. I hope this helps, though it is just my personal preference of course…

Please note that this post is based on the (more...)

Oracle Database 12c STIG Compliance Standard sample code is here!

One of the most requested features in the compliance management area has been a compliance standard for Oracle Database 12c. As most of you would know, Oracle Database 12c has been out for quite some time, and indeed Larry Ellison has just announced at OOW2016 availability of Oracle Database 12cR2 in Oracle’s public cloud offering. However, as I discussed in another post earlier this year, creating a new STIG compliance standard is not a simple (more...)

Virtual Development Server: Provide Docker images in docker registry for Oracle XE Database and others

For later creation of containers as needed in the deployment process we have first to build docker images whenever we do not find suitable one in docker hub.

For most of my development I need a oracle database. On the internet you can find a lot of Dockerfile’s for this, but no ready image. This is because for running a database you have to accept a license and this happens when you download the installation (more...)

#OOW16, San Francisco

This year, 2016, is turning out to be an amazing year again, with #OOW16 being once again on of the apices!

Looking back

After the discovery of the Oracle community in 2012, as a result of a very first trip to downtown San Francisco in 2010 for #OOW10, an amazing chain of events was set in motion. This very first introduction in the Oracle World was as ‘a mere participant’ in this awe-inspring, large (more...)