TRAINING CATEGORIES
(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies


IT-D 223 - Oracle Database 12c: RAC Administration

Code Start Date Duration Venue
IT-D 223 07 October 2024 5 Days Istanbul Registration Form Link
IT-D 223 11 November 2024 5 Days Istanbul Registration Form Link
IT-D 223 16 December 2024 5 Days Istanbul Registration Form Link
Please contact us for fees

 

Course Description

Oracle Real Application Clusters (Oracle RAC) is a clustered version of the Oracle Database providing high availability, scalability and flexibility. This learning path covers the architecture, installation, maintenance and tuning of Oracle Database 12c RAC, essential skills for DBAs supporting highly available Oracle systems and covers a portion of the objectives for exam 1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure.

Course Objectives

  • Install Oracle RAC software
  • Create cluster databases
  • Administer both administrator and policy-managed Oracle RAC databases
  • Monitor and address performance issues
  • Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard
  • Create and administer a RAC One Node Database
  • Create and manage multitennant RAC databases

Who Should Attend?

  • Oracle Database Administrators
  • Systems Administrators
  • Technical Consultants

Course Details/Schedule

Day 1

  • Grid Infrastructure Overview and Review
  • Oracle Clusterware
  • Hardware and Software Concepts (High level)
  • RAC Databases Overview & Architecture
  • RAC One Node
  • Cluster-Aware Storage Solutions
  • Scaleup and Speedup
  • I/O Throughput Balanced
  • Global Resources
  • RAC and Flex ASM
  • Installing and Configuring Oracle RAC

Day 2

  • RAC Databases Overview & Architecture
  • Instance Startup, Shutdown and Quiesce
  • Use Enterprise Manager Cluster Database Pages
  • RAC Backup and Recovery
  • Instance Failure And Recovery In RAC - LMON and SMON
  • Redo Threads and Archive Log Configurations and Admin
  • RAC and the Fast Recovery Area
  • RMAN Configuration
  • RMAN Restore And Recovery RAC Considerations
  • RAC Global Resource Management and Cache Fusion
  • Library Cache Management
  • Row cache management
  • Buffer Cache Management Requirements
  • Accessing single blocks in RAC
  • Multi-block read considerations in RAC
  • Undo and read consistency considerations in RAC

 

Day 3

  • RAC Monitoring and Tuning
  • OCPU and Wait Time Latencies
  • Wait Events for RAC
  • Session and System Statistics
  • RAC specific V$ Views
  • Automatic Database Diagnostic Monitor for RAC
  • Managing High Availability of Services in a RAC Environment
  • Oracle Services
  • Managing High Availability of Connections
  • Client-Side Load Balancing
  • Server-Side Load Balancing
  • Runtime Connection Load Balancing and Connection Pools
  • Fast Application Notification
  • The Load Balancing Advisory FAN Event
  • Server-Side Callouts

Day 4

  • Upgrading and Patching RAC
  • Release and Patch Set Upgrades
  • PSU, CPU and Interim Patches
  • Merge Patches
  • Performing Out Of Place Database Upgrades
  • Performing Out of Place Release Install or Upgrade
  • Post Upgrade Tasks
  • What is AC?
  • AC Architecture
  • Application requirements
  • Quality of Service Management
  • QOS Management concepts
  • QoS Management functionality

Day 5

  • RAC One Node
  • Adding Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Convert an Oracle RAC database to a RAC One Node database
  • Use DBCA to convert a single instance database to a RAC One Node database
  • Design for High Availability
  • Oracle's Solution to Down Time
  • RAC and Data Guard
  • Maximum Availability Architecture
  • Fast-Start Failover
  • Hardware Assisted Resilient Data
  • RAID Configuration for High Availability

 

ETABS and SAFE. Training 24 CCE 210 5 SAP 2000. Training 25 CCE 305 5 Quality Assurance in Pavement Construction 26 CCE 401 5 Construction Project Management 27 CCE 402 10 Construction Project Management (10 Days) 28 CCE 403 5 Construction Project Management-Intensive 29 CCE 405 5 Principles of Construction Project Management 30 CCE 406 10 Principles of Construction Project Management (10 Days) 31 CCE 410 10 Construction Project and Risk Management (10 days) 32 CCE 411 5 Project & Contract Management for Marine Construction 33 CCE 412 5 Application of GIS in Construction Management 34 CCE 415 4 Sustainable Water Management Techniques, Innovation and Solution (4 Days) 35 CCE 419 5 Construction Management of Hydraulic Projects 36 CCE 420 5 Water Project Management 37 CCE 421 10 Modern Technologies in the Supervision and Quality Control of Irrigation Projects and Dealing with Contractors (10 Days) 38 CCE 422 5 Rapid Earthquake Hazard Evaluation of Buildings 39 CCE 425 10 Practical Application of Computers in Structural Engineering (10 Days) 40 CCE 428 5 Survey & Profile Using Total Station 41 CCE 430 5 Bridge Construction and Maintenance 42 CCE 435 5 Bridge Inspection and Maintenance 43 CCE-A 410 10 إدارة المشاريع الهندسية -10 أيام
21 - TTC - Transportation and Traffic Control
22 - ADV - Architectural Design and Visualization
23 - SRM - Safety and Occupational Health
24 - CSM - Public Relations, Communication Skills & Office Management
25 - TEM - Training and Education Management
26 - CMR - Customer Relations