Oracle Database 10g Managing Oracle on Linux for DBAs
Course
In London
Description
-
Type
Course
-
Location
London
-
Class hours
14h
-
Duration
2 Days
Suitable for: The Oracle Database 10g Managing Oracle on Linux for DBAs training course is designed to give delegates practical experience in deploying an Oracle 10g Database on Linux.
Facilities
Location
Start date
Start date
Reviews
Course programme
The Oracle Database 10g Managing Oracle on Linux for DBAs course provides the skills needed to query optimally configure the Linux operating system, install the Oracle Database software and configure an Oracle database.
Oracle Database 10g Managing Oracle on Linux for DBAs Training Course
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Linux Overview
- Kernel Version Information
- Common Linux Commands
- The Linux Directory Structure
- Linux Utilities and Directories
- Navigating the File System
- The Linux Server Interface
- Linux Web Server Utilities
- Processes and Threads
- Devices
- Filesystems
- The Virtual File System
- Bash Shell Scripting
- Kernel Configuration Parameters
- Set Shared Memory Parameters
- Set Semaphore Parameters
- Manage Packages
- Configure the ASM Library Driver
- Configure the X Window System
- Create Oracle Users and Groups on Linux
- Storage Requirements
- File System Security
- Set Environment Variables
- Create Oracle Directories
- Manage Multiple Versions of Oracle Software
- Pre Installation Procedures for Linux
- The Oracle Universal Installer
- The Installation Process
- Post Installation Procedures for Linux
- Testing and Validation of the Installation
- Storage Requirements
- Certified and Supported File Systems
- Disk Partitioning
- Automatic Storage Management
- Overview of ASM
- ASMLib
- Configure Disks for ASM
- Create an ASM Instance
- ASM Best Practices
- Select the Storage Mechanism
- Assign ASM Disk Groups in the Database
- dbca Log Files
- Installation Log Files
- Instance Dump Files
- Background Processes
- Server Processes
- Process Hierarchy
Course Contents - DAY 2
Session 7: AUTOMATE ORACLE ON LINUX
- Linux Startup Sequence
- Linux Runlevels
- Database Startup and Shutdown
- Administrative Scripts
- Manage Services with chkconfig
- Automate Jobs
- Server Parameter File
- Configure Swap Space
- Evaluate the Memory Usage
- Implement Hugepages on 32-bit Linux
- Enlarge the SGA
- Measure CPU Activity and Reduce Bottlenecks
- Tune Memory
- Measure Memory with sar
- Monitor and Tune Disk I/O
- Use iostat
- Reduce I/O Bottlenecks
- The System Activity Recorder
- Tune Linux and Oracle for Network Performance
- Create Shell Scripts to Simplify DBA Tasks
- Add Command History to SQL*Plus
- Change Access Rights on Files with SETUID and SETGID
- Server and Background Processes
- OS Watcher
- The Remote Diagnostic Agent
- Trace Processes with strace
- Deal with ORA-600 Errors
- Deal with ORA-7445 Errors
Oracle Database 10g Managing Oracle on Linux for DBAs