Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Need Linux Oracle scripts?  Just click here!

Linux Oracle Administration

A 3-day intensive Linux Oracle Overview
© 2007-2016 by Burleson Corporation

 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

 

   
Key Features

* Understand the OFA standard for all Oracle Linux systems.

* See how to set a Linux profiles for fast server access.

* Learn important Linux commands for Oracle administration.

* See how to create server-side alerts.

* Avoid unnecessary downtime by monitoring Linux files.

* See how to monitor Linux server stress.

  

This Oracle Linux training course is an introduction to using Linux in the Oracle environment.  The focus of this Oracle Linux training course is on how Linux applies to the Oracle developer and DBA, and all course examples are drawn from Oracle. The instructor for this Oracle Linux training course will be a certified Oracle professionals with years of experince. This Oracle Linux training course will cover the basic Linux commands, and build on the foundation, eventually showing the student how to write Korn shell scripts that access the Oracle database. This Oracle Linux training class will cover most dialects of Linux including HP/UX, AIX, Solaris and Linux.

Book Recommended

  Linux For the Oracle DBA:  The Definitive Reference

Jon Emmons

Rampant TechPress

This Oracle Linux training course is designed for practicing Oracle professionals who have basic experience with Oracle and want to understand how to access and manage Oracle on a Linux environment.  This Oracle Linux training course is useful for Oracle developers, Oracle DBA’s, Linux system administrators, and anyone who must access Oracle IN Linux.

This Oracle Linux training course was designed by Donald K. Burleson, an acknowledged leader in Oracle Linux  database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle Linux Administration Handbook and High-Performance SQL tuning.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle Linux training.

Learning Objectives

By the end of this Oracle Linux training course the student will be able to execute complex Linux commands on a server, and issue commands that retrieve data from Oracle.  The student will also be able to write script to manage Oracle in Linux.



Linux Oracle Administration
Syllabus

© 2007-2016 by Donald K. Burleson

     

DAY ONE – Linux server basics

 

CHAPTER 1 – Introduction to Linux

-          Overview of Linux evolution

-          Introduction to the Linux architecture

Linux shells

Case sensitivity

Building Linux commands

-          Kernel parameters and Oracle

-          Linux monitors

-          top

-          glance

-          sar

- Monitoring Linux with vmstat

 

CHAPTER 2 – Server monitoring Linux

RAM memory in Linux

-          Virtual memory in Linux

Paging

Swapping

Swap disk definition

-          Overview of RAM uses by Oracle

-          Monitoring RAM usage in Linux

-          Adjusting the RAM demands of Oracle

SGA components

Using the MTS

CPU usage and Oracle in Linux

-          The basics of Linux process scheduling

Linux task dispatching

Using the nice command

-          Determining the number of CPUs on your server (from bookLinux)

-          Viewing the Linux run queue in vmstat

A run queue alert report

Semaphores and Linux

 

CHAPTER 3 – Extending STATSPACK for server statistics

- Creating STATSPACK Tables

                       

CHAPTER 4 – Disk I/O monitoring in Linux (bookstat material)

-          Extending STATSPACK for Linux I/O statistics

-          Measuring disk I/O within STATSPACK

-          Using raw devices in Linux

CHAPTER 5 – Linux Network considerations (from bookstat)

-          Linux networking basics

-          Net8 and network traffic

-          Monitoring the network with the Linux netstat utility

 


DAY TWO -  The interaction between Oracle and the Linux server

CHAPTER 6 – Oracle interfaces to the server

-          Oracle background processes

Monitoring DBWR

Monitoring OPQ

-          Dynamic RAM allocation and Linux

 

CHAPTER 7 – Oracle sessions and the Linux server

-          Dedicated connections and Linux

Using the ps command to count sessions

-          Monitoring Linux activity at the session level

Connecting Linux sessions to Oracle sessions

Linux interaction with MTS connections (mts.sql)

 

CHAPTER 8 – Building a server monitor with STATSPACK

-          Monitoring Linux file systems

-          Monitoring trace, log and dump files

-          Monitoring the alert log

-          Scheduling Linux monitoring tasks

 

CHAPTER 9 – Creating server exception reports and alerts

-          Interfacing server reports with STATSPACK extension tables

Scripts for vmstat_alert

-          Reporting on the status of Linux file systems

Details on server monitor script

 


Day Three – Linux Administration for the Oracle DBA

CHAPTER 10 – Linux administration for the Oracle DBA

-          Areas of Linux administration

o       Standard Linux prompt

o       Creating Oracle aliases

o       Changing Linux environment for multiple instances

o       File cleanup

o       Scheduling Linux jobs with crontab

o       Monitoring Linux file systems with scripts

 

-          Setting Oracle file permissions

Linux basics of file permissions

Default file permissions

Sticky bits

-          Creating ancillary Oracle directories with OFA standard

Udump

Bdump

Cdump

-          Using umask in Linux

-          Identifying log and trace file directories from the data dictionary (from script)

-          Monitoring Oracle file systems

Use with autoextend on option

Using the df and du commands

 

CHAPTER 11 – Oracle job scheduling in Linux

-          When to schedule jobs in Linux

-          When to schedule jobs with dbms_job

-          Typical hourly, daily and weekly tasks

-          Interfacing jobs with e-mail and pagers

 

CHAPTER 12 – Advanced Linux administration for Oracle

-          Writing Linux script to access Oracle

-          Linux script to access remote Oracle databases

-          Linux scripts to perform enterprise-wide audits

-          Linux scripts to perform enterprise-wide changes

This is a BC Oracle training course (c) 2002-2016

This Oracle Linux training course is fully customizable. Our expert instructors will work directly with your team to ensure that your receive the Oracle Linux training course that covers the topics most important to your organization.

   

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.