11g: Managing Oracle on Linux for DBAs

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

Sorry, no course dates found

  • Configure and verify the Linux operating system for optimal performance with an Oracle Database.
  • Tune the database to take advantage of the Linux operating system.
  • Learn 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.
  • Optimize the Linux environment for Oracle Database.
  • Discover Linux tips and tricks.
  • Prepare and update a Linux 64-bit system for an Oracle Database silent installation.
Database Administrators
Support Engineer
Technical Administrator
Technical Consultant
Oracle Database Administration
  • 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