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

* 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.   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