Oracle APPS DBA Online Training at Xcelresources.com

1
ORACLE APPS DBA Online Training and Placements in
US
www.xcelresources.com
2
ORACLE APPS DBA Online Training

• Oracle Apps DBA Online Course Content
• Introduction
• Identify the oracle product
• Describe the basic concept of a relational
  database
• Installing oracle database 10g software
• System requirements
• Use Oracle Optimal Flexible Architecture (OFA) 
• Install software with the Oracle Universal
  Installer
• Create an oracle database
• Oracle Database Architecture
• Oracle instance architecture
• Use the Database Creation Assistant

www.xcelresources.com
3
ORACLE APPS DBA Online Training

• Controlling the database
• Manually configure the Oracle 10g EM dbconsole
• Start and stop the agent 
• Start and stop the enterprise manager database
  console 
• Start and stop the listener 
• Startup and shutdown the database
• Storage Structures 
• Defining the tablespaces and data files
• Create tablespaces
• Manage tablespaces
• Obtain tablespace information
• Create and manage tablespace using oracle
  enterprises manager

www.xcelresources.com
4
ORACLE APPS DBA Online Training

• Administering users
• Create and manage database user accounts 
• Create and manage roles 
• Grant and revoke privileges 
• Oracle Database Security  ---  Only Theory
• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features
• Oracle Net Services
• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure
  listeners
• Use the Oracle Net Manager to configure client
  and middle-tier connection
• Use TNSPING to test Oracle Net connectivity

www.xcelresources.com
5
ORACLE APPS DBA Online Training

• Performance Monitoring
• Gather optimizer statistics
• View performance metrics
• Monitoring and Managing Memory
• Oracle Memory Structures
• Automatic PGA Memory Management
• Using the Memory Advisor
• Using Automatic Shared Memory Management to avoid
  long running query issues
• Monitoring and Resolving Lock Conflicts
• Detect and resolve lock conflicts
• Manage deadlocks
• Diagnostic Sources
• The Alert Log
• Viewing Alerts with EM
• Alerts Notification   ----- Only Theory
• Editing Thresholds ----- Only Theory
• Trace Files

www.xcelresources.com
6
ORACLE APPS DBA Online Training

• Proactive Maintenance Objectives   ---  Only
  Theory
• Set warning and critical alert thresholds
• Collect and use baseline metrics
• Use tuning and diagnostic advisors
• Use the Automatic Database Diagnostic Monitor
  (ADDM)
• Automatic Storage Management  ---- Only Theory
• ASM Concepts
• ASM General Architecture
• Creating an ASM instance
• Creating tablespaces that use ASM storage
• Viewing ASM information
• Migrating a tablespace to use ASM storage.

www.xcelresources.com
7
ORACLE APPS DBA Online Training

• Undo Management  ---  Only Theory
• Monitor and administer undo
• Configure undo retention
• Guarantee undo retention
• Use the undo advisor
• Backup and Recovery    ---  Only Theory
• Describe the basics of database backup, restore
  and recovery
• List the types of failure that may occur in an
  Oracle Database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log
  files, and archived log file

www.xcelresources.com
8
ORACLE APPS DBA Online Training

• Managing Data
• Manipulating data through SQL
• Using Import
• Using Export
• Database backups
• Configure ARCHIVELOG mode
• Create consistent database backups
• Back your database up without shutting it down
• Create incremental backups
• Automate database backups
• Monitor the flash recovery area

www.xcelresources.com
9
ORACLE APPS DBA Online Training

• Managing schema objects
• Create and modify tables
• Define constraints
• View the attributes of a table
• View the contents of a table
• Create indexes and views
• Database Recovery
• Recover from loss of a control file
• Recover from loss of a redo log file
• Recover from loss of a data file

www.xcelresources.com
10
Contact-us

• Xcel Resources Inc.
• 777 S. Post Oak Lane
• One Riverway
• Suite 1700
• Houston
• TEXAS, 77056
• United States of America
• Visit http//www.xcelresources.com/
• E-mail  training_at_xcelresources.com

www.xcelresources.com