Oracle Real Application Clusters 18c Internals

1 Copyright 2018, Oracle and/or its affiliates. All rights reserved. | Oracle real Application Clusters 18c Internals Anil Nair - Oracle RAC Product 2018, Oracle and/or its affiliates. All rights reserved. |Safe Harbor StatementThe following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing,and pricing of any features or functionality described for Oracle s products may change and remains at the sole discretion of Oracle 2018, Oracle and/or its affiliates.

2 All rights reserved. | Oracle RAC 18c InternalsOracle RAC Family of SolutionsOracle real Application ClustersCopyright 2018, Oracle and/or its affiliates. All rights reserved. |Program AgendaCluster DomainFeatures, Performance and SecurityOracle RAC OptimizationsDRF, Reconfiguration, Exadata Specific125 Copyright 2018, Oracle and/or its affiliates. All rights reserved. |Program AgendaCluster DomainFeatures, Performance and Security126 Copyright 2018, Oracle and/or its affiliates. All rights reserved. | cluster DomainApplication Member ClusterUses ASMD atabaseMember ClusterUses local ASMD atabaseMember ClusterUses ASM ServiceDatabaseMember ClusterUses IO ServiceDomain Services cluster (DSC)Shared ASMIOS erviceACFS ServiceASM ServiceTFAS erviceManagementServiceFPPS erviceDatabaseMember ClusterUses ASM ServiceDatabaseMember ClusterUses IO ServiceTFAS erviceManagementServiceFPPS erviceIOServiceACFS ServiceASM Service DSC Application MC Database MC with local Storage Database MC with I/O Service Database MC using ASMDSC=Domain Services ClusterMC = Member ClusterCopyright 2018, Oracle and/or its affiliates.

3 All rights reserved. |Transition into the cluster Domain Model Gradually utilize Services of the Domain Services cluster I/O services need careful planning Capacity PerformanceCopyright 2018, Oracle and/or its affiliates. All rights reserved. | Similar concept as DevOps Methodology for optimizing Database deployment and Management at high velocity Define once and reuseCluster Domains enable DBAs to be agile: DBAOpsWhy should ONLY Developers have all the fun?DBAC opyright 2018, Oracle and/or its affiliates. All rights reserved. | Install Provision Patch OS, Database Upgrade Performance Database OS settings Hangs Automation DependencyAutomate Mundane tasks in a cluster DomainOracle RAC, Single Instance, Restart & RAC One Node123 Copyright 2018, Oracle and/or its affiliates.

4 All rights reserved. | Domain Services cluster (DSC) includes Fleet Provisioning and Patch (FPP) to Provision Oracle RAC, Single Instance, Oracle RAC One, Oracle Restart and Application Servers Includes GI/DB Homes and Instances Manages versions from 11204 all the way to current release Utilize Zero downtime Grid Infrastructure Patching Upgrade with ZDU (Zero Downtime Upgrade) Creating and maintaining Gold Image All the above can be defined once and reused cluster Domain Services for Rapid DBA OperationsInstallManageRelateReuseDBAC opyright 2018, Oracle and/or its affiliates. All rights reserved. |Copyright 2018, Oracle and/or its affiliates. All rights reserved.

5 |Applied Machine Learning for easier ManageabilityApplied Machine Learning applies Pre-built optimized models on collected data in real time to Analyze Failures Performance Patch Application timelines Significantly reduce time spent on RCAS ubject Matter ExpertLogASHM etricsMLKnowledgeExtractionModelGenerati onHuman SupervisionApplicationOptimizedModelsFee dbackCopyright 2018, Oracle and/or its affiliates. All rights reserved. | One Management repository for many Member Clusters Sharing Diagnostics Data can lead to better Availability Large Diagnostic Data sets makes the diagnostic engine better Incident based Engine collects Diagnostic Data from all nodes and layers ORA-600 [.]

