Oracle 9i DBA for Linux (O911) Training Course

Training Course Objectives

This follow-on course is designed to introduce the Oracle 9i-database admin-istrator to the functional controls in-volved in the management of the RDBMS on a Linux platform.

The course acts as an additional asset to the Oracle 9i DBA Part 1 course and covers platform specific issues around a Linux based implementation including installation, configuration and manage-ment functions.


Who Should Attend

  • Oracle Database Administrators
  • Oracle Technical IT Manager
  • Oracle Support Engineers
  • Oracle Application Developers
  • Oracle Project Managers

Training Course Prerequisites

Training Course Duration

3 Days


Training Course Contents

Introduction

  • Introduction to Linux
  • Enterprise Linux Distributions

Basic Linux Commands

  • Linux file system Fundamentals
  • Navigating the File System
  • Viewing Files
  • Modifying Files

Operating System pre-requisite

  • Required kernel modifications
  • Kernel tuning
  • Additional package requirements
  • Network setup
  • File system options.
  • X-Server setup

Oracle 9i Special Requirements

  • Package requirements
  • Patches
  • Specific 9i requirements

Preparing Linux

  • Configuring the Kernel
  • Linux update systems
  • Installing OS updates
  • Creating Users and Groups
  • Preparing the Environment
  • Asynchronous I/O

Installing Oracle

  • Using the Universal Installer and X Windows.
  • Java requirements
  • Using the Database Configuration Assistant

Database creation

  • Creating a new database using the Oracle toolset
  • Oracle network service configuration

Database integration

  • Service creation
  • Scripting for database management
  • OS utilities and Oracle integration

Managing the Database

  • Processes
  • Oracle tuning
  • Enterprise Manager access
  • Using Export/Import and pipes
  • Configuring the SGA

Linux Monitoring Tools

  • Using top
  • Measuring system load
  • Analyzing OS statistics

Maintenance and Backup

  • Linux backup commands
  • Automated task scheduling
  • Logical backups and Linux

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.

Training Services






NHS Brochure 2010


Room Rentals


London Office

Find Us
Clerks Court
18-20 Farringdon Lane
Clerkenwell
London
EC1R 3AU
uksales@itraineducation.co.uk
Tel: +44 (0)207 608 1835
Fax: +44 (0)207 490 3465

Edinburgh Office

Find Us
2nd Floor
37 George Street
Edinburgh
West Lothian
EH2 2HN
uksales@itraineducation.co.uk
Tel: +44 (0)131 226 6620
Fax: +44 (0)131 226 6650

Leeds Office

Find Us
WESTONE
Wellington Street
Leeds
West Yorkshire
LS1 1BA
uksales@itraineducation.co.uk
Tel: +44 (0)207 608 1835
Fax: +44 (0)207 490 3465

Manchester Office

Find Us
Pall Mall Court
61 - 67 King Street
Manchester
M2 4PD
uksales@itraineducation.co.uk
Tel: +44 (0)207 608 1835
Fax: +44 (0)207 490 3465

Swindon Office

Minton Place
Station Road
Swindon SN1 1DA
uksales@itraineducation.co.uk
Tel:+44 (0)207 608 1835
Fax:+44 (0)207 490 3465

Reading

Napier Court
Napier Road
Reading
RG1 8B
uksales@itraineducation.co.uk
Tel:+44 (0)207 608 1835
Fax:+44 (0)207 490 3465

Birmingham

Birmingham Brindley Place
3 Brindley Place
Birmingham
B1 2JB
uksales@itraineducation.co.uk
Tel:+44 (0)207 608 1835
Fax:+44 (0)207 490 3465