Oracle Database 11g Release 2 DBA - Part I

5 Day Course
Hands On
Code O11GDBAI

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Overview

This 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.

The delegate will practise:

  • 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

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Introduction to Oracle Database 11g (3 topics)

  • Relational database concepts
  • Database administration tasks
  • DBA responsibilities

Oracle Database 11g Architecture (7 topics)

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

Installation and Configuration of an Oracle Database (12 topics)

  • 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
  • Upgrade a database using Database Upgrade Assistant (DBUA)

Administer a Database Instance (8 topics)

  • 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

Configure the Oracle Network Environment (14 topics)

  • 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 Shared Server architecture
  • Identify when to use Shared Servers and when to use Dedicated Servers

Manage an Oracle Instance (10 topics)

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

Tablespace and Datafile Management (13 topics)

  • 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

Manage Redo Logs (12 topics)

  • 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

Manage Control Files (8 topics)

  • 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

Manage Schema Objects (9 topics)

  • 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

Manage Users (10 topics)

  • 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

Manage Profiles and Resources (7 topics)

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

Managing Privileges (11 topics)

  • 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

Database Auditing (8 topics)

  • 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

Undo Management (11 topics)

  • 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

Moving Data (15 topics)

  • 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

Manage an ASM Instance (5 topics)

  • 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

Data Concurrency and Lock Conflicts (7 topics)

  • 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

Proactive Database Maintenance (6 topics)

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

Performance Management (7 topics)

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

Backup and Recovery Considerations (9 topics)

  • 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

Database Backups (8 topics)

  • 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

Database Recovery (7 topics)

  • 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
  • Data Recovery Advisor Views

Work with Oracle Support (5 topics)

  • Enterprise Manager Support Workbench
  • Register for security updates
  • Work with Oracle support
  • Log Service Requests
  • Manage patches

Prerequisites

A working knowledge of SQL is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Relevant Certifications

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections