D58830GC10, Oracle Database 11g: Managing Oracle on Linux for DBAs

Click course dates link in the "Dates" column to register for the class!

Course target

This course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 11g database on Oracle Enterprise Linux. Students will learn how to configure and verify the Linux operating system for optimal performance with an Oracle database. Students will also learn how to tune the database to take advantage of the Linux operating system and the Enterprise level features of the OS.

The course covers administrative tasks related to the database like file system choices, kernel and memory model selection, automated startup and shutdown scripts, and customizing the database for Linux. Lectures are reinforced with hands-on practices designed to walk the student through the entire installation, tuning, configuration and troubleshooting process.

Audience

• Database Administrators
• Support Engineer
• Technical Administrator
• Technical Consultant

After course students will be able to

• Optimize the Linux environment for Oracle Database, and vice versa
• Use Linux tips and tricks especially important for Oracle DBAs
• Prepare and update a Linux 64-bit system for an Oracle Database silent installation
• A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time.

Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Prerequisites

Required Prerequisites:

• Oracle Database 11g: 2 Day DBA

Suggested Prerequisites:

• Basic knowledge of Linux or Unix operating systems.
• Hands-on experience administering Oracle Database 10g or 11g.

Course materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Course contents

1. Review of Linux Basics:

• Linux Directory Structure
• File Permissions and Security
• Common Linux Commands and Programs
• Working with Linux Shells
• Bash Shell Scripting

2. Preparing Linux for Oracle:

• Linux Distributions
• Verifying the Linux Kernel
• Using the /proc System
• Setting Kernel Parameters
• Managing Packages
• Using the oracle-validated RPM
• Creating Groups and Users
• The nobody User

3. Installing Oracle on Linux:

• Setting Environment Variables Pre-Installation
• Optimal Flexible Architecture
• Installing New Releases
• Managing Multiple Oracle Versions
• Setting Oracle Environment Variables
• Performing a Silent or Suppressed Installation
• Oracle Patch Utility
• Oracle Relink Utility

4. Managing Storage on Linux:

• Oracle Database Storage Options
• Supported Linux I/O Modes
• Disks and Partitions
• Managing Partitions
• Logical Volume Manager Concepts
• Attached Storage
• Linux and File Systems
• Monitoring Disk Usage and Free Space

5. Using Oracle ASM on Linux:

• Automatic Storaget Management Library Driver
• Installing and Initializing ASMLib
• Configuring Disks
• Marking Disks as Automatic Storage Management Disks
• Creating an ASM Instance
• ASM Installation Best Practices
• Disk Group Configuration Best Practices

6. Automating Oracle on Linux:

• Automating Tasks
• Linux Startup Sequence
• Linux Runlevels
• Automating Startup and Shutdown of Oracle Processes
• Working with the dbstart and dbshut Scripts
• Linux Scheduling Tools
• Scheduling a Backup with cron

7. Optimizing Linux for Oracle:

• Standard Linux Measurement Tools
• Measuring CPU Activity and Reducing CPU Bottlenecks
• Monitoring and Tuning Memory
• Monitoring and Tuning Disk I/O
• Basic Oracle Database Optimizations
• Basic Linux Optimizations
• Page Address Extensions for 32-bit Systems
• Configuring Hugepages

8. Additional Linux Tips for DBAs:

• Simple Shell Scripts to Simplify DBA Tasks
• Adding Command History to SQL*Plus
• Finding Files with SETUID or SETGID Set
• Capturing System Data Using Scripts
• Finding Background Processes
• Finding Server Processes
• Killing Server Processes
• Query Output in an Environment Variable

9. Troubleshooting Oracle Issues on Linux:

• Monitoring alert log with ADRCI
• Resolving ORA-600/ORA-7445 Errors
• Process Hierarchy
• Viewing the Startup Environment for a Process
• Viewing the Status of a Process
• Recovering from Database Crashes
• Debugging a Core Dump
• Using strace