Upgrading my Oracle JVM Diagnostics Agents.

Hello there,

Taking Off One of my Community Hats – Oracle Scene

For the last couple of years I’ve been involved in “Oracle Scene”, the UKOUG magazine about all things Oracle. Click the link to see the current edition, which is free to view to everyone, member of the UKOUG or not.

I take of my OS hat - and they give me one to keep :-)

I take of my OS hat – and they give me one to keep🙂

I first became involved by writing an article for Oracle Scene. In fact it was the first thing I’d written (more...)

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

Reorganising data within tablespaces

I am currently interested in managing storage on our Exadata platform which is primarily used for running a data warehouse.

The ongoing challenge is that most of the large tablespaces use a bigfile datafile and we insert data using append. That causes data gaps within the datafile and it is constantly growing. A recent example showed a 7Tb datafile containing only 2Tb of data and yet the ASM diskgroups were reporting we were running out (more...)

12 Days of #Cloud: Enabling #DBaaS Backups

12 Days of #Cloud: Day 6 When I created the #DBaaS instance, did not create a backup policy. I chose the backups as “None”. Now that some work has been done on the database, would like to create an adhoc backup as well as want to schedule regular local disk backups. On-demand backup can be performed […]

My new role

Today I can finally tell you the good news on my new role. December 8th was my last day at Oracle. So what was the good news? I already have a new job, as a technical architect with a small company called archTIS. I saw the job advertised on LinkedIn and applied, spent an hour and a half in a phone interview the next day, got called in to meet the CEO the day after (more...)

Updates to Oracle image copy backup scripts

I added a few larger updates to my Oracle Image Copy backup scripts.

  • Now it also has built in support for Netapp NAS storage
  • In addition to autorestore script there now is restore.py script that you can use to spin off cloned databases restored to a specified point in time

Go and check out the scripts from here

Oracle Week 2016: Oracle Database Advanced Querying 2016 (slides)

This is the presentation for Oracle Advanced Querying session I did in Oracle Week few weeks ago.

Since most of my readers aren’t from Israel, let explain a bit about this event. Oracle Week is by far the biggest Oracle oriented conference/event in Israel. It’s a 5 days conference that is being organized by John Bryce Education (a technology schooling company) and has around 1500 participants each year. It’s an educational event – meaning, as (more...)

Cloning 12c SE2 Oracle Home for Windows 2012 R2

Process is pretty much similar to *nix environment with a few exceptions.

It was harder that it should be since I wanted to perform task using CLI vs GUI.

This does not cover zip and unzip of OH and I cannot believe how junky Winzip has become since I have typically been using 7-Zip.

Cloning 12c SE2 Oracle Home for Windows 2012 R2



12 Days of #Cloud: Exploring #DBaaS File System

12 Days of #Cloud: Day 5 When you create a new Cloud DBaaS instance, Oracle Cloud Service provision a VM and required file systems. These are the file systems:   [crayon-58563e80d4a01338487156/] /u01 – Local file system – Oracle software binaries, DIAGNOSTIC_DEST /u02 – Cloud Storage – Database Files, Change tracking file /u03 – Cloud Storage […]

Oracle Database 12c on Fedora 25

I was having a play around with Fedora 25 last weekend and I just noticed there was no associated blog post about it, so here goes.

First the warning I always have to include. Do not install Oracle on Fedora before reading this! With that out of the way, let’s continue.

Since Fedora is the proving ground for future releases of Red Hat Enterprise Linux (RHEL) and I’m a fan of running Oracle on (more...)

The Twelve Days with Delphix


On the first day with Delphix, I provisioned with glee, an IT Manager Happy.

On the second day with Delphix, I provisioned with glee, two SAP ASE and an IT Manager Happy.

On the third day with Delphix, I provisioned with glee, three Oracle Databases, two SAP ASE and an IT Manager Happy.

On the fourth day with Delphix, I provisioned with glee, four (more...)

Friday Philosophy – Is a “Free Lunch” Only Ever a Mirage? Look Closer!

Nearly all of us have heard (or even used) the phrase “There is no such thing as a free lunch” and we know what it means – if something of value is provided for no up-front cost, you are paying for it in some other way. According to the Wikipedia entry for it the phrase could have originated from US bars that offered a free meal with a drink, but the meal was salty and (more...)


First, any backup implementation should have recovery point and time objective.

Next, there’s no right or wrong, just what fits the requirements.

FILESPERSET controls maximum number of files for each backupset.
MAXPIECESIZE controls maximum size of backuppiece.
MAXSETSIZE controls maximum size of backupset.

Typically, if MAXSETSIZE is set it should be equal to or greater than maximum size of all data files.
In general, it is not recommended to set MAXSETSIZE.

Backupset can contains 1 (more...)

Password validation takes a while, how cool is that!!

You log in to your favorite web app and it takes a little while to get your login validated, or your password consumed, depending on your take on things,
You log in to your favorite APEX application, and after every 3rd shot, it takes a bit longer to retry

You are sure what you are doing and you are surely not drunk, but just mistyped the ****-password.

It is annoying, but is it?

I (more...)

Catalog your Named Credentials

You can catalog your named credentials quickly and easily with EM CLI.

emcli login -username=SYSMAN

emcli sync

[ $NCCATALOG ] && rm -f ${NCCATALOG}
touch ${NCCATALOG}

for thisNC in `emcli list_named_credentials | awk '{ print $1 }' | grep -v "Credential"`; do
emcli get_named_credential -cred_name=${thisNC} >>${NCCATALOG}



Your results will look like this:

Credential Name:CRED_SYSDBA
Credential Owner:SYSMAN
Credential Type:DBCreds
Credential Target Type:oracle_database
Credential Username:sys
Credential Scope:global
Credential Guid:<string>
Credential Stripe:TARGETS

Oracle’s Database as a Service in action


Have a look at Oracle's Database as a Service in action:

This is a preview lecture of the Udemy Course: Oracle Private Database Cloud. 

The full Udemy course is available on https://www.udemy.com/oracle-private-database-cloud/?couponCode=ORANOVTODEC16 


Porus Homi Havewala.

Advanced Replication

Long before Streams, long before Goldengate, if you want to keep data between sites synchronised in some fashion, or even allow sites to independently update their data, there was the Advanced Replication facility in Oracle.  An “extension” of the concept of simple materialized views (or snapshots as they were called then), you could design complete replicated environments across Oracle databases.

But it was a non-trivial exercise to do this.  You had to be (more...)

Creating a RAC 12.1 Data Guard Physical Standby environment (1)

I have just realised that the number of posts about RAC 12c Release 1 on this blog is rather too small. And since I’m a great fan of RAC this has to change :) In this mini-series I am going to share my notes about creating a Data Guard setup on my 2 node RAC primary + identical 2 node RAC standby system in the lab.

NOTE: As always, (more...)

Investigating IO Performance on Amazon RDS for Oracle

I’ve recently been involved in quite a few database migrations to Oracle RDS. One thing that I had noticed when dealing with post-migration performance issues was related to queries that used TABLE SCAN FULL in their execution. It seemed, that in many cases, it just took a single query to max out the allocated IOPS (IOs per second) or bandwidth, which in turn would caused overall slowness of the RDS instance.

The search in documentation (more...)