ORACLE APPS DBA ONLINE TRAINING

Oracle Applications is an Enterprise Resource Planning Software, which is run by large industries to control their industry-wide operations.This software involves separate segments known as modules for separate business processes.Each module is basically a collection of forms . Read More

Enroll

Reviews

Free Demo

Enroll

Up Coming Demos
Description
Curriculum

Up Coming Demos

Apr

Sat - Sun (5 Weeks)

7:00AM - 7:00AM (IST)

Enroll

Apr

Sat - Sun (5 Weeks)

7:00AM - 7:00AM (IST)

Enroll

Apr

Sat - Sun (5 Weeks)

7:00AM - 7:00AM (IST)

Enroll

Description

ORACLE APPLICATIONS DBA OVERVIEW

Oracle Applications is an Enterprise Resource Planning Software, which is run by large industries to control their industry-wide operations.

This software involves separate segments known as modules for separate business processes.

Each module is basically a collection of forms (with some data displaying reports) where at each stage of the business process, data needs to be entered.

The forms enforce industry best-practices controls on data input and process flow.

An Oracle Applications DBA is very different from a regular Oracle database administrator and requires specialized skills in business administration and Oracle application server architectures.

The Oracle Applications DBA job role is less compartmentalized than a traditional Oracle DBA and the Oracle Applications DBA must also have skills in these areas:

Database Design – Many shops require customized functional extensions and reporting data marts and the Oracle Applications DBA must have outstanding Database design skills.

racle Application Server – The Oracle Applications DBA must understand the internals of the Oracle concurrent manager and understand how to monitor and tune Oracle Applications.

Functional Expertise – Many shops requires a business degree and a general understanding of the Oracle Applications module. For example, accountants are widely used to support Oracle eBusiness Suite (Oracle Financials), and accountants with an IT background are easily trained in Oracle Applications DBA support.

Curriculum

ORACLE APPS DBA COURSE CURRICULUM Download[PDF] 0/17
- Lecture
  Overview of the Architecture
  
  Defining an Oracle server
  
  Database, Instance
  
  Understanding Physical structure
  
  Memory structure, process structure
  
  logical structure, execution of SQL statements
  
  User sessions
  25 hour(s)
- Lecture
  Installing oracle database
  
  System requirements
  
  Pre-install steps – checking certification
  
  software compatibility, hardware
  
  compatibility
  
  creating Unix logins, setting kernel parameter
  
  applying OS level patches
  
  Installing the software ,post install steps
  
  Creating a New Database
  
  Identifying the application
  
  no. of applications the DB will support.
  
  Understanding TS
  
  changing initialization parameters- SGA size
  
  Processes, TS Naming conventions, Block
  
  sizes, Type of DB
  
  No. of Users the DB has to support etc.
  
  Dropping a Database, sysaux, Tablespace
  
  Default tablespace.
  25 hour(s)
- Lecture
  Managing an Oracle Database
  
  Creating and Managing initialization files- PFILE
  
  SPFILE , Adv.Of SPFILE over PFILE
  
  Identifying the various states
  
  options of instance startup/shutdown DB mount
  
  open stages
  
  Monitoring Alert
  
  Trace files in udump, bdump
  
  cdump for DB troubleshooting
  
  Configuring System Global Area (SGA) – DB buffer Cache
  
  Log buffer and shared pool
  
  Understanding Back ground processes-Mandatory
  
  Optional and the jobs performed by them using the data dictionary to retrieve information about the database- Vs DBA_views
  25 hour(s)
- Lecture
  Managing Tablespaces and datafiles
  
  Creating and Altering Tablespaces, adding, resizing, renaming a Datafile, renaming Tablespace
  
  Tablespace- offline, online, read only, read write, temporary Tablespace groups multiple blocks
  
  Creating and managing a Tablespace when using OMF and advantages of OMF feature
  
  Extent Management – Dictionary managed and locally managed Tablespaces AUTOALLOCATE./UNIFORM )and advantages of locally managed over dictionary managed Tablespace
  
  Big file Tablespace, temporary Tablespace group
  25 hour(s)
- Lecture
  Storage Management
  
  Creating, maintaining tables using appropriate storage settings- initial, minextents pctfree etc
  
  Obtaining table information like avg row length, chained rows, etc. after analyzing the tables
  
  Managing, listing diff types of indexes and their uses, creating B-tree and Bitmap indexes, Maintaining indexes, identifying unused indexes, obtaining index information
  25 hour(s)
- Lecture
  Oracle Data Pump
  
  Introduction, Benefits of Data pump export and import
  
  Data pump export and import modes
  
  Transport of Tablespace across different platform’s
  25 hour(s)
- Lecture
  Maintaining the control file, redo log files and archive log files
  
  Importance role, sizing contents, multiplexing and backing up of the control file
  
  Purpose of and how online redo log file work with their associated background processes
  
  Controlling log switches and check points, multiplexing and archiving online redo log files
  25 hour(s)
- Lecture
  Database patching
  
  Applying RDBMS patches using OPatch utility, applying PATCHSET ,analyzing the readme file , applying multiple patches with napply option
  
  Overview of oraInventory – central inventory and local inventory
  
  Removing applied rdbms patches using rollback option
  25 hour(s)
- Lecture
  Networking Overview
  
  Explaining solution included with oracle for managing complex networks
  
  Oracle net Architecture – Explaining the key components Role in client/Server connections
  
  Oracle Net Services Server side configuration. Oracle Net services client-side configuration
  
  Configuring and maintaining distributed DB’s by creating DB links, Materialized views
  
  Usage and configuring of oracle shared server components of the Oracle shared server, configuring shared servers and dispatchers, identifying useful data dictionary view
  25 hour(s)
- Lecture
  Backup and Recovery
  
  Describing the basics of DB backup, Restore and Recovery, Listing the types of Failures that may occur in an oracle environment. Defining Backup and Recovery Strategies
  
  Instance and media Recovery structures- Describing the Oracle Processes, memory structure and files related to recovery, identifying the importance of check points, redo log files and archived log files
  
  User Managed Backups and Recoveries – Backup and recovery operations closed and open DB backups(hot and Cold). Complete Recovery identifying the situations which require incomplete recovery from loss of online redo logs, creating clone DBï¿½s
  
  Oracle Recovery Manager (RMAN) – Features and components, Repository. channel allocation, configuring RMAN environment, complete and incomplete Recovery and Full/Incremental compressed backups, incremental backups with block change tracking RMAN compressed Backups
  25 hour(s)
- Lecture
  Database cloning
  
  Pre-clone steps on the target(dev server)–backup the key config and environment files ,export any schemas if needed
  
  Cloning the database using cold backup and hot backup(partial clone/full clone)
  
  Copying the files to the target , configure the instance on the target, post clone steps
  25 hour(s)
- Lecture
  Database upgrade
  
  Db upgrade from 9i to 10g(10.2.0.3) applying the bug fixers of 10.2.0.3 , running pre-upgrade tool(utlu102i.sql)
  
  Analyzing the obsolete/deprecated parameter ,backing up connect role ,checking for invalid objects if any
  
  Compiling invalid objects and gather sys statistics as post upgrade steps
  25 hour(s)
- Lecture
  Performance Tuning
  
  Overview of Tuning phases , Goals , Methodology and common performance problems
  
  DB conf. and I/O issues file striping, optimizing /tuning sorting operations, Diagnosing partitioning Redo log files configuration, online segment shrinking
  25 hour(s)
- Lecture
  Managing Undo Segments
  
  Understanding Oracle Undo Segments, Retention Policy, retention guarantee
  25 hour(s)
- Lecture
  Enabling Oracle’s parallel query option , multiple DB writers Log writers table caching
  
  Gather statistics of database ,schema ,table ,index
  
  Overview of reorganization of database ,schema
  
  Sizing SGA – Shared pool(reuse stmts, etc) buffer Cache, Redo log Buffers cache
  
  Tuning Rollback /Undo segments – Usage , configuration, detecting and resolving problem
  25 hour(s)

Contact Us

ORACLE APPS DBA ONLINE TRAINING

ORACLE APPLICATIONS DBA OVERVIEW

Curriculum

ORACLE APPS DBA COURSE CURRICULUM Download[PDF] 0/17

Diagnostic and Tuning Tools – Alert Log files, Tkprof, Explain plan, Dynamic performance viewview, STATASTICS_LEVEL parameter to collect statistics AWR, ADDM