Home
Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions
DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers
Applications
Series
E-Business Suite
Fusion Middleware Series
Oracle Application Server
Oracle Identity Management
Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi
Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
E-Business
Suite 11i & Release 12
|
|
|
Why take this class?
- Learn to install,
configure, and deploy EBS
- Learn EBS 11i and
Release 12 architecture
- Learn how to patch EBS
11i and Release 12
- Learn how to clone EBS
11i and Release 12
|
|
|
The PSOUG's E-Business Suite class is nothing like anyone else's. It is a combination
of lecture and hands-on labs with the emphasis on hands on. No virtual environments here. Every students team get their
own server and everything is real. You'll spend your time in vi and SQL*Plus as well as in a GUI.
If you are looking for a reasonably priced two week boot camp that can take an Oracle DBA and turn them into an
Apps DBA with experience with both 11i and Release 12 this is it.
multiple servers, create tuning sets, and work with the most significant features. The syllabus, below, shows the
topics covered as well as the fact that this class is hands-on: Not slow death by PowerPoint.
$4,995/student
including membership for in PSOUG and OAUG or, for
existing OAUG members, a one year renewal.
|
|
Day 1
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you
complete registration |
| 9:00-12:00am |
Discussion |
Oracle
Concepts and Architecture
The Oracle database is not just SQL Server or DB2
sold by a different company. The underlying
concepts and architecture are substantially
different. This session will cover these concepts
with live demos of multiversion read consistency,
how transactions and locking work including the
details of the Undo tablespace and log files, as
well as teach basic data dictionary object
concepts related to DBA_, ALL_, USER_, and V$
views.
|
| 12:00-1:00pm |
Lunch |
1 day of regular Oracle arch
2-6 days of existing curriculum
7 day of backing it all up (db and FMW and apps)
8 Maximum Avail - RAC, ASM, Data Guard, Streams, Flashback
9 Audit Vault, Grid Control, Governance/Compliance FGA TDE
10 Metalink, RDA, DB Patching
miderm - final |
| 1:00-2:30pm |
Discussion&
Lab |
Installation
Fest
Students will perform a hands-on installation of
Oracle Unbreakable Linux, kernel configuration,
and installation of Oracle 10gR2. |
| 2:30-3:30pm |
Discussion |
Metalink
Metalink is where DBAs obtain critical information
about managing their Oracle database, download
patches, obtain support, report bugs. This instructor led
session will take students into metalink and teach
them what is there and how to find it. |
| 3:30-4:30pm |
Lab
1 |
Patching
Lab
Students will research required patches for their
installed 10.2.0.1 database and then patch them to
10.2.0.3. They will also locate the most current
version of Oracle's RDA (Remote Diagnostic Agent)
tool, deploy it, create RDAs, and review what they
contain. |
| 4:30-4:45pm |
Discussion |
Review
The day's work will be reviewed and students will
receive a homework assignment to prepare them for
Day 2. |
|
|
Day 2
|
| 9:00-12:00am |
Discussion |
What
are Oracle Applications - Pt 1
Oracle Applications E-business Suite Current,
Future & Confusion
Logical and functional components |
| 1:00-2:30pm |
Discussion |
What
are Oracle Applications - Pt 2
Physical components - Forms Server, Concurrent
Manager |
| 2:30-3:00pm |
Discussion |
Architecture
Review
Preparation for the lab- we will review all the components
and how Applications deploys out of the box |
| 3:00-4:30pm |
Lab
1 |
Architecture
Lab
Walk through an existing Vision Database and
11.5.10 deployment
We will begin the
installation of Oracle Applications and then go
home as it installs overnight
|
| 4:00-4:30pm |
Discussion |
Recap
and Homework Assignment
Answer questions and Preview
Installation |
|
|
Day
3 |
| 9:00-9:30am |
Review |
Homework
and Architecture Review
We will review the components of Oracle
Applications and how Applications work with the
Oracle Database- confirm 11i Installation |
| 9:30-10:30am |
Discussion |
Applications
File System
A walk through the physical implementation and
mapping of environment variables such as APPL_TOP,
COMM_TOP, DATA_TOP, etc. |
| 10:30-11:00am |
Lab |
11i
Installation
We will login and create users and explore the
console for managing Applications |
| 11:00-12:00am |
Discussion |
11i
Installation Tree Creation - Pt 1
A walk through the physical implementation and
mapping of environment variables such as APPL_TOP,
COMM_TOP, DATA_TOP, etc. |
| 1:00-2:00pm |
Discussion |
11i
Installation Tree Creation - Pt 2
A walk through the physical implementation and
mapping of environment variables such as APPL_TOP,
COMM_TOP, DATA_TOP, etc. |
| 2:00-2:30pm |
Lab |
Installation
Verification
Start and stop Release 11 components |
| 2:30-3:00pm |
Discussion |
11i
and Auto Configuration
How to make modifications to environment variables
to - Alter config. |
| 3:00-4:00pm |
Discussion
6 |
Tablespace
Migration
What is Tablespace Migration and what benefits
do you gain from doing Tablespace Migration |
| 4:00-4:30pm |
Discussion |
Recap
and Homework Assignment
Review of File System and the *_top environments |
|
|
Day
4 |
| 9:00-9:30am |
Review |
Homework
and Architecture Review
Architecture review - making sure that students
can articulate components |
| 9:30-10:00am |
Lab |
Metalink
Discussion & Lab
This lab will review previous discussion and look
at patching the 11i installation- practice
researching issues |
| 10:00-11:00am |
Discussion |
Patching
Discussion
Why do we patch, how often do we patch the
applications, what process should we follow - how
much testing ? |
| 11:00-12:00am |
Lab |
Patching
Lab
Confirm patches on Metalink, discuss the outcome,
mount the NetApp, apply patches |
| 1:00-1:30pm |
Lab |
Patch
Validation
How do you validate patches, who should be
involved, and confirm previous patches were successful. |
| 1:30-2:30pm |
Discussion |
Manual
Cloning of 11i
What is cloning, how do you clone Applications,
Manual vs Automatic Cloning. |
| 2:30-3:00pm |
Lab |
Cloning
Clone 11i manually, change the environmental
variables, confirm the new clone |
| 3:00-4:00pm |
Discussion |
Upgrade
11i to Release 12
Why do you want to upgrade to Release 12? What are
the implications of upgrading to Release 12.
What is the pathway to Upgrade to Release 12 |
| 4:00-4:15pm |
Lab |
Upgrade
11i to Release 12
Perform upgrade ( which is a patch) - |
| 4:15-4:30pm |
Lab |
Apply
5 hour patch
This patch is run after the upgrade and will
run overnight |
|
|
Day 5 |
| 9:00-9:30am |
Lab |
Upgrade
Review and Verification
Start and stop Release 12 components |
| 9:30-10:00am |
Discussion |
AdPatch
Utility Discussion
Instructor goes to metalink and shows how it works |
| 10:00-10:30am |
Lab |
AdPatch
Lab
Use of AdPatch Utility to determine if any
additional patches are required and confirm all components
are working |
| 13:00-11:30am |
Discussion |
Release
12 Cloning Discussion
What are the issues
around cloning and review the utility of
RapidClone
|
| 11:30-12:30pm |
Lunch |
|
| 12:30-1:30pm |
Lab |
Auto
Clone
Use Rapid Clone to clone R12 and determine clone succeeded |
| 2:00-3:30pm |
Midterm |
MidTerm
we will review the installation,
configuration, patching and cloning options with
Oracle Applications |
| 3:30-4:30pm |
Midterm |
Complete
the Midterm |
| 4:00-4:30pm |
Discussion |
Review
Midterm
Review Midterm and go home |
|
|
Day
6 |
| 9:00-9:30am |
Discussion |
Review
Midterm
Review any questions from previous day |
| 9:30-12:00am |
Discussion
Pt 1 |
Maximum
Availability Architecture
RAC, Data Guard, Replication, ASM, Grid Control,
and Flashback |
| 1:00-3:00pm |
Discussion
Pt 2 |
Maximum
Availability Architecture
RAC, Data Guard, Replication, ASM, Grid Control,
and Flashback |
| 2:30-3:30pm |
Demo
& Lab |
Grid
Control Demo Lab
A |
| 3:30-4:30pm |
Lab |
Flashback
Lab
A |
|
|
Day
7 |
| 9:00-9:30am |
Discussion |
Governance,
Security, Auditing, Compliance
Audit Vault, SarbOx, HIPAA, Gramm-Leach, PCI, etc.
etc. etc. |
| 9:30-12:00am |
Discussion |
M
R |
| 1:00-2:00pm |
Discussion
3 |
Audit
Vault
Why is Audit Vault an important consideration in
your compliance strategy? What are the
considerations are there for Audit Vault |
| 2:00-4:00pm |
Lab |
Collection
Agent Installation & Patching
Install the Agent, Patch the Agent and set up Fine
Grain Auditing- confirm |
| 4:00-4:30pm |
Go
Home |
Review
Governance,
Compliance and what we need to know to be successful
|
|
|
Day
8 |
| 9:00-9:30am |
Discussion |
Review
Disaster Avoidance
|
| 9:30-12:00am |
Discussion |
What
is Disaster Avoidance
What are the differences between Business Continuity,
Disaster Planning and why do we care.
Flashback, RMAN |
| 10:00-11:00am |
Lab |
RMAN
PT 1
Backup and Recover your Application |
| 1:00-1:30pm |
Lab |
RMAN
PT2
Confirm recovery of your Application |
| 1:30-3:00pm |
Discussion |
Flashback
A |
|
|
Day
9 |
| 9:00-9:30am |
Lab |
R
A |
| 9:30-12:00am |
Discussion |
M
R |
| 1:00-1:30pm |
Discussion
3 |
G
A |
|
|
Day
10 |
| 9:00-9:30am |
Lab |
R
A |
| 9:30-12:00am |
Discussion |
M
R |
| 1:00-1:30pm |
Discussion
3 |
G
A |
|
|
Instructors |
Victoria Whitlock has more than 23 years experience in the
Information Technology industry. She specializes in Database Architecture, Administration, Data Warehousing, Training,
and Mentoring. Formerly one of Oracle Corporation's top Education trainers, Victoria excels in teaching and working
with diverse groups to master complex procedure-based processes by applying leading edge technologies. Victoria
managed a variety of successful international data warehousing projects and speaks regularly at industry forums such
as Oracle OpenWorld: Most recently in 2007. She is currently Enpria's Compliance Practice Manager, responsible for
both the conceptual integrity of Enpria's IP and quality of deliverables.
Victoria has built a strong sub-specialty in the world of government mandated compliance. Her understanding of the
technical systems which must ultimately be crafted, either by design or modification, to deliver compliant
performance and her understanding of automated business processes grant her a very rare perspective.
Victoria is a frequent contributor to both PCAOB and SEC data calls. Her work is posted on their websites and is
recognized for its thoughtful, thorough, and unbiased point of view.
Victoria also is currently serving on the AEA National Governance committee.
|
|
Dan Morgan is an Oracle Ace Director, a 10g and 11g Beta tester
for Oracle, and the instructor of the Oracle program at the University of Washington since its inception in 1999.
He began his IT career in 1969 with an IBM 370/145, punch cards, and Fortran IV, and though he will vigorously deny
it, wrote COBOL for a decade before moving into Oracle about when version 6 hit the market.
In addition to Dan's work at the university he is the Education Chair of the Puget Sound Oracle Users Group, a
member of UKOUG, and a member of the British-American Chamber of Commerce in Seattle. He is also a frequent
lecturer at training events and at conferences and has presented at Oracle OpenWorld on RAC (2005), at Seattle
OracleDay (2004-2007), at numerous government and corporate training events including Apple Computer,
Argonne National Laboratory, Boeing Commercial Airplane Group, Dow Jones & Company, Lawrence Livermore
National Laboratory, NASA, T-Mobile, US Navy at Pearl Harbor, and Weyerhaeuser to name but a few and presented
on Streams and Change Data Capture at UKOUG in 2006.
Dan Morgan is the Morgan behind the "Morgan's Library" website that contains the many demos he has
created for his University of Washington classes as well as for his frequent lectures. He is the former publisher
of MacTech Journal, has presented Oracle technical lectures in the US, Canada, Great Britain, and Japan.
Morgan is also the author of this course.
|
|
