DBCA Missing – Oracle 11.2 ASM/Grid

August 16th, 2010 § 1 Response

Oracle provides three ways to manage ASM: (1) through SQL, (2) through the web-based database console or grid control, and (3) through the server-based java GUI tool DBCA.  These are your choices for adding storage, replacing a disk, growing a volume, etc. But if you’re an experienced DBA who recently started playing with 11gR2 ASM, [...]

Michigan OakTable – Illinois Visitors?

July 29th, 2010 Comments Off

Quite a few people have already plugged this event (Charles Hooper, Jonathan Lewis, Tanel Poder, Doug Burns, Christian Antognini, Randolf Geist, etc) – but I want to chime in anyway.  It’s so closeby and the price goes up in two days! The Thursday and Friday before OpenWorld (September 16-17), some kind folks in Michigan are [...]

ASM Mirroring – No Hot Spare Disk

July 15th, 2010 § 3 Responses

Some time ago, we installed Oracle on a Sun box with 48 local 1TB disks (spread across six controllers). I explained to the storage and system teams that we would use ASM as the volume manager – and as such, it would take care of mirroring. One storage admin asked me which disk was the [...]

Five Reasons to do RAC Attack at Collaborate

April 6th, 2009 Comments Off

Last week Dan broke the news that we’re bringing RAC Attack back to Collaborate! We’ve run this workshop several times now: it’s gotten better every time and we’ve always received overwhelmingly positive feedback. This is going to be a great workshop in Orlando that you don’t want to miss! A Short History We first ran [...]

ASM Negative Free Space

March 17th, 2009 § 3 Responses

In the last post I showed mathematically how ASM calculates the free usable space that it displays. However one of the first questions I received after presenting that internally was from someone concerned about all of the unusable space being saved just in case we lose a disk. (In my worked example it was 1/6 [...]

ASM Space Calculations and Hot Spares

March 12th, 2009 § 1 Response

This is quick and dirty. I hope to get a more polished write-up of what it means and how it works, but since I’m so busy right now I don’t know if I’ll get to it soon. In the meantime someone just might find this useful or informative so I’m just going to put it [...]

Future of OCFS2

February 5th, 2009 § 6 Responses

At the company where I’m working right now, I’m part of an architecture effort to come up with our standard design for RAC on Linux across the firm. There will be dozens or possibly hundreds of deployments globally using the design we settle on. We’re internally debating whether or not we should include OCFS2 in [...]