Oracle Database Administration for E-Business Suite

 Click here

Course Overview

This course provides experienced Oracle DBAs, who are new to Oracle E-Business Suite (EBS), with the fundamental differences between core DBA skills and activities and the skills and activities of an Oracle EBS AppsDBA. The course covers Apps Installation, EBS file system architecture, database architecture, E-Business Suite Administration, Database Administration, Oracle Workflow Administration, Oracle Application Server. and so much more. The class will cover patching, cloning and backup methods that are unique to E-Business Suite. We'll also cover some best practices related to EBS Administration that will help you keep the environment running at peak performance.

The step-by-step method of instruction employed makes it possible for students without prior knowledge of the Oracle E-Business Suite to quickly grasp the key topics.

The course consists of a series of lessons, each one consisting of demonstrations and hands-on practice that reinforce the fundamental concepts and encourage students to interact with the E-Business Suite.

Course Goals

• To provide students with a solid understanding of the basic additional skills necessary to install and administer an Oracle E-Business Suite environment.
• To step a little beyond the basics into some valuable tips and tricks that can keep the environment running at peak performance.
• To complete hands-on exercises in an interactive, instructor-led environment.

Prerequisites

• Experience as an Oracle Database Administrator.

Who Should Attend?

• Experienced DBAs, new to the Oracle E-Business Suite

Course Materials

• Student Handbook
• Quick Reference Guide

Duration

• Three (3) days

Course Outline

• Introduction
  • The differences between core DBAs and EBusiness Suite AppsDBAs
  • Overview of the Oracle Technology Stack as implemented within E-Business Suite
  • Overview of key areas to be addressed by the class, identificaiton of areas of knowledge that will be useful, but not covered in this class
• Operating System Environment
  • Identify EBS specific Operating System tasks, commands
• Installations
  • Gain familiarity with Rapidwiz utility for EBS installations
• File Systems
  • Oracle EBS has a very specific file system structure that must be used that is different and foreign to a Oracle DBA (non - apps)
• Database Architecture
  • Oracle EBS database architecture
  • Nomenclature
  • Structure
  • Best Practices
• Oracle E-Business Suite Administration
  • Start/Stop Oracle E-Business Services
  • Install Printers
  • Security
  • Create/Modify Application User Accounts
  • Migrate Custom Applications
  • Concurrent Manager
  • Create Managers
  • Submit/Cancel Requests
  • Load balance managers
  • Maintain Application DB Entities such as responsibilities, menus, forms, functions, system profile options, etc.
  • Schedule system maintenance jobs
  • SR Management - Knowledge of Apps Architecture to help classify request
• Database Administration
  • Use FNDCPASS to change database and user application accounts
  • Monitor and maintain database storage
  • Assign and revoke database privileges
  • Troubleshoot DB ORA errors
  • Troubleshoot performance issues. Rules and guidelines around database objects (indexes, etc.). EBS has a highly integrated, multi-tier stack which has to be diagnosed as a whole, not just at the DB level.
  • "gather statistics", as an example has to be done a certain way.
• Backups
  • Create, test and monitor backup scripts for application and database tiers.
• Patching
  • Analyze and create a patch plan based on patch requirements. Patching is vastly more complex in an EBS environment. Holistic view of the environment.
  • Use Oracle Application AD tools such as ADADMIN, ADPATCH and ADCTRL to apply Oracle E-Business patches.
• Clones
  • Use Oracle Rapid Clone methodology to perform clones, refresh and partial clones from cold backups.
• Oracle BI Discoverer Administration
  • Start/stop Oracle BI Discoverer Services
  • Manage User privileges
  • Create/refresh Business Areas
  • Create/Share Workbooks
• Oracle Workflow (OWF) Administration
  • Configure OWF Notification Mailer
  • Schedule Workflow Background Process
  • Perform Workflow Maintenance Tasks
• Best Practices around Oracle EBS
  • Naming conventions
  • Promotion paths
  • Development guidelines
• Oracle Application Server
  • Single Sign-on
  • Portal
  • Configuration of iModules
  • Networking (iModules in DMZ?)
  • Load Balancing (F5 - Big IP)
  • Context file -
• Preventative Maintenance
  • Concurrent requests - cleanup scripts
  • Purging
• 3rd Party Tools
  • Kintana
  • Version Control Tools (PVCS, Clearcase, etc.)
  • Markview
  • Crystal Reports
  • Hyperion
  • Evergreen
• Other Tips and Tricks
  • Additional Tips and Tricks