Oracle DBA Training in Bangalore

#12,Level 2, Shravanthi Blue Chip,

100Ft Ring Road, BTM 1st Stage,

Bangalore-68

www.pragathitech.com PH- +91-9538734732

email: info@pragathitech.com

Prerequisites:

Required Prerequisites:

• Taken Oracle Introduction to SQL course or equivalent experience
• Oracle Database: Introduction to SQL

Suggested Prerequisites:

• 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 Topics:

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

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

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

Manage the ASM Instance

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

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

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)

Administering User Security

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

Managing Data Concurrency

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

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

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

Performance Management

• 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

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

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

Performing Database Recovery

• 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

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

Working with Support

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

Prerequisites:

Required Prerequisites:

• Oracle Database 11g Database Administration
• Oracle Database 11g: Administration Workshop I DBA Release 2

Suggested Prerequisites:

• Working knowledge of SQL and how to use PL/SQL packages

Course Objectives:

• Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
• Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
• Use an appropriate and flexible memory configuration for your database
• Identify burdensome database sessions and poorly performing SQL
• Configure the Oracle Database for optimal recovery
• Configure the database instance such that resources are appropriately allocated among sessions and tasks
• Schedule jobs to run inside or outside of the database
• Use compression to optimize database storage and duplicate a database

Course Topics:

Core Concepts and Tools of the Oracle Database

• The Oracle Database Architecture: Overview
• ASM Storage Concepts
• Connecting to the Database and the ASM Instance
• DBA Tools Overview

Configuring for Recoverability

• Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
• Using the Recovery Manager (RMAN)
• Configuring your Database for B&R Operations
• Configuring Archivelog Mode
• Configuring Backup Retention
• Configuring and Using a Flash Recovery Area (FRA)

Using the RMAN Recovery Catalog

• Tracking and Storing Backup Information
• Setting up a Recovery Catalog
• Recording Backups
• Using RMAN Stored Scripts
• Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)

Configuring Backup Settings

• Configuring and Managing Persistent Settings for RMAN
• Configuring Autobackup of Control File
• Backup optimization
• Advanced Configuration Settings: Compressing Backups
• Configuring Backup and Restore for Very Large Files (Multisection)

Creating Backups with RMAN

• RMAN backup types
• Creating and Using the following:

- Backup Sets and Image Copies

- Whole Database Backup

- Fast Incremental Backup

- Configure Backup Destinations

- Duplexed Backup Sets

- Archival Backups

Restore and Recovery Task

• Restoring and Recovering
• Causes of File Loss
• Automatic Tempfile Recovery
• Recovering from the Loss of a Redo Log Group
• Recovering from a Lost Index Tablespace
• Re-creating a Password Authentication File
• Complete and Incomplete Recovery
• Other Recovery Operations

Using RMAN to Perform Recovery

• Complete Recovery after Loss of a Critical or Noncritical Data File
• Recovering Image Copies and Switching Files
• Restore and Recovery of a Database in NOARCHIVELOG Mode
• Incomplete Recovery
• Performing Recovery with a Backup Control File
• Restoring from Autobackup: Server Parameter File and Control File
• Restoring and Recovering the Database on a New Host

Monitoring and Tuning RMAN

• Monitoring RMAN Jobs
• Balance Between Speed of Backup Versus Speed of Recovery
• RMAN Multiplexing
• Synchronous and Asynchronous I/O
• Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

Diagnosing the Database

• Data Recovery Advisor (DRA)
• Block Corruption
• Automatic Diagnostic Repository (ADR)
• Health Monitor
• The ADR Command-Line Tool, ADRCI

Using Flashback Technology I

• Flashback Technology: Overview and Setup
• Using Flashback Technology to Query Data
• Flashback Table
• Flashback Transaction Query
• Performing Flashback Transaction Backout

Using Flashback Technology II

• Oracle Total Recall
• Flashback Drop and the Recycle Bin

Performing Flashback Database

• Configuring Flashback Database
• Performing Flashback Database Operations
• Monitoring Flashback Database

Managing Memory

• Oracle Memory Structures
• Oracle Database Memory Parameters
• Using Automatic Memory Management
• Automatic Shared Memory Management
• Using Memory Advisors
• Using Data Dictionary Views

Managing Database Performance

• Tuning Activities
• Using Statistic Preferences
• Optimizer Statistics Collection
• Monitor the Performance of Sessions and Services
• Automatic Workload Repository (AWR)
• Describing the Benefits of Database Replay

