Cross-Instance Deadlock in RAC

 I've created a video demonstration of a Cross-Instance Deadlock in a 2-node RAC environment and how to read the trace file.

Note : Only the SQL that has been returned the "deadlock" error is failed, the session and transaction are still valid.

An introduction to Oracle Cloud Infrastructure

 A 1hour video

Description:

This session will cover the fundamentals of Oracle Cloud Infrastructure (OCI) including cloud concepts, OCI structures, and core OCI services. OCI service areas that will be discussed include Identity and Access Management (IAM), networking, compute, storage, and database. You will also learn about Users, Groups, and Policies, along with the core tenets of virtual network design that will help set the foundations for application deployment to OCI. We will also cover terms and definitions for each of the topic areas to establish a foundation for additional sessions.

Configuring a RAC Service tied to a PDB and specific Instance

 I have created a new Video demonstrating how you can add new Services to an existing database.  In RAC, you can choose to have the Service running on all or selected or a single node of the Cluster.  The service can be bound to a PDB.

This allows you to separate different applications / groups of users via Services and manage availability via Startup/Shutdown/Relocation/Failover of services.

The comand to configure a service to a single PDB and Instance is :

srvctl add service -db RACDB -service prdapps1 -preferred RACDB1 -available RACDB2 -tafpolicy BASIC -failovertype SELECT -clbgoal SHORT -pdb PDAPPTST