Oracle Database 10g: Managing Oracle on Linux for DBAs
Seminar
In Stuttgart
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
Beginn
Meinungen
Inhalte
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