S7

Oracle Database 10g DBA - Part I Course Overview

This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database.

The Oracle Database 10g DBA - Part I course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle10g database.  Database administrators will gain an understanding of the architecture and processes of the Oracle database server.  They will be able to ensure the integrity and availability of a company's data within the Oracle environment.  They will be able to monitor the performance of the database and perform basic backup and recovery of the database.

Skills Gained

The delegate will practise:

• Installing and Configuring Oracle
• Creating and Managing an Oracle Database
• Administering an Oracle Database
• Configuring the Oracle Network Environment
• Configuring Shared Servers
• Creating and Managing Database Storage Structures
• Managing Redo Log Files and Control Files
• Managing Schema Objects
• Managing Users, Profiles, Privileges and Roles
• Managing Undo Data and Temporary Segments
• Monitoring and Resolving Lock Conflicts
• Maintaining Database Security
• Monitoring the Performance of the Database
• Loading and Unloading Data
• Backing Up and Recovering the Database

Who will the Course Benefit?

Anyone who needs to administer, monitor and support an Oracle 10g database.

Course Objectives

The objectives of the Oracle Database 10g DBA - Part I course are that the Oracle database administrator will gain practical experience in setting up, administering and troubleshooting an Oracle10g database. Database administrators will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment.

Examinations

This Oracle Database 10g DBA - Part I course covers the main examination topics of the Oracle exam #1Z1-042 Oracle Database 10g: Administration I.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience.  The Oracle website lists all exam requirements and these are updated regularly.

Requirements

Delegates wishing to attend the Oracle Database 10g DBA - Part I course should have an understanding of relational database concepts and good operating system knowledge.  They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL.  Knowledge of PL/SQL would be beneficial.

Pre-Requisite Courses

• Oracle SQL

Follow-On Courses

• Oracle Database 10g DBA - Part II

NOTE: Course technical content is subject to change without notice.

---

Oracle Database 10g DBA - Part I Training Course

Course Contents - DAY 1

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

---

Oracle Database 10g DBA - Part I Training Course

Course Contents - DAY 2

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

---

Oracle Database 10g DBA - Part I Training Course

Course Contents - DAY 3

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

---

Oracle Database 10g DBA - Part I Training Course

Course Contents - DAY 4

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

---

Oracle Database 10g DBA - Part I Training Course

Course Contents - DAY 5

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