Wednesday, 25 February 2009

Training Tip: When to Ignore Advice

One of my earliest mentors in training gave me many immensely valuable pieces of advice.  And two that I've learned to ignore. I was thinking about this today while re-reading an old classic, Teacher as Servant: A Parable, by Robert K. Greenleaf (now out of print, but available used). So, here are two bits of advice I learned to ignore.


1. "Always perpetuate the illusion that in the classroom, you are God."


By that, I'm sure he meant to say that one must establish and maintain credibility. Once credibility is lost in a class, you seldom have the chance to regain it with that group. It's also important to maintain the authority that keeps you in control of the classroom process. But I've found it more useful to consider myself a servant of the group than its master. Yes, it's my job to maintain control; but only because they're paying me to do it, and because it serves their best interests for me to do so.


As usual, there are exceptions to every rule. I had one class that consisted entirely of highly-paid business consultants. I was told up front by their manager that it was a smart-alecky group that would give me trouble unless tightly managed. So I went in with the Top Gun approach, very authoritarian, but at the same time letting them know that "You're the best - but we're going to make you better."


2. "When you are doing class introductions, try to identify up front who the troublemakers are."


I tried this exactly once.  And I got what I expected: troublemakers. I haven't done it since. Now I expect up front that everyone in class is going to have fun, learn a lot, and contribute. It doesn't always happen that way, of course, but I think my expectations and mindset help it to happen more than it otherwise would.


The night before a class, as I'm falling asleep, I repeat to myself the affirmation (in present tense), "This is the best class I've ever had."



Thursday, 8 January 2009

Tom Kyte's New Years Resolutions

Anyone who knows me knows I'm a BIG Tom Kyte fan.


Tom's published his list of New Years Resolutions for 2009, and the top of the list is "Practice a restore at least once a month."  You can read the rest of the resolutions here:


http://www.oracle.com/newsletters/information-indepth/database-insider/jan-09/kyte.html


(Thanks to Chen Shapira on Twitter for the pointer to this.)



Thursday, 1 January 2009

Training tip: Teleconference Don'ts

Esther Schindler of CIO.com has a great article on PC World, listing 17 Telecommuting Disadvantages. One of them, #8,  is all about the annoyances of teleconferences -- but if you flip those annoyances around, they become training tips.



...people who lead teleconferences (with a half dozen participants) and start out by saying, "Who's here?" Doing so makes everyone on the phone wonder if it's their turn to speak up...  


Tip: take roll call instead, using the list of invited participants. Starting out this way also puts you squarely in control of the meeting. If possible, use web conferencing where rollcall is always available on the screen.



Organizers who show up late. Telecommuters are stuck listening to music-on-hold for ten minutes, during which they wonder, "Was today the right day? Did I miss the meeting?"  


Tip: Be there early if you're leading a session. Just like in the classroom, being early means you get to welcome everyone individually and establish rapport before the group session starts.



People who refer to a lot of visuals without bothering to send the file to telecommuters; and then they don't refer aloud to the data they're pointing at. 


