Search

OakieTags

Who's online

There are currently 0 users and 24 guests online.

Recent comments

Affiliations

June 2012

Oracle WebLogic and Forms Installation on Oracle Linux (64-bit)…

In an attempt to delay packing for my trip, I decided to give the server installation on Linux a go.

The installation was pretty straight forward. I will take a look at some of the further configuration stuff when I get back from my trip.

Cheers

Tim…

Oracle WebLogic and Forms Installation on Windows (32-bit)…

At least one of the apps at work will be moving to Forms 11gR2, so I thought I better do a run through of the desktop developer installation before someone asks me how it is done. :)

Our standard desktop environment is still Windows XP (32-bit), hence the archaic choice here.

Speaking at E4!

I’ll be co-speaking with Randy Johnson (one of the authors of Expert Oracle Exadata) at E4 to share about the war stories and detail on a bunch of technical stuff on a Peoplesoft and BIEE consolidation project we had on one of our clients. See the abstract below:

if you have month and year as separate columns…

An easy confusion of logic was succinctly cleared up by Toon Koppelaars on oracle-l today. It *may* be helpful to read that thread before you read this post, but I hope it stands alone.

The original poster wanted to exclude only month number 5 from year 2012, but was perplexed that
"where (month != 5 and year != 2012)"
also excluded the 5th month of 2011 and all of the data from 2012.

Toon referenced and explained from De Morgan’s Laws that “not X and not Y” is equivalent to “not (X or Y)”, which would be “not (month=5 or year=2012) in your first query.

For those who are truth table challenged, it may be helpful to consider this (regardless of the actual plan Oracle might choose) as a filter operation. So you get a row, and if it is either that nasty 5th month you apparently did not want or that nasty year 2012, throw it away.

How to set up data guard broker for RAC

This is pretty much a note to myself on how to set up Data Guard broker for RAC 11.2.0.2+. The tests have been performed on Oracle Linux 5.5 with the Red Hat Kernel. Oracle was 11.2.0.2. Sadly my lab server didn’t support more than 2 RAC nodes, so everything has been done on the same cluster. It shouldn’t make a difference though. If it does, please let me know).

WARNING: there are some rather deep changes to the cluster here, be sure to have proper change control around making such amendments as it can cause outages! Nuff said.

The effect of ASM redundancy/parity on read/write IOPS – SLOB test case! for Exadata and non-Exa environments

Last week I had a lengthy post at oracle-l that tackles Calibrate IO, Short Stroking, Stripe size, UEK kernel, and ASM redundancy effect on IOPS Exadata which you can read here
followed by interesting exchange of tweets with Kevin Closson here (see 06/21-22 tweets) which I was replying in between games at UnderwaterHockey US Nationals 2012 which we won the championship for the B division ;) I have my awesome photo with the medal here

Different Execution Plans when Converting SQL from SELECT to UPDATE … IN SELECT, ROWNUM Related Bug in 11.2.0.2

June 28, 2012 (Modified June 28, 2012) Sometimes it is possible to build a very effective test case to reproduce a particular problem.  Sometimes the test case drifts a bit offtrack, in the process revealing other information that is not directly related to the original problem that the test case attempted to simulate.  You will [...]

WordPress 3.4.1 Released…

WordPress 3.4.1 has been released. You can see the updates in this maintenance release here. Happy upgrading.

Cheers

Tim…

Desktops, Laptops and Tablets…

File this under #NothingNewHere :)

Over the last couple of years we’ve been constantly bombarded with the “tablets are the future” message. Today I read this piece about Microsoft.

Being a techie, it’s hard for me to get in the “normal folk” frame of mind when thinking about technology, but it just so happens I had a conversation with a “normal person” last night. He’s a personal trainer at my gym. It turns out his opinion on the desktop/laptop/tablet debate is pretty similar to all the techies I’ve spoken with. He was asking me for some advice (which I’m not qualified to provide), but before I said a word he hit me with a few statements:

Prometheus (3D)

I went to see Prometheus at the start of the month and wrote about it here.

A few days ago some friends asked me if I wanted to go with them to see it in 3D, so I did.

In 2D, the opening sequence was amazing. In 3D it was a bit of a let down. The opening credits (being 3D) jumped out at you and distracted from scenes behind. As for the rest of the film, some scenes worked and others didn’t. Pretty much any time there is movement, 3D sucks.

If I had gone to see the film in 3D first, I think my impression of it would have been quite different. If you have yet to see it, please go to the 2D version!

Cheers

Tim…

PS. The Spiderman trailer was a mess in 3D. All of us commented on it being just a big blur. Truly terrible. I think the film will be good though (in 2D).