Managing Performance by SQL Tuning

• SQL Tuning and SQL Advisors
• Using SQL Tuning Advisor
• SQL Access Advisor
• SQL Performance Analyzer Overview

Managing Resources

• Database Resource Manager: Overview and Concepts
• Accessing and Creating Resource Plans
• Creating Consumer Group
• Specifying Resource Plan Directives, including:
• - Limiting CPU Utilization at the Database Level
• - Instance Caging
• Activating a Resource Plan
• Monitoring the Resource Manager

Automating Tasks with the Scheduler

• Simplifying Management Tasks
• Creating a Job, Program, and Schedule
• Using Time-Based, Event-Based, and Complex Schedules
• Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
• Multi-Destination Jobs

Managing Space in Blocks

• Free Space Management
• Monitoring Space
• Compressing Data

Managing Space in Segments

• Segment Creation on Demand
• Additional Automatic Space-Saving Functionalit
• Shrinking Segments
• Segment Advisor
• Managing Resumable Space Allocation

Managing Space for the Database

• Using 4 KB-Sector Disks
• Transporting Tablespaces
• Transporting Databases

Duplicating a Database

• Purpose and Methods of Cloning a Database
• Using RMAN to Create a Duplicate Database
• Cloning a Database from a Backup
• Duplicate a Database Based on a Running Instance
• Targetless Duplicating a Database
• Oracle SQL & PL/SQL Performance Tuning Workshop - Oracle Core
• Duration: 20 hours
• Prerequisites: Basics of SQL and DBA knowledge
• SQL Performance Tuning Workshop provides hands-on learning to SQL Performance Tuning techniques, features and best practices.
• The course provides focus on performance tuning techniques for SQL, PL/SQL code and hands-on learning for participants.
• This course introduces the participants to identify performance issues using oracle utilities viz Explain Plan / TKPROF, diagnosis the issue and take corrective action.
• Course includes performance-tuning techniques for SQL query, PL/SQL program, and use of other Oracle database objects viz Materialized views, Partitions, Indexes etc to improve database performance.
• Module 1: Introduction with Oracle Architecture
• Module 2: Query Optimization, SQL Query Execution, Explain Plan, Auto trace, Locking Mechanisms, and Interpret TKPROF
• Module 3: Speeding up Queries with Semi Joins and Anti Joins
• Module 4: Understand Statistics, Indexes, and Partitions
• Module 5: Hints, Parsing, and Dynamic SQLs
• Module 6: Views, Materialized Views
• Module 7: Bulk Data processing, Parallel DML, DWH features like External table, Merge, Multi-table Insert
• Module 8: Rewriting SQL for Performance, Merging Multiple SQL to Single SQL, Use of Temporary Tables,
• Module 9: Using AWR and ADDM Reports in Oracle11g r2
• Module 10: Performance Tuning using Oracle Enterprise Manager 11g r2
• Module 11: Tuning Scenarios
• Hands-on Activities for every required section.

ORACLE 11g RAC DATABASE

(Oracle 11g – RAC on Enterprise Linux)

Duration: 20 hours

Suggested Prerequisites:

• Oracle Database Administrator (DBA) 9i/10g/11g.

Course Topics:

Overview

• Hardware
• Software

Configure Linux for Oracle

• OS Requirements
• Oracle Groups and User Account
• Create Mount Points
• Configure Kernel Parameters
• Configure /etc/hosts
• Configure SSH for User Equivalence
• Establish User Equivalence
• Test Connectivity

Prepare the Shared Disks

• Disk Partitions
• Oracle Cluster File System (OCFS) Release 2
• Configure OCFS2
• Configure O2CB to Start on Boot and Adjust O2CB Heartbeat Threshold
• Creat and format the OCFS2 filesystem on the unused disk partition
• Mount the OCFS2 filesystem
• Create the directories for shared files
• Automatic Storage Management (ASM)
• Installing ASM
• Configuring ASMLib

Install Oracle Software

• Installing ASM
• Install Oracle Clusterware
• Create the ASM Instance
• Create the RAC Database
• Startup and Shutdown Steps ( Instance and Database)
• Maintenance Commands – (crsctl and srvctl)
• Backup and Recovery files

For Details Please contact :

#12,Level 2, Shravanthi Blue Chip,

100Ft Ring Road, BTM 1st Stage,

Bangalore-68

www.pragathitech.com PH- +91-9538734732

email: info@pragathitech.com