My Oracle Support Banner

Exadata Starter Kit (Doc ID 1244344.1)

Last updated on AUGUST 28, 2023

Applies to:

Exadata X3-2 Hardware - Version All Versions and later
Exadata Database Machine X2-2 Hardware - Version All Versions and later
Exadata X3-8 Hardware - Version All Versions and later
Exadata Database Machine X2-2 Qtr Rack - Version All Versions and later
Oracle Exadata Storage Server Software - Version 11.2.1.2.0 and later
Linux x86-64
Oracle Solaris on x86-64 (64-bit)

Purpose

The purpose of this document is to provide a starter kit for Oracle Exadata V2, which consists of the Oracle Exadata Database Machine, and Exadata Storage Server. This starter kit presents Exadata specific, along with a generic set of Best Practices, Platform-specific Configuration Information, Tuning Recommendations, Hardware Configuration Recommendations, and e-Business Suite deployment Recommendations for clustered environments. This Starter Kit is not meant in any way to replace or supplant the Oracle Documentation set for Exadata, but rather, it is meant as a supplement to the Oracle Documentation. It is still imperative that the Oracle Documentation be read and understood, and Oracle documentation should be referenced to provide answers to any questions that may not be clearly answered within this Starter Kit.

Additionally, as every customer environment is unique, the success of any Oracle implementation, including implementations involving Exadata, and its component technologies, is predicated upon a successful deployment environment. Therefore any recommendations from this Starter Kit should be carefully reviewed by the relevant Operations Groups, and should only be implemented if the potential gain as measured against the associated risk warrants. Risk assessments can only be made with a detailed knowledge of the system, application, and business environments that comprise each deployment scenario. It is imperative that any recommendations that come from this Starter Kit are thoroughly tested and validated using a suitable testing environment that is a reasonalbe replica of the target production environment before being implemented in a production environment to ensure that there is no negative impact associated with the recommendations that are made.

Understanding that Exadata is a highly optimized, pre-configured, solution for all database workloads, the recommendations contained within this document are directed, and relevant to understanding Exadata, and the underlying technology component infrastructure used in Exadata. These recommendations are provided to highlight traditional areas where Best Practice recommendtaions have been applied in order to optimize deployments consisting of Oracle's Grid Infrastructure, RAC/RDBMS, and Network products. By default the majority of the Best Practices presented in this document, are already present, and pre-configured in Exadata deployments. As stated in various Exadata documentation references "The Exadata architecture was developed from the ground up, employing scale-out principles at both the server and storage layers, unified connectivity based on network (not disk) protocols, tightly integrated flash technology and application-aware intelligence within storage. It is the most modern architecture available and is expected to endure for years to come, with only evolutionary changes over the near term."

It is beyond the scope of this document to address detailed configuration requirements for extended networking, and external subsystem components including their configuration, or to evaluate system performance and operational infrastructure requirements associated with sustaining operations or disaster recovery. The areas that require analysis as part of assessing this functionality should be addressed separately in order to provide the appropriate level of detail and focus that are needed to provide recommendations specific to each area of focus.

All recommendations of the Exadata Starter Kit should be carefully reviewed by your own Operations Group and should only be implemented if the potential gain as measured against the associated risk warrants implementation. Risk assessments can only be made with a detailed knowledge of the system, application, and business environment.

All recommendations should be thoroughly tested and validated using a testing environment that is a replica of the target production environment, before being implemented in a production environment to ensure that there is no negative impact associated with changes that are made.

Scope

This article is intended for applications development, product management, system architects, and system administrators involved in deploying and configuring Oracle Exadata. This document will also be useful to field engineers and consulting organizations to facilitate installations and configuration requirements.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1.    Exadata Specific Best Practices
     A.   Exadata Oracle Technology Network References
     B.    Database Machine and Exadata Storage Server Patching
     C.   Performance Best Practices
     D.   High Availability Best Practices
     E.    Diagnosability and Troubleshooting Best Practices
     F.     Migration Best Practices
     G.   Manageability Best Practices
     H.   Security Best Practices
     I.   Backup Best Practices
     J.      Enterprise Manager Best Practices
     K.   Best Practices for data warehousing on the oracle database machine
     L.    Exadata Setup / Configuration
 2.    Oracle Database General Best Practices
     A.   General
     B.    Machine and OS Configuration
     C.   OS Network Configuration
     D.   Cluster Configuration
     E.     General Cluster Information
     F.     Extended/Stretch Cluster
     G.    Database Network Configuration
             1.     Listener Configuration
             2.     Oracle Networking
             3.      Infiniband Interconnect
     H.    Database Configuration
             1.      SGA Sizing
             2.      Database Datafile Storage (ASM Configuration)
             3.      Tablespaces
             4.      Automatic Undo Management
             5.     Online Logfiles
             6.     Control Files
     I.        Grid Infrastructure/ASM, RDBMS, and Storage Cell Patching / Maintenance Requirements
     J.        Database Configuration Parameter File
 3.     RAC Platform Generic Highlighted Recommendations, Best Practices, and References
     A.    Highlighted Recommendations
     B.     RAC Platform Generic Best Practices
             1.      Hardware
                     a.      STORAGE
                     b.      NETWORKING
                     c.      CONFIGURATION
             2.      Operating System
                     a.      STORAGE
                     b.     NETWORKING
             3.      Oracle
                     a.      STORAGE
                     b.     INSTALL
                     c.       PATCHES
                     d.     UPGRADE
                     e.      PARAMETERS
                         f.       PACKAGES/MODULES
                         g.      CONFIGURATION
                     h.     TOOL/UTILITY
                     i.        E-BUSINESS SUITE
             4.      IT Best Practices
                     a.      PROJECT MGMT
                     b.     CONFIGURATION
                     c.       TOOL/UTILITY
                     d.     INSTALL
     C.     Maximum Availability Architecture
     D.    RAC Technology References
             1.      Oracle Product Documentation 
             2.      My Oracle Support, and Oracle Technology Network References 
 4.     RAC on Linux Highlighted Recommendations, Best Practices, and References
     A.    RAC on Linux Best Practices
                1.      Hardware
                        a.      STORAGE
                     b.     NETWORKING
                     c.      CONFIGURATION
             2.      Operating System
                     a.      STORAGE
                     b.     NETWORKING
                         c.      PARAMETERS
                         d.     CONFIGURATION
                     e.      TOOL/UTILITY
     B.     RAC on Linux Platform Specific References 
 5.  RAC Performance Tuning Recommendations
 6.  RAC Related E-Business Recommendations & References
     A.  RAC Related E- Business Recommendations 
     B.  RAC Related E-Business References
 7.  Appendix A - Storage
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.