Loading...

Oracle 10g DBA for Linux

Course code: O921

2 days

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

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

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

This course acts as an additional asset to the Oracle 10g DBA Part 1 course and covers platform specific issues around a Linux based implementation including installation, configuration and management functions.

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 prerequisites

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

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
Contact us for more information