11g: Managing Oracle on Linux for DBA's

Course Fees: $2146.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 2 days
Course Manual

Sorry, no course dates found

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.

Learn 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
Database Administrators
Support Engineer
Technical Administrator
Technical Consultant
Basic knowledge of Linux or Unix operating systems.
  • Identify the different kernels available for Linux
  • View installed packages on a Linux system
  • Prepare and update a system for an Oracle Database installation
  • Identify and implement the best storage options for an Oracle database
  • Customize the database to take advantage of Linux features
  • Optimize Linux for running an Oracle database
  • Use Linux commands and techniques to automate and streamline DBA tasks
  • Troubleshoot database errors specific to the Linux OS
Review of Linux Basics
Linux Directory Structure
File Permissions and Security
Common Linux Commands and Programs
Working with Linux Shells
Bash Shell Scripting

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

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

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

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

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

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

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

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