SkillXpert :: Oracle DBA

Oracle DBA

Class Room Training

  • Training for 30 Days
  • Daily 1Hr 30 Min
  • Printed Material
  • 24/7 Lab Facility
  • Placement Assistance

Online Training

  • Training for 30 Days
  • Daily 1Hr 30 Min
  • Material through Softcopy
  • 24/7 Lab Facility
  • Placement Assistance

Weekend Training

  • Training for 4 Weeks
  • Every Weekend day 3 Hrs
  • Printed/Softcopy Material
  • 24/7 Lab Facility
  • Placement Assistance

Oracle DBA

Best Oracle DBA Training institution is SkillXpert. Learn Oracle DBA Training with one of the software industry expert, who have been dealing with Oracle DBA Applications since a decade.

Introduction

  • What is a ClusterOracle Real Application Clusters (RAC)
  • Advantage of using RAC
  • Clusters High Availability, Scalability and Performance
  • Oracle Real Application Clusters Architecture
  • Cache fusion
  • Multi instance transaction behaviour
  • Extra background process in RAC

Installation of Oracle Clusterware (CRS) and configuration

  • Oracle RAC 10g Installation: Outline
  • Pre-Installation Tasks
  • Hardware Requirements
  • Network Requirements
  • The oracle User Environment Setup & User Shell Limits
  • Linux Operating System Parameters
  • Cluster Setup Tasks
  • Storage for Cluster
  • Oracle Cluster Registry File
  • Voting Disk File
  • Verifying the Oracle Clusterware Installation
  • Cluster verify utility (CLUVFY)

ASM with RAC

  • ASM Overview
  • Installation of ASM Instances
  • Managing ASM Disk Groups and Instances.
  • ASM Instance and Crash Recovery in RAC

RAC Software Installation & Database Creation

  • Oracle database software installation
  • Cluster database creation
  • Post installation tasks

Oracle Clusterware Administration & Debugging

  • Oracle Cluster registry (OCR)
  • Voting disk
  • VIP Addresses
  • Debugging Clusterware log files
  • Workload distribution
  • Transparent application failover

RAC Administration

  • Starting and Stopping RAC Instances
  • Creating and Registering Instances
  • Transparent Application Failover (TAF)
  • Database files with RAC
  • Initialization Parameter Files
  • Trace & Alert logs.
  • Undo management
  • Temporary table space monitoring

RAC Services

  • What is a Service
  • Advantage of using service
  • Possible service configuration
  • Creation and maintenance of services using SRVCTL, DBCA,EM
  • Statistics gathering and tracing to check performance of Services
  • Service performance views
  • Workload distribution
  • Transparent application failover

Performance Monitoring

  • Finding & Monitoring the Sessions
  • Session and system statistics
  • Finding and Resolving Locks across Instances
  • Cache Fusion impact & events in RAC
  • Wait events & Wait event views
  • Generating AWR Snapshots & Reports in RAC
  • Doing ADDM analysis

Backup and Recovery in RAC

  • Protecting Against Media Failure
  • Archived Log File Configurations & Conventions
  • RAC and the Flash Recovery Area
  • Oracle Recovery Manager
  • Distribution of Backups

Workshop

  • Single instance to RAC conversion
  • Cloning a RAC Instance
  • No archive log to Archive log conversion
  • Node addition and deletion
  • Patching RAC software and Clusterware

Job Opportunities:

After the course completion, we have strong clients Relation Existing with many IT Organizations, we will help the students with Placement Assistance Program with these Clients.

List of the Companies Offering Job Opportunities to our Students.

Infosys Wipro Prokarma
Cognizant Virtusa Marlabs
GalaxESolutions CapGemini Cigniti
Polaris HSBC ValueLabs
NCR Dell IBM
Deloitte NTT Data GalaxESolutions
Persistent iGate Sapient

Course Complete Certification:

We implemented Course Complete Certification process to give enormous information and support through the projects to our students, the one who gets the course complete certification is eligible to login to the projects developed and will be developed by us on the related technology, tools and course.

This Access will be provided for 12 months for the student from the day when he gets his CCC for SkillXpert.