Linux Oracle Administration

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.

Audience

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.

 

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