Search

OakieTags

Who's online

There are currently 0 users and 51 guests online.

Recent comments

Affiliations

November 2011

Getting started with Xen virtualisation on Ubuntu 11.10

After a long time and lots of problems I decided to abandon openSuSE 11.4 and its xen implementation in favour of the PVOPS kernel and a different distribution.

It’s been difficult to choose the correct one for me, for now I’m working with Ubuntu 11.10. One reason is that it’s said to be user friendly, and highly customisable. It comes with all the right ingredients for running different hypervisors, including my favourite: xen.

Important update! See “Security” below.

Background on Xen

For those who don’t know the story behind xen, here’s a short summary (errors and omissions are not intentional!)

UKOUG – A Deep Dive into the SQL Monitoring Report

The UK Oracle User Group Conference 2011 is just around the corner and I just realized that I haven’t yet highlighted this, other than the “I’m speaking” banner on my blog.  I’ll be speaking on one of my favorite and most used reports — the SQL Monitor Report.  Below are the session details [direct link].  Hope to see you there!

Upcoming Speaking Engagements

James Morle will be presenting at the UKOUG conference this year. He will be presenting full sessions on Oracle load testing during both the OakTable Sunday event and the main conference on the Wednesday. In addition he will be presenting an OAK Talk during Tuesday lunchtime. February 14-16 2012, James will present Sane SAN at [...]

Announcing OAK Talks

This year at the UKOUG conference the OakTable Network will be trying something a little different. In addition to the usual 45-60 minute presentations during the conference, and the special OakTable Sunday event immediately prior to the conference, we will also be trialling a new concept - the OAK Talk. Anybody that has watched a [...]

Back At Oracle Corporation (The Return Of The Thin White Duke)

I’ve been very quiet on the blogging front lately, so apologies for that. One of the main reasons is that after a period of nearly 10 years, I’ve decided to take up a position back at Oracle Corporation as a “Principal Solutions Consultant” in sunny Canberra. So things have been rather hectic, finishing up in [...]

A Year Older, Any Wiser? 2

November 30, 2011 (Back to the Previous Post in the Series) Today marks the second anniversary of this blog.  With just 372 articles posted in the last two years, the rate at which new articles are posted has decreased rather dramatically from the 1+ article per day average that was established shortly after the launch [...]

New link

I’ve just added Toon Koppelaars to my blog roll – and this is just a temporary note to highlight the addition.

The blog is “Triggers considered harmful, considered harmful” (and the near-quine is deliberate). It is a series of articles presenting and expanding on the presentations that Toon has given in the past at events like the Hotsos Symposium; and, eventually, will explain how we can implement all the necessary levels of constraints that allow a relational database implemented in Oracle to guarantee correct data.

UKOUG Agenda

Here’s my personal agenda for the UKOUG annual conference. I know it probably looks a bit busy – but even then there are some other sessions that I’ll be sad to miss.

I’m not sure I’ll be able to make it to all the things I’ve listed, though, however hard I try:

What happens when 12c Cloud Control runs out of disk space?

Question: What happens when 12c Cloud Control runs out of disk space?

Answer: It doesn’t work very well. :)

I have a 12c Cloud Control installation on an Oracle Linux 6.1 VM and I was pushing an agent to both nodes of an 11.2.0.3 RAC, also on OL6.1 VMs. The agent installation seemed to go fine and the agent upload to CC was fine, but when I tried to discover the database on the nodes it went a bit loopy. After a little messing about I noticed my disk was maxed out on the 12c CC server. Bummer!

So I turned off the VM, added another virtual disk, turned it back on and added the new disk to the existing volume. Bob’s your uncle!

SQL Trace and Oracle Portal

Recently I was involved in a project where I had to trace the database calls of an application based on Oracle Portal 10.1.4. The basic requirements were the following:

  • Tracing takes place in the production environment
  • Tracing has to be enable for a single user only
  • Instrumentation code cannot be added to the application

Given that Oracle Portal uses a pool of connections and that for each HTTP call it can use several database sessions, statically enable SQL trace for specific sessions was not an option.