Oracle Database 11g Managing Oracle on Linux for DBAs

Level:
Costs:
Total time:
Provider rating: 10Perpetual Solutions has an average rating of 10 (out of 1 reviews)
Logo Perpetual Solutions

Tip: Receive more information about the programme, starting dates & price. Or request a proposal from multiple providers for in-house training.

Overview

Your experience of this course?

Did you attend the course Oracle Database 11g Managing Oracle on Linux for DBAs at Perpetual Solutions? Help other people by submitting your review at Springest!

Springest will donate £1.- to the Edukans Foundation as a thank you for each review

 
Schedule:
Daytime
Run time:
2 Days
Location type:
Open

vat information, completion, maximum participants, and starting dateplaces are unknown for this course.

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
  • C…

Read the complete description

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
  • 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!

Reviews

There are no reviews yet. Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

More courses within this subject:

Compare 36,057 training courses in subjects like Oracle

Sign up to create your own Learning Lists.

Not for humans