Oracle Database 10g: Managing Oracle on Linux for DBAs

AS-SYSTEME Unternehmensberatung
In Stuttgart

1.180 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
711 9... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

  • Seminar
  • Anfänger
  • Stuttgart
  • Dauer:
    2 Tage
Beschreibung

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten: - Optimally configure Linux for an Oracle Database installation. - Identify the different kernels and memory models available for Linux. - View installed packages on a Linux system. - Create a database and listener. - Customize the database to take advantage of Linux features. - Identify and implement the best..
Gerichtet an: Datenbankadministratoren, Technischer Berater.

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Stuttgart
Wankelstraße 1, D-70563, Baden-Württemberg, Deutschland

Themenkreis

Trainingsziel

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten:

  • Optimally configure Linux for an Oracle Database installation


  • Identify the different kernels and memory models available for Linux


  • View installed packages on a Linux system


  • Create a database and listener


  • Customize the database to take advantage of Linux features


  • Identify and implement the best storage options for an Oracle database


  • Enable a large SGA that overcomes 32-bit addressing limitations


  • Monitor memory, CPU, and I/O activity and performance


  • Tune an Oracle database on Linux


  • Debug database errors specific to the Linux OS


Teilnehmerkreis

Datenbankadministratoren, Technischer Berater

Überblick über den Inhalt des Trainings

Introduction to Linux

  • Kernel Version Information
  • Common Linux Commands
  • Navigating the File System
  • Using the Virtual File System
  • The Basics of Bash Shell Scripting


Preparing Linux for Oracle

  • Setting Shared Memory Parameters
  • Setting Semaphore Parameters
  • Managing Packages
  • Configuring the X Window System
  • Creating the Necessary Linux Users


Installing Oracle on Linux

  • File System Security
  • Setting Environment Variables
  • Creating Oracle Directories
  • Managing Multiple Version of Oracle Software
  • Using the Oracle Universal Installer
  • Installation Pre-requisites
  • The Oracle Relink Utility


Managing Storage

  • Certified and Supported File Systems
  • Disk Partitioning
  • Automatic Storage Management


Automatic Storage Management (ASM)

  • ASMLib
  • Configuring Disks for ASM
  • Creating an ASM Instance
  • ASM Best Practices


Creating the Database

  • Choosing the Storage Mechanism
  • Assigning ASM Disk Groups in the Database
  • dbca Log Files
  • Installation Log Files
  • Instance Dump Files
  • Background Processes
  • Server Processes
  • Process Hierarchy


Customizing Oracle on Linux

  • Linux Startup Sequence
  • Linux Runlevels
  • Database Startup and Shutdown
  • Administrative Scripts
  • Managing Services with chkconfig
  • Automating Jobs
  • Server Parameter File


Managing Memory

  • Swap Space
  • Evaluating Memory Usage
  • Implementing Hugepages on 32-bit Linux
  • Enlarging the SGA


Using Linux Measurement Tools

  • Tuning CPU
  • Tuning Memory
  • Measuring Memory with sar
  • Monitoring and Tuning I/O
  • Using iostat
  • Reducing I/O Bottlenecks


Tuning Oracle on Linux

  • Sizing Database Blocks
  • Using Multiple DBWR Processes
  • Using DB Writer Slaves
  • Using Automatic Shared Memory Management


Debugging Oracle on Linux

  • Using OS Watcher
  • Using the Remote Diagnostic Agent
  • Using strace to Trace Processes
  • Resolving ORA-600 Errors
  • Resolving ORA-7445 Errors



Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen