The Oracle Database RAC Administration Course (12c and 19c)

1. Welcome to the Course

In this video, we will delve into the Oracle database RAC administration course, guiding us through the process of building and managing Oracle 12C RAC databases. From understanding database architecture to implementing load balancing, this extensive course, led by experienced instructor Ahmed Baraka, covers key skills essential for Oracle DBAs seeking proficiency in RAC administration.

1. Oracle RAC Database Overview

In this foundational video of Oracle database RAC administration, the video covers an in-depth overview of Oracle RAC database. The video delves into the advantages, disadvantages, and crucial reasons for acquiring skills in Oracle database RAC administration.

2. Oracle RAC Architecture Part 1 of 3

In this comprehensive video, we will explore the architecture of an Oracle RAC database in detail. The video covers crucial aspects such as hardware requirements, shared storage configurations, Oracle Grid Infrastructure components, network configurations, and database file locations.

3. Oracle RAC Architecture Part 2 of 3

In this video, we will focus on delving deeper into the Oracle Grid Infrastructure software, explaining its role in managing resources through the Clusterware. The video covers crucial components such as the Clusterware-managed resources, Oracle Clusterware Registry, Oracle Local Registry, network profiles, and the key processes in Clusterware operations.

4. Oracle RAC Architecture Part 3 of 3

In this video, we will focus on network configuration choices and their implications, comparing Oracle Grid Naming Service (GNS) and static IP address configuration options. The video details the setup processes, explains the significance of DNS configurations, and delves into the intricate connection lifecycle between clients and Oracle RAC instances.

1. Installing and Creating Oracle RAC

In this video, the installation process of the Oracle RAC software stack is explained in detail. Covering the sequential steps involving the installation of Oracle Grid Infrastructure, Oracle database software, and the creation of an Oracle RAC database, the video offers insights into system requirements, user configuration, networking choices, and different installation methods.

2. Practice 1 Preparing Practice Environment Part 1 of 4

In this practice video, the setup and preparation of the practice environment for Oracle database RAC administration are demonstrated step-by-step. The video covers the configuration requirements of Oracle VirtualBox, network setup, software downloads, and adjustments within the virtual machines to facilitate Oracle RAC installation.

3. Practice 1 Preparing Practice Environment Part 2 of 4

In this practice video, the setup of network adapters, IP address assignment, and various configurations necessary for preparing the environment for Oracle database RAC administration are demonstrated. The video covers network adapter renaming, setting static IP addresses, configuration validation, and firewall settings adjustments within the virtual machine.

4. Practice 1 Preparing Practice Environment Part 3 of 4

In this practice video, the process of setting up a shared folder, cloning a virtual machine, and reinitializing network cards for Oracle database RAC administration is demonstrated. The video covers steps to share folders, clone a machine, update network adapter settings, and verify connections between virtual machines.

5. Practice 1 Preparing Practice Environment Part 4 of 4

In this practice video, the creation of shared storage disks, configuration, and attachment to virtual machines are demonstrated. The video includes steps to create and configure shared disks, change disk types, attach disks to virtual machines, and verify their visibility in the ASM (Automatic Storage Management) library.

6. Practice 2 Create Oracle 12c R1 Two-Node RAC Database Part 1 of 4

In this practice video, we will delve into creating an Oracle 12c R1 two-node RAC database. The video guides us through essential steps including OS preparation, Grid Infrastructure installation, ASM disk group creation, Oracle database installation, and the final setup of the RAC database. Additionally, we will learn about VM environment setups, crucial configurations, and user profile adjustments necessary for successful deployment.

7. Practice 2 Create Oracle 12c R1 Two-Node RAC Database Part 2 of 4

In this practice video, the mounting of data and FRA disk groups in Oracle VirtualBox, along with the installation of Oracle database software and resolving installation issues, is demonstrated. The video covers steps to create disk groups, install the Oracle database software, execute fix-up scripts, and ensure successful installation on multiple nodes.

8. Practice 2 Create Oracle 12c R1 Two-Node RAC Database Part 3 of 4

