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 UNIX Oracle scripts?  Just click here!

UNIX Oracle Administration
Training Course

A 3-day intensive UNIX 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

 

 

Key Features

* Understand the OFA standard for all Oracle UNIX systems.

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

* Learn important UNIX commands for Oracle administration.

* See how to create server-side alerts.

* Avoid unnecessary downtime by monitoring UNIX files.

* See how to monitor UNIX server stress.

  

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

Book Recommended

  Oracle 9i UNIX Administration Handbook

Donald K Burleson

Oracle Press

ISBN: 0072223049

This 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 UNIX environment.  This course is useful for Oracle developers, Oracle DBA’s, UNIX system administrators, and anyone who must access Oracle IN UNIX.

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle UNIX  database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle UNIX 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 UNIX training.

Learning Objectives

By the end of this course the student will be able to execute complex UNIX 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 UNIX.



UNIX Oracle Administration
Syllabus

© 2007-2016 by Donald K. Burleson

     

DAY ONE – UNIX server basics

 

CHAPTER 1 – Introduction to UNIX

-          Overview of UNIX evolution

-          Introduction to the UNIX architecture

UNIX shells

Case sensitivity

Building UNIX commands

-          Kernel parameters and Oracle

-          UNIX monitors

-          top

-          glance

-          sar

- Monitoring UNIX with vmstat

 

CHAPTER 2 – Server monitoring UNIX

RAM memory in UNIX

-          Virtual memory in UNIX

Paging

Swapping

Swap disk definition

-          Overview of RAM uses by Oracle

-          Monitoring RAM usage in UNIX

-          Adjusting the RAM demands of Oracle

SGA components

Using the MTS

CPU usage and Oracle in UNIX

-          The basics of UNIX process scheduling

UNIX task dispatching

Using the nice command

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

-          Viewing the UNIX run queue in vmstat

A run queue alert report

Semaphores and UNIX

 

CHAPTER 3 – Extending STATSPACK for server statistics

- Creating STATSPACK Tables

                       

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

-          Extending STATSPACK for UNIX I/O statistics

-          Measuring disk I/O within STATSPACK

-          Using raw devices in UNIX

CHAPTER 5 – UNIX Network considerations (from bookstat)

-          UNIX networking basics

-          Net8 and network traffic

-          Monitoring the network with the UNIX netstat utility

 


DAY TWO -  The interaction between Oracle and the UNIX server

CHAPTER 6 – Oracle interfaces to the server

-          Oracle background processes

Monitoring DBWR

Monitoring OPQ

-          Dynamic RAM allocation and UNIX

 

CHAPTER 7 – Oracle sessions and the UNIX server

-          Dedicated connections and UNIX

Using the ps command to count sessions

-          Monitoring UNIX activity at the session level

Connecting UNIX sessions to Oracle sessions

UNIX interaction with MTS connections (mts.sql)

 

CHAPTER 8 – Building a server monitor with STATSPACK

-          Monitoring UNIX file systems

-          Monitoring trace, log and dump files

-          Monitoring the alert log

-          Scheduling UNIX 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 UNIX file systems

Details on server monitor script

 


Day Three – UNIX Administration for the Oracle DBA

CHAPTER 10 – UNIX administration for the Oracle DBA

-          Areas of UNIX administration

o       Standard UNIX prompt

o       Creating Oracle aliases

o       Changing UNIX environment for multiple instances

o       File cleanup

o       Scheduling UNIX jobs with crontab

o       Monitoring UNIX file systems with scripts

 

-          Setting Oracle file permissions

UNIX basics of file permissions

Default file permissions

Sticky bits

-          Creating ancillary Oracle directories with OFA standard

Udump

Bdump

Cdump

-          Using umask in UNIX

-          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 UNIX

-          When to schedule jobs in UNIX

-          When to schedule jobs with dbms_job

-          Typical hourly, daily and weekly tasks

-          Interfacing jobs with e-mail and pagers

 

CHAPTER 12 – Advanced UNIX administration for Oracle

-          Writing UNIX script to access Oracle

-          UNIX script to access remote Oracle databases

-          UNIX scripts to perform enterprise-wide audits

-          UNIX scripts to perform enterprise-wide changes

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

   

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.