Training Calendar

Mon Tue Wed Thu Fri Sat Sun
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

psmb

Total Visitors

46.6%United States United States
24.4%China China
17.7%Canada Canada
4.4%Malaysia Malaysia
2.2%United Kingdom United Kingdom
2.2%Russian Federation Russian Federation
2.2%France France

This Week: 1
Last Week: 3
This Month: 9
Last Month: 26
Total: 50073

Oracle Database 11g: Administration Workshop I Release 2

 

Course Overview

This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

 

 

Pre-requisites

Taken Oracle PL/SQL course or equivalent experience

Course Objectives

  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor and administer undo data
  • Manage the database storage structures
  • Create and administer user accounts
  • Perform basic backup and recovery of a database
  • Manage data concurrency
  • Monitor performance
  • Describe Oracle Database Architecture

 

Course Schedule

Day 1

09.00am – 10.00am

Exploring the Oracle Database Architecture

  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structrues
  • Logical and physical storage structures
  • ASM storage components
10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Installing your Oracle Software

  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Creating an Oracle Database

  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database

Managing the Oracle Database Instance

  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views

Day 2

09.00am – 10.00am

Manage the ASM Instance

  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Configuring the Oracle Network Environment

  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Managing Database Storage Structures

  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  • Oracle Managed Files (OMF) Validating Credit Cards

Administering User Security

  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles

                                                                        Day 3

09.00am – 10.00am

Managing Data Concurrency

  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Managing Undo Data

  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention

Implementing Oracle Database Auditing

  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Database Maintenance

  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks

                                                                        Day 4

09.00am – 10.00am

Performance Management

  • Performance Monitoring
  • Managing Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects

Backup and Recovery Concepts

  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Media Failure
  • Archive Log Files

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Performing Database Backups

  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area

                                                                        Day 5

09.00am – 10.00am

Performing Database Recovery

  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views

Moving Data

  • Describe ways to move data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Working with Support

  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches