Training in BTM is a leading Training as well as Placement company with experience in leading IT Sectors of India. Our training reproduces the latest technologies, techniques, as well as processes that are advanced in practical knowledge collected from years of experience. Advanced Oracle DBA Training in BTM Layout offers planned training paths intended for the certification skills necessary to work in latest technological environment, while offering a wide-ranging curriculum of application centric courses for customers looking to implement upgraded/new business applications. The purpose of software Professional training is to help students to advance their knowledge overtime while being acknowledged for their achievement.

Advanced Oracle DBA Training in BTM Layout is an outstanding Online and corporate training center. We provide a number of tailored training programs for small, medium along with big organizations in Bangalore and across India. Our training courses are very cost effective for all clients/students plus students. Our training Syllabus is prepared from the team of experts and the students can improve from basic knowledge to advance level. Our Syllabus includes Oracle 11g R2 Grid Infrastructure Concepts , Grid Infrastructure Installation and Configuration , Oracle Automatic Storage Management concepts , Cluster installation Prerequisite for Oracle 11g R2 RAC , Shared Storage Configuration , Oracle 11g Grid Infrastructure Installation , Administering Oracle Clusterware , Administering ASM Instances , Prerequisite Steps for Extending a Cluster , Cluster Node Management , Understanding the Oracle Data Guard Architecture , Configuring Data Protection Modes , Creating a Physical Standby Database by Using SQL , Creating a Logical Standby Database by Using SQL , Performing Switchover and Failover with real time experience.

Training in BTM Layout is one of the greatest Software training institutes in Bangalore with 100% placement support. It has well defined training modules in addition to training sessions for pupils. At Advanced Oracle DBA Training in BTM Layout, training is conducted in day time classes on all weekdays as well as weekends to suit the timings for all students and working professionals .Advanced Oracle DBA Training in BTM Layout helps you acquire a foothold in the growing IT & ITeS industry. 100% Placement Assistance- While a student finishes his/ her course effectively, our dedicated Placement Cell arranges interviews with major companies. This wide hands-on experience in Software training ensures that you captivate the knowledge as well as skills that you can apply at work after your placement. All of our mentors are work specialists with years of experience in well recognized IT sectors. Learning from the work experts is the only method to understand what happens in the actual IT world.

Advanced Oracle DBA Training Syllabus – RAC

Session : 1 – Oracle 11g R2 Grid Infrastructure Concepts

  • What is a Cluster
  • Grid Foundation Components
  • Oracle Clusterware Architecture
  • Oracle Clusterware Software and Storage
  • Describe ASM Architecture
  • Creating and Managing ASM Disk Groups
  • Creating and Managing ASM Cluster File systems
  • Administering Oracle Clusterware
  • Troubleshooting Oracle Clusterware

Session : 2 – Grid Infrastructure Installation and Configuration

  • Hardware Requirements
  • Network Requirements
  • Software Requirements
  • DNS and DHCP Configuration
  • Grid Plug and Play Considerations
  • Single Client Access Names
  • Post installation tasks

Session : 3 – Oracle Automatic Storage Management concepts

  • ASM Instance
  • ASM Disks
  • ASM Disk Groups
  • ASM Redundancy

Session : 4 – Cluster installation Prerequisite for Oracle 11g R2 RAC

  • Linux OS Software Installation
  • Create OS Group and User Accounts
  • Networking
  • Synchronizing the Time on ALL Nodes
  • Configuring Kernel Parameters
  • Set shell limits for the oracle & grid user
  • Create the Oracle Inventory Directory
  • Creating the Oracle Grid Infrastructure Home Directory
  • Creating the Oracle Base Directory
  • Creating the Oracle RDBMS Home Directory
  • Stage the Oracle Software
  • Check OS Software Requirements
  • Cluster Verification Utility

Session : 5 – Shared Storage Configuration

  • Types of Shared Storage
  • Partition the Shared Disks
  • Installing and Configuring ASMLib
  • Using ASMLib to Mark the Shared Disks as Candidate Disks

Session : 6 – Oracle 11g Grid Infrastructure Installation

  • Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)…
  • Grid Infrastructure Home Patching
  • RDBMS Software Install
  • Run ASMCA to create diskgroups

Session : 7 – Oracle 11g R2 RAC Database Software Installation

  • Installing The Oracle Database Software
  • Creating A Cluster Database
  • Post database Creation Tasks

Session : 8 Administering Oracle Clusterware

  • Managing Clusterware with Enterprise Manager
  • Determining the Location of the Oracle Clusterware Configuration Files
  • Backing Up and Recovering the Voting Disk
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups
  • Oracle Local Registry
  • Migrating OCR Locations to ASM
  • Managing Network Settings
  • Managing Oracle Clusterware

Session : 9 – Administering ASM Instances

  • ASM Initialization Parameters
  • Adjusting ASM Instance Parameters in SPFILEs
  • Starting and Stopping ASM Instances Using srvctl
  • Starting and Stopping ASM Instances Using ASMCA and ASMCMD
  • Starting and Stopping ASM Instances Containing Cluster Files
  • Starting and Stopping the ASM Listener
  • Administering ASM Disk Groups
  • Creating and Deleting ASM Disk Groups
  • ASM Disk Group Attributes
  • ASM Disk Group Maintenance Tasks
  • Viewing ASM Disk Statistics

Session : 10 – Prerequisite Steps for Extending a Cluster

  • Using addNode.sh to add a Node to a Cluster
  • Rolling Patches and Rolling Upgrades
  • Installing a Patchset with the OUI Utility
  • Installing a Patch With The opatch Utility

Session : 11 – Cluster Node Management

  • Add/Deleting the instance
  • Add the Node
  • Remove the Node
  • Single-Instance Conversion Using rconfig
  • Single-Instance Conversion Using DBCA

Session : 12 – Troubleshooting Oracle Clusterware

  • Oracle Clusterware Log Files
  • Gathering Log Files Using diagcollection.pl
  • Component-level Debugging
  • RAC-Specific Wait Events, Global Enqueues, and System Statistic
  • Implementing the Most Common RAC Tuning Tips
  • Using the Cluster Database Performance Pages
  • Using the Automatic Workload Repository in RAC
  • Using Automatic Database Diagnostic Monitor in RAC

Oracle Data Guard Training Syllabus

Session : 1 – Overview

  • What Is Oracle Data Guard?
  • Oracle Data Guard Architecture
  • Types of Standby Databases
  • Types of Services
  • Benefits of Implementing Oracle Data Guard

Session : 2 – Understanding the Oracle Data Guard Architecture

  • Data Guard Redo Apply Architecture
  • Data Guard SQL Apply Architecture
  • Standby Database Modes

Session : 3 – Configuring Data Protection Modes

  • Maximum Protection
  • Maximum Availability
  • Maximum Performance
  • Comparisons
  • How to Set the Mode

Session : 4 – Creating a Physical Standby Database by Using SQL

  • Preparing the Primary Database
  • Setting Initialization Parameters on the Primary Database
  • Backing Up the Primary Database
  • Creating a Control File for the Standby Database
  • Setting Initialization Parameters on the Standby Database
  • Setting Up the Environment to Support the Standby Database
  • Starting the Physical Standby Database
  • Performing Additional Configuration Tasks

Session : 5 – Creating a Logical Standby Database by Using SQL

  • Preparing to Create a Logical Standby Database
  • Creating a Physical Standby Database
  • Preparing the Primary Database
  • Transitioning to a Logical Standby Database
  • Opening the Logical Standby Database
  • Verifying the Logical Standby Database

Session : 6 – Performing Switchover and Failover

  • Choosing the Best Role Transition Operation
  • Performing a Switchover by Using SQL
  • Performing a Failover by Using SQL

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya