Skip to content

Oracle Database 11g Release 2 Managing Oracle on Linux for DBAs - In-house Training

StayAhead Training

Summary

Price
Enquire to get more info on pricing
Study method
Onsite
Duration
2 days
Qualification
No formal qualification
Additional info
  • Tutor is available to students

Overview

The Oracle Database 11g Release 2 Managing Oracle on Linux for DBAs training course is designed to give delegates practical experience in deploying an Oracle 11gR2 Database on Linux. This course is also suitable for Oracle Database 12c.

The delegate will learn and acquire skills as follows:

  • Configuring Linux for an Oracle Database Installation
  • Viewing and installing packages on a Linux system
  • Monitoring memory, CPU and I/O activity and performance
  • Identifying the different kernels and memory models available for Linux
  • Creating a database and listener
  • Customizing a database to utilize Linux features
  • Implementing storage options for an Oracle database on Linux
  • Enabling a large SGA
  • Tuning an Oracle Database on Linux
  • Debugging database errors specific to Linux

Who will the Course Benefit?

The Oracle Database 11g Release 2 Managing Oracle on Linux for DBAs course will benefit Database Administrators who need to deploy an Oracle Database in a Linux environment.

Course Objectives

The Oracle Database 11g Release 2 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.

Description

Course Contents - DAY 1 Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

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

  • Plan an Installation
  • Linux Distributions
  • Linux Certification
  • Kernel Version Information
  • Verify Package Requirements
  • Install and Manage Packages
  • Use the /proc Filesystem
  • Inter Process Communication
  • Validate and prepare the Hardware and Operating System
  • Verify Swap Space
  • Kernel Configuration Parameters
  • Set Shared Memory Parameters
  • Set Semaphore Parameters
  • Set network Options
  • Set File Handles and Shell Limits
  • udev Rules
  • 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
  • Operating System Requirements
  • Validate System Architecture
  • Oracle Flexible Architecture
  • 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

  • Oracle Database Storage Options
  • Certified and Supported File Systems
  • Supported Linux I/O Modes
  • RAID
  • Logical Volume Managers
  • Supported Linux Filesystems
  • Linux Disk and Partition Names
  • File System Handling
  • Check the Filesystem Table
  • Disk Partitioning
  • Automatic Storage Management

Session 5: AUTOMATIC STORAGE MANAGEMENT OVERVIEW

  • Overview of ASM
  • Disk Group Configuration
  • SYSASM Role
  • ASMLib
  • Configure the ASM Driver
  • Configure Disks for ASM
  • Mark Disks as ASM Disks
  • Administer the ASM Library Driver and Disks
  • Create an ASM Instance
  • Administer ASM Disk Groups
  • ASM Files
  • The ASM Command Line Tool
  • ASM Best Practices

Session 6: INSTALL GRID INFRASTRUCTURE AND CREATE THE DATABASE

  • Install Grid Infrastructure for a Standalone Server
  • Select the Storage Mechanism
  • Assign ASM Disk Groups in the Database
  • Use the dbca to Create a Database
  • Installation and dbca Log Files
  • Instance Dump Files
  • Background Processes
  • Server Processes
  • Process Hierarchy
  • Configure New or Upgraded Databases

DAY 2 Session 7: AUTOMATE ORACLE ON LINUX

  • Automate Systen Administration Tasks
  • Linux Startup Sequence
  • Linux Run Levels
  • Automate Tasks with the Startup Script Framework
  • Automate Database Startup and Shutdown
  • Administrative Scripts
  • Manage Services with chkconfig
  • Start and Stop Services Dynamically
  • Automate Jobs with cron
  • Schedule an Oracle Backup with cron
  • Server Parameter File

Session 8: MANAGE MEMORY

  • Configure Swap Space
  • Evaluate the Memory Usage
  • Monitor and Tune Memory
  • Implement Hugepages
  • Enlarge the SGA
  • Tempfs and MEMORY_TARGET

Session 9: OPTIMISE ORACLE ON LINUX

  • Measure CPU Activity and Reduce Bottlenecks
  • Tune Memory
  • Measure Memory with sar
  • Monitor and Tune Disk I/O
  • Use iostat
  • Reduce Real Time Process Activity with top
  • 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
  • Kill Sever 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

Who is this course for?

The Oracle Database 11g Release 2 Managing Oracle on Linux for DBAs course will benefit Database Administrators who need to deploy an Oracle Database in a Linux environment.

Requirements

Pre-Requisite Courses

  • Linux Introduction

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all