In this practice video, we will learn the step-by-step process of creating an Oracle RAC database in Oracle VirtualBox. Covering the DBCA utility setup, configuration options, database file storage, memory settings, and initial checks, this walkthrough ensures a comprehensive understanding of setting up a functional RAC database.

9. Practice 2 Create Oracle 12c R1 Two-Node RAC Database Part 4 of 4

In this practice video, learn the proper shutdown procedure for an Oracle RAC database and the cluster technology stack. Additionally, explore steps to relocate virtual machines, including the process of exporting, copying shared disks, and reattaching them. The video concludes with guidance on configuring EM database Express in the virtual machine environment.

1. Oracle RAC Basic Administration Part 1 of 2

In this video, explore the fundamentals of Oracle RAC basic administration. Learn about starting up and shutting down Oracle RAC databases, switching between management policies, managing initialization parameters, undo, videos, and accessing performance views specific to RAC databases.

2. Oracle RAC Basic Administration Part 2 of 2

In this video, delve into managing initialization parameters, active undo table spaces, video termination, and accessing performance views specific to Oracle RAC databases. Learn the differences in managing parameters in RAC versus single-instance databases and explore various methods for managing these configurations.

3. Practice 3 Oracle RAC Administration Topics Part 1 of 3

In this practice video, explore and test various authentication methods to connect to Oracle RAC databases, including operating system authentication, password file authentication, and Oracle database authentication. Learn about Easy Connect, a local naming method while configuring tnsnames.ora to establish connections to specific instances within the Oracle RAC database.

4. Practice 3 Oracle RAC Administration Topics Part 2 of 3

In this practice video, the demonstration focuses on starting up and shutting down Oracle RAC instances and databases using the srvctl utility. Various commands are shown, including status checks, startup, and shutdown commands for instances and the database, emphasizing the management of Oracle RAC components within an Oracle Home.

5. Practice 3 Oracle RAC Administration Topics Part 3 of 3

In this practice video, the focus is on managing initialization parameters in an Oracle RAC database, exploring how to modify parameters in the spfile, understanding different parameter values in memory and the SP file, and resetting parameter values in various instances.

6. Managing Backup and Recovery in Oracle RAC

In this video, the focus is on understanding backup and recovery management in Oracle RAC, covering various considerations, such as archived log management, control file backups, and RMAN parallelism in the context of Oracle RAC databases.

7. Practice 4 Managing Backup and Recovery in Oracle RAC

In this practice video, various aspects of Oracle database RAC administration related to backup and recovery are covered. It includes enabling archive log mode, configuring backup settings, creating automatic backup jobs, setting snapshot control files in shared locations, using RMAN for backups and restores in Oracle RAC with parallelism enabled.

8. Practice 5 Installing and Using Swingbench 2.5

In this practice video, we are guided through the installation and setup of Swingbench 2.5, a load generator tool for Oracle databases. The video covers downloading and installing Oracle client software, configuring the tnsnames.ora file, installing Swingbench 2.5, setting up the order entry schema, and getting familiar with Swingbench functionality.

9. Practice 6 Getting Familiar with Oracle EM Database Express

In this practice video, viewers are guided through the utilization of Oracle Enterprise Manager (EM) Database Express in Oracle Database RAC Administration. The video covers applying workloads using Swingbench, performing basic administration functions, and leveraging EM Database Express for performance monitoring and management.

1. Global Resource Management in Oracle RAC

In this video, we will delve into global resource management in Oracle RAC. Exploring concepts such as global concurrency control, global resource directory, mastering and shadowing instances, and global cache management scenarios for single block access, this video provides insights into the intricate internal workings of Oracle RAC's resource allocation and access mechanisms.

2. Monitoring and Tuning Oracle RAC Database - Part 1 of 2

In this video, we will focus on monitoring and tuning the Oracle RAC database. Covering tools for performance tuning, understanding global cache wait events, common RAC-related performance issues, and their solutions, this video offers insights into optimizing the performance of Oracle RAC databases.

3. Monitoring and Tuning Oracle RAC Database - Part 2 of 2

