Search

Top 60 Oracle Blogs

Recent comments

November 2013

Listener Error from addNode.sh with Second Network

Recently I ran into an problem with 11.2.0.3 RAC. I observed this on a system patched to PSU6 and it looks like a bug to me. But the interesting part isn’t the problem – it’s an impressive and creative workaround that my colleague found over the weekend. I should add that this teammate doesn’t have much background with Oracle RAC though he does have lots of experience with other technologies. His email this weekend surprised me and also gave me a good laugh – hope you find it equally useful and enjoyable!

The problem originated with a requirement I was given when designing this particular cluster system: I was asked to run Data Guard traffic over the backup network instead of the public network. This sounds simple enough if you haven’t worked with RAC. But if you’ve worked with Oracle clusters you realize that nothing is simple anymore. (A big reason I often encourage people to wait on moving to RAC, especially if the main driver is high availability…)

Listener Error from addNode.sh with Second Network

Recently I ran into an problem with 11.2.0.3 RAC. I observed this on a system patched to PSU6 and it looks like a bug to me. But the interesting part isn’t the problem – it’s an impressive and creative workaround that my colleague found over the weekend. I should add that this teammate doesn’t have much background with Oracle RAC though he does have lots of experience with other technologies. His email this weekend surprised me and also gave me a good laugh – hope you find it equally useful and enjoyable!

The problem originated with a requirement I was given when designing this particular cluster system: I was asked to run Data Guard traffic over the backup network instead of the public network. This sounds simple enough if you haven’t worked with RAC. But if you’ve worked with Oracle clusters you realize that nothing is simple anymore. (A big reason I often encourage people to wait on moving to RAC, especially if the main driver is high availability…)

Outline hassle

Here’s the output I got from a 10.2.0.5 system after generating a stored outline on a query – then dropping the index that was referenced by the stored outline and creating an alternative index. Spot the problem:

Browser Quirks and JSON Lint


Anyone want to look through the following JSON and spot the problem?

KeePass 2.24 Released

Just a quick note to say that KeePass 2.24 has been released. The downloads are here and the changelog is here.

I’ve written about my use of KeePass here.

I use the Portable KeePass version, so I just unzip it over the old version and we are good to go!

Cheers

Tim…

Update: Remember, if you are planning to use KeePass on Mac, make sure you have the latest version of X11 and Mono (3.2.3 or later).

 

Not Pushing

Here’s an odd little optimizer glitch – probably irrelevant to most people, but an indication of the apparent randomness that appears as you combine features. I’ve created an example which is so tiny that the only explanation I can come up with the for optimizer not “behaving properly” is that I’ve found an undocumented restriction relating to a particular feature.

Here’s the basic schema structure with query and execution plan – there’s nothing particularly significant about the object definitions – they’re just a couple of (reduced) structures from a client site I visited a few years ago:

VirtualBox 4.3.2 Released

After a major release, it’s not surprising that a maintenance release follows hot on the heals, so VirtualBox 4.3.2 has been released. The downloads and changelog are in the usual places. The changes include a fix for the Mac OS X upgrade issue I mentioned recently.

I’m currently running VirtualBox 4.3.x on Fedora 19, Oracle Linux 6, OS X Mavericks and Windows 7 with no real dramas, but the fixes are a welcome addition.

Cheers

Getting Started with Dtrace

 


22-45-34-755_950x510

Structure of a dtrace script