Managing Oracle on Linux

Class times are from 9 A.M. to 5 P.M.

What you will learn:

This course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle9i Database on Linux. Students will learn how to configure the Linux operating system for optimal performance with an Oracle9i database. Then they will install and create an Oracle9i database on Linux. The students will also learn how to tune the Oracle9i database to take advantage of the Linux operating system and the Enterprise level features of the OS. Basic administration OS tasks as they relate to the database will also be covered; file system choices, automated startup and shutdown scripts, network configuration, customizing the database for Linux, and configuring Oracle Enterprise Manager. Lectures are reinforced with hands-on practices designed to walk the student through the entire installation, tuning and configuration process.

Audience:

Technical Consultant
Database Administrators
Database Designers

Course Objectives:

Install Oracle9i on the Linux
Configure Oracle9i on Linux
Manage and Tune Oracle9i on Linux
Configure the Linux OS for Oracle 9i

Course Topics:

Oracle9i on Linux: Overview
Select a supported Linux distribution and version
Select the proper Oracle database versions
Identify Enterprise Linux level distributions

Preparing the Operating System
Configure the operating system (OS) kernel
Install the required OS patches
Configure the Linux network
Select a file system
Configure the X Window System

Installing Oracle9i Software
Create the OS user oracle
Configure the Oracle9i OS environment
Install Oracle9i software by using the Oracle Universal Installer (OUI)
Create a General Purpose database with OUI
Install patch sets and temporary patches

Creating a Custom Oracle9i Database
Create a custom Oracle9i database
Configure and start Oracle Net components

Installing and Configuring Enterprise Manager
Configure Oracle Management Server (OMS)
Discover Oracle9i databases and nodes
Configure the HTTP server and Enterprise Manager Reporting
Configure and test jobs and events by using Oracle Enterprise Manager

Customizing the Oracle9i Database
Create automated startup/shutdown scripts
Automate tasks using scheduling tools
Configure Linux startup and shutdown sequence
Create automated startup/shutdown scripts

Linux Measurement Tools
Identify and use basic measurement tools
Measure the CPU load
Gather memory usage statistics
Gather input/output (I/O) load statistics
Collect network activity statistics

Oracle9i Measurement Tools
Use Statspack with operating system (OS) tools
Use Oracle Enterprise Manager tools with OS tools
Configure and measure System Global Area (SGA) and Program Global Area (PGA) usage

Tuning Oracle9i and Linux
Evaluate file systems
Tune supported file systems
Configure initialization parameters
Implement asynchronous input/output (I/O)
Implement advanced memory management techniques

- top -

[home] [about us] [people] [products] [investors] [training] [conferences] [news] [contact us]

Copyright RPC Data 2005
Site Design and Development by MindQ