Oracle Apps DBA

Oracle Apps DBA

Sample Description
Sample Description

R12 Oracle Applications Install

  • Oracle Applications Overview
  • Preparing for Your Installation
  • Single-node Installation
  • Multi-node Installation
  • Finishing Your Installation

R12 Oracle E-Business Suite Architecture

  • Oracle Applications Technology
  • Oracle Applications Environment Files, Server Process Scripts, and Languages
  • Oracle Applications File System
  • Oracle Applications Database

R12 Use Oracle Applications AD Utilities

  • What are the AD Utilities?
  • AD Administration
  • Special Utilities
  • Context Editor
  • AutoConfig
  • License Manager
  • Reporting Utilities
  • Configuration Utilities

R12 Patch and Maintain Oracle Applications

  • What are the AD Utilities?
  • AD Administration
  • Special Utilities
  • Context Editor
  • AutoConfig
  • License Manager
  • Reporting Utilities
  • Configuration Utilities

R12 Patch and Maintain Oracle Applications

  • Patching and the Auto Patch Process
  • Patch Advisor
  • Running AutoPatch
  • Other Patching Topics
  • Patch History Database

Oracle Applications Advanced Topics

  • Cloning Oracle Applications
  • Advanced Cloning Options
  • Other Advanced Topics

R12 System Administrator Fundamentals

  • Managing Application Security
  • Managing Concurrent Programs and Reports
  • Administering Concurrent Managers
  • Managing Profile Options
  • Incorporating a Custom Program
  • Auditing System Resources
  • Managing Printers
  • System Management using Oracle Application Manager (OAM)
  • Applications DBA Duties
  • Introduction to Oracle Workflow
  • Overview of Oracle Alert




This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms. DB2 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few. The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.

  • List and describe the major components of IBM's relational database, DB2
  • Explain the characteristics of a DB2 table
  • Relate the basic concepts of data modeling
  • Comprehend the processing instructions given to DB2 via simple SQL statements
  • List and describe steps needed to imbed SQL statements in an application program
  • Explain some of the functions performed by, and the responsibilities of, database and system administrators
  • Establish a base for more specialized DB2 education
  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support


Curriculum based on Real time DBA activity

  • DB2 Introduction
  • DB2 Database Architecture
  • DB2 installation
  • Database creation – Lab Work

Creation and Identification of DB2 database objects – Lab Work

  • Table
  • Index
  • View
  • Tablespace
  • Buffer pool Concept

  • Create
  • Alter
  • Drop

Database diagnostics and administrator notification Log

Overview of Database Transaction – Lab Work

  • Select
  • Insert
  • Update
  • Delete

Important Database Parameters

STMM Concept

Tablespace State

Automatic Storage Concept

Database Granularity and Locking

Brief Overview of SQL

Database Utilities– Lab Work

  • Import
  • Export
  • Load

Database Tools– Lab Work

  • Db2pd
  • Db2look
  • Db2tops

Introduction to Database security – Lab Work

  • DB2 authorizations and privileges
  • security administrator role
  • Audit facility
  • trusted context
  • row column access control (RCAC)
  • LBAC

Introduction to database Logging

  • Circular Logging
  • Archival Logging
  • Infinite Logging
  • Overview of Database logs

    • Active Log
    • Archive Log

    Introduction to database Backup – Lab Work

    • Offline Backup
    • Online Full Backup
    • Incremental Backup
    • Delta Backup

    Database Recovery – Lab Work

    • Database restoration
    • Roll forward recovery
    • Crash Recovery

    Overview of REORG – Lab Work

    • Offline Reorg
    • Online Table Reorg
    • Online Index Reorg
    • Online Table movement

    Overview of RUNSTATS – Lab Work

    HADR Replication:

    • HADR Concept
    • HADR State and Stages
    • HADR building

    Database Fix-pack Update – Lab Work

    • Process and Concept

    Database Migration – Lab Work

    • Process and Concept

    Database Mirroring Concept

    Database Ingest Utility

    MDC and ITC table concept

    Database Compression concept

    • Row Compression
    • Deep Compression
    • Adaptive Compression

    Database Performance Tuning

    • DB2ADVIS
    • INSERT TIME tuning
    • Backup Time tuning