6 ]Benefit from Consolidated Diagnostic Data Collection1120411204 DBA 1 DBA 2 Copyright 2018, Oracle and/or its affiliates. All rights reserved. | OraChkcan help compare and contrast different configurations Different I/O scheduler? Centralized location makes it easier to identify diffs Daemon Mode $orachk d start/stop/status Configure Schedule $orachkAUTORUN_SCHEDULE What s difference between OraChkand ExaChk?Benefit from a Centralized OraChk1120411204 DBA 1 DBA 2 Oracle RAC Assessment ReportSystem Health Score is 89 out of 100 Oracle RAC Assessment ReportSystem Health Score is 98out of 100 Copyright 2018, Oracle and/or its affiliates. All rights reserved.

7 | Utilize TFA notification features $tfactlset smtp $tfactlset notificationAddress= .. Prepend the owner for specific homes $tfactlset notificationAddress= salesora: Events include Oracle Errors (ORA-) cluster Health Monitor events Diagnostic Data is moved to DSC for further analysis by TFA ServiceAutomatic Notification and Diagnostic Collection using TFADBA 1 DBA 2 TFA AgentTFA AgentCopyright 2018, Oracle and/or its affiliates. All rights reserved. |What about Security?DSC ServiceProtocolManagement ServiceEncryption over SQL*NetTFA ServiceTLS/SSLF leet Patching and ProvisioningJMX/TLSS torage Services (ASM)Encryption over SQL*NetI/O ServiceFPPS erviceManagementServiceTFAS erviceFPPS erviceCopyright 2018, Oracle and/or its affiliates.

8 All rights reserved. |Roles and Responsibilities Member cluster Administrator Manages Databases, Services on MC Can only access Database that they have permission for Certain Member cluster Configurations can continue working when DSC is unavailable Choose when to upgrade DSC Administrator Aware of Member cluster GI/DB versions and can dictate Gold Image Defines Member cluster type and hence the services offered to Members Unable to access Database DataCopyright 2018, Oracle and/or its affiliates. All rights reserved. |Choosing between cluster Domain and StandAlone All features apply to both cluster Domain and StandAlonedeployments Possible to utilize subset of Services provided by DSC StandAlonedeployment can be converted to Member cluster Moving back requires planningCopyright 2018, Oracle and/or its affiliates.

9 All rights reserved. |Program AgendaOracle RAC OptimizationsDRF, Reconfiguration, Exadata Specific1220 Copyright 2018, Oracle and/or its affiliates. All rights reserved. |22 All Deployments Benefit from Oracle RAC Features PDB IsolationDRFLock DomainsCopyright 2018, Oracle and/or its affiliates. All rights reserved. | Oracle RAC Optimization Design GoalsMonitorReduce BrownoutsOptimize CPU usageDynamically Adjust Copyright 2018, Oracle and/or its affiliates. All rights reserved. | More PDBs per Database Large SGAs Large Global Resource Directory More work for LMS* Dynamic Internal Structures Smarter DRM Optimized MessagingOracle RAC ScaleabilityRequirementsCopyright 2018, Oracle and/or its affiliates.

10 All rights reserved. | Monitors for problems before service disruption for critical processes Detects the cause of problem Use collected data across all nodes to identify root cause Waits on GRD Resolves the problem with minimal disruption internal StructuresIntroducing Database Reliability Framework Normal Busy Extremely BusyUtilization Type 1 Type 2 Type 3 Resource TypesResourcesCopyright 2018, Oracle and/or its affiliates. All rights reserved. |PDB1 PDB2 PDB3 PDB4 PDB5 PDB6 PDB7 PDB8 PDB9 PDB10 PDB11 PDB12 RAC ClusterInst1 Inst2 Inst3 Inst4 Oracle RAC ScaleabilityCopyright 2018, Oracle and/or its affiliates. All rights reserved. |MonitorDetectReviewResolve Increase in number of resources in the Global Resource Directory (GRD) Resulting in higher wait times for GRD Several solutions possible Is wait time due to high CPU load?