Oracle Database 11g : Administration Workshop I

Description

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.

Benefit

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter. OBJECTIVE Ÿ 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

Content

Oracle Database 11g Release 2 (11.2.0.1.0) COURSE OUTLINE Ÿ Exploring the Oracle Database Architecture Ÿ Installing your Oracle Software Ÿ Creating an Oracle Database Ÿ Managing the Oracle Database Instance Ÿ Manage the ASM Instance Ÿ Configuring the Oracle Network Environment Ÿ Managing Database Storage Structures Ÿ Administering User Security Ÿ Managing Data Concurrency Ÿ Managing Undo Data Ÿ Implementing Oracle Database Auditing Ÿ Database Maintenance Ÿ Performance Management Ÿ Backup and Recovery Concepts Ÿ Performing Database Backups Ÿ Performing Database Recovery Ÿ Moving Data Ÿ Working with Support

Course

-Oracle Database Architecture Overview -Oracle ASM Architecture Overview -Process Architecture -Memory structrues -Logical and physical storage structures -ASM storage components

-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

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

• 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

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

• 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

• 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)

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

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

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

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

• 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

• Performance Monitoring • Managing Memory Components • Enabling Automatic Memory Management (AMM) • Automatic Shared Memory Advisor • Using Memory Advisors • Dynamic Performance Statistics • Troubleshooting and Tuning Views • Invalid and Unusable Objects

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

• 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

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

• 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

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

Methodology

1
Presentation
2
Discussion
3
Practice Activities
4
Case Studies

Evaluation

1
Pre Test
2
Post Test
3
Certification Exam

Duration

5 Days

Target Audience

Database Administrators , Java Developers , Support Engineer , Technical Consultant , Technical Administrator

Schedule

Nov 2017
06-10