Versión para impresora

Código: D55650GC10
Duración: 12 horas (2 días)
Horario:  9:00 a 15:00 horas 

Fechas previstas
Curso bajo demanda

Descripción del Curso

Este curso está diseñado para  ofrecer al administrador una comprensión firme de los componentes requeridos para desarrollar una base de datos Oracle 11g en Oracle Enterprise Linux. Los alumnos estudiarán como configurar el sistema operativo Linux para un desarrollo optimo con la base de datos Oracle.

Prerequisitos

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

 

 Objetivos

• 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

Contenido

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