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 11.5.10 & Release 12
|
|
|
Why take this class?
- Hands on installion,
configuration, and deployment of E-Business Suite
- Learn E-Business Suite 11i and
Release 12 architecture
- Hands on patching of
E-Business Suite 11i and Release 12
- Hands on cloning of
E-Business Suite 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 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 one week class
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. $2,500/student including membership for
non-OAUG members. Discounts available to OAUG members.
|
|
|
|
Day 1
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you
complete registration |
| 9:00-10:00am |
Discussion |
Oracle Applications
Background
Oracle Applications E-business Suite Current,
Future & Confusion
Logical, physical and functional components |
| 10:00-11:00am |
Lab
1 |
Operating
System Configuration
E-Business Suite specific configuration of Oracle
Enterprise Linux |
| 11:00-12:00pm |
Lab2 |
Release
11 Installation
Hands-on installation of E-Business Suite 11.5.10 |
| 12:00-1:00pm |
Lunch |
|
| 2:00-3:00pm |
Lab
3 |
Physical
Walk-Through
Walk through of the structure of the installed
Vision Database and Applications layer |
| 3:00-4:30pm |
Lab
4 |
Release
11Patching Lab - Part 1
This hands-on lab begins the process of
patching the R11 installation |
|
|
Day 2 |
| 9:00-11:00am |
Lab
5 |
Release
11Patching Lab - Part 2
This hands-on lab begins the process of
patching the R11 installation |
| 11:00-12:00am |
Lab
6 |
Starting
and Stopping Components
This hands-on lab covers starting and stopping
application and database components. |
|
|
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
Make sure the installation was successful
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
T |
| 4:00-4:30pm |
Discussion |
Recap
and Homework Assignment
T |
|
|
Day 3 |
| 9:00-9:30am |
Review |
Homework
and Architecture Review
A |
| 9:30-10:00am |
Lab |
Metalink
Discussion & Lab
T |
| 10:00-11:00am |
Discussion |
Patching
Discussion
O |
| 11:00-12:00am |
Lab |
Patching
Lab
Go to metalink look around, discuss the outcome,
mount the NetApp, apply patches |
| 1:00-1:30pm |
Lab |
Patch
Validation
T |
| 1:30-2:30pm |
Discussion |
Manual
Cloning of 11i
A |
| 2:30-3:00pm |
Lab |
Cloning
D |
| 3:00-4:00pm |
Discussion |
Upgrade
11i to Release 12
D |
| 4:00-4:15pm |
Lab |
Apply
first upgrade patch
T |
| 4:15-4:30pm |
Lab |
Apply
5 hour patch
T |
|
|
Day
4 |
| 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
T |
| 10:30-11:30am |
Discussion |
Release
12 Cloning Discussion
T |
| 12:30-1:00pm |
Discussion |
Validate
Add Patch
T |
| 1:00-1:30pm |
Lab |
Auto-Clone
and RapidClone Lab
A |
| 1:30-4:00pm |
Discussion |
Disaster
Avoidance
A |
| 4:00-4:30pm |
Discussion |
Recap
and Homework Assignment
T |
|
|
Day
5 |
| 9:00-9:30am |
Lab |
Review
and Clone Verification
A |
| 9:30-12:00am |
Discussion |
Maximum
Availability Architecture
RAC, Data Guard, Replication, ASM, Grid |
| 10:00-11:00am |
Lab |
Grid
Agent Installation and Review with OEM Grid
Control
T |
| 1:00-1:30pm |
Discussion
3 |
Governance,
Security, Auditing, Compliance
Audit Vault, SarbOx, HIPAA, Gramm-Leach, PCI, etc.
etc. etc. |
| 1:30-3:00pm |
Lab |
Audit
Vault installation and report creation
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.
|
|
