What do you do if you lose a node in a RAC as a result of destruction, theft, or other unrecoverable error? How do we clean up the existing cluster so the inaccessible node is removed permanently from Oracle Clusterware and Oracle RAC Databases? I demonstrate the current process with 11gR2, which now has many [...]
This is a video demonstrating the creation of a second database of 2 instances in an Oracle RAC of 4 nodes, coexisting with a pre-existing 4-instance database. I created this video to demonstrate an answer in response to a forum question: http://forums.oracle.com/forums/thread.jspa?threadID=960350&tstart=0
I put together a follow-up video to the 3-node install where I add a 4th node of RAC 11gR2 in VMWare successfully, including extending the database to a total 4 instances. In less than 10 minutes of video, you will see the cloning of the Grid Infrastructure 11gR2 home, cloning of the Database 11gR2 home, [...]
I have just put together some videos to demonstrate installing Oracle RAC 11g R2 successfully in VMWare, simulating 3 separate nodes. I will be adding a 4th node in VMWare to demonstrate how to add (and later remove) nodes and RAC instances in open databases. These videos show how viable it can be to use [...]
The latest release of Oracle Database came with an overhaul of the Oracle Universal Installer GUI. There is a strange interaction between gnome and the OUI (runInstaller) that causes the screen to flash uncontrollably and not resize properly when the screen resolution is 800×600 and gnome is configured as per defaults of RedHat Enterprise Linux [...]
I put together a video on a recent flight (September 11, 2009) from Toronto to Vancouver while killing time. I just happened to have all the 11.2.0.1 distribution downloaded and ready to install, so I whipped up a few Virtual Machines, iSCSI based shared storage (No, I don’t use openfiler; rolled my own iSCSI Enterprise [...]
For some reason all the browsers I use on OS X Snow Leopard (Camino, Firefox, Safari) cannot upload to YouTube. Leopard 10.5 works fine, as does Windows XP/Vista/7. At first I thought it might be browser or flash plugin related, but I’ve tried installing fresh flash plugins and updating the browsers to no avail. This [...]
This represents my first blog entry on my site, masterschema.com. As a a complete newbie to both reading and writing blogs, hopefully my writing and publishing skills improve with time. In the meantime the purpose of this blog is to serve as a dumping zone for ideas, concepts, and ultimately whitepapers and tutorials that are [...]