Oracle DBA

Duration : 40 Hrs

Evanta Technologies offers Oracle DBA online training established on present industry values that
helps students to secure jobs in their dream MNCs. At Evanta Oracle DBA Online training is
conducted by subject specialist corporate professionals with well experience in managing real-time
Oracle DBA projects and implements a blend of academic learning and real-world sessions to give
the student ideal introduction that helps in the transformation students into thorough experts that
are easily recruited within the industry.

At Evanta Technologies well-equipped Oracle DBA online training centre offers students to learn the
skills for oracle database. Oracle DBA online Training course was designed as per up-to- date industry
techniques and upcoming advanced Oracle DBA course content and syllabus based on the
professional requirement of the student.

Oracle rapidly converging all IT required solutions like middleware, storage and OS by acquiring
leading core pioneers and technology players in market. It is providing very strong and unique
supports to customers. Still now oracle has acquired around 40 companies and expands its wings
around 90% on RDBMS and ERP tools and services and related technologies. This Oracle DBA is a
foremost leading and tough skill-set in IT from the time when the role need to be conduct the
backbone of organization’s vital data management at large scale.

Database administrators (DBAs) use specialized software to store and organize data. Each database
requires at least one database administrator (DBA) to administer it. For that reason an Oracle
database system can be large and can have many users frequently this is not a one person job. In
such cases, there is a group of DBAs who share responsibility. We are happy to be one of the best
leading Oracle DBA online training institutes with best experienced IT professionals and skilled

Who can learn this course:
  • Database Administrators
  • Support Engineer
  • Data Warehouse Administrator
  • Technical Administrator
Pre Requisite:
  • General understanding of database administration
End Objective:
  • Install, create, administer, and monitor a Real Application Clusters database
  • Use configuration and management tools for Real Application Clusters databases
  • Setup services for workloads management, and applications high availability
  • Develop a backup and recovery strategy for Real Application Clusters databases
  • Configure and monitor Oracle Clusterware resources
  • Review high availability best practices
  • Identify Real Application Clusters components
Exploring the Oracle Database Architecture
  • What is a Cluster Oracle Real Application Clusters (RAC)
  • Types of cluster
  • Components Of Cluster
  • Hardware requirement for clusters
  • Components SGA Structures
  • Advantage of using RAC
  • Clusters High Availability, Scalability and Performance
  • Oracle Real Application Clusters Architecture
  • Cache fusion
  • Multi instance transaction behavior
  • Background process in RAC
Installation of Oracle Clusterware (CRS) and configuration
  • Oracle 11g RAC Installation
  • Pre-Installation Tasks
  • Operating System preparation for Rac
  • Introduction to Network Hardware
  • Private & Public Configuration
  • SHMMAX and Semaphores for Oracle 11g RAC
  • Groups & Users For Oracle Software
  • Clusters Setup Tasks
  • Storage for Cluster
  • Oracle Cluster Registry File
  • Cluster verify utility (CLUVFY)
  • Introduction to 11g daemons
  • Installing Cluster ready services
ASM with RAC
  • ASM Overview
  • Adv .Of ASM
  • 11g ASM Enhancements
  • Parameter used for configure ASM
  • Creating ASM Instances & Disk groups
Requires RAC Database Files : UNDO and REDO management
  • Managing Redo Log groups in RAC Environment
  • Managing Undo table space in RAC Environment
  • parameter used for 11g RAC Database/
  • SP-File management in RAC
  • Oracle database software installation
  • Cluster database creation in RAC
  • Post installation tasks
  • Database creation in Rac
  • Enabling/Disabling Archive Log mode
  • Flash recovery area
Oracle Clusterware Administration & Debugging
  • Oracle Cluster registry (OCR)
  • Voting disk
  • VIP Addresses
  • Debugging Clusterware log files
  • Workload distribution
  • Transparent application failover
RAC Administration with SRVCTL Commands
  • Adding ASM Instances
  • Adding RDBMS Instances
  • Starting and stopping instances and database
  • Managing service with SRVCTL Commands
  • Management of OCR & Voting disk
  • Multiplexing of OCR & Voting Disk
  • 11g Enhancements in cluster where Administration
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
  • Adding Node in existing RAC
  • Deleting Node in Existing RAC
OCFS(Oracle Cluster File System)
  • OCFS(Oracle Cluster File System)
  • Introduction to OCFS1 & OCFS2,
  • Of OCFS2 Installation of OCFS2
  • Database creation on OCFS using DBCA OEM(Oracle Enterprise Manager)
  • Introduction to OEM
  • OEM Configuration for
  • RAC database using EMCA
  • EMCTL Commands for OEM
  • 11g Enhancements in OEM
High Availability Connections configuration
  • Configure client side connect -Time load balancing
  • Configure server side connect -Time load balancing
  • Configure transparent application failover(TAF )
Performing Backups and Recovery in RAC
  • Protecting Against Media Failure
  • Archived Log File Configurations & Conventions
  • RAC and the Flash Recovery Area
  • Distribution of Backups
Using the RMAN Recovery Manager
  • Introduction to RMAN
  • 11g Enhancement in RMAN
  • Backup and Recovery in RAC through RMAN
  • Migration RAC (Single instances to multi instances )
RAC 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
  • Determine RAC specific Tuning
Data guard setup in RAC Environment
  • Introduction to SAN
  • Hardware setup and Adv of SAN
  • RAC Implementation on SAN setup
Workshop and Case Studies
 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
  • Oracle RAC (10g, 11g)


No reviews

Post Review

Review Title
Review Content
View All Categories

Quick Enquiry

Technology Portfolio