In this video, we will delve into the specifics of Oracle database RAC administration, focusing on performance tuning tools and techniques. The video covers understanding various types of enqueues, crucial statistics for performance diagnosis, tips for performance tuning in RAC, and insights into tools such as AWR, ASH, and ADDM to optimize Oracle RAC performance.

4. Practice 7 Monitoring and Tuning Oracle RAC Database - Part 1 of 3

In this practice video, we will learn essential techniques to monitor and fine-tune an Oracle RAC database, covering steps to check cluster resources, RAC database status, GRD memory usage impact, and using EM Express to tune slow videos. The video concludes with implementing a solution to resolve a performance issue in a reporting scenario.

5. Practice 7 Monitoring and Tuning Oracle RAC Database - Part 2 of 3

In this practice video, explore the impact of sequences in Oracle databases for generating primary key values. The video demonstrates performance analysis between using sequences and tables for primary key generation and investigates the efficiency gain by increasing the sequence cache size in a real-time case study.

6. Practice 7 Monitoring and Tuning Oracle RAC Database - Part 3 of 3

In this practice video, explore transaction queue issues and delve into the intricacies of the enqueue wait event in Oracle RAC databases. Learn to utilize AWR reports to troubleshoot and resolve performance problems, utilizing comparison reports and SQL analysis to identify and address problematic statements causing transaction delays.

1. Managing Dynamic Database Services

In this video, discover the crucial aspects of managing dynamic database services in Oracle RAC. Explore the benefits, creation, modification, relocation, and utilization of database services, highlighting how these services facilitate performance optimization, load balancing, failover, and resource allocation within a RAC environment.

2. Practice 8 Managing Services in Oracle RAC

In this practice video, we will navigate through managing dynamic database services in Oracle RAC. Learn to create, configure, test failover functionality, relocate services between instances, and collect statistics by module and action to optimize performance tuning.

3. Implementing Connection Load Balancing and TAF - Part 1 of 2

In this video, delve into implementing connection load balancing and Transparent Application Failover (TAF) in Oracle RAC administration. Learn the setup of Client-Side Connect Time Load Balancing, Server-Side Connect Time Load Balancing, Load Balancing Advisory (LBA), TAF on client and server sides, Fast Connection Failover (FCF), and Fast Application Notification (FAN).

4. Implementing Connection Load Balancing and TAF - Part 2 of 2

In this video, explore Transparent Application Failover (TAF), its types, configuration on both the client and server sides, alongside detailed guidance on configuring Fast Application Notification (FAN) and Fast Connection Failover (FCF). Gain insights into setting up various failover methods and efficiently utilizing Oracle RAC administration's high availability features.

5. Practice 9 Implementing Connection Load Balancing and TAF - Part 1 of 3

In this practice video, we will explore various high availability methods for client connections in Oracle RAC databases. Covering setups such as client-side connect time load balancing, server-side connect time load balancing, Load Balancing Advisory (LBA), Transparent Application Failover (TAF) configurations, including basic TAF on server-side and preconnect TAF on both client and server sides.

6. Practice 9 Implementing Connection Load Balancing and TAF - Part 2 of 3

In this practice video, we will configure Load Balancing Advisory (LBA) in the lbrsrv service and test connection distribution among nodes under varying loads. Additionally, we will set up client-side Transparent Application Failover (TAF), execute tests involving failover configurations, and observe video behavior during node crashes.

7. Practice 9 Implementing Connection Load Balancing and TAF - Part 3 of 3

In this practice video, we will configure various Transparent Application Failover (TAF) settings-Basic TAF, Preconnect TAF-both client-side and server-side configurations. Additionally, we will set up Load Balancing Advisory (LBA) and perform tests on the configurations created in Oracle database RAC administration.

8. Using Application Continuity

In this video, we will explore the functionalities of Application Continuity within Oracle database RAC administration. We will grasp its benefits, transaction guard specifics, understand its operational restrictions, and learn how to set up services to enable Application Continuity and Transaction Guard.

9. Practice 10 Using Application Continuity

