Oracle Database 10g: Managing Oracle on Linux for DBAs

Seminar

In Stuttgart

1.180 € zzgl. MwSt.

Beschreibung

  • Kursart

    Seminar

  • Niveau

    Anfänger

  • Ort

    Stuttgart

  • Dauer

    2 Tage

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.

Standorte und Zeitplan

Lage

Beginn

Stuttgart (Baden-Württemberg)
Wankelstraße 1, D-70563

Beginn

auf Anfrage

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Inhalte

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


Oracle Database 10g: Managing Oracle on Linux for DBAs

1.180 € zzgl. MwSt.