ODC Appreciation Day: Online Database Move Datafile

ODC Appreciation Day - 10th October 2017 Last year Tim aka 'ORACLE-BASE' launched the the first OTN (Oracle Technology Network) Appreciation Day, after the success of last year this is being repeated again this year under the new moniker of ODC. As today is Tuesday 10th October 2017 expect some great content from fellow Oracle ACE's... Continue Reading →

One-Click Oracle 12c Database Clone

Background Earlier in the year at the excellent OUgf Finnish Oracle User Group Harmony 17 conference, I performed a Live demo where I refreshed an Oracle 12c database using an Ansible Playbook in just over a minute, 1min 16sec to be more precise. Once I had completed my presentation Frits Hoogland mentioned that he had recently used... Continue Reading →

Oracle EBS R12.2.6 on Virtual Box Pt2

If you followed my previous post Oracle E-Business Suite R12.2.6 on Virtual Box you will have already downloaded the 19 required zip files, and be ready to go. Ok, change directory to the location of the downloaded files, unzip and concatenate them into a single OVA file using the following: $ unzip 'V*.zip' $ cat Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.* >... Continue Reading →

Oracle EBS 12.2.6 on VirtualBox

Back in May, Oracle announced the general availability of Oracle VM Virtual Appliance for E-Business Suite 12.2.6 for download from the Oracle Software Delivery Cloud. In this series of Blog posts I will detail how you can build an Oracle EBS 12.2.6 environment with VirtualBox for use on a laptop / PC. Getting Started Logon to... Continue Reading →

Automate to avoid database cloning disasters.

"Accidentally destroyed production database on first day of a job" Wow, that headline grabbed my attention. Earlier this week you may have seen an article reported by The Register about a post in  reddit from a junior software developer going by the name of  "cscareerthrowaway567", who on his/her first day destroyed a Production database and lost their job.... Continue Reading →

Oracle 12c Online Database Move Datafile

After watching an Oracle R12c new features presentation at a recent conference somebody asked me what was my favourite Oracle R12c database feature, for me it was easy has to be 'ALTER DATABASE MOVE DATAFILE' Prior to Oracle 12c moving non-ASM data files required taking data files 'offline' and negotiating an outage with the business, with... Continue Reading →

How to resize an XFS filesystem

A question which I frequently get asked is, how do I a resize my Oracle XFS file system ? As I needed to resize an Oracle FRA area today, I thought this would make a great topic for a Blog post. Ok, lets start be checking the current size and geometry using the Linux df... Continue Reading →

Create a website or blog at WordPress.com

Up ↑