Search

Top 60 Oracle Blogs

Recent comments

November 2013

Theory of Constraints

phoenixproject-680x400

Great interview with Gene Kim, author of The Phoenix Project, discussing the Theory of Constraints and delays in project development. Here is an excerpt starting from minute 6:50

Untogether Lives

A little over a year ago, I wrote a review of a book called Girl 99 by Andrew P. Jones. I got an email from the author a few days ago to say his latest book, Untogether Lives, was released on Kindle, so I downloaded it straight away. Here’s what it’s all about.

Untogether Lives is a collection of fourteen stories that peek through the curtains of an eclectic cast, struggling to keep mind, body and the world around them together. From an amputee shoe thief, to an unlikely arsonist, to a sexually frustrated quadriplegic.

Predominantly dark and occasionally disturbing, these stories are not for the faint-hearted, but neither are they without humour. Not everyone in Untogether Lives gets a happy ending, and not everyone survives – but, hey, that’s life for you.

Oaktable World UK Dec 2 & 3

Oaktable World UK 2013

Oaktable World continues it’s global tour with the next stop in Manchester, UK during the UKOUG.

Scale Abilities is proud to be sponsoring the first independent OakTable World UK event along with co-sponsors Pythian and Dbvisit.

Check out the awesome lineup

otwuk

And it’s free. Just be sure to register to reserve your place.

 

Register at  http://www.scaleabilities.co.uk/oaktable-world-uk-2013/

Minimal-downtime PSUs on CRS with Cloned Golden Images

About a month or two ago, I was doing some work toward developing a process to patch CRS out-of-place using cloned golden images. I held off on publishing anything because I wanted to do some testing but we’ve been so busy with deployments and maintenance over the past month that I haven’t had a chance. I think that it might benefit a few people to go ahead and post the work I’ve done so far even though I’m not finished. Thus… note that this material is still very much in-process.

Minimal-downtime PSUs on CRS with Cloned Golden Images

About a month or two ago, I was doing some work toward developing a process to patch CRS out-of-place using cloned golden images. I held off on publishing anything because I wanted to do some testing but we’ve been so busy with deployments and maintenance over the past month that I haven’t had a chance. I think that it might benefit a few people to go ahead and post the work I’ve done so far even though I’m not finished. Thus… note that this material is still very much in-process.

Applying PSU 12.1.0.1.1 in the lab environment

Since the first patch for Oracle 12c has been made available I was of course keen to see how to apply it. For a first test I opted to use my 3 node RAC cluster which is running on Oracle Linux 6.4 with UEK2. This post is not terribly well-polished, it’s more of a log of what I did…

The cluster makes use of some of the new 12c RAC features such as Flex ASM but it is not a Flex Cluster:

[oracle@rac12node3 ~]$ srvctl config asm
ASM home: /u01/app/12.1.0.1/grid
Password file: +OCR/orapwASM
ASM listener: LISTENER
ASM instance count: 2
Cluster ASM listener: ASMNET1LSNR_ASM
[oracle@rac12node3 ~]$

My database is a standard 3 node administrator managed build:

Handoffs delay, self service saves

“Self-service is awesome; if they can get work done without opening a ticket, we’re winning.” - Kelsey Hightower via Gene Kim, author of The Phoenix Project

There is a great “ah ha” moment in the book, The Phoenix Project, when the hero, Bill Palmer, realizes why it takes his  star IT technician, Brent, several days to accomplish a task that Brent said would take him 45 minutes!  The reason it’s taking Brent days to accomplish the 45 minute task is that the task depends on several hand offs between different people and each hand off is eating a surprising amount of time. Why if each of the multiple steps only takes a few minutes each does the completed task end up taking several days? The reason is the queuing time between each handoff. Handoff time delays and handoffs delay inordinately the busier each resource is.

The Thin Cloning Left Shift

The DevOps approach to software delivery manages risk by applying change in small packages instead of big releases. By increasing release frequency, overall risk falls since more working capabilities are delivered more often. The consequence of this is that problems with your data can be amplified. And, as a result, you can squeeze the risk out of one aspect of your delivery just to introduce it in another. Thin cloning attacks that risk, enhancing and amplifying the value of DevOps by reducing the data risk inherent in your architecture.

Data Delivery

Scripts to create AWR reports quickly.

It is easier to create one or two AWR reports quickly using OEM. But, what if you have to create AWR reports for many snapshots? For example, your Oracle support analyst wants you to supply 10 1-hour AWR reports from 10AM to 8PM in a 8 node cluster? That’s about 80 AWR reports to create! Okay, okay, I may(!) be overselling it, but you get the point. It is useful to have a script to create AWR report for all instances for a given range of snapshot IDs. Following scripts are handy:

OakTable World UK 2013

Just a quick post to remind people coming to UKOUG Tech13, you can also register for OakTable World UK 2013.

If you go to the page you can see the agenda and the registration form. The event is free, but you need to be registered for UKOUG Tech13!

Enjoy!

Cheers

Tim…