Friday Jan 31, 2014

Simplifying the Installation of Oracle Database on Oracle Linux - Reprint








Most of my workdays start by shapechanging me into a seven-headed Hydra, and each Hydra promptly makes a beeline for multi-tasking hell. So, when I get a chance to simplify something, anything, I jump on it.

Ginny has done that for OTN at last twice. Below are two of her exercises in simplifying our lives. We published these articles before, but we recently had to rebuild one of them because somebody (I'm not going to say who) deleted it. To avoid annoying one of your Hydras, and instead send you off to a peaceful weekend, here they are again.









How I Simplified Oracle Database Installation on Oracle Linux 5

by Ginny Henningsen

Before installing Oracle Database 10g or 11g on a system, you need to preconfigure the operating environment since the database requires certain software packages, package versions, and tweaks to kernel parameters. Ginny discovered that Oracle Linux provides a remarkably easy way to address these installation prerequisites. Find out how.

How I Simplified Oracle Database 11g and 12c Installation on Oracle Linux 6

by Ginny Henningsen

Similar to the article above, but updated for Database 12c and Oracle Linux 6. Ginny simplifies the installation of Oracle Database 11g by automatically pre-configuring Oracle Linux with the required software packages and correct kernel parameters.

Photograph of Fat Boy on Sakajawea Road in Idaho taken by Rick Ramsey

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Wednesday Jan 29, 2014

Man Vs. Machine

Man vs machine. Command Line vs GUI. It's not a new debate. In fact, when I was a little boy I watched this Paul Bunyan cartoon with the dismay of a sysadmin watching the increasing popularity of GUIs:

Cartoon: Paul Bunyan's Ax vs The Chain Saw

What Skills Do Sysadmins Need to Manage a Modern Data Center?

Video Interview with Brian Bream

When I wrote technical manuals for Oracle Solaris back in the day, I had the luxury of my very own lab. For instance, while writing the NIS+ books, I was able to discover my own procedures on a small network and, when I needed something larger, I could ask the sysadmins in Sun's bigger labs to try some experiments for me. Little did I know those were the Golden Years of technical writing.

They were also the Command Line Years. We used the command line for everything, including email, product testing and, of course, managing Solaris. The command line put the operator in control. You had a mental map of what you were doing, you were completely engaged, and if something became repetitive, you could always write a script for it. The shell was the interface, and emacs was the only tool you needed.

When GUI's first came out, we hated them on principle. They were slower than the command line, and they didn't really add any value. Plus, they weakened your skills.

Since then it's been a tossup. GUI's have gotten steadily better, but they didn't add enough value to overcome our attachment to the command line. In fact, we kinda resented them because they were used as a pretext to hire less experienced and cheaper sysadmins.

However, with the advent of vertically-integrated systems such as Oracle's Exadata and SuperCluster, the GUI may have finally come into its own. Listen to Brian Bream explain why.

Watch video interview here

Photograph of bicycle in Durango taken by Rick Ramsey in Oct 2012

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Thursday Jan 23, 2014

Hands-On Lab Setup Instructions Now Available for Next Virtual Sysadmin Day

As you may already know, OTN's next Virtual Sysadmin Day is on January 28 from 9:00 am to 1:00 pm PT. This sysadmin day is going to be very cool because its hands-on labs focus on solving real-world problems with Oracle technologies.

You'll definitely want to do the prep work before the day of the event. The prep work consists of configuring your laptop and uploading the images. Don't be that guy. The one who, the day of, asks where the instructions are. Him. Don't be him.

Pre-Event Checklist

The checklist provides:

  • Virtual Conference hardware requirements
  • Virtual Conference software requirements
  • Setup instructions for Oracle Solaris labs
  • Setup instructions for Oracle Linux labs
  • Setup instructions for Oracle VM labs

If You Must Tweet

If you can't keep your hands off your danged phone while working on the labs, at least use this hashtag:

#OTNVSAD

Questions for Ed

Oracle ACE extraordinaire Ed Whalen and I will be hanging out at the Sysadmin Lounge during the last 30-45 minutes of the event. Ed knows his stuff, so if you have any questions about Linux, such as how to optimize it for the database or other applications, ask Ed. If you have questions about Harleys or Ducatis, ask me.

See you next week.

photograph of Harleys in Wisconsin by Rick Ramsey

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Wednesday Jan 22, 2014

Cache Algorithms and Other Storage Tricks

This morning I was reading about something called a cache algorithm. According to our friends at TechTarget, a cache algorithm specifies rules for discarding items from a computer's cache. So I started rooting through some of our tech articles to see if I could find any more about it.

I failed.

But I did find a couple of articles about storage, plus a video, that although not specifically about cache algorithms, do talk about storage efficiency. The video interview is new. I recorded it at Oracle OpenWorld, but had not edited until now. The articles have both been published before.

Video Interview: Simplifying the Way You Manage Data

with Art Licht

Simplification, efficiency, and data protection. That's what you get when you manage your data with Oracle Enterprise Manager. Art Licht explains. Recorded at Oracle OpenWorld 2013.

Tech Article: How to Multiply the Capacity of Oracle Storage Systems

by Tom Luckenbach
Hybrid columnar compression can effectively multiply your storage capacity by 10-15 times, increasing performance and reducing your hardware costs. It's available on Oracle's Pillar Axiom storage systems. Tom Luckenbach walks you through the steps to set it up.

Tech Article: How We Improved SAN and NAS Performance with Hybrid Columnar Compression

by Art Licht

A case study showing how Oracle reduced storage space requirements by a multiple of 19 while getting a six-fold increase in database query performance. All thanks to the Hybrid Columnar Compression capability of Oracle Database 11g Release 2. Plus how you can achieve similar results. By Art Licht.

About the Photograph

The photo is real stretch ...
from left to right, my riding partners
JimBob, El Jefe Con Queso, and Da Don.
Snapped at Luckenbach, Texas a couple of years ago,
on the almost famous Ghost Rider Dog Run.

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Monday Jan 13, 2014

Lab - How to Deploy Oracle Software in Minutes Using Oracle VM Templates

In my first 12 years of school I had a natural ability in Math and Science, but had to work hard at English and History.

When I went to college, I didn't do well in Math and Science, so I transferred into Liberal Arts, where strangely enough, I did well. After all these years I just realized why. I never had to study for Math and Science. I just understood the material. If I did any homework, I did it during class. Which means I never listened to lectures. As a result, I never learned how to learn what I didn't know. So, when college presented me with more advanced topics that I couldn't just grok, I didn't know what to do. I fell behind. I assumed I wasn't any good. The opposite was true with Liberal Arts. Literature, History, Economics, it all confused me. So I listened in class. And I studied after class. SoI did well.

And that's why I'm not an engineer.

If you're a hands-on learner like me and Joel Schallhorn, the guy doing bicycle tricks in the picture, you'll appreciate our latest hands-on lab.

Lab: How to Deploy a Four-Node Oracle RAC 12c Cluster in Minutes, Using Oracle VM Templates

Hands-On Lab by Olivier Canonge with contributions from Christophe Pauliat, Simon Coter, Saar Maoz, Doan Nguyen, Ludovic Sorriaux, Cecile Naud, and Robbie De Meyer

This lab demonstrates how easy it is to deploy software environments with Oracle VM Templates. It uses a single-instance, Oracle Restart (Single-Instance High Availability [SIHA]), and Oracle Real Application Clusters (Oracle RAC) for Oracle Database as an example. During this lab, you are going to deploy a four-node Flex Cluster (three hubs and one leaf) with a dedicated network for Oracle Flex ASM traffic.

See more of Joel Schallhorn on Instagram | Facebook | YouTube

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Friday Jan 10, 2014

It's Friday, Ask Your Boss to Dance

Happy Friday, OTN Garage!

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Thursday Jan 09, 2014

Why Are So Many People Smarter Than Me?







When Tim said "Heisenbug," I pictured a large dirigible exploding and heard a radio reporter cry, "Oh the Humanity!"

As Tim started talking, I realized he'd said "Heisenbug," not Hindenbug. So I pictured my favorite chemistry teacher. Here is a link to his likeness:

Picture of Heisenberg

It was only when I heard my deceased physicist father-in-law's voice growling his favorite endearment "Rick, you dumbass," that I finally realized Tim was talking about Werner Heisenberg's Uncertainty Principle.

Although I wasn't completely sure.






Video Interview: How Ksplice Crushes the Heisenbug

As it turns out, Tim was talking about that phenomenon that happens to all of us when we call in a sysadmin to fix a problem with our system. When the sysadmin shows up, the problem disappears. I know you guys write scripts to make that happen on purpose, but Tim doesn't. And neither does the Ksplice team. So they developed some very cool technology to diagnose these heisenbugs and get our systems running properly again. Don't worry, your secret is safe with me. And everyone who reads this blog.

In any case, you can find out how Ksplice crushes the Heisenbug in this short video:

Video Interview: How Ksplice Crushes the Heisenbug

Here's a video of the Hinderburg crash

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Wednesday Jan 08, 2014

Hands-On Lab: How to Deploy and Manage a Private Cloud

Hands-On Lab: How to Deploy and Manage a Private Cloud

With Oracle VM and Oracle Enterprise Manager Cloud Control 12c

We just updated this lab to get it ready for OTN's next Virtual SA Day on January 28. You can run the lab anytime from your laptop, or you can attend our virtual event and run it with the help of a proctor. There will be several hundred sysadmins running the same lab at the same time, so you can discuss it with others via chat, and get help from our proctors. Details here.

Cloud Building with Oracle Solaris

Blog by OTN Garage

At the risk of raising PITA's ire, there's more than one way to skin a cat. This blog provides three resources to help you build a private cloud with Oracle Solaris: one training class and two tech articles.

photograph of clouds at sunset over Colorado snapped by Rick Ramsey with lousy iPhone camera

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Tuesday Jan 07, 2014

Tips for Using Linux Huge Pages

Ed Whalen is the Chief Technologist at Performance Tuning Corp. He knows an awful lot about making databases run faster, including the use of Linux Huge Pages. Here are two of his very helpful resources.

Tech Article: How to Configure x86 Memory Performance for Large Databases

by Ed Whalen, Oracle ACE

Performance issues in large databases are not easy to detect using normal analysis methods such as AWR reports and OS tools such as sar, top, and iostat. And yet, if you configure your memory appropriately in x86 environments, your database can run significantly faster. This article describes you can use Linux Huge Pages to do just that.

Ed covers x86 virtual memory architecture, Linux memory management, and enabling Linux Huge Pages. See the article here.

Video Interview: What Are Linux Huge Pages?

with Ed Whalen, Oracle ACE

Ed Whalen, Oracle ACE, explains Linux huge pages, the huge performance increase they provide, and how sysadmins and DBA's need to work together to use them properly. Taped at Oracle Open World 2013.

photograph of cliff face in Perry Park, Colorado, copyright Rick Ramsey

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

Thursday Jan 02, 2014

About our Latest Lab: How to Migrate to Oracle Linux and Oracle VM





Step by Step Instructions for Migrating to Oracle Linux and Oracle VM

Red Hat Linux and VMWare are fine technologies. A great pairing. However, if you have business reasons for migrating to Oracle Linux and Oracle VM, such as having earlier access to the latest Linux innovations or taking advantage of more integrated virtualization, take a look at our latest lab. It provides the best step by step instructions we could come up with for carrying out that migration. You can also try it just to hone your migration skills. You never know when the boss is going to ask you whether you can handle a migration.





Here's a peek at the major tasks:

  1. Start the two servers (Oracle VM Server and Oracle VM Manager).
  2. Connect to Oracle VM Manager and become familiar with the product.
  3. Verify that the Oracle VM environment started correctly.
  4. Import an assembly that has Oracle Database on top and was exported from VMware.
  5. Create an Oracle VM Template based on the VMware assembly.
  6. Edit the Oracle VM Template that was created.
  7. Create a guest based on the Oracle VM Template that was created.
  8. Verify and then start the Oracle VM guest that was created.
  9. Manually modify the guest configuration and remove VMware tools.
  10. Switch from the Red Hat kernel to Oracle's Unbreakable Enterprise Kernel for free.
  11. Transform the guest into a usable Oracle VM Template ("gold image").

You can run the lab anytime you like on your laptop, or you can attend OTN's next Virtual SA Day, and run it with the help of a proctor. There will be several hundred sysadmins running the same lab at the same time, so you can discuss it with others via chat, and get help from our proctors. Details here.

photograph of a brewery in Ouray, Colorado, by Rick Ramsey

- Rick

Follow me on:
Blog | Facebook | Twitter | YouTube | The Great Peruvian Novel

About

Contributors:
Rick Ramsey
Kemer Thomson
and members of the OTN community

Search

Archives
« January 2014 »
SunMonTueWedThuFriSat
   
1
3
4
5
6
11
12
14
15
16
17
18
19
20
21
24
25
26
27
28
30
 
       
Today
Blogs We Like