Top 60 Oracle Blogs

Recent comments

October 2011

OOW2011 A.P. (After Presentation)


OEM 12c , cloud control

Was emailing with my esteemed college John Beresniewicz at Oracle in the OEM group. John and I worked together on OEM 10g and thank goodness he is still there as he is generally behind any good quantitative visualizations you might see in the product. Here is one cool example he sent me:

The database load, AAS, can be time selected and from the selection a load map is shown, in this case of which objects are creating the most I/O load, group by type of I/O. Super cool. Congrats JB and I look forward to exploring more in OEM 12c “cloud control”.



Friday Philosophy – The One Absolute Requirement for System Success

Alternative title “The lady from Patient Admin – she says YEEESSSS!!!!!!”

What must you always achieve for an IT system to be a success?

  • Bug free? Never happens.
  • Within budget/time frame? That would be nice.
  • Includes critical business functionality? Please define critical.
  • Secure? Well, it’s important for many systems but then it is often lacking (even when it is important).
  • That it is to specification? Well we all know that’s wrong.

There is only one thing that an IT system must always achieve to be a success.

User Acceptance.

For an individual system other considerations may well be very important, but the user acceptance is, I think, non-negotiable.

A History of (my) Certifications…

I was chatting with the lady doing OCP Lounge registrations at OOW11. During this chat I mentioned I hadn’t received a certificate for the SQL Expert certification. It never crossed my mind to re-request it, since my certifications are visible on anyway. Yesterday, a DHL man delivered the missing certificate, which prompted me to look though my certifications and scan this image.

First, check out the card on the bottom right. I was unaware the “Expert” certifications had a different colour card.

Second, notice anything funny about the 9i DBA OCP certification?

It’s hard to believe it’s over 12 years since I first completed one of these certifications… :)



Ad: Der Oracle DBA – Handbuch für die Administration der Oracle Database 11gR2

Der Oracle DBA

The book Der Oracle DBA (Hanser, 2011), which was written in German, is at last available!

I say “at last” because the authors worked on this project for not less than two years.

What Could Go Wrong? Testing the DB_FILE_MULTIBLOCK_READ_COUNT Parameter

October 14, 2011 (Modified October 15, 2011) When reading various Oracle Database books, I often perform mental exercises related to the book’s contents, asking “what could go wrong?”   That is probably why some of my book reviews have extended to record setting lengths… who knew that Amazon imposed a limit on book review lengths… I [...]

Its that time of the year

When its time to start booking hotel rooms and planning your agenda for the UKOUG conference in Birmingham (UK) for the 4th to the 7th December. Yep, all the cool sessions from Oracle Open World, minus an awful lot of the pure marketing. So just to wet your appetite here are my highlights in advance [...]

OTN Night at OOW11: Circus Performers…

I mentioned in a previous post that I went to the OTN Night on the Monday at OOW11. I also spoke about eating far too much when I was there, but forgot to mention were the circus performers…

Anyone who knows me knows I’m obsessed with flexibility. I love stretching and I love watching anything involving flexibility. San Francisco has a famous Circus School, so previous OTN parties have had assorted circus performers to entertain the punters. In addition to the usual clowns, this year there was a contortionist with a hula hoop. She did elements of the Cirque du Soleil act made famous by Elena Lev in Alegria. You can see the original act here.

Needless to say I watched the contortionist at the OTN Night while stuffing noodles into my face.



The UKOUG 2011 Conference: OakTable Sunday !

Do I need to say more………. Why not join us for OakTable day on Sunday 4th December? In a smaller setting, you can attend a dedicated set of sessions directly from a selection of OakTable members away from any potential session contention of the main conference. The sessions will be presented in just two streams, …

Continue reading »

The tale of restoring the OCR and voting files on Linux for RAC

As part of a server move from one data centre to another I enjoyed working in the depths of Clusterware. This one has been a rather simple case though: the public IP addresses were the only part of the package to change: simple. One caveat though was the recreation of the OCR disk group I am using for the OCR and 3 copies of the voting file. I decided to reply on the backups I took before the server move.

Once the kit has been rewired in the new data centre, it was time to get active. The /etc/multipath.conf file had to be touched to add the new LUNs for my +OCR disk group. I have described the processes in a number of articles, for example here:

A few facts before we start: