Oracle Database 12c Managing Oracle on Linux for DBAs

Course

In London-City

£ 845 + VAT

Description

  • Type

    Course

  • Location

    London-city

The Oracle Database 12c Managing Oracle on Linux for DBAs training course is designed to give delegates practical experience in deploying an Oracle 11gR2 12c Database on Linux. This course is also suitable for Oracle Database 12c. Who will the Course Benefit?The Oracle Database 12c Managing Oracle on Linux for DBAs course will benefit Database Administrators who need to deploy an Oracle Database in a Linux environment. Learning Objectives The delegates will practise: Configuring Linux for an Oracle Database InstallationViewing and installing packages on a Linux systemMonitoring memory, CPU and I/O activity and performanceIdentifying the different kernels and memory models available for LinuxCreating a database and listenerCustomizing a database to utilize Linux featuresImplementing storage options for an Oracle database on LinuxEnabling a large SGATuning an Oracle Database on LinuxDebugging database errors specific to Linux The Oracle Database 12c 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.

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

Pre-Requisite CoursesLinux Introduction

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Install
  • Installation
  • Database training
  • Database
  • Linux

Course programme

Course Contents - DAY 1Course 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
  • Plan an Installation
  • Linux Distributions
  • Linux Certification
  • Kernel Version Information
  • Verify Package Requirements
  • Install and Manage Packages
  • Use the /proc Filesystem
  • Inter Process Communication
  • Validate and prepare the Hardware and Operating System
  • Verify Swap Space
  • Kernel Configuration Parameters
  • Set Shared Memory Parameters
  • Set Semaphore Parameters
  • Set network Options
  • Set File Handles and Shell Limits
  • udev Rules
  • 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
  • Operating System Requirements
  • Validate System Architecture
  • Oracle Flexible Architecture
  • 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
  • Oracle Database Storage Options
  • Certified and Supported File Systems
  • Supported Linux I/O Modes
  • RAID
  • Logical Volume Managers
  • Supported Linux Filesystems
  • Linux Disk and Partition Names
  • File System Handling
  • Check the Filesystem Table
  • Disk Partitioning
  • Automatic Storage Management
Session 5: AUTOMATIC STORAGE MANAGEMENT OVERVIEW
  • Overview of ASM
  • Disk Group Configuration
  • SYSASM Role
  • ASMLib
  • Configure the ASM Driver
  • Configure Disks for ASM
  • Mark Disks as ASM Disks
  • Administer the ASM Library Driver and Disks
  • Create an ASM Instance
  • Administer ASM Disk Groups
  • ASM Files
  • The ASM Command Line Tool
  • ASM Best Practices
Session 6: INSTALL GRID INFRASTRUCTURE AND CREATE THE DATABASE
  • Install Grid Infrastructure for a Standalone Server
  • Select the Storage Mechanism
  • Assign ASM Disk Groups in the Database
  • Use the dbca to Create a Database
  • Installation and dbca Log Files
  • Instance Dump Files
  • Background Processes
  • Server Processes
  • Process Hierarchy
  • Configure New or Upgraded Databases
Course Contents - DAY 2Session 7: AUTOMATE ORACLE ON LINUX
  • Automate Systen Administration Tasks
  • Linux Startup Sequence
  • Linux Run Levels
  • Automate Tasks with the Startup Script Framework
  • Automate Database Startup and Shutdown
  • Administrative Scripts
  • Manage Services with chkconfig
  • Start and Stop Services Dynamically
  • Automate Jobs with cron
  • Schedule an Oracle Backup with cron
  • Server Parameter File
Session 8: MANAGE MEMORY
  • Configure Swap Space
  • Evaluate the Memory Usage
  • Monitor and Tune Memory
  • Implement Hugepages
  • Enlarge the SGA
  • Tempfs and MEMORY_TARGET
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 Real Time Process Activity with top
  • 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
  • Kill Sever 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

Oracle Database 12c Managing Oracle on Linux for DBAs

£ 845 + VAT