Tip: Reference at least the slide title (and slide number -- you do put slide numbers on your slides, don't you?) when referring to visuals.


[A big thank you to Twitter user Reg Saddler (zaibatsu) for the link to this great article!]



Monday, 29 December 2008

Training Tip: Nearly Free Laser Pointer

When I got started in training, the pencil-type laser pointer was over $100. Needless to say, I found other ways to point at the screen  (hand shadows being the primary one).


Recently, I finally broke down and got a laser pointer, which I keep in my trainer kit. The cost?  Only $3, in a clearance bin at Walgreens. It was sold as a cat toy: a way to put a spot of light on the wall for cats to chase around. (It also puts up an image of a mouse, a butterfly, a star, and my favorite, a smiley face.)


The use of laser diodes in mass-market equipment such as CD and DVD players has lowered their production cost so far that now they can be sold as toys, not $100 professional tools.  I don't care what it says on the package, it's a dandy training aid.


On the other hand, training is often compared to herding cats, so maybe the package description is appropriate.


NOTE: Do not put this in your carry-on luggage. It's considered a weapon and forbidden by the TSA, so pack it with your trainer kit in your checked luggage.


UPDATE 2/4/2011:  Laser pointers no longer appear on the TSA's list of prohibited items, and haven't for some time.  Thanks to reader LaserPointers for asking me to research and update this post.



Tuesday, 23 December 2008

Oracle Database 11gR1 on VMWare

I've just finished creating the test environment I'm going to use to prepare for the 11g OCP upgrade test. Instead of installing directly on a lab machine as I've done before, I decided to do this one inside a VMWare virtual machine. Here are some notes on what I did, while they're fresh in my mind.


Don't you just love the Internet?  I found an excellent step-by-step install guide by John Smiley, and it really shortened the learning curve. It also contains links to the download sites for Oracle Enterprise Linux 5, which is functionally similar to Red Hat Enterprise Linux 5, and Oracle Database 11gR1.


VMWare layer: 


I created a VM with 1024Mb memory, a single 20GB hard disk, one network adapter bridged. I don't plan to do RAC scenarios with this image, it's just for the basics, so I kept it simple. I can add more virtual hard drives to it later to practice ASM.


Linux layer:


I used Oracle Enterprise Linux 5, downloaded from Oracle.  I followed the install instructions from Oracle-Base, which included details on disk partitioning. OEL5 includes 5 CD images as .iso files, but the install only required the first 3.


On my first attempt, I did as the Oracle notes suggested and did a default install of packages. But this led to problems later with missing libraries needed by various RPMs. So, I started over, selected "Customize Now" instead of "Customize Later," and followed instructions I had used successfully with 10gR2 in terms of which packages to include and not:






    • GNOME Desktop Environment
    • Editors
    • Graphical Internet
    • Text-based Internet
    • Development Libraries
    • Development Tools
    • Legacy Software Development
    • Server Configuration Tools
    • Administration Tools
    • Base
    • Legacy Software Support
    • System Tools
    • X Window System



This worked much better.


I then followed the Oracle instructions exactly for preparing the OS for Oracle, in terms of adding several additional RPMs, setting kernel parameters, creating security groups and creating the oracle user.



Oracle installation:


My first try failed due to unzipping all the files on my Windows machine and burning an ISO image. I got permissions errors when trying to start the Oracle Universal Installer. So, I reburned the image with just the ZIP file as downloaded by Oracle, and unzipped it within the Linux environment. The rest of the install was textbook.


Throughout, I used the VMware Workstation 6.5 snapshot feature, taking snapshots of the base Linux machine, Linux machine plus additional packages, Linux machine plus customizations for Oracle, and finally after the successful install.  I connected with sqlplus and was rewarded with the opening banner giving the version as 11.1.0.6.0.


Let the studying begin!  Oh wait, it already has.



Sunday, 14 December 2008

New Oracle Certified Associate (OCA) Requirements

New candidates for Oracle's entry level DBA certification must now pass an exam on SQL, in addition to the existing requirement for passing the Database Administration I test. The Oracle Certified Associate (OCA) credential is the first rung in Oracle's 3-step DBA certification ladder. The change went into effect December 1st, 2008.


According to the Oracle University website, any of four exams will meet the requirement:




  • 1Z0-001: Introduction to SQL and PL/SQL

  • 1Z0-007: Introduction to 9i SQL

  • 1Z1-051: Oracle Database 11g SQL Fundamentals I

  • 1Z0-047: Oracle Database SQL Expert


Existing OCAs and OCPs do not have to fulfill the additional requirement. Their upgrade paths remain the same.



Sunday, 23 November 2008

Training Tips: Use an Electronic "Whiteboard"

Training on-site at customer locations is sometimes challenging. Every classroom is set up differently, and that means having to be adaptable to the tools available.


For example, I like to draw on whiteboards as I talk, but many classrooms have such a big pull-down screen that the whiteboard is almost completely covered. It's a hassle (and distracting) to constantly raise and lower the screen.


My accomodation to this was to open a Word document, set the font to 24 pt. Arial, and use it to type my notes. It was awkward at first, but after a while, I found I really liked this approach. I can use the notes during review on future days without messing with bulky easel pads. And I email the entire whiteboard document to the participants after class is over, which makes a good "after sale" reminder of the value I've delivered.


I'm still struggling with how to draw diagrams: the tools in Word are a bit primitive.


One tip: back up the whiteboard to a flash drive before you leave each day. Some classroom environments reset themselves upon logout, and your documents might not be there the next day. Also, some on-site training rooms are shared spaces that others might use between class sessions. Be prepared: backup!