Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE DATABASE 10g

• Relational database concepts
• Database administration tasks
• DBA responsibilities

Session 2: ORACLE DATABASE 10g ARCHITECTURE

• Oracle architecture
• The Oracle instance
• Memory structures
• Background processes
• Server and client processes
• The Oracle database

Session 3: INSTALLATION & CONFIGURATION OF AN ORACLE DATABASE

• Installation Prerequisites
• Understand system requirements
• Use optimal flexible architecture
• Authentication methods for a database
• Oracle environment variables
• Install Oracle software using the Oracle Universal Installer (OUI)
• Use the Database Configuration Assistant (DBCA) to create a database
• Use DBCA to manage templates
• Upgrade a database using Database Upgrade Assistant (DBUA)

Session 4: ADMINISTER A DATABASE

• Administrative tools available to a DBA
• Using SQL*Plus in Oracle to manage a database
• Administer the database using Enterprise Manager (EM)
• Start and stop the agent
• Start and stop the EM Database Console
• Access EM
• EM navigation
• Grant EM administrative privileges to a user

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

• Overview of network configuration
• Oracle Net Listener configuration and management
• Oracle Net Naming methods
• Tools for configuring and managing the Oracle network
• Configure client connections with Net Manager
• View listener configuration
• Start and stop the Oracle listener
• Use TNSPING to test Oracle Net connectivity
• Connect to the database

Session 6: MANAGE AN ORACLE INSTANCE

• Access an Oracle database
• Database authentication methods
• Initialization parameters
• Password file
• SHUTDOWN the database
• STARTUP the database
• View alert log and trace files

Session 7: TABLESPACE AND DATAFILE MANAGEMENT

• Overview of tablespaces and datafiles
• Use EM to view the storage structure of the database
• Create tablespace commands
• Locally managed tablespaces
• Dictionary managed tablespaces
• Bigfile tablespaces
• Temporary tablespaces
• Multiple temporary tablespaces
• Create tablespaces
• Manage tablespaces
• Use standard and non-standard block sizes
• Create and manage tablespaces using OMF
• Manage tablespaces

Session 8: MANAGE REDO LOGS

• Redo log file structure
• Maintaining redo log files
• Log switches and checkpoints
• Multiplex redo log files
• Manage online redo log files with OMF
• List redo log information

Session 9: MANAGE CONTROL FILES

• The usage of the control file
• The contents of a control file
• Manage control files
• Standby control file
• Manage control files with OMF
• List control file information

Session 10: MANAGE SCHEMA OBJECTS

• Create a new table
• View the attributes and contents of a table
• Understand data integrity
• Define constraints
• Create indexes
• View index attributes
• Create views
• Create and use sequences

Session 11: MANAGE USERS

• Database administration accounts
• User accounts
• Create a user account
• Change a user's password
• Alter and drop a user account
• Monitor user information
• Terminate user sessions

Session 12: MANAGE PROFILES AND RESOURCES

• Create profile command
• Manage passwords with profiles
• Control resource usage with profiles
• Alter and drop profile command

Session 13: MANAGING PRIVILEGES

• Database access
• System level roles and privileges
• Object level privileges
• The grant and revoke commands
• Create roles
• Modify and drop roles
• Control the availability of roles
• Use predefined roles
• Synonyms
• Listing valid grants
• Product user profiles

Session 14: DATABASE AUDITING

• Auditing SYS statements
• Auditing end user sessions
• Auditing the use of privileges
• Auditing modifications made to database objects
• Audit table relocation
• Fine grained auditing

Session 15: UNDO MANAGEMENT

• Undo data overview
• Monitor and administer undo
• Configure undo retention
• Guarantee undo retention
• Use the undo advisor
• Size the undo tablespace

Session 16: MANAGE DATA

• Use Data Pump to export data
• Use Data Pump to import data
• Use SQL Loader
• Create directory objects

Session 17: ORACLE SHARED SERVER

• When shared servers should be used
• Configure shared servers
• Monitor shared servers
• Shared server architecture

Session 18: MONITORING AND RESOLVING LOCK CONFLICTS

• Detect and resolve lock conflicts
• Manage deadlocks

Session 19: PROACTIVE DATABASE MAINTENANCE

• Automatic Workload Repository
• Automatic Database Diagnostic Monitoring
• Monitor an Oracle database
• Use the Advisors
• Set up notification rules

Session 20: PERFORMANCE MONITORING

• Troubleshoot invalid and unusable objects
• Gather optimizer statistics
• View performance metrics
• React to performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS

• Oracle Suggested Backup Strategy
• Database backup, restore and recover
• Types of failure
• Tune instance recovery
• Checkpoints, redo log files and archive log files
• Configure ARCHIVELOG mode
• Configure a database for recoverability

Session 22: DATABASE BACKUPS

• Types of RMAN backup
• Backup sets and image copies
• Create consistent database backups
• Perform online backups
• Perform incremental backups
• Automate database backups
• Monitor the flash recovery area
• Manage backups

Session 23: DATABASE RECOVERY

• Recover from the loss of a system critical data file
• Recover from the loss of a non system critical data file
• Recover from the loss of a control file
• Recover from the loss of a redo log file

Session 24: FLASHBACK

• Flashback Query
• Flashback Version Query
• Flashback Transaction Query
• Flashback Table
• Flashback Drop