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