Oracle Database 11g Release 2 DBA - Part I

Course Code: O11GDBAI

Duration: 5 days

 
 

Oracle Database 11g Release 2 DBA - Part I Course Overview

The Oracle Database 11g Release 2 DBA - Part I course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 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.

This Oracle Database 11g Release 2 DBA - Part I course is suitable for users of both Release 1 and Release 2.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Course Objectives

This Oracle Database 11g Release 2 DBA - Part I course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle 11g database. The Oracle Database 11g administrator will gain practical experience in setting up, administering and troubleshooting an Oracle 11g database.

Who will the Course Benefit?

The Oracle Database 11g Release 2 DBA - Part I course anyone who needs to administer, monitor and support an Oracle 11g database. The Oracle Database 11g Release 2 DBA - Part I course is also suitable for personnel who need to administer, monitor and support an Oracle Database 11g Release 1 or Release 2 database.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Installing and Configuring Oracle
  • Creating and Managing an Oracle Database
  • Administering an Oracle Database
  • Configuring the Oracle Network Environment
  • 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

Oracle Database 11g Release 2 DBA - Part I Training Course

Course Introduction

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

Session 1: INTRODUCTION TO ORACLE DATABASE 11g

  • Relational database concepts
  • Database administration tasks
  • DBA responsibilities

Session 2: ORACLE DATABASE 11g ARCHITECTURE

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

Session 3: INSTALLATION AND CONFIGURATION OF AN ORACLE DATABASE

  • System Hardware Requirements
  • Optimal Flexible Architecture
  • Authentication methods for a database
  • Oracle environment variables
  • Install Oracle software using the Oracle Universal Installer (OUI)
  • Silent Install
  • Use the database Configuration Assistant (DBCA)
  • Create a database with DBCA
  • Manage a database with DBCA
  • Delete a database with DBCA
  • Manage Templates using DBCA

Session 4: ADMINISTER A DATABASE INSTANCE

  • 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 EM Database Console
  • Access EM
  • EM navigation
  • Grant EM administrative privileges to a user
  • Overview of Oracle Restart

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
  • Use Enterprise Manager to create and configure the Listener
  • Configure client connections with Net Manager
  • View listener configuration
  • Start and stop the Oracle listener
  • Enable Oracle Restart to monitor the listener
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database
  • Configure Net Services with Enterprise Manager
  • Overview of Dedicated Server architecture
  • Overview of Shared Server architecture
  • Identify when to use Shared Servers and when to use Dedicated Servers

Oracle Database 11g Release 2 DBA - Part I Training Course

Session 6: MANAGE AN ORACLE INSTANCE

  • Access an Oracle database
  • Database authentication methods
  • Password file
  • The Startup Process
  • The Shutdown Process
  • Initialization parameters
  • Shutdown a database and instance using SQL and EM
  • Startup a database and instance using SQL and EM
  • View alert log and trace files
  • View or modify initialization parameters with EM

Session 7: TABLESPACE AND DATAFILE MANAGEMENT

  • Overview of tablespaces and datafiles
  • Use EM to view the storage structure of the database
  • Create and alter 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
  • Drop tablespace command

Session 8: MANAGE REDO LOGS

  • Redo log overview
  • Plan redo logs
  • Redo log data dictionary tables
  • Log switches and checkpoints
  • Log file maintenance
  • Add and drop log file members and groups
  • Clear a log file
  • Move or rename an online redo log file
  • Multiplex redo log files
  • Use EM to manage redo logs
  • 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
  • Replace a lost or damaged control file
  • Mirror a control file
  • Standby control file
  • Manage control files with OMF
  • List control file information

Oracle Database 11g Release 2 DBA - Part I Training Course

Session 10: MANAGE SCHEMA OBJECTS

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

Session 11: MANAGE USERS

  • Database administration accounts
  • User accounts
  • Create a user account
  • Operating system authentication
  • Change a user's password
  • Manage a user account
  • Drop a user account
  • Monitor user information
  • Terminate user sessions
  • Product user profiles

Session 12: MANAGE PROFILES AND RESOURCES

  • Overview of user profiles
  • Profile resource parameters
  • Create profile command
  • Manage passwords with profiles
  • Control resource usage with profiles
  • Maintain profiles
  • Drop profiles

Session 13: MANAGING PRIVILEGES

  • Database access
  • Oracle supplied roles
  • System level 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

Session 14: DATABASE AUDITING

  • Overview of database auditing
  • Auditing SYS statements
  • Auditing end user sessions
  • Statement auditing
  • Privilege auditing
  • Auditing modifications made to database objects
  • Audit table relocation
  • Auditing from Enterprise Manager

Oracle Database 11g Release 2 DBA - Part I Training Course

