Oracle Database 11g Release 2 Managing Oracle on Linux for DBAs

GB Direct

Course

In London

£ 895 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

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 11g R2 Database on Linux.

Facilities

Location

Start date

London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database
  • Database training
  • Linux
  • IT

Course programme

Follow-On Courses

  • Oracle Database 11g Release 2 DBA Performance & Tuning
  • Oracle Database 11g Release 2 Data Guard

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

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

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

Manage Storage on Linux

  • Oracle Database Storage Options
  • Certified and Supported File Systems
  • Disk Partitioning
  • Automatic Storage Management

Automatic Storage Management Overview

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

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
  • Installation Log Files
  • Instance Dump Files
  • Background Processes
  • Server Processes
  • Process Hierarchy

Automate Oracle on Linux

  • Linux Startup Sequence
  • Linux Runlevels
  • Automate Tasks with the Startup Script Framework
  • Database Startup and Shutdown
  • Administrative Scripts
  • Automate Database Startup and Shutdown
  • Manage Services with chkconfig
  • Start and Stop Services Dynamically
  • Automate Jobs with cron
  • Server Parameter File

Manage Memory

  • Configure Swap Space
  • Evaluate the Memory Usage
  • Implement Hugepages on 32-bit Linux
  • Enlarge the SGA

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

Additional Tips for DBA's

  • 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

Debug Oracle on Linux

  • OS Watcher
  • The Remote Diagnostic Agent
  • Trace Processes with strace
  • Deal with ORA-600 Errors
  • Deal with ORA-7445 Errors

See related categories

Oracle Database 11g Release 2 Managing Oracle on Linux for DBAs

£ 895 + VAT

The best Oracle courses

See all

See all