Oracle DBA

Faculty profile:

Real time professionals with 15+ years of experience.

Duration:

60 Hours

Audience:

Database Administrators, Support Engineers

Software needed on student PC:

Linux OS on laptop or desktop,  Oracle Database 11g

Course Objectives:

Oracle DBA course is to have clear understanding of Architecture, Installation, Database Configuration, Physical Structure, Memory Management, User Management, Redo, Undo, Temp Management, Security, Backup, Recovery, Oracle Utilities, ASM Configuration, Performance Tuning tools etc.

Course Topics:

Introduction

  • Types of Databases.
  • Duties of a DBA, Classifications of DBA.
  • Oracle Versioning and versions history.
  • Grid? Advantages of Grid Computing.
  • What is Instance? What is Database? What is Database Server?
  • Users the DBA interacts with.
  • Supported OS.
  • Introduction to Linux OS.
  • Linux File Layout structure.

 Installation of Oracle Software

  • Fulfilling prerequisites for installation.
  • Setting up environment.
  • Installation.
  • Post Installation scripts.
  • Changes done to the OS files after installation is complete.
  • /etc directory, /home/oracle directory, global inventory, oracle home.

 Database Creation

  • Database files introduction.
  • Table spaces and Schemas.
  • Control files introduction.
  • PFile Introduction, Creation and default parameters(10g/11g).
  • Instance States.
  • Database Creation Manually and Using DBCA.

 Background processes and Different stages of Database.

  • Instance Start, Mount and Open states.
  • Dynamic views related to database.
  • Oracle memory layout.
  • Background processes.
  • Instance states more detailed.
  • How to look for background processes.

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.

 Database objects and Tablespaces.

  • Introducing putty and VNC server(How it works in realtime environment).
  • Sys owned objects.
  • Data Dictionary.
  • User Created objects.
  • Sys Tablespaces.
  • User Tablespaces.
  • Dictionary Managed Tablespace, Locally managed tablespace.
  • Bigfile tablespace.
  • Managing tablespaces.
  • Managing datafiles.
  • Datafiles layout, Internal organization.
  • Tables and Fragmentation.

 Threads and Redo log groups

  • Archive log, No Archive log.
  • Threads and Groups concepts.
  • Multiplexing Redo logs.
  • Log switching.
  • Different stages of Log files.
  • Processes related to online Redo logs.
  • Adding Threads, Groups.
  • Dropping Threads, Groups.

 Oracle Memory architecture Different components of memory

  • Dedicated Server and Shared Server.
  • SGA and PGA, Differences between them.
  • Different Stages of a query.
  • Parsing: Hard parsing and Soft parsing.
  • Different stages during an update statement.
  • Checkpointing
  • Indexes
  • Different types of Indexes.
  • B-Trees.
  • Creation.
  • Views related to indexes.
  • Statistics collection on indexes.
  • Listeners.
  • Listener.ora file.
  • Tnsnames.ora file.

 Views and Materialized views

  • Types of views.
  • Creation.
  • Database links.
  • Materialized views.
  • Refreshing materialized views.
  • Processes related to materialized views.
  • Problems with materialized views refresh.

 Users, Privileges, Roles and Responsibilities

  • Security and Passwords(10g/11g).
  • User Creation.
  • Creating Roles.
  • Assigning Privileges, Roles and Responsibilities.
  • Dropping users.
  • Revoking privileges.
  • Password file. Remote sys connect.

 Pfile and spfile

  • Types of parameters(static and dynamic).
  • Managing spfile.
  • Creating pfile from spfile and vice versa.
  • Changing parameters dynamically.

 Control files

  • Multiplexing.
  • Details stored in controlfiles.
  • Creating, Backing up and Recreating controlfiles.
  • Scenarios when a controlfile needs to be created.
  • Changing the Instance name and Database name.

 RMAN

  • RMAN tool introduction.
  • Catalog mode No-Catalog mode.
  • Configurations of RMAN.
  • Hot backups using RMAN.
  • Backing up Databases, Archivelogs and Controlfiles.
  • Channels and Multiple copies.
  • Retention policies.
  • Incremental backups, Cumulative backups.
  • Recovery using RMAN.
  • Cloning databases using RMAN.
  • Restoration from Incremental Backups and Cumulative Backups.

 Automatic Storage Management(ASM).

  • Striping and Mirroring.
  • RAID concepts.
  • ASM concepts and file systems.
  • Background processes used by ASM.
  • CSS daemon.
  • Creating Disk groups and Redundancy.
  • RMAN backups in ASM.
  • Migrating a NON-ASM database to ASM.
  • Rebalancing.
  • ASMCMD command-line tool.
  • md_backup and md_restore.

 Performance Tuning.

  • Categories of tuning.
  • Areas of tuning.
  • SQL Tuning.
  • Memory Tuning.
  • Tools used for tuning.
  • Waits and Contention.
  • Locks and Lock Resolution.
  • AWR reports

 Oracle Enterprise Manager and Grid Control.

  • Configuring OEM
  • AWR Reports from OEM
  • Creating and Configuring Listener in OEM.