• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

Oracle Database 11g: Managing Oracle on Linux for DBA

30 Hours
Online Instructor-led Training
USD 2800
Oracle Database 11g: Managing Oracle on Linux for DBA course and certification
318 Learners

About this Course

This Database 11g: Managing Oracle on Linux course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 11g database on Oracle Enterprise Linux.

Course Objective

  • Identify the different kernels available for Linux
  • View installed packages on a Linux system
  • Prepare and update a system for an Oracle Database installation
  • Identify and implement the best storage options for an Oracle database
  • Customize the database to take advantage of Linux features
  • Optimize Linux for running an Oracle database
  • Use Linux commands and techniques to automate and streamline DBA tasks
  • Troubleshoot database errors specific to the Linux OS
Target Audience

  • Administrator
  • Database Administrator
  • Implementer

Oracle Database 11g: Managing Oracle on Linux for DBA

Course Details & Curriculum

1.      Review of Linux Basics

·       Linux Directory Structure

·       File Permissions and Security

·       Common Linux Commands and Programs

·       Working with Linux Shells

·       Bash Shell Scripting

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

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

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

5.      Using Oracle ASM on Linux

·       Automatic Storage 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

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

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

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

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



Didn't find what you are looking for?  Contact Us