Starting dates and places

Description

Prerequisites:

There are no formal pre-requisites. A working knowledge of Oracle Database Administration and of operating system concepts is required.

Course Description:

This Oracle training course is designed to give delegates practical experience in deploying an Oracle 11g Database on Enterprise Linux. It will benefit Database Administrators who need to deploy an Oracle Database in a Linux environment.

The delegates will practise:

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

Frequently asked questions

Prerequisites:

There are no formal pre-requisites. A working knowledge of Oracle
Database Administration and of operating system concepts is
required.

Course Description:

This Oracle training course is designed to give delegates
practical experience in deploying an Oracle 11g Database on
Enterprise Linux. It will benefit Database Administrators who need
to deploy an Oracle Database in a Linux environment.

The delegates will practise:

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

This course includes the following modules:

Introduction to Linux

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

Storage Requirements

Certified and Supported File Systems

Disk Partitioning

Automatic Storage Management

Automatic Storage Management

Overview of ASM

ASMLib

Configure Disks for ASM

Create an ASM Instance

ASM Best Practices

Create the Database

Select the Storage Mechanism

Assign ASM Disk Groups in the Database

dbca Log Files

Installation Log Files

Instance Dump Files

Background Processes

Server Processes

Process Hierarchy

Customize Oracle on Linux

Linux Startup Sequence

Linux Runlevels

Database Startup and Shutdown

Administrative Scripts

Manage Services with chkconfig

Automate Jobs

Server Parameter File

Manage Memory

Configure Swap Space

Evaluate the Memory Usage

Implement Hugepages on 32-bit Linux

Enlarge the SGA

Linux Tuning Tools

Tune CPU

Tune Memory

Measure Memory with sar

Monitor and Tune I/O

Use iostat

Reduce I/O Bottlenecks

Tune Oracle on Linux

Size Database Blocks

Configure Multiple Database Writer Processes or DB Writer
Slaves

Configure Automatic Shared Memory Management

Tune Linux for Network Performance

Debug Oracle on Linux

OS Watcher

The Remote Diagnostic Agent

Trace Processes with strace

Deal with ORA-600 Errors

Deal with ORA-7445 Errors

For online live training advice please visit our
Learning Advice Centre on our website. Be sure to follow us on
Twitter to receive special course offers, news and updates!