Oracle Realtime Application Cluster RAC with Practical Demos

Prepare the first node by setting up an Oracle Linux VM, configuring host-only and bridged networks, assigning IPs, and creating users and groups for Oracle installation.

Clone server one to create server two by generating MAC addresses and updating public and private IPs. Reconfigure network adapters, then verify servers can communicate on public and private networks.

Learn to create and share three ASM disks in a two-node Oracle RAC environment using VirtualBox, including creating, attaching, formatting partitions, and validating access from both servers.

Learn how to create asm disk groups from shared storage using the asm creation assistant, configuring data and fra disk groups with external redundancy for Oracle RAC.

Configure final os level settings on node servers by defining Oracle and Grid environment variables in bash profiles and updating security limits for Oracle and Grid users before grid installation.

Install grid infrastructure on two nodes with virtual machines, meeting hardware and two network adapters, using Oracle Enterprise Linux and grid software, and verify the cluster.

learn how to install Oracle database software on a two-node RAC environment, including prerequisites, grid infrastructure, and running the Oracle Universal Installer to complete the database software installation.

Learn to create an Oracle RAC database instance using the DVC utility, configuring admin-managed, general-purpose RAC on two nodes, with a DNS ora file and round-robin connections.

Export the entire RAC setup by backing up and exporting virtual machines in VirtualBox, detaching external disks, and preserving network and disk configurations for quick reimport and restart.

Explore verifying Oracle grid infrastructure by checking online and offline components and services with grid verification commands, confirming resource states across nodes and viewing status in tabular form.

Explore how RAC components allocate memory and monitor memory usage by background processes, including the global cache service and global cache, via a live demo and a bytes-to-megabytes query.

Detect and resolve rac hang situations by using or debug to identify culprit sessions and generate a crace file for analysis, then kill the session or release the lock.

Learn how swing bench, an open source Java-based load generator, creates simulated load on an Oracle database through a guided setup, schema creation, and configurable modules.

Learn how to activate archive log mode in a RAC environment, configure the log archive destination, and verify archivelog generation across RAC instances.

Configure basic RMAN settings for a RAC database: enable control file auto backup, set disk device type and parallelism to two, and apply a 30-day redundancy retention policy.

Configure the snapshot control file location to shared storage accessible by all RAC nodes, then back up the current control file to complete the setup.

Learn to write a shell RMAN script that performs a full database backup with log files, schedules via cron, and deletes obsolete backups without prompts.

Perform a database backup of your environment with RMAN and tag the backup set. Verify backup contents, include archive logs, SP files, control files; delete obsolete backups to save space.

Demonstrate restoring a database from backup in a RAC setup, executing media recovery on two channels, and verifying both instances come online after the restore.

Configure Oracle Enterprise Manager Database Express, a web-based tool built inside the database server, to manage storage, users, and performance diagnostics in open mode.

Explore Oracle enterprise manager with a hands-on walkthrough of features like user management, initialization parameters, memory and storage views, and live RAC performance across active sessions.

Explore Oracle RAC services as a high availability feature, covering service types, application continuity, load balancing, and pre connect. Learn to monitor with OEM and relocate services using service commands.

Relocate a service in oracle RAC by manually moving from a preferred node to an available node, with DPA involvement and status checks to confirm the new preferred node.

Monitor Oracle services at module and action levels using DBI, Monita, and EUM; enable statistics, run swing bench loads, and analyze results in the performance hub.

Explore client-side load balancing in Oracle RAC across multiple nodes using round-robin and session workload coordination via local and scan listeners. See how connections distribute and adapt to node failures.

Explore Oracle RAC with practical demos by configuring server-side load balancing using a dedicated service, setting preferred instances, and verifying distribution of connections through the listener and client connections.

Discover how transparent application failover works in Oracle RAC, including client-side and server-side setup, session and select modes, automatic reconnects, and preserving fetch cursor position while rolling back uncommitted changes.

Explore transparent application failover on the server side using select and basic failover methods, with a five-second delay and practical service configuration to switch connections between server instances.

Explore preconnect, a backup client connection for failure resilience in Oracle RAC. The demo demonstrates creating two DNS entries and a preconnected backup, then validating failover from primary to backup.

Define a server-side service with the reconnect death policy to enable failover. Configure pre def and three deaths dot local domain DNS entries to validate reconnect.