In this practice video, we will explore implementing Application Continuity within an Oracle database RAC scenario. Demonstrations include running Java applications with and without Application Continuity enabled, showcasing their reactions to RAC instance failures and recovery processes.

1. Patching Oracle RAC - Part 1 of 2

In this video, we delve into the process of patching Oracle RAC, exploring various patch types, methods for applying patches on RAC, and understanding best practices using utilities such as OPatch for patch application.

2. Patching Oracle RAC - Part 2 of 2

In this video, the focus is on utilizing the OPatch utility for applying patches in Oracle RAC, understanding its functionality, prerequisites, application methods, and employing best practices to manage patches effectively.

3. Practice 11 Applying Patch Set Update (PSU) - Part 1 of 2

In this practice video, the process of applying Patch Set Update (PSU) number 663-5815 to the Oracle RAC database stack, including Grid Infrastructure and Database Home, is demonstrated. The steps involve preparation, PSU extraction, OPatch upgrade, disabling backup jobs, and taking a complete database backup.

4. Practice 11 Applying Patch Set Update (PSU) - Part 2 of 2

In this practice video, the process of creating a service, setting up client videos, connecting to the database, and examining client video responses during the application of Patch Set Update (PSU) on the Oracle RAC database is detailed step-by-step.

5. Upgrading Oracle RAC

In this video, the video covers essential aspects of upgrading Oracle RAC, explaining the difference between upgrading and data migration, Oracle release number format, the RAC upgrade procedure, and utilizing tools such as the Pre-Upgrade Tool and Database Upgrade Assistant (DBUA) for Oracle RAC.

6. Practice 12 Upgrading Oracle RAC Database - Part 1 of 4

In this practice video, the video focuses on upgrading the Oracle RAC database from release 12.1.0.2 to release 12.2.0.1, involving critical steps such as expanding the CRS disk group in ASM and preparing the installation files for the Oracle RAC database stack.

7. Practice 12 Upgrading Oracle RAC Database - Part 2 of 4

In this practice video, the video focuses on upgrading Oracle Grid Infrastructure in a rolling upgrade fashion, showcasing the steps involved in the process, including directory creation, unzipping installation files, executing the grid setup script, and handling warnings during the upgrade.

8. Practice 12 Upgrading Oracle RAC Database - Part 3 of 4

In this practice video, the focus lies on installing Oracle Database 12.2 software without upgrading the RAC database, illustrating steps such as setting up the Oracle home, invoking the OUI utility, running configuration scripts, and conducting pre-upgrade checks for optimal database performance.

9. Practice 12 Upgrading Oracle RAC Database - Part 4 of 4

In this practice video, the upgrade process of the Oracle database to release 12.2 through DBUA (Database Upgrade Assistant) in a VirtualBox environment is illustrated, encompassing various steps such as setting the Oracle HOME, handling warnings about invalid views, and ensuring database stability post-upgrade.

1. Oracle RAC One Node

In this video, we will delve into Oracle RAC One Node, exploring its architecture, database creation, instance relocation, conversion processes, and cost-effective advantages over Oracle RAC. Learn how to seamlessly manage and convert databases in this practical guide to Oracle RAC One Node.

2. Practice 13 Creating a RAC One Node Database

In this practice video, we will explore hands-on tasks involving Oracle RAC One Node database administration. From creation to conversion, relocation, and issue resolution, this video provides step-by-step guidance on managing Oracle RAC One Node databases.

1. Multitenant Architecture and RAC

In this video, delve into Oracle Database Multitenant Architecture. Covering concepts such as CDBs, PDBs, user types, database connections, startup/shutdown processes, and performance views, this video provides an introductory overview of managing databases using the multitenant model.

2. Practice 14 Creating a Multitenant RAC Database - Part 1 of 2

In this practice video, we will execute fundamental tasks to oversee a multitenant Oracle RAC database. From creation to connecting, startup/shutdown, cloning PDBs, managing services, and dropping PDBs, this video provides hands-on experience in managing a multitenant Oracle RAC database.

