|
Need
Linux Oracle scripts? Just click here!
Linux Oracle Administration
A 3-day intensive Linux Oracle
Overview
© 2007-2016 by Burleson Corporation
* 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.
 |
|
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.
|
