+91-7828025941 +91-9983026744
Pay Now

Advanced Oracle DBA Training Course in Jaipur

Certification

Industry-oriented certification Advanced Oracle DBA training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate

Experienced Faculty

Professional expert Sr. Advanced Oracle DBA Institute With 15+ Years of working experience will provide you industrial level training.

Placement Assistance

Receive placement assistance after completion of 70% training, E-Lite team will arrange interviews till you’ll get the placement.

LAB Facility

You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.

Workshop Sessions

You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete E-Lite workshop.

Admin Support

E-Lite’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.

Advanced Oracle DBA Programme Details

Course Duration: 50 HRS with Highly Skilled Corporate Trainers

Advanced Oracle DBA Training for Modules – Weekdays / Weekend

E-Lite Institute Jaipur – Advanced Oracle DBA Certification Training Delivery Method:

  • Web / Desktop Base.
  • Instructor-Led Classroom Sessions.
  • Presentations/Demonstration/Practicals of concepts.
  • Handouts/Assignments/Real-time Exposure to work on Clients.

Advanced Oracle DBA Programme Modules

Advanced Oracle DBA Training Modules

Advanced Oracle DBA Training Syllabus – RAC

Module 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

Module 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

Module 3 – Creating an Advanced Oracle Database

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

Module 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

Module 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

Module 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

Module 7 – Oracle 11g R2 RAC Database Software Installation

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

Module 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

    • Module 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

    Module 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

    Module 11 – Cluster Node Management

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

    Module 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

    Module 1 – Overview

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

    Module 2 – Understanding the Oracle Data Guard Architecture

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

    Module 3 – Configuring Data Protection Modes

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

    Module 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

    Module 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

    Module 6 – Performing Switchover and Failover

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

    Find the Advanced Oracle DBA course details below.

    Duration of Module

    Advanced Oracle DBA Module Advanced Oracle DBA Duration
    SAdvanced Oracle DBA Module 50 (Hours)

    Batch Timings

    Advanced Oracle DBA Schedule Advanced Oracle DBA Timing
    Monday to Friday 8:00 AM – 10:00 AM
    Monday to Friday 10:00 AM – 12:00 PM
    Monday to Friday 2:00 PM – 4:00 PM
    Monday to Friday 4:00 PM – 6:00 PM
    Saturday/Sunday 8:00 | 12:00 | 2:00 | 4:00
    Sunday 8:00 AM – 10:00 AM
    Sunday 10:00 AM – 12:00 PM
    Sunday 2:00 PM – 4:00 PM
    Sunday 4:00 PM – 6:00 PM