3. Practice 14 Creating a Multitenant RAC Database - Part 2 of 2

In this practice video, we will delve into managing Pluggable Databases (PDBs) in a multitenant Oracle RAC environment. Learn the intricacies of cloning PDBs, creating managed services, observing clusterware behaviors, and dropping PDBs along with their associated data files.

1. Managing Policy-Managed Oracle RAC Databases - Part I

In this video, we delve into the intricacies of policy-managed Oracle RAC databases. Explore the fundamentals of server pools, benefits of policy-managed databases, converting from administrator-managed to policy-managed, and configuring services within a policy-managed database. Learn how these configurations influence database functionality and service availability within a cluster environment.

2. Practice 15 Creating Policy-Managed Oracle RAC Database

In this practice video, we will learn to create a policy-managed RAC database, set up server pools, create dynamic database services, and simulate node failover scenarios to understand Oracle database RAC administration.

3. Managing Policy-Managed Oracle RAC Databases Part II - Part 1 of 2

In this video, we will explore managing policy managed Oracle RAC databases, understanding server categorization, cluster configuration policies, and dynamic resource provisioning, examining how these elements function and the advantages they offer in Oracle RAC administration.

4. Managing Policy-Managed Oracle RAC Databases Part II - Part 2 of 2

The video covers the implementation of server categorization and policy configuration in Oracle database RAC administration. It demonstrates setting server attributes, defining server categories, associating categories with server pools, creating policy configurations, and activating policies based on attributes and server pools.

5. Practice 16 Using Server Categorization and Cluster Configuration Policies

In this practice video, the demonstration revolves around creating and testing server categories and cluster configuration policies in Oracle database RAC administration. It involves setting server labels, creating categories, associating them with server pools, testing configurations, creating policies, and observing their effects on server pool distribution.

1. Oracle Flex Clusters

In this video, the discussion revolves around Oracle Flex Clusters in Oracle database RAC administration. It covers the advantages of Flex Clusters, their architecture, database creation, hub and leaf nodes, conversion processes, management of Flex Clusters, and the implementation of Oracle Flex ASM for enhanced performance and scalability.

1. Deleting and Adding a Node from-to an Oracle RAC

In this video, the discussion focuses on the processes of adding and deleting nodes in an Oracle RAC. It covers the systematic steps required to delete a node, emphasizing sequential actions and the precautions needed, and explains the prerequisites and procedures for adding a node to the RAC cluster.

2. Practice 17 Deleting an Oracle RAC Node from a Cluster

In this practice video, the procedure for deleting the Oracle RAC node srv2 from the Oracle RAC Database Cluster rac is demonstrated step by step. It covers the deletion of the database instance, removal of software homes, and the removal of the node from the cluster, emphasizing the caution required while executing destructive commands.

3. Practice 18 Adding an Oracle RAC Node to a Cluster

In this practice video, the procedure to add the Oracle RAC node srv2 to the Oracle RAC Database Cluster rac is demonstrated step by step. The video covers installing necessary packages, extending software homes, adding the database instance, emphasizing the process of online addition without shutting down the cluster or the database.

1. Creating an Oracle 12c R2 Physical Standby RAC Database from a Primary RAC

In this demo video, the implementation of Data Guard in an Oracle RAC environment is extensively demonstrated. It covers the creation of physical standby databases, differences between single-instance and RAC configurations, and detailed steps for setting up and verifying the Data Guard configuration.

1. Practice 19-a Preparing the Environment for Oracle 19c RAC

In this practice video, we will be guided through building an Oracle RAC Database 19C on a Linux 7 system. Covering crucial differences between Oracle 12C and 19C, the video demonstrates preparing the environment, installation, creating databases, configuring shared disks, and addressing memory requirements.

2. Practice 19-b Creating an Oracle 19c RAC Database

In this practice video, we delve into the installation of Oracle software and the creation of an Oracle 19C RAC database. Covering steps similar to Oracle RAC 12C with minor differences, the video focuses on OS preparation, software installation, ASM disk group creation, and database setup, ending with troubleshooting for EM Express access.