I’ve been slowly editing and putting up videos that outline my 2 day cram spree before an OCM 11g Exam. Unfortunately, because of an Oracle administrative error, I was denied seating in the exam. So, since I’ve signed no NDAs, and since I’ve seen no material… this is a perfect time for me to get as much online as possible before I forget.
I may never find the balls to register again for the exam, unless you all want to donate to see how close my prep really is.
The videos will be free, so long as attribution back to me is given. Kudos would be nice, etc… I intend to complete the youtube playlist with videos that cover every objective published by Oracle for the OCM 11g exam. I make no guarantees you’ll pass with this, but it’s still fun for me! =)
Bored one evening after class, I decided to play with CDH4 and Cloudera Manager on the release date of June 5, 2012. This video is the result of my install attempt, which could be used as a quick tutorial of how to create a 5-node hadoop cluster based on Cloudera CDH4 using Cloudera Manager on top of CentOS 6.2 in virtual machines. The steps are just as valid with real machines.
Ok, a day late with this one… recorded a bunch of tracks yesterday (Canada Day, July 1 2010) and edited down to this rather interesting video.
Yes, way off topic… have also recorded a bunch of segments on VMWare, and in 2 weeks will put together some slides/animations to explain virtual networking in VMWare. May also demonstrate Citrix XenServer and Oracle VM depending on time. VirtualBox just has not caught my attention partly because of it’s lacklustre performance and stability. I haven’t the time to play around with crashing junk.
Of course, I do have time to play around with garden hose junk! =)
Bored one late evening, I built up a VM in which I installed Oracle Enterprise Manager Grid Control 11g a couple days before it’s officially released. Started the project on April 20, 2010, product is to be released on April 22, 2010.
Quick synopsis of the procedure (a how-to may follow if I have the time):
1) Install and create a supported database
2) Install middleware (Weblogic Server)
3) Install Grid Control 11g
4) Deploy some agents
The big change for installation is that the Enterprise Manager package does not include the database or middleware bits for easy install.
It’s presently one day before the official release of the product. =)
I quickly viewed all the webcasts that were available today and from what I can see, Oracle Grid Infrastructure is here to stay along with Oracle VM, and I guess Sun Cluster (Solaris Cluster) goes into legacy mode. No mention of ZFS, but enough mention of ASM that I suspect pieces of ZFS algorithms will be picked off and added to ASM.
I recorded some tracks on hose playing the piece well known as the olympic theme music/fanfare. I’d have to say that Vancouver 2010 is starting to show it’s face, and this is not a positive or negative comment… it was just a fun project for an afternoon with some garden hose.
I was really really bored… this is a concept which I’ll probably re-record more seriously. I’m also thinking other pieces, like O’Canada, perhaps the John Williams olympic fanfare and theme.
Yes, I realize the last two posts are a tad off beat; I’ll be back on the IT craze soon… it’s been holiday season for me.
I really hope you enjoy! If you do, please comment/rate/spread the word. It’s just plain funny!
I’m working on a series of videos to demonstrate all the steps required to create a RAC 11g R2 using VMWare and iSCSI from scratch. These videos will be reasonably free from clips, to show the full process and what to expect. I find there are a lot of “How-tos” out there that are written, with screenshots, but that do not provide the newer DBA with the confidence that the procedure will work. I feel a video first, procedure second, provides confidence that the steps documented do lead to something usable in the end.
These videos will be published in a seemingly random order, partly related to how I decide to edit/cut them. Also there will be some differences in video/audio quality as I improve my processes over time. The videos were not necessarily shot in the order of execution, but I will sequence them in a “Playlist” on youtube so it’s easy to figure out the order in which they should be watched.
Please keep in mind there will be gaps. At present, I have put four new videos up; my intention is the following set of videos:
Working with VMWare: Understanding guests, multiple virtual NICs, vmnet, vmdks, and the cloning process
Install Oracle Enterprise Linux (OEL, RHEL, CentOS) 5.4 or 5.3 using a kickstart file to build a generic “base brick machine” (BBM)
Understanding runlevels and booting into single user mode with GRUB and Linux
Create an iSCSI target host using a BBM (not bloated openfiler)
Create a router using a BBM to serve as a gateway and DHCP server for the public network of a RAC
Create a DNS server using a BBM, and create zones for Oracle Grid Infrastructure GNS
Install Oracle Enterprise Manager Grid Control 10.2.0.x and patch to 10.2.0.5 (10gR5) on a BBM
Understanding ssh user equivalency and using the basics of authorized_keys
Prepare a BBM for Oracle Grid Infrastructure 11g R2
Install Oracle Grid Infrastructure 11g R2 in VMWare on 2 nodes
Run root scripts for Oracle Grid Infrastructure 11g R2
Install Oracle Database Real Application Clusters (RAC) 11g R2 on 2 nodes
Creating a RAC 11g R2 database using DBCA
Arguably steps 4 and 9 are probably the most difficult for configuring a RAC; #4, creating the shared storage “device” (in this case, a server running OEL with iSCSI target software) and #9, attaching the nodes to this device.
Demonstrate installation of Solaris Cluster (formerlly Sun Cluster) 3.2 using VMWare and iSCSI
Demonstrate Solaris Cluster + Oracle CRS Clusterware for RAC
Demonstrate Solaris Cluster + Zone Clusters + Oracle RAC
Demonstrate ADVM + ACFS to give applications high availability (I think MySQL would be a fitting example)
Demonstrate the configuration of Oracle RAC Guard (RAC to RAC Dataguard)
Demonstrate the configuration of Oracle Dataguard (non-RAC)
Demonstrate the concepts and basic administration of ASM, ADVM and ACFS
Demonstrate the concepts and basic administration ZFS
Demonstrate basic systems administration of RedHat Enterprise Linux (and derivatives) for the DBA
Document all the aforementioned… =)
Let me know what you think… I have this habit of biting off more than I can chew, but at least I manage to eat some of it… and to date, people seem to feel I’ve eaten a lot.
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 new crsctl commands that can help with this administrative task.
Obviously when this type of thing does happen in production, I’m sure it’ll be impossible to remain calm and collected, but I hope this video helps to demonstrate just how easy it is to deal with this type of disaster.
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: