Oracle Database 10g Managing Oracle on Linux for DBAs

Oracle Database 10g Managing Oracle on Linux for DBAs

2 days @ £995.00 exc. VAT 

Course Code: O10GMOL

25 Years - The IT Training specialist

Virtual Events StayAhead Virtual Courses available

You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.

S9

Oracle Database 10g Managing Oracle on Linux for DBAs Course Overview

The Oracle Database 10g Managing Oracle on Linux for DBAs training course is designed to give delegates practical experience in deploying an Oracle 10g Database on Linux.

The delegate will learn and acquire skills as follows:

  • 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

Who will the Course Benefit?

The Oracle Database 10g Managing Oracle on Linux for DBAs course will benefit Database Administrators who need to deploy an Oracle Database in a Linux environment.

Course Objectives

The Oracle Database 10g Managing Oracle on Linux for DBAs course provides the skills needed to query optimally configure the Linux operating system, install the Oracle Database software and configure an Oracle database.

Examinations

The Oracle Database 10g Managing Oracle on Linux for DBAs course covers the major topics required for the Oracle examination 1Z0-046: Oracle Database 10g: Managing Oracle on Linux for DBAs.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Pre-Requisite Courses

Follow-On Courses

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Oracle Database 10g Managing Oracle on Linux for DBAs Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: A REVIEW OF LINUX BASICS

  • 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

Session 2: 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

Session 3: 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

Session 4: MANAGE STORAGE ON LINUX

  • Storage Requirements
  • Certified and Supported File Systems
  • Disk Partitioning
  • Automatic Storage Management

Session 5: AUTOMATIC STORAGE MANAGEMENT OVERVIEW

  • Overview of ASM
  • ASMLib
  • Configure Disks for ASM
  • Create an ASM Instance
  • ASM Best Practices

Session 6: 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

Oracle Database 10g Managing Oracle on Linux for DBAs Training Course

Session 7: AUTOMATE ORACLE ON LINUX

  • Linux Startup Sequence
  • Linux Runlevels
  • Database Startup and Shutdown
  • Administrative Scripts
  • Manage Services with chkconfig
  • Automate Jobs
  • Server Parameter File

Session 8: MANAGE MEMORY

  • Configure Swap Space
  • Evaluate the Memory Usage
  • Implement Hugepages on 32-bit Linux
  • Enlarge the SGA

Session 9: OPTIMIZE ORACLE ON LINUX

  • Measure CPU Activity and Reduce Bottlenecks
  • Tune Memory
  • Measure Memory with sar
  • Monitor and Tune Disk I/O
  • Use iostat
  • Reduce I/O Bottlenecks
  • The System Activity Recorder
  • Tune Linux and Oracle for Network Performance

Session 10: ADDITIONAL TIPS FOR DBAS

  • Create Shell Scripts to Simplify DBA Tasks
  • Add Command History to SQL*Plus
  • Change Access Rights on Files with SETUID and SETGID
  • Server and Background Processes

Session 11: DEBUG ORACLE ON LINUX

  • OS Watcher
  • The Remote Diagnostic Agent
  • Trace Processes with strace
  • Deal with ORA-600 Errors
  • Deal with ORA-7445 Errors
Home Let Us Call You Enquiry

Place A booking





Print Friendly





Please call for Dates



If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.

Quick Search...


Enquiry
StayAhead Promo 12


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

See what our clients say . . .

Technical course content was excellent and just what I required regards procedures, functions and packages, so the exercises were very useful and learning the syntax and formats and commands. Plenty of time was allocated for practical exercises and writing code which I would encourage on future courses. The theory was much needed also and improved my understanding of PL/SQL I have already seen in daily tasks. The trainer was very knowledgeable and took time to explain sections as required and answers to any questions. The folder will be very beneficial in practicing back at work to consolidate these Oracle skills.

Andrew - Application Support Manager - Postal/Distribution - February 2018

More Reviews

+44 (0)20 7600 6116
Cookies Policy
Copyright © 2018 StayAhead Training Ltd
sales@stayahead.com