Oracle Database 11g: Managing Oracle on Linux for DBAs

Oracle Database 11g: Managing Oracle on Linux for DBAs Certification Training Course Overview

Koenig offers a course on Oracle Database 11g: Managing Oracle on Linux for DBAs. This course covers administrative tasks related to the database like file system choices, kernel and memory model selection, automated startup and shutdown scripts, and customizing the database for Linux. Lectures are reinforced with hands-on practices designed to walk the student through the entire installation, tuning, configuration and troubleshooting process. After completing this course, students will be able to use Oracle ASM on Linux, automate Oracle on Linux, and troubleshoot Oracle Issues on Linux. This course is best suited for database administrators, support engineers, technical administrators, and technical consultants.

Test your current knowledge Qubits42

Oracle Database 11g: Managing Oracle on Linux for DBAs (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 850
18 - 19 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 02 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1:Review of Linux Basics
  • Linux Directory Structure
  • File Permissions and Security
  • Common Linux Commands and Programs
  • Working with Linux Shells
  • Bash Shell Scripting
Module 2:Preparing Linux for Oracle
  • Linux Distributions
  • Verifying the Linux Kernel
  • Using the /proc System
  • Setting Kernel Parameters
  • Managing Packages
  • Using the oracle-validated RPM
  • Creating Groups and Users
  • The nobody User
Module 3:Installing Oracle on Linux
  • Setting Environment Variables Pre-Installation
  • Optimal Flexible Architecture
  • Installing New Releases
  • Managing Multiple Oracle Versions
  • Setting Oracle Environment Variables
  • Performing a Silent or Suppressed Installation
  • Oracle Patch Utility
  • Oracle Relink Utility
Module 4:Managing Storage on Linux
  • Oracle Database Storage Options
  • Supported Linux I/O Modes
  • Disks and Partitions
  • Managing Partitions
  • Logical Volume Manager Concepts
  • Attached Storage
  • Linux and File Systems
  • Monitoring Disk Usage and Free Space
Module 5: Using Oracle ASM on Linux
  • Automatic Storaget Management Library Driver
  • Installing and Initializing ASMLib
  • Configuring Disks
  • Marking Disks as Automatic Storage Management Disks
  • Creating an ASM Instance
  • ASM Installation Best Practices
  • Disk Group Configuration Best Practices
Module 6:Automating Oracle on Linux
  • Automating Tasks
  • Linux Startup Sequence
  • Linux Runlevels
  • Automating Startup and Shutdown of Oracle Processes
  • Working with the dbstart and dbshut Scripts
  • Linux Scheduling Tools
  • Scheduling a Backup with cron
Module 7:Optimizing Linux for Oracle
  • Standard Linux Measurement Tools
  • Measuring CPU Activity and Reducing CPU Bottlenecks
  • Monitoring and Tuning Memory
  • Monitoring and Tuning Disk I/O
  • Basic Oracle Database Optimizations
  • Basic Linux Optimizations
  • Page Address Extensions for 32-bit Systems
  • Configuring Hugepages
Module 8:Additional Linux Tips for DBAs
  • Simple Shell Scripts to Simplify DBA Tasks
  • Adding Command History to SQL*Plus
  • Finding Files with SETUID or SETGID Set
  • Capturing System Data Using Scripts
  • Finding Background Processes
  • Finding Server Processes
  • Killing Server Processes
  • Query Output in an Environment Variable
Module 9:Troubleshooting Oracle Issues on Linux
  • Monitoring alert log with ADRCI
  • Resolving ORA-600/ORA-7445 Errors
  • Process Hierarchy
  • Viewing the Startup Environment for a Process
  • Viewing the Status of a Process
  • Recovering from Database Crashes
  • Debugging a Core Dump
  • Using strace
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.

Upon Completion of this Course, you will accomplish following:

  • Prepare Linux for Oracle
  • Employ Oracle ASM on Linux
  • Install Oracle on Linux
  • Automate Oracle on Linux
  • Optimize Linux for Oracle
  • Administer Storage on Linux
  • Additional Linux Tips for DBAs
  • Troubleshoot Oracle Issues on Linux

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 11g: Managing Oracle on Linux for DBAs Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.