Real Application Clusters
Oracle Real Application Clusters (RAC) allow customers to run a single Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage. User sessions connecting to Oracle RAC instances can failover and safely replay changes during outages, without any changes to end user applications, hiding the impact of the outages from end users.
New Generation Oracle RAC
Oracle Real Application Clusters 19c includes many improvements that enable applications to achieve significantly better levels of availability and scalability than previous versions. These improvements create a new generation of Oracle RAC technology ready to meet the needs of next-generation workloads and applications.
Grid Infrastructure Concepts
What is a cluster? Grid foundation components. Oracle clusterware architecture. Oracle Clusterware software and Storage. Describe ASM Architecture. Benefits of RAC. Cluster Products
Grid Infrastructure Installation and Configuration
Hardware requirements, Network Requirements. DNS and DHCP Configuration. Determining the location of the Oracle clusterware Configuration files. Backing up and Recovering the Voting disk. Adding, Deleting or Migrating Voting disks. Locating the OCR Automatic Backups. Oracle Local Registry. Managing Network settings.
Administering Clusterware
Determining the location of the Oracle clusterware Configuration files. Backing up and Recovering the Voting disk. Adding, Deleting or Migrating Voting disks. Locating the OCR Automatic Backups. Oracle Local Registry. Managing Network settings
Troubleshooting Oracle Clusterware
Oracle Clusterware Log Files. Gathering Log Files using diagcollection.pl. Troubleshooting the Oracle cluster Registry.
ASM Architecture
Overview of ASM. ASM Concepts. ASM Instances. Stripping. Mirroring. Disk group Administration. Discovering Disks. Mounting Disk Groups. Adding and Dropping Disks. Rebalancing Disks.ASM and Multipathing.
RAC Tools
Using Srvctl
Using crctl
Using oficfg
Using cluvfy
Using sqlplus
Using asmca
Using asmcmd
Administering ASM Instances
ASM Initialization Parameters. Adjusting ASM Instance Parameters in SPFILE’s. Starting and Stopping ASM Instances using srvctl. Starting and Stopping the ASM Listener. Starting and Stopping ASM Instances Containing Cluster files.
Administering ASM Diskgroups
Creating and Deleting ASM Disk Groups. ASM Disk Groups Attributes. ASM Disk Group Maintenance Tasks. Preferred Read Failure Groups. Viewing ASM Disk Statistics. Performance and Scalability Considerations for ASM Disk Groups.
ASM Files , Directories and Templates
Using Different client tools to Access ASM files. Fully Qualified ASM File Name Format. Creating and Managing ASM Files, Directories and Aliases.
Monitoring Performance
Performance views in RAC, Monitoring RAC Databases. Automatic workload Repository (AWR) in RAC. Monitoring RAC Statistics and Events. Work Load Management
Managing Applications
Starting Application resources, Stopping Application Resources. Relocating Application Resources. Unregistering Applications and application Resources.
Adding ASM Disks
ASM Storage disk Addition and Configuration
Managing ASM disks
Managing Disk group and Configuration
Adding and Deleting Nodes,Instances
Cloning Oracle Clusterware and RAC S/W in Grid Environments. Quick start Node and Instance Addition and Deletion Procedures. Adding an Oracle Clusterware Home to a New Node.
19c RAC Cluster Domain
Cluster Domain Overview