 |
Oracle Applications DBA (10g) |
|
Software Version |
R12 and 11i - 10g |
Course Duration |
5 days or 40 Hours Approx. |
Course Type |
Class Room and On-Line (E-Learning) Instructor-Led Hands-On Training |
|
Course Overview |
This course provides basic understanding of the architecture, database and file system used in Oracle Applications Release 11i and R12. The course also covers Oracle Applications 11i and R12 overview, EBS architecture, installation and managing databases, management of user, performance turning, advanced PL/SQL concepts, managing schemas, backup and recovery, rapid install overview, instance management, and all advanced features of Oracle database 10g. |
Intended Audience for this course |
This course is designed for those who have technical background, knowledge with any computer language, Java, J2EE, XML, .NET Developers, ERP Developers, DBAs, Data Warehouse Developers, IT management and Staff, Business Analysts, Technical Consultants, Students and also those who want to become Oracle Applications Data Base Administrators. |
|
Course Topics |
Introduction to Oracle Applications |
|
- Overview of Oracle E-Business Suite
- Architecture
- Components
- Roles and Responsibilities of Applications DBA
- Oracle Application Implementation Methodology (AIM)
|
Introduction to DBA |
- Relational Database Systems
- Integrity Constraints
- Tasks and Responsibilities of DBA
- Installation
- Operating System Configuration
- Patching
|
Installation |
- Oracle Universal Installer
- Prerequisite Checks
- Installation
- Configuration
- Single-node Installation
- Multi-node Installation
|
Creating Database |
- Database Architecture
- Control and Redo Log Files
- Oracle Instance Management
- Data Dictionary and Control, Grid Control
- Configuration Assistant Overview
- Creating Database
- Passwords and Storage
- File Locations and Backup Recovery
|
Managing Database and Schemas |
- Starting and Stopping database control
- Accessing Database Control
- Viewing Alert Log
- Introduction to Schemas
- Schema Objects
- Data Types
- Defining Constraints
- Creating views and indexes
- Sequences
|
Managing Users |
- User Accounts
- Users and Profiles
- Privileges
- Roles
- Database Users and Schemas
|
Backup and Recovery |
- Backup and Recovery issues
- Instance Recovery
- Configuring Backup Strategy
- Scheduling and Managing Backups
- Instance Status
- Control and Redo Log files
- Oracle Recovery Manager overview
- Catalog Maintenance>
|
PL/SQL |
- Overview
- Components and Syntax
- Cursors
- Stored Procedures, Functions and Packages
- Built-in Packages and Functions
- Control Structures
- Database Triggers
- Tips and Techniques
|
Performance Monitoring and Utilities |
- Monitoring Methodologies
- Data Dictionary Metrics
- Optimizer Statistics
- Dynamic Performance Views
- AD Utilities and Administration
- Special Utilities
- AutoConfig Overview
- License Manager
- Reporting Utilities
- Configuration Utilities
|
Advanced Features |
- Cloning Oracle Applications
- RAID Partitioning
- Thresholds
- Tuning and Diagnostic Advisors
- Patch Wizard and AutoPatch
- OAM Timing Reports
- OAM Applied Patches
|
|