Session 15: UNDO MANAGEMENT

  • Undo data overview
  • Monitor and administer undo
  • Configure undo retention
  • Switch undo tablespaces
  • Specify the retention period
  • Guarantee undo retention
  • Retention period for flashback queries
  • View undo space information
  • Use the undo advisor
  • Size the undo tablespace
  • Manage undo with EM

Session 16: MOVING DATA

  • Create directory objects
  • Data Pump Export and Import
    • Data Pump architecture
    • Data Pump data dictionary views
    • Data Pump interactive mode
    • Data Pump API
    • Use Data Pump to export data
    • Use Data Pump to import data
  • SQL Loader
    • Overview of SQL Loader
    • Command line parameters
    • Record filtering
    • Control file keywords
    • Datafiles
    • SQL Loader data paths

Session 17: OVERVIEW OF MANAGING AN ASM INSTANCE

  • Overview of Automatic Storage Management
  • ASM Storage Components
  • Set up initialization files for an ASM instance
  • Startup and Shutdown ASM Instances
  • Administer ASM disk groups
  • Administer ASM Files

Session 18: DATA CONCURRENCY AND LOCK CONFLICTS

  • Levels of locking in Oracle
  • Methods used to acquire locks
  • Possible causes of contention
  • Deadlocks
  • Prevent locking problems
  • Detect lock contention
  • Resolve conflicts in an emergency

Oracle Database 11g Release 2 DBA - Part I Training Course

Session 19: PROACTIVE DATABASE MAINTENANCE

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

Session 20: PERFORMANCE MANAGEMENT

  • Tuning information sources
  • Identify unusable objects
  • Optimizer Statistics collection
  • Automated statistics collection
  • Performance metrics
  • Use the advisors
  • React to performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS

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

Session 22: DATABASE BACKUPS

  • Types of RMAN backup
  • Backup sets and image copies
  • Perform backups using EM
  • Automate database backups
  • Configure backup settings
  • Catalog settings
  • Monitor the flash recovery area
  • Manage backups

Session 23: DATABASE RECOVERY

  • Restore and recovery operations
  • Recover an entire database from backup
  • Recover from the loss of a system critical data file
  • Recover from the loss of a control file
  • Recover from the loss of a redo log file
  • Data Recovery Advisor

Session 24: ENHANCE THE CAPABILITIES OF THE DATABASE

  • Enterprise Manager Support Workbench
  • Register for security updates
  • Work with Oracle support
  • Log Service Requests
  • Manage patches
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Requirements

Delegates who wish to attend the Oracle Database 11g Release 2 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 Oracle PL/SQL would be beneficial.

Pre-Requisite Courses

Course Reviews

Very enjoyable course and very relevant to my role. Trainer was very knowledgeable and able to tailor the course to our requirements.

Helen - DBA - Government


Excellent course and very well presented. Lecturer was extremely helpful and because the course was one to one very good at presenting examples relevant to my current workplace environment. All content was covered fully and areas of interest were expanded on. Lots of very helpful tips an tricks picked up and I look to applying these when I return to my workplace. I look forward to part two. Receptionist was lovely - very helpful on first day and greeted me every day in a professional and courteous manner - excellent first impression of the company. All staff I met were lovely and lunch vouchers were great idea. Thanks for a great week and see you all soon.

Pauline - IT Manager - Manufacturing


The instructor was very professional and delivered the course at the right pace. Very knowledgeable and knew how to answer all our queries. The documentation was appropriate for the course.

Carlos - Deployment Lead - Finance


Great course and really well explained.

Aaron - Support Engineer - IT


The class size was 2 people, with 1 person attending remotely. We were able to ask any questions, without feeling we weren't interrupting the flow of the class. There were adequate breaks and opportunities to ask questions. The tutor was happy to go over some material that we had already covered, so we were happy that the content was understood. I enjoyed the course and got a lot from it. I will definitely be able to go back to work and put into practice what I have learned this week.

David - Oracle DBA - Police


I felt the course was very easy to follow and the trainer was extremely good at delivering the course and explaining the details.

Mohammed - Technical Support Specialist - Communications


Public Scheduled Events

Classroom & Live Virtual Instructor-Led Training

Duration: 5 days

Price: £2,250.00 exc. VAT 

Please contact us to review your requirements and schedule a date.

 

Live Virtual Classroom

 
Join live instructor-led classroom training from the comfort of your home or office.
All the convenience and benefits of the classroom experience without the hassle and costs of travel and accommodation.
 
 



Our Customers Include

 
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
 
 



Our Course Curriculum

 
 
 
 
Facebook LinkedIn Twitter Instagram E-Mail
 
+44 (0)20 7600 6116
Enquiries@StayAhead.com
Copyright © 2021 StayAhead Training Ltd
Cookies   /   Privacy Policy