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 Real Application Clusters Classroom Lecture Video 1

    2. Oracle Real Application Clusters Classroom Lecture Video 2

    3. Oracle Real Application Clusters Classroom Lecture Video 3

    4. Oracle Real Application Clusters Classroom Lecture Video 4

    5. Oracle Real Application Clusters Classroom Lecture Video 5

    6. Oracle Real Application Clusters Classroom Lecture Video 6

    7. Oracle Real Application Clusters Classroom Lecture Video 7

    8. Oracle Real Application Clusters Classroom Lecture Video 8

    9. Oracle Real Application Clusters Classroom Lecture Video 9

    10. Oracle Real Application Clusters Classroom Lecture Video 10

    11. Oracle Real Application Clusters Classroom Lecture Video 11

    12. Oracle Real Application Clusters Classroom Lecture Video 12

    13. Oracle Real Application Clusters Classroom Lecture Video 13

    14. Oracle Real Application Clusters Classroom Lecture Video 14

    15. Oracle Real Application Clusters Classroom Lecture Video 15

    16. Oracle Real Application Clusters Classroom Lecture Video 16

    17. Oracle Real Application Clusters Classroom Lecture Video 17

    18. Oracle Real Application Clusters Classroom Lecture Video 18

    19. Oracle Real Application Clusters Classroom Lecture Video 19

    20. Oracle Real Application Clusters Classroom Lecture Video 20

    21. Oracle Real Application Clusters Classroom Lecture Video 21

    22. Oracle Real Application Clusters Classroom Lecture Video 22

    23. Oracle Real Application Clusters Classroom Lecture Video 23

    24. Oracle Real Application Clusters Classroom Lecture Video 24

    25. Oracle Real Application Clusters Classroom Lecture Video 25

    26. Oracle Real Application Clusters Classroom Lecture Video 26

    27. Oracle Real Application Clusters Classroom Lecture Video 27

    28. Oracle Real Application Clusters Installation Video 1

    29. Oracle Real Application Clusters Installation Video 2

    30. Oracle Real Application Clusters Installation Video 3

    31. Oracle Real Application Clusters Installation Video 4

    32. Oracle Real Application Clusters Installation Video 5

    33. Oracle Real Application Clusters Installation Video 6

    34. Oracle Real Application Clusters Installation Video 7

    35. Oracle Real Application Clusters Installation Video 8

    36. Oracle Real Application Clusters Installation Video 9

    37. Oracle Real Application Clusters Installation Video 10

    38. Oracle Real Application Clusters Installation Video 11

    39. Oracle Real Application Clusters Installation Video 12a

    40. Oracle Real Application Cluster Installation Video 12b

    41. Oracle Real Application Clusters Installation Video 12

    42. Oracle Real Application Clusters Installation Video 13

    43. Oracle Real Application Clusters Installation Video 14

    44. Oracle Real Application Clusters Installation Video 15

    45. Grid Infrastructure Commands

    46. RAC RPMS

    47. ORACLE REAL APPLICATION CONFIGURATION SCRIPTS

    1. Data Guard Class Lecture

    2. Dataguard Pre-Installation Video 1

    3. Dataguard Pre-Installation Part 2

    4. Dataguard Pre-Installation Part 3

    5. Dataguard Pre-Installation Part 4

    6. Changing Modes In Dataguard Configuration part 1

    7. Changing Modes In Dataguard Configuration part 2

    8. Changing Modes In Dataguard Configuration part 3

    9. Verifying Archived Logs Are Applying To Standby Database

    10. Inserting Data Into Primary Database In a Datguard Environment

    11. Converting From Standby to Snapshot Database

    12. Converting From A Snapshot To A Physical Standby Database

    13. Performing A Switchover From Primary To Standby

    14. How To Resolve "Resolvable Gap Issues"

    15. How To Perform A Switchover From Standby To Primary

    16. How To Configure Data Broker

    17. Changing Protection Modes Via Data Guard Broker

    18. Performing A Switch Over Via Databroker

    19. DATAGUARD CONFIGURATION SCRIPTS

    1. Oracle RAC Video 1 - How To Download Linux 6.5 ISO File

    2. Oracle RAC Video 2 - Installing Your Virtual Machine

    3. Downloading XMING Software

    4. Oracle RAC Video 5 - Downloading Putty Software

    5. Oracle RAC Video 6 - Creating Primary Node Virtual Machine

    6. Oracle RAC Video 7 - Configuring Network Settings For Primary Node

    7. Oracle RAC Video 8 - Installing OEL 6.5 To Virtual Machine

    8. Oracle Rac Video 9 - Creating Second Node

    9. Oracle Rac Video 10 - Configuring Network Settings On Node 2

    10. Oracle Rac Video 11 - Establishing Connectivity Between The Two Nodes

    11. Oracle Rac Video 12 - Fixing Eth0 and Eth1 Connectivity Issues

    12. Oracle Rac Video 13 - Installing Yum Packages

    13. Oracle Rac Video 14 - Installing WinSCP

    14. Oracle RAC Video 15 - Transferring Database and Grid Infrastructure Software Files Via WinSCP

    15. Oracle RAC Video 16 - Configuring Private , VIP And Scan Name Ip's For Connectivity

    16. Oracle RAC Video 17 - Configuring Shared Storage

    17. Oracle RAC Video 18 - Partitioning Hard Disks For Both Nodes

    18. Oracle RAC Video 19 - Creating ASM Disks From Partitions

    19. Oracle RAC Video 20 - Configuring Grid Infrastructure Pre-Requisites

    20. Oracle RAC Video 21 - Configuring SSH Utility

    21. Oracle RAC Video 22 - Running Grid Infrastructure Pre Check

    22. Oracle RAC Video 23 - Installing Grid Infrastructure

    23. Oracle RAC Video 24 - Creating Diskgroups Via ASMCA

    24. Oracle RAC Video 25 - Installing Oracle Software On Both Nodes

    25. Oracle RAC Video 26 - Creating Oracle Database On Both Nodes

    26. Oracle RAC Video 27 - Setting Up RAC Connection

    27. Oracle RAC Video 28 - Different Ways To Connect To Rac DB

    28. Oracle RAC Video 29 - How To Use Srvctl Utility

    29. Oracle RAC Video 30 - How To Stop A Database On An Instance

    30. Oracle RAC Video 31 - How To Stop A Database On All Instances

    31. Oracle RAC Video 32 - How To Start A Database On A Local Instances

    32. Oracle RAC Video 33 - How To Locate The Spfile On Shared Storage

    33. Oracle RAC Video 34 - Creating A Pfile From An Spfile In Rac

    34. Oracle Rac Video 35 - Changing Spfile Parameters On All Nodes

    35. Oracle RAC Video 36 - Putting Your Database In Archivelog Mode

    36. Oracle RAC Video 37 - Backing Up Your RAC Database

    37. Oracle RAC Video 38 - Creating Backup Jobs For Your Database

    38. Oracle RAC Video 39 - Backing Up Your Database WIth Tags

    39. Oracle RAC Video 40 - Using The Global View

    40. Oracle RAC Video 41 - Using CRSCTL Utility

    41. Oracle RAC Video 42 - Using Olsnodes Utility To Check The Number Of Nodes

    42. Oracle RAC Video 43 - Shutting Down The Clusterware Resources

    43. Oracle RAC Video 44 - Shutting Down The Clusterware Resources On A Local Node

    44. Oracle RAC Video 45 - Enabling High Availability Service

    45. Oracle RAC Video 46 - Creating User Friendly OCR Copies

    46. Oracle RAC Video 47 - Performing Manual OCR Backups

    47. Oracle RAC Video 48 - Understanding The OLR File

    48. Oracle RAC Video 49 - Understanding The Voting Disks

    49. Oracle Rac Video 50 - Verifying The Status Of Node Applications Via SRVCTL

    50. Oracle Rac Video 51 - Understanding ASM Basics

    51. Oracle Rac Video 52 - Understanding ASMCMD Basics

    52. Oracle Rac Video 53 - Creating Directories VIA ASMCMD

    53. Oracle Rac Video 54 - Creating A Service on A Local Node

    54. Oracle Rac Video 55 - Modifying A Service

    55. Oracle Rac Video 56 - Enabling And Relocating Services

    56. Oracle Rac Video 57 - Creating TNS Entry For Dynamic Services

    57. Oracle Rac Video 58 - Testing A Dynamic Services

    58. Oracle Rac Video 59 - Testing A Dynamic Services From RAC2 Back To RAC1

    59. Oracle Rac Video 60 - How To Create A One Node RAC Database

    60. Oracle Rac Video 61 - How To Start A Service On A One Node RAC DB On 12c Release 1

    61. Oracle Rac Video 62 - How To Relocate A One Node RAC DB On 12c Release 1

    62. Oracle Rac Video 63 - How To Convert A One Node DB To A RAC Database

    63. Oracle Rac Video 64 - Creating A Multitenant RAC Database

    64. Oracle Rac Video 65 - Different Ways Of Connecting To A Single Node A RAC Database

    65. Oracle Rac Video 66 - Getting The Status Of A Rac Database

    66. Oracle Rac Video 67 - Connecting To A Of A Multitenant RAC Database

    67. Oracle Rac Video 68 - Connecting To A Multitenant PDB RAC Database

    68. Oracle Rac Video 69 - Closing To A Multitenant PDB RAC Database On A Particular Node

    69. Oracle Rac Video 70 - Closing To A Multitenant PDB RAC Database On All Nodes

    70. Oracle Rac Video 71 - Cloning A Multitenant PDB RAC Database On All Nodes

    71. Oracle Rac Video 72 - Connecting To A Cloned Multinentant PDB

    72. Oracle Rac Video 73 - Creating A Service For A Multitenant PDB

    73. Oracle Rac Video 74 - Dropping A Multitenant PDB Via SQLPlus

    74. Oracle Rac Video 75 - Dropping A Multinentant PDB and CDB Via DBCA

    75. Oracle Rac Video 76 - Creating Serverpools

    76. Oracle Rac Video 77 - Creating Policy Managed Database

    77. Oracle Rac Video 78 - Connecting To Your Policy Managed Database

    78. Oracle Rac Video 79 - Creating Dynamic Services For Your Policy Managed PDB Database

    79. Oracle Rac Video 80 - Creating Labels For Serverpools

    80. Oracle Rac Video 81 - Displaying Serverpool Configuration

    81. Oracle Rac Video 82 - Removing Serverpool Labels and Server Categories

    82. Oracle Rac Video 83 - Removing A Node From A CLuster - Part 1

    83. Oracle Rac Video 84 - Removing A Node From A Cluster - Removing Oracle Home - Part 2

    84. Oracle Rac Video 85 - Removing A Node From A Cluster - Removing Clusterware - Part 3

    85. Oracle Rac Video 86 - Removing A Node From A Cluster - Deleting Node From Clusterware - Part 4

    86. Oracle Rac Video 87 - Adding Node Incomplete

    87. Oracle Rac Video 88 - Connecting To ASM Instance

    88. Oracle Rac Video 89 - Determining Which DIskgroups are in Use By ASM

    89. Oracle RAC Video 90 - Determing Which ASM Disks Are Not Members Of A Diskgroup

    90. Oracle RAC Video 91 - Creating A New Diskgroup Via ASM Instance - External Redundancy

    91. Oracle RAC Video 92 - Adding A Disk To A Diskgroup Via ASM Instance

    92. Oracle RAC Video 93 - Removing A Disk From A Diskgroup

    93. Oracle RAC Video 94 - Creating A New Diskgroup Via ASM Instance - Normal Redundancy

    94. Oracle RAC Video 95 - Renaming A Diskgroup

    95. Oracle RAC Video 96 - Navigating ASMCMD Utility

    96. Oracle RAC Video 97 - Getting ASM Version and Patch Information

    97. Oracle RAC Video 98 - Using LSDG Command

    98. Oracle RAC Video 99 - Using LSDSK Command

    99. Oracle RAC 100 - Using The Find And IOStats Command

    100. Oracle RAC Video 101 - Creating New Hard Disks From Scratch

    101. Oracle RAC Video 102 - Adding Second Node To New Disk

    102. Oracle RAC Video 103 - Using Fdisk To Create Partitions

    103. Oracle RAC Video 104 - Stamping Disks With Oracle ASM

    104. Oracle RAC Video 105 - Adding Disks To A Diskgroup via ASMCA

    105. RAC PRACTICE SCRIPTS

    1. Downloading XMING Software

    2. Downloading Putty Software

    3. Installing Your Virtual Machine Video 1

    4. Oracle RAC Video 1 - How To Download Linux 6.5 ISO File

    5. Oracle GG Video 5 - Download Oracle Software From Edelivery Platform

    6. Oracle Dataguard Video 1 - How To Create A New VM For The Primary Server Part 1

    7. Oracle Dataguard Video 2 - How To Create A New VM For The Primary Server Part 2

    8. Oracle GG Video 9 - HOw To Create A New VM For The Target Server Part 2a

    9. Oracle GG Video 10 - How To Create A New VM For The Source Server Part 3a

    10. Oracle GG Video 11 - How To Create A New VM For The Target Server Part 3a

    11. Oracle Dataguard Video 6 - Adding Oracle User To Primary VM

    12. Oracle Dataguard Video 8 - Adding Oracle User To Standby VM

    13. Oracle GG Video 13 - Adding Oracle User To Target VM a

    14. Oracle Dataguard Video 14 - Saving Your Machine State

    15. Oracle Dataguard Video 15 - Configuring IP Address For Primary VM

    16. Oracle GG Video 16 - Configuring IP Address For Target VMa

    17. Oracle GG Video 17 - Installing YUM updates and Downloading Oracle Software on Source Server

    18. Oracle GG Video 18 - Setting Up Communication Between The Primay and Standby VM'sa

    19. Oracle GG Video 19 - Installing YUM updates and Downloading Oracle Software on Target Server

    20. Oracle GG Video 20 - Installing Oracle Database on Source Server

    21. Oracle GG Video 21 - Installing Oracle Database on Target Server

    22. Oracle GG Video 22 - Installing Oracle GoldenGate Software For Edelivery Site

    23. Oracle GG Video 23 - Copying Oracle GoldenGate Software Zip Files To VM's

    24. Oracle GG Video 25 - Installing Oracle Golden Gate Software on Source and Target Servers

    25. Oracle GG Video 26 - Adding Entries In The Bash Profile For Both Servers

    26. Oracle GG Video 27 - Configuring Golden Gate Supplemental Logging For Both Servers

    27. Oracle GG Video 28 - Configuring The Golden Gate Master User For Replication

    28. Oracle GG Video 29 - Granting Admin Privileges To Golden Gate Master User For Replication

    29. Oracle GG Video 30 - Adding Parameters In The Manager Process

    30. Oracle GG Video 31 - Starting The Manager Process

    31. Oracle GG Video 32 - Creating A Basic Table For Replication On Both Servers

    32. Oracle GG Video 33 - Connecting To GG Via Master User

    33. Oracle GG Video 34 - Adding Table Level Logging and Creating An Extract Process

    34. Oracle GG Video 35 - Adding A Trail File Locaton For Extract Process

    35. Oracle GG Video 36 - Creating Parameter File For Extra Process

    36. Oracle GG Video 37 - Creating A Datapump Process

    37. Oracle GG Video 38 - Creating A Remote Trail For The Datapump Process

    38. Oracle GG Video 39 - Creating A Parameter File For The Datapump Process

    39. Oracle GG Video 40 - Creating The Replicat Process

    40. Oracle GG Video 41 - Creating Parameters For The Replicat Process

    41. Oracle GG Video 42 - Starting Golden Gate Processes on Source Server

    42. Oracle GG Video 43 - Starting Golden Gate Replicat Processes on Target Server

    43. Oracle GG Video 44 - Basic Replication Unifnished

    44. Oracle GG Video 45 - Performance Tuning - Fixing Replication Issues

    45. Oracle GG Video 46 - Fixing Performance Issues - Handle Collission Clause

    46. Oracle GG Video 47 - Issuing Delete In Golden Gate

    47. Oracle GG Video 48 - Issuing Insert In Golden Gate

    48. Oracle GG Video 49 - Issuing Updates In Golden Gate

    49. Oracle GG Video 50 - Golden Gate Basic Command - Info All and Help Command

    50. Oracle GG Video 51 - Golden Gate Command - Detail Flag

    51. Oracle GG Video 52 - Golden Gate Basic Command - View Parameters

    52. Oracle GG Video 53 - Golden Gate Basic Commands - Stats

    53. Oracle GG Video 54 - Single Table Initial Load Part 1

    54. Oracle GG Video 55 - Single Table Initial Load Part 2

    55. Oracle GG Video 56 - Single Table Initial Load - Adding Initial Load Extract - Part 3

    56. Oracle GG Video 57 - Single Table Load Part 4 - Performing Change Synch and Initial Load Extract

    57. Oracle GG Video 58 - Performing Replication With Different Schema Definitions Part 1

    58. Oracle GG Video 59 - Performing Replication With Different Schema Definitions Part 2

    59. Oracle GG Video 60 - Performing Replication With Different Schema Definitions Part 3

    60. Oracle GG Video 61 - Performing Replication With Different Schema Definitions Part 4

    61. Oracle GG Video 62 - Performing Replication With Different Schema Definitions Part 5

    62. Oracle GG Video 63 - Performing Delete Operation On Schemas With Columns

    63. Performing Update Operation On Tables With Data Mapped To Diff Columns

    64. Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1

    65. Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2

    66. Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1

    67. Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2

    68. Oracle GG Video 67 - Updating Data Mapped To Columns With Different Names Part 3

    69. Oracle GG Video 68 - Golden Gate Filter Functions - Understanding Case Filter

    70. Oracle GG Video 69 - Golden Gate Filter Functions - Understanding Eval Filter

    71. Oracle GG Video 70 - Golden Gate Filter Functions - Understanding IF Filter

    72. Oracle GG Video 71 - Golden Gate Filter Functions - Understanding DATENOW Filter

    73. Oracle GG Video 72 - Golden Gate Filter Functions - Understanding DATEDIFF Filter

    74. Oracle GG Video 73 - Golden Gate Filter Functions - Understanding COLSTAT Filter

    75. Oracle GG Video 74 - Golden Gate Filter Functions - Understanding COLTEST Filter

    76. Oracle GG Video 75 - Golden Gate Filter Functions - Understanding NUMSTR Filter

    77. Oracle GG Video 76 - Golden Gate Filter Functions - Understanding STRNUM Filter

    78. Oracle GG Video 77 - Golden Gate Filter Functions - Understanding STRUP Filter

    79. Oracle GG Video 78 - Golden Gate Filter Functions - Understanding COMPUTE Filter

    80. Oracle GG Video 79 - Golden Gate - Setting Up DDL Replication

    81. Oracle GG Video 80 - Golden Gate - Performing DDL Transactions

    82. Oracle GG Video 81 - Golden Gate - SCHEMA Replication

    83. Oracle GG Video 82 - Golden Gate - DDL AND DML SCHEMA REPLICATION

    84. Oracle GG Video 83 - Golden Gate - Bidirectional Replication

    85. Oracle GG Video 84 - Golden Gate - Trouble Shooting Abended Processes

    86. Oracle GG Video 85 - Golden Gate - Confirming Bi-Directional Replication

    87. Oracle GG Video 86 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 1

    88. Oracle GG Video 87 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 2

    89. Oracle GG Video 88 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 3

    90. GOLDEN GATE BI-DIRECTIONAL PART 1

    91. GOLDEN GATE BI-DIRECTIONAL PART 2

    92. GOLDEN GATE EXPRESSIONS

About this course

  • $3,500.00
  • 263 lessons
  • 32.5 hours of video content

Course Cost