Who is the target audience?

Oracle Database Administrators who want to learn how to create and manage Oracle RAC databases and administer Oracle Data Guard.

Course curriculum

  • 1
    Oracle/AWS Advanced Course
    • Oracle Real Application Clusters Classroom Lecture Video 1
    • Oracle Real Application Clusters Classroom Lecture Video 2
    • Oracle Real Application Clusters Classroom Lecture Video 3
    • Oracle Real Application Clusters Classroom Lecture Video 4
    • Oracle Real Application Clusters Classroom Lecture Video 5
    • Oracle Real Application Clusters Classroom Lecture Video 6
    • Oracle Real Application Clusters Classroom Lecture Video 7
    • Oracle Real Application Clusters Classroom Lecture Video 8
    • Oracle Real Application Clusters Classroom Lecture Video 9
    • Oracle Real Application Clusters Classroom Lecture Video 10
    • Oracle Real Application Clusters Classroom Lecture Video 11
    • Oracle Real Application Clusters Classroom Lecture Video 12
    • Oracle Real Application Clusters Classroom Lecture Video 13
    • Oracle Real Application Clusters Classroom Lecture Video 14
    • Oracle Real Application Clusters Classroom Lecture Video 15
    • Oracle Real Application Clusters Classroom Lecture Video 16
    • Oracle Real Application Clusters Classroom Lecture Video 17
    • Oracle Real Application Clusters Classroom Lecture Video 18
    • Oracle Real Application Clusters Classroom Lecture Video 19
    • Oracle Real Application Clusters Classroom Lecture Video 20
    • Oracle Real Application Clusters Classroom Lecture Video 21
    • Oracle Real Application Clusters Classroom Lecture Video 22
    • Oracle Real Application Clusters Classroom Lecture Video 23
    • Oracle Real Application Clusters Classroom Lecture Video 24
    • Oracle Real Application Clusters Classroom Lecture Video 25
    • Oracle Real Application Clusters Classroom Lecture Video 26
    • Oracle Real Application Clusters Classroom Lecture Video 27
    • Oracle Real Application Clusters Installation Video 1
    • Oracle Real Application Clusters Installation Video 2
    • Oracle Real Application Clusters Installation Video 3
    • Oracle Real Application Clusters Installation Video 4
    • Oracle Real Application Clusters Installation Video 5
    • Oracle Real Application Clusters Installation Video 6
    • Oracle Real Application Clusters Installation Video 7
    • Oracle Real Application Clusters Installation Video 8
    • Oracle Real Application Clusters Installation Video 9
    • Oracle Real Application Clusters Installation Video 10
    • Oracle Real Application Clusters Installation Video 11
    • Oracle Real Application Clusters Installation Video 12a
    • Oracle Real Application Cluster Installation Video 12b
    • Oracle Real Application Clusters Installation Video 12
    • Oracle Real Application Clusters Installation Video 13
    • Oracle Real Application Clusters Installation Video 14
    • Oracle Real Application Clusters Installation Video 15
    • Grid Infrastructure Commands
    • RAC RPMS
    • ORACLE REAL APPLICATION CONFIGURATION SCRIPTS
  • 2
    Dataguard Classroom Lecture And Installation
    • Data Guard Class Lecture
    • Dataguard Pre-Installation Video 1
    • Dataguard Pre-Installation Part 2
    • Dataguard Pre-Installation Part 3
    • Dataguard Pre-Installation Part 4
    • Changing Modes In Dataguard Configuration part 1
    • Changing Modes In Dataguard Configuration part 2
    • Changing Modes In Dataguard Configuration part 3
    • Verifying Archived Logs Are Applying To Standby Database
    • Inserting Data Into Primary Database In a Datguard Environment
    • Converting From Standby to Snapshot Database
    • Converting From A Snapshot To A Physical Standby Database
    • Performing A Switchover From Primary To Standby
    • How To Resolve "Resolvable Gap Issues"
    • How To Perform A Switchover From Standby To Primary
    • How To Configure Data Broker
    • Changing Protection Modes Via Data Guard Broker
    • Performing A Switch Over Via Databroker
    • DATAGUARD CONFIGURATION SCRIPTS
  • 3
    Oracle 12C RAC
    • Oracle RAC Video 1 - How To Download Linux 6.5 ISO File
    • Oracle RAC Video 2 - Installing Your Virtual Machine
    • Downloading XMING Software
    • Oracle RAC Video 5 - Downloading Putty Software
    • Oracle RAC Video 6 - Creating Primary Node Virtual Machine
    • Oracle RAC Video 7 - Configuring Network Settings For Primary Node
    • Oracle RAC Video 8 - Installing OEL 6.5 To Virtual Machine
    • Oracle Rac Video 9 - Creating Second Node
    • Oracle Rac Video 10 - Configuring Network Settings On Node 2
    • Oracle Rac Video 11 - Establishing Connectivity Between The Two Nodes
    • Oracle Rac Video 12 - Fixing Eth0 and Eth1 Connectivity Issues
    • Oracle Rac Video 13 - Installing Yum Packages
    • Oracle Rac Video 14 - Installing WinSCP
    • Oracle RAC Video 15 - Transferring Database and Grid Infrastructure Software Files Via WinSCP
    • Oracle RAC Video 16 - Configuring Private , VIP And Scan Name Ip's For Connectivity
    • Oracle RAC Video 17 - Configuring Shared Storage
    • Oracle RAC Video 18 - Partitioning Hard Disks For Both Nodes
    • Oracle RAC Video 19 - Creating ASM Disks From Partitions
    • Oracle RAC Video 20 - Configuring Grid Infrastructure Pre-Requisites
    • Oracle RAC Video 21 - Configuring SSH Utility
    • Oracle RAC Video 22 - Running Grid Infrastructure Pre Check
    • Oracle RAC Video 23 - Installing Grid Infrastructure
    • Oracle RAC Video 24 - Creating Diskgroups Via ASMCA
    • Oracle RAC Video 25 - Installing Oracle Software On Both Nodes
    • Oracle RAC Video 26 - Creating Oracle Database On Both Nodes
    • Oracle RAC Video 27 - Setting Up RAC Connection
    • Oracle RAC Video 28 - Different Ways To Connect To Rac DB
    • Oracle RAC Video 29 - How To Use Srvctl Utility
    • Oracle RAC Video 30 - How To Stop A Database On An Instance
    • Oracle RAC Video 31 - How To Stop A Database On All Instances
    • Oracle RAC Video 32 - How To Start A Database On A Local Instances
    • Oracle RAC Video 33 - How To Locate The Spfile On Shared Storage
    • Oracle RAC Video 34 - Creating A Pfile From An Spfile In Rac
    • Oracle Rac Video 35 - Changing Spfile Parameters On All Nodes
    • Oracle RAC Video 36 - Putting Your Database In Archivelog Mode
    • Oracle RAC Video 37 - Backing Up Your RAC Database
    • Oracle RAC Video 38 - Creating Backup Jobs For Your Database
    • Oracle RAC Video 39 - Backing Up Your Database WIth Tags
    • Oracle RAC Video 40 - Using The Global View
    • Oracle RAC Video 41 - Using CRSCTL Utility
    • Oracle RAC Video 42 - Using Olsnodes Utility To Check The Number Of Nodes
    • Oracle RAC Video 43 - Shutting Down The Clusterware Resources
    • Oracle RAC Video 44 - Shutting Down The Clusterware Resources On A Local Node
    • Oracle RAC Video 45 - Enabling High Availability Service
    • Oracle RAC Video 46 - Creating User Friendly OCR Copies
    • Oracle RAC Video 47 - Performing Manual OCR Backups
    • Oracle RAC Video 48 - Understanding The OLR File
    • Oracle RAC Video 49 - Understanding The Voting Disks
    • Oracle Rac Video 50 - Verifying The Status Of Node Applications Via SRVCTL
    • Oracle Rac Video 51 - Understanding ASM Basics
    • Oracle Rac Video 52 - Understanding ASMCMD Basics
    • Oracle Rac Video 53 - Creating Directories VIA ASMCMD
    • Oracle Rac Video 54 - Creating A Service on A Local Node
    • Oracle Rac Video 55 - Modifying A Service
    • Oracle Rac Video 56 - Enabling And Relocating Services
    • Oracle Rac Video 57 - Creating TNS Entry For Dynamic Services
    • Oracle Rac Video 58 - Testing A Dynamic Services
    • Oracle Rac Video 59 - Testing A Dynamic Services From RAC2 Back To RAC1
    • Oracle Rac Video 60 - How To Create A One Node RAC Database
    • Oracle Rac Video 61 - How To Start A Service On A One Node RAC DB On 12c Release 1
    • Oracle Rac Video 62 - How To Relocate A One Node RAC DB On 12c Release 1
    • Oracle Rac Video 63 - How To Convert A One Node DB To A RAC Database
    • Oracle Rac Video 64 - Creating A Multitenant RAC Database
    • Oracle Rac Video 65 - Different Ways Of Connecting To A Single Node A RAC Database
    • Oracle Rac Video 66 - Getting The Status Of A Rac Database
    • Oracle Rac Video 67 - Connecting To A Of A Multitenant RAC Database
    • Oracle Rac Video 68 - Connecting To A Multitenant PDB RAC Database
    • Oracle Rac Video 69 - Closing To A Multitenant PDB RAC Database On A Particular Node
    • Oracle Rac Video 70 - Closing To A Multitenant PDB RAC Database On All Nodes
    • Oracle Rac Video 71 - Cloning A Multitenant PDB RAC Database On All Nodes
    • Oracle Rac Video 72 - Connecting To A Cloned Multinentant PDB
    • Oracle Rac Video 73 - Creating A Service For A Multitenant PDB
    • Oracle Rac Video 74 - Dropping A Multitenant PDB Via SQLPlus
    • Oracle Rac Video 75 - Dropping A Multinentant PDB and CDB Via DBCA
    • Oracle Rac Video 76 - Creating Serverpools
    • Oracle Rac Video 77 - Creating Policy Managed Database
    • Oracle Rac Video 78 - Connecting To Your Policy Managed Database
    • Oracle Rac Video 79 - Creating Dynamic Services For Your Policy Managed PDB Database
    • Oracle Rac Video 80 - Creating Labels For Serverpools
    • Oracle Rac Video 81 - Displaying Serverpool Configuration
    • Oracle Rac Video 82 - Removing Serverpool Labels and Server Categories
    • Oracle Rac Video 83 - Removing A Node From A CLuster - Part 1
    • Oracle Rac Video 84 - Removing A Node From A Cluster - Removing Oracle Home - Part 2
    • Oracle Rac Video 85 - Removing A Node From A Cluster - Removing Clusterware - Part 3
    • Oracle Rac Video 86 - Removing A Node From A Cluster - Deleting Node From Clusterware - Part 4
    • Oracle Rac Video 87 - Adding Node Incomplete
    • Oracle Rac Video 88 - Connecting To ASM Instance
    • Oracle Rac Video 89 - Determining Which DIskgroups are in Use By ASM
    • Oracle RAC Video 90 - Determing Which ASM Disks Are Not Members Of A Diskgroup
    • Oracle RAC Video 91 - Creating A New Diskgroup Via ASM Instance - External Redundancy
    • Oracle RAC Video 92 - Adding A Disk To A Diskgroup Via ASM Instance
    • Oracle RAC Video 93 - Removing A Disk From A Diskgroup
    • Oracle RAC Video 94 - Creating A New Diskgroup Via ASM Instance - Normal Redundancy
    • Oracle RAC Video 95 - Renaming A Diskgroup
    • Oracle RAC Video 96 - Navigating ASMCMD Utility
    • Oracle RAC Video 97 - Getting ASM Version and Patch Information
    • Oracle RAC Video 98 - Using LSDG Command
    • Oracle RAC Video 99 - Using LSDSK Command
    • Oracle RAC 100 - Using The Find And IOStats Command
    • Oracle RAC Video 101 - Creating New Hard Disks From Scratch
    • Oracle RAC Video 102 - Adding Second Node To New Disk
    • Oracle RAC Video 103 - Using Fdisk To Create Partitions
    • Oracle RAC Video 104 - Stamping Disks With Oracle ASM
    • Oracle RAC Video 105 - Adding Disks To A Diskgroup via ASMCA
    • RAC PRACTICE SCRIPTS
  • 4
    ORACLE 12C GOLDEN GATE
    • Downloading XMING Software
    • Downloading Putty Software
    • Installing Your Virtual Machine Video 1
    • Oracle RAC Video 1 - How To Download Linux 6.5 ISO File
    • Oracle GG Video 5 - Download Oracle Software From Edelivery Platform
    • Oracle Dataguard Video 1 - How To Create A New VM For The Primary Server Part 1
    • Oracle Dataguard Video 2 - How To Create A New VM For The Primary Server Part 2
    • Oracle GG Video 9 - HOw To Create A New VM For The Target Server Part 2a
    • Oracle GG Video 10 - How To Create A New VM For The Source Server Part 3a
    • Oracle GG Video 11 - How To Create A New VM For The Target Server Part 3a
    • Oracle Dataguard Video 6 - Adding Oracle User To Primary VM
    • Oracle Dataguard Video 8 - Adding Oracle User To Standby VM
    • Oracle GG Video 13 - Adding Oracle User To Target VM a
    • Oracle Dataguard Video 14 - Saving Your Machine State
    • Oracle Dataguard Video 15 - Configuring IP Address For Primary VM
    • Oracle GG Video 16 - Configuring IP Address For Target VMa
    • Oracle GG Video 17 - Installing YUM updates and Downloading Oracle Software on Source Server
    • Oracle GG Video 18 - Setting Up Communication Between The Primay and Standby VM'sa
    • Oracle GG Video 19 - Installing YUM updates and Downloading Oracle Software on Target Server
    • Oracle GG Video 20 - Installing Oracle Database on Source Server
    • Oracle GG Video 21 - Installing Oracle Database on Target Server
    • Oracle GG Video 22 - Installing Oracle GoldenGate Software For Edelivery Site
    • Oracle GG Video 23 - Copying Oracle GoldenGate Software Zip Files To VM's
    • Oracle GG Video 25 - Installing Oracle Golden Gate Software on Source and Target Servers
    • Oracle GG Video 26 - Adding Entries In The Bash Profile For Both Servers
    • Oracle GG Video 27 - Configuring Golden Gate Supplemental Logging For Both Servers
    • Oracle GG Video 28 - Configuring The Golden Gate Master User For Replication
    • Oracle GG Video 29 - Granting Admin Privileges To Golden Gate Master User For Replication
    • Oracle GG Video 30 - Adding Parameters In The Manager Process
    • Oracle GG Video 31 - Starting The Manager Process
    • Oracle GG Video 32 - Creating A Basic Table For Replication On Both Servers
    • Oracle GG Video 33 - Connecting To GG Via Master User
    • Oracle GG Video 34 - Adding Table Level Logging and Creating An Extract Process
    • Oracle GG Video 35 - Adding A Trail File Locaton For Extract Process
    • Oracle GG Video 36 - Creating Parameter File For Extra Process
    • Oracle GG Video 37 - Creating A Datapump Process
    • Oracle GG Video 38 - Creating A Remote Trail For The Datapump Process
    • Oracle GG Video 39 - Creating A Parameter File For The Datapump Process
    • Oracle GG Video 40 - Creating The Replicat Process
    • Oracle GG Video 41 - Creating Parameters For The Replicat Process
    • Oracle GG Video 42 - Starting Golden Gate Processes on Source Server
    • Oracle GG Video 43 - Starting Golden Gate Replicat Processes on Target Server
    • Oracle GG Video 44 - Basic Replication Unifnished
    • Oracle GG Video 45 - Performance Tuning - Fixing Replication Issues
    • Oracle GG Video 46 - Fixing Performance Issues - Handle Collission Clause
    • Oracle GG Video 47 - Issuing Delete In Golden Gate
    • Oracle GG Video 48 - Issuing Insert In Golden Gate
    • Oracle GG Video 49 - Issuing Updates In Golden Gate
    • Oracle GG Video 50 - Golden Gate Basic Command - Info All and Help Command
    • Oracle GG Video 51 - Golden Gate Command - Detail Flag
    • Oracle GG Video 52 - Golden Gate Basic Command - View Parameters
    • Oracle GG Video 53 - Golden Gate Basic Commands - Stats
    • Oracle GG Video 54 - Single Table Initial Load Part 1
    • Oracle GG Video 55 - Single Table Initial Load Part 2
    • Oracle GG Video 56 - Single Table Initial Load - Adding Initial Load Extract - Part 3
    • Oracle GG Video 57 - Single Table Load Part 4 - Performing Change Synch and Initial Load Extract
    • Oracle GG Video 58 - Performing Replication With Different Schema Definitions Part 1
    • Oracle GG Video 59 - Performing Replication With Different Schema Definitions Part 2
    • Oracle GG Video 60 - Performing Replication With Different Schema Definitions Part 3
    • Oracle GG Video 61 - Performing Replication With Different Schema Definitions Part 4
    • Oracle GG Video 62 - Performing Replication With Different Schema Definitions Part 5
    • Oracle GG Video 63 - Performing Delete Operation On Schemas With Columns
    • Performing Update Operation On Tables With Data Mapped To Diff Columns
    • Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1
    • Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2
    • Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1
    • Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2
    • Oracle GG Video 67 - Updating Data Mapped To Columns With Different Names Part 3
    • Oracle GG Video 68 - Golden Gate Filter Functions - Understanding Case Filter
    • Oracle GG Video 69 - Golden Gate Filter Functions - Understanding Eval Filter
    • Oracle GG Video 70 - Golden Gate Filter Functions - Understanding IF Filter
    • Oracle GG Video 71 - Golden Gate Filter Functions - Understanding DATENOW Filter
    • Oracle GG Video 72 - Golden Gate Filter Functions - Understanding DATEDIFF Filter
    • Oracle GG Video 73 - Golden Gate Filter Functions - Understanding COLSTAT Filter
    • Oracle GG Video 74 - Golden Gate Filter Functions - Understanding COLTEST Filter
    • Oracle GG Video 75 - Golden Gate Filter Functions - Understanding NUMSTR Filter
    • Oracle GG Video 76 - Golden Gate Filter Functions - Understanding STRNUM Filter
    • Oracle GG Video 77 - Golden Gate Filter Functions - Understanding STRUP Filter
    • Oracle GG Video 78 - Golden Gate Filter Functions - Understanding COMPUTE Filter
    • Oracle GG Video 79 - Golden Gate - Setting Up DDL Replication
    • Oracle GG Video 80 - Golden Gate - Performing DDL Transactions
    • Oracle GG Video 81 - Golden Gate - SCHEMA Replication
    • Oracle GG Video 82 - Golden Gate - DDL AND DML SCHEMA REPLICATION
    • Oracle GG Video 83 - Golden Gate - Bidirectional Replication
    • Oracle GG Video 84 - Golden Gate - Trouble Shooting Abended Processes
    • Oracle GG Video 85 - Golden Gate - Confirming Bi-Directional Replication
    • Oracle GG Video 86 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 1
    • Oracle GG Video 87 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 2
    • Oracle GG Video 88 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 3
    • GOLDEN GATE BI-DIRECTIONAL PART 1
    • GOLDEN GATE BI-DIRECTIONAL PART 2
    • GOLDEN GATE EXPRESSIONS

Course Cost