Syllabus
© 2007-2009 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-2009
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.
