Session 1: A REVIEW OF LINUX BASICS
- 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
Session 2: CONFIGURE LINUX FOR ORACLE
- 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
Session 3: INSTALL ORACLE 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
Session 4: MANAGE STORAGE ON LINUX
- Storage Requirements
- Certified and Supported File Systems
- Disk Partitioning
- Automatic Storage Management
Session 5: AUTOMATIC STORAGE MANAGEMENT OVERVIEW
- Overview of ASM
- ASMLib
- Configure Disks for ASM
- Create an ASM Instance
- ASM Best Practices
Session 6: CREATE THE DATABASE
- 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
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
Session 8: MANAGE MEMORY
- Configure Swap Space
- Evaluate the Memory Usage
- Implement Hugepages on 32-bit Linux
- Enlarge the SGA
Session 9: OPTIMIZE ORACLE ON LINUX
- 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
Session 10: ADDITIONAL TIPS FOR DBAS
- 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
Session 11: DEBUG ORACLE ON LINUX
- OS Watcher
- The Remote Diagnostic Agent
- Trace Processes with strace
- Deal with ORA-600 Errors
- Deal with ORA-7445 Errors