MODULE I Oracle 11i Applications DBA Fundamentals I Oracle Architectural Components [ ] Describe the Oracle architecture and its main components [ ] List (describe) the structures involved in connecting a user to an Oracle instance Getting Started With the Oracle Server [ ] Identify common database administrative tools available to a DBA Managing an Oracle Instance [ ] Create and manage initialization parameter files [ ] Start up and shut down an instance [ ] Monitor the use of diagnostic files Creating a Database [ ] Describe the prerequisites necessary for database creation [ ] Create a database manually Data Dictionary Content and Usage [ ] Identify key data dictionary components [ ] Identify the contents and uses of the data dictionary [ ] Query the data dictionary Maintaining the Control File [ ] Explain the uses of the control file [ ] Mulitplex and manage the control file [ ] Obtain control file information Maintaining Redo Log Files [ ] Explain the purpose of online redo log files [ ] Describe the structure of online redo log files [ ] Control log switches and checkpoints [ ] Mulitplex and maintain online redo log files Managing Tablespaces and Data files [ ] Describe the logical structure of tablespaces within the database [ ] Create tablespaces [ ] Allocate space for temporary segments [ ] Change the status of tablespaces [ ] Change the storage settings of tablespaces Storage Structure and Relationships [ ] List the segment types and their uses [ ] List the keywords that control block space usage [ ] Obtain information about storage structures from the data dictionary
Managing Undo Data [ ] Describe the purpose of undo data [ ] Implement Automatic Undo Management Managing Tables [ ] Identify the various methods of storing data [ ] Create regular and temporary tables [ ] Reorganize, truncate, drop a table [ ] Drop a column within a table Managing Indexes [ ] List the different types of indexes and their uses [ ] Reorganize indexes [ ] Monitor the usage of an index Maintaining Data Integrity [ ] Describe the Types of Data Integrity Constraints Managing Users [ ] Create new database users [ ] Alter and drop existing database users [ ] Monitor information about existing users Managing Privileges [ ] Identify system and object privileges [ ] Grant and revoke privileges Using Globalization Support [ ] Choose database character set and national character set for a database [ ] Specify the language-dependent behavior using initialization parameters, environment variables and the ALTER SESSION command Basic Oracle Net Architecture [ ] Explain the key components of the Oracle Net layered architecture [ ] Explain Oracle Net Services role in client server connections [ ] Describe how web client connections are established through Oracle networking products Basic Net Server-Side Configuration [ ] Identify how the listener responds to incoming connections [ ] Configure the listener using Oracle Net Manager [ ] Control the listener using the Listener Control Utility (lsnrctl) [ ] Describe Dynamic Service Registration
Basic Oracle Net Services Client-Side Configuration [ ] Describe the difference between host naming and local service name resolution [ ] Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names [ ] Perform simple connection troubleshooting
MODULE II Oracle 11i Applications DBA Fundamentals II Overview of Tuning [ ] Describe the dependency between tuning in different development phases [ ] Describe appropriate tuning goals [ ] Describe the most common tuning problems Diagnostic and Tuning Tools [ ] Describe how the alert.log file is used [ ] Describe the statistics kept in the dynamic performance views [ ] Collect statistics using StatsPack [ ] Use other tuning tools Database Configuration and I/O Issues [ ] Diagnose tablespace usage problems [ ] Describe how checkpoints work [ ] Monitor and tune checkpoints [ ] Monitor and tune redo logs Tuning the Shared Pool [ ] Measure and tune the library cache hit ratio [ ] Measure and tune the dictionary cache hit ratio [ ] Size and pin objects in the shared pool [ ] Tune the shared pool reserved space [ ] Describe the user global area (UGA) and session memory considerations [ ] Explain other tuning issues related to the shared pool Tuning the Buffer Cache [ ] Describe how the buffer cache is used by different Oracle processes [ ] Describe the tuning issues related to the buffer cache [ ] Monitor the use of buffer cache, and the different pools within buffer cache [ ] Implement dynamic SGA allocation [ ] Set the DB_CACHE_ADVICE parameter [ ] Create and size multiple buffer pools [ ] Detect and resolve free list contention Sizing Other SGA Structures [ ] Monitor and size the redo log buffer
[ ] Monitor and size the java pool Optimizing Sort Operations [ ] Identify the SQL operations which require sorts [ ] Create and monitor temporary tablespaces [ ] Reduce total sorts and disk sorts SQL Statement Tuning [ ] Describe how the Optimizer is used [ ] Use stored outlines [ ] Use SQL Trace and TKPROF [ ] Collect statistics on indexes and tables [ ] Copy statistics between databases Using Oracle Blocks Efficiently [ ] Describe the correct usage of extents and Oracle blocks [ ] Explain space usage and the high-water mark [ ] Recover space from sparsely populated segments [ ] Describe and detect chaining and migration of Oracle blocks [ ] Perform index reorganization [ ] Monitor indexes to determine usage Application Tuning [ ] Explain the different types of indexes [ ] Describe materialized views and the use of query rewrites Resolving Locking Issues [ ] Define levels of locking [ ] List possible causes of contention [ ] Use Oracle utilities to detect lock contention [ ] Resolve contention in an emergency [ ] Prevent locking problems Backup and Recovery Overview [ ] Describe the basics of database backup, restore and recovery [ ] List the types of failure that may occur in an Oracle environment [ ] Define a backup and recovery strategy Instance and Media Recovery Structures [ ] Identify the importance of checkpoints, redo log files, and archived log files Configuring the Database Archiving Mode [ ] Describe the differences between Archivelog and Noarchivelog modes [ ] Configure a database for Archivelog mode [ ] Enable automatic archiving
User-Managed Backups [ ] Describe user-managed backup and recovery operations [ ] Perform closed database backups [ ] Perform open database backups [ ] Back up the control file User-Managed Complete Recovery [ ] Perform recovery in Noarchivelog mode [ ] Perform complete recovery in Archivelog mode [ ] Restore datafiles to different locations [ ] Relocate and recover a tablespace by using archived redo logfiles [ ] Describe read-only tablespace recovery User-Managed Incomplete Recovery [ ] Describe the steps of incomplete recovery [ ] Perform an incomplete database recovery [ ] Identify the loss of current online redo log files Transporting Data Between Databases [ ] Describe the uses of the Export and Import utilities [ ] Describe Export and Import concepts and structures [ ] Perform simple Export and Import operations Loading Data into a Database [ ] Demonstrate usage of direct-load insert operations [ ] Describe the usage of SQL*Loader [ ] Perform basic SQL*Loader operations
MODULE III 11i Install Patch and Maintain Oracle Applications
Oracle Applications Overview [ ] Describe components of file system in Oracle Applications Preparing for Installation [ ] Describe the benefits of Rapid Install Utility [ ] Describe release platforms for 11i Applications [ ] Describe the software requirements to complete installation of 11i Applications [ ] Describe CPU, Memory and Disk Space Requirements for 11i Applications [ ] Explain the pre-requisites for starting rapid install [ ] Run rapid install wizard [ ] Restart installation
Single Node Installation [ ] Explain the steps involved in performing a single-node installation [ ] Use Rapid Install for a single-node installation [ ] Perform an Express installation Multi Node Installation [ ] Explain the differences between the single-node and multi-node installation processes [ ] Analyze situations in which a multi-node installation is appropriate [ ] Use Rapid Install to perform a multi-node installation Finishing the Installation [ ] Describe required post-installation tasks [ ] Describe the client software configuration process [ ] Set up printers [ ] Apply Oracle E-Business Suite Consolidated Update [ ] Configure Multiple Servers to Use JInitiator [ ] Resize the database [ ] Set Up National Language Support (NLS) [ ] Set Up UTF8 Character Set [ ] Configure Oracle Workflow Java-based Notification Mailer [ ] Set Up and Implement Oracle Embedded Data Warehouse (EDW) Oracle Applications Components [ ] Explain How Oracle Applications uses the Applications technology stack components [ ] Describe Components of the desktop tier [ ] Describe Components of the application tier [ ] Describe Components of the database tier [ ] Describe products of the Application Technology layers [ ] Describe Oracle Application Manager Oracle Applications Environment Files, Control Scripts, and Languages [ ] Explain environment files created by Rapid Install [ ] Describe Application Tier Server Control Scripts [ ] Start and stop server processes [ ] Explain Character Sets [ ] Explain National Language Support (NLS) [ ] Install multiple Languages Oracle Applications File System [ ] Describe Oracle Applications File System [ ] Describe APPL_TOP directory structure [ ] Describe Globalization as components of Oracle Applications [ ] Distribute files across disks [ ] Describe Structure and Contents of product directories [ ] Describe Key APPL_TOP subdirectories
Oracle Applications Database [ ] Describe the objects and schemas that exist in the Oracle Applications database [ ] Describe the purpose of the APPS schema [ ] Describe Multiple Organization Architecture [ ] Describe Multiple Reporting Currencies [ ] Identify the Oracle database features utilized by Oracle Applications [ ] Start and stop the database server and listener Advanced Configuration Options [ ] Describe the Shared APPL_TOP feature available for Oracle Applications [ ] Identify the main load balancing options and their key features [ ] Describe the major factors in efficient network design for Oracle Applications AD Utilities [ ] Describe AD utilities [ ] Explain AD Administration: Generate Applications Files Tasks [ ] Explain AD Administration: Maintain Applications Files Tasks [ ] Explain AD Administration: Maintain Database Entities Tasks [ ] Explain AD Administration: Compile/Reload Database Entities Tasks [ ] Explain AD Administration: Non-interactive Operation and Describe Maintenance Mode [ ] Describe AutoConfig [ ] Describe License Manager [ ] Describe Reporting Utilities [ ] Set the Application environment and locate the AD Utilities AD Administration: Generate Applications Files [ ] Describe AD Administration [ ] Perform preliminary steps before using AD Administration [ ] Respond to prompts [ ] Describe the Generate Applications Files menu tasks [ ] View log files [ ] Perform file generation tasks with AD Administration [ ] Generate message, form, report, graphics, and product jar files AD Administration: Maintain Applications Files [ ] Create the Applications environment file [ ] Copy files to destinations [ ] Convert the character set [ ] Maintain snapshot information [ ] Check for missing files [ ] Perform file system tasks on multi-node systems [ ] Create the main Applications environment file AD Administration: Maintain Database Entities [ ] Maintain Database Entities menu tasks [ ] Validate APPS schema
[ [ [ [ [
] Recreate grants and synonyms for APPS schemas ] Maintain multilingual tables ] Convert to / Maintain Multiple Reporting Currencies ] Maintain Multiple Reporting Currencies ] Convert to Multiple Organizations
AD Administration: Compile/Reload Database Entities [ ] Compile/Reload Database Entities menu tasks [ ] Compile APPS schemas [ ] Compile menu information [ ] Compile flexfield data in AOL tables [ ] Reload JAR files to the database AD Administration: Non-interactive Operation and Maintenance Mode [ ] Create a defaults file [ ] Run AD Administration in non-interactive mode [ ] Enable and Disable maintenance mode Special Utilities [ ] Monitor worker processes [ ] Restart and shutdown a worker [ ] Troubleshoot worker processes [ ] Relink AD programs [ ] Describe the AutoUpgrade utility AutoConfig [ ] Describe the Applications Context [ ] Update Applications Contact parameters [ ] Restore Applications Context parameter [ ] Describe AutoConfig [ ] Run AutoConfig to configure your Oracle Applications system [ ] Roll back an AutoConfig session [ ] Identify the control scripts created by AutoConfig [ ] Run AutoConfig in test mode License Manager [ ] Register products [ ] Register country-specific functionalities [ ] Register languages [ ] Identify licensed products and languages Reporting Utilities [ ] Run AD Configuration [ ] Use AD File Identification [ ] Run the AD Job Timing report [ ] Reduce system downtime
Configuration Utilities [ ] Install a new off-cycle product [ ] Convert the character set of Applications files Patching and the AutoPatch Process [ ] Describe Patches, minipacks, and maintenance packs [ ] Describe Family packs and family consolidated upgrade patches [ ] Describe Patch naming convention [ ] Describe patch components [ ] Explain Patch creation [ ] Download a patch [ ] Describe AutoPatch [ ] Explain AutoPatch operations [ ] Apply a patch [ ] Explain Patch application in a multi-node system [ ] Describe Patch documentation files Patch Wizard [ ] Access Patch Wizard [ ] Describe Patch Wizard main page [ ] Set up Patch Wizard [ ] Define the stage directory [ ] Define patch filters [ ] Submit Patch Wizard requests [ ] View Patch Wizard requests [ ] Describe Patch Wizard results Running AutoPatch [ ] Explain AutoPatch Setup Tasks [ ] Run AutoPatch [ ] Describe AutoPatch Prompts [ ] Describe AutoPatch Messages [ ] Perform Post AutoPatch Tasks [ ] Restart AutoPatch OAM Timing Reports [ ] Access OAM Timing Reports [ ] Describe Timing Reports main page [ ] Use the AutoPatch Timing Details report [ ] Use the AD Administration Timing Details report [ ] Use the Job Timing report [ ] Use the Phase Information report [ ] Use the Exceptions report [ ] Track an In-Progress AutoPatch Session AutoPatch Modes & Testing
[ [ [ [ [ [
] Run AutoPatch in test mode ] Run AutoPatch in pre-install mode ] Run AutoPatch in non-interactive mode ] Use AutoPatch command line options ] Use test systems to test patches ] Merge patch drivers from multiple patches
Applied Patches [ ] Use the Applied Patches search pages [ ] Use Applied Patches reports [ ] Explain Applied Patches and AutoPatch modes [ ] Access Applied Patches [ ] Perform Simple Search for applied patch information [ ] Perform Advanced Search for applied patch information Cloning Oracle Applications [ ] Describe situation that may require cloning [ ] Describe the Rapid Clone utility [ ] Explain the phases of the cloning process [ ] Perform the steps within each phase of cloning Advanced Cloning Options [ ] Refresh a cloned target system [ ] Clone a single-node system to a multi-node system [ ] Clone a multi-node system to a multi-node system [ ] Add a node to an existing system [ ] Reduce the number of nodes on a multi-node system OAM Rapid Clone [ ] Differentiate between a Simple Clone and an Advanced Clone [ ] Establish cloning parameters [ ] Prepare the Source System [ ] Copy Files from Source to Target [ ] Configure the Target System [ ] Initiate Data Purge [ ] Review Checklist