An Oracle White Paper September Deploying Oracle Database on x86 Systems with Oracle Solaris - PDF

Please download to get full document.

View again

of 23
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Book

Published:

Views: 2 | Pages: 23

Extension: PDF | Download: 0

Share
Related documents
Description
An Oracle White Paper September 2010 Deploying Oracle Database on x86 Systems with Oracle Solaris Oracle White Paper Deploying Oracle Database on x86 Systems with Oracle Solaris Introduction... 3 Overview
Transcript
An Oracle White Paper September 2010 Deploying Oracle Database on x86 Systems with Oracle Solaris Oracle White Paper Deploying Oracle Database on x86 Systems with Oracle Solaris Introduction... 3 Overview of Solaris 10 on x86 Servers... 3 x86 Hardware for Oracle Solaris Oracle Solaris on Sun x86 Servers... 5 Oracle Solaris x86 on third-party x86 hardware... 7 Oracle Solaris 10: Optimized for the Intel Xeon Processor... 8 Storage Options for Oracle Solaris x File System Recommendations... 9 Improving Performance with Flash Cache Virtualization Options for Oracle Solaris x Oracle VM Server for x86 and Hypervisor Based Virtualization Oracle Solaris Containers Oracle Solaris Resource Manager Oracle RAC on Oracle Solaris x Tools, Process Monitoring, and Observability Oracle Enterprise Manager Oracle Solaris Tuning and Observability Tools Free Software for Oracle Solaris Proven Performance and Scalability Protect against faults: Enhance uptime Protect against hardware faults: Solaris Fault Manager Protect against memory faults: Memory Page Retirement Protect against software faults: Service Management Facility Configure Oracle as a service in Service Management Facility Enhance out-of-box accountability Track activities of individual DBAs Create an Oracle role Simplify Deployment Create a project for Oracle Database Installation... 33 Oracle White Paper Deploying Oracle Database on x86 Systems with Oracle Solaris Consolidate multiple Oracle Database instances Oracle Solaris Containers Manage license Maintain Quality of Service (QoS) Conclusion References Appendix A: Oracle s Current Sun x86 Servers Appendix B: Manifest file to add Oracle database as an SMF service40 Introduction Oracle Solaris 10 is the ideal operating system for use on x86 hardware. Innovative, built-in features deliver breakthrough virtualization and utilization, high availability, advanced security, and industry leading performance. Oracle Database 11g delivers industry leading performance, scalability, security and reliability on a choice of clustered or single-servers and provides comprehensive features to easily manage the most demanding transaction processing, business intelligence, and content management applications. This whitepaper introduces the Oracle Solaris Operating System to users of Oracle Database 11g on x86-based platforms. It examines Oracle Solaris features and capabilities that are relevant to database environments, including performance, observability tools, security, compatibility, availability and virtualization options. Highly regarded features of Oracle Solaris on x86 include Oracle Solaris ZFS for next-generation volume management and file system support, Oracle Solaris DTrace for advanced observability, virtualization options including Oracle VM and Oracle Solaris Containers, Predictive Self Healing for continuous availability, and Solaris Trusted Extensions. These features are discussed with focus on the relevance to Oracle Database 11g deployments. Overview of Solaris 10 on x86 Servers With a single source code base, Oracle Solaris 10 runs on both x86- and SPARC-based systems, delivering the same features across all platforms. This means that applications developed and optimized on Oracle Solaris 10 run on more than 1,000 system models from leading vendors. The operating system runs on hardware ranging from laptops and single-board computers to datacenter and grid installations, while serving applications ranging from military command-and-control systems to telecommunications switch gear and stock trading. Oracle Solaris 10 on x86 features which are particularly relevant to Oracle DBAs include: Dynamic SGA tuning of Oracle s database memory using Oracle Solaris s Dynamic Intimate Shared Memory (DISM) feature. When running Oracle Database on Oracle Solaris, the amount of physical memory consumed by the SGA can dynamically grow or shrink to meet continually changing resource requirements of the database. Oracle Database performance on x86 servers benefits from the use of Solaris 10 large memory pages which are automatically allocated for the database s SGA shared memory. Large pages can reduce the 3 number of memory pointers by more than 500 times. This reduction in complexity translates into noticeable performance improvements, especially on systems with very large amounts of memory. Oracle Solaris 10 security features are critical to enterprise deployments. The system s integrity can be verified by using Oracle Solaris digitally signed binaries and file verification features. Reduce risk by granting only the privileges needed for users and processes. Simplify administration and increase privacy and performance by using the standards-based key management and cryptographic frameworks in Oracle Solaris. The system can be secured by using dynamic service profiles, including a built-in, reduced exposure network services profile. Access to data can be controlled based on its sensitivity level by using the labeled security technology in Oracle Solaris 10 with Trusted Extensions Oracle Solaris ZFS is a general-purpose file system that is designed to span from the desktop to the datacenter. Anyone who has ever lost important files, run out of space on a partition, spent weekends adding new storage to servers, tried to grow or shrink a file system, or experienced data corruption knows the limitations of traditional file systems and volume managers. Oracle Solaris ZFS addresses these challenges efficiently and with minimal manual intervention. System administrators, integrators, and developers can use the dynamic instrumentation and tracing capabilities in Oracle Solaris to see what s really going on in the system. DTrace can be safely used on production systems, without modifying applications. It is a powerful tool that gives a comprehensive view of the entire system, from kernel to application, even those running in a Java Virtual Machine. This level of insight reduces the time for diagnosing problems from days and weeks to minutes and hours, and ultimately reduces the time required to fix those problems. Oracle Solaris 10 includes the leading Web 2.0 open source packages, optimized and ready to run. Oracle Solaris 10 delivers binary compatibility from release to release and source compatibility between SPARC and x86 processors. Oracle Solaris 10 also offers powerful built-in virtualization features. With Oracle Solaris Containers, you can maintain a one-application-per-virtual-server deployment model while consolidating dozens or even hundreds of applications onto a single server and OS instance. These features let you share hardware resources while maintaining predictable service levels, increase utilization rates, and cut system and licensing costs while gaining the ability to quickly provision and move workloads from system to system. Setting numerous price/performance records since its release, Oracle Solaris 10 unleashes even more power from existing applications. Download the latest Oracle Solaris Studio compilers and developer tools to bring even greater performance to your applications. Predictive self-healing is a key feature in Oracle Solaris 10 that helps you increase system and service availability. It automatically detects, diagnoses, and isolates system and software faults before they cause downtime. And it spans the full range from diagnosis to recovery on systems based on SPARC, AMD, and Intel processors. 4 Oracle is moving fast to differentiate its x86 server products by leveraging flash memory, Sun's Flash Accelerator, Oracle system-management software, and Oracle Grid Control software, and by building a clustering fabric to tie multiple x86 servers together. The broader view of the software landscape that Oracle brings to the Sun product line is one that: 1. Is working to combine Sun Ops Center systems management with the Oracle Enterprise Manager (OEM) framework, and remote-control for lights-out management via Oracle ILOM 2. Is building solutions optimized for specific solution-sets (e.g., analytics, ERP, data warehouse); this is the integrated stack approach announced by Oracle in January, combining hardware and software into deployable systems 3. Supports virtualized fabrics that provide virtualized I/O to arrays of scale-out x86 servers, and also supports Oracle's own Oracle Virtual Machine (OVM) hypervisor, leveraging its software IP as it competes with HP, Cisco and IBM in scale-out converged infrastructure At the same time, Oracle is advancing its support of scale-out x86 server systems, whether deployed in an array, a grid, or a cluster. Oracle Grid Control software, and Oracle Real Application Clusters (RAC) are key elements of this scale-out approach to enterprise computing. And, addressing the management complexity and IT skill-set issues that many customers have faced in deploying scale-out enterprise systems, Oracle has pre-tested and pre-certified specific solutions that include automation of virtualized networking and workload management. Oracle s strategy is differentiated by the way that it is selling a complete end-to-end solution that combines Sun hardware with Oracle database software, Oracle middleware and Oracle applications, offering customers a full solution from a single vendor. This approach provides rapidly deployable solutions for customers but also full responsibility for all components within the system Jean Bozman, Jed Scaramella, IDC Link x86 Hardware for Oracle Solaris 10 Oracle Solaris on Sun x86 Servers Oracle offers x86 clustered systems tightly integrated from applications to disk. Oracle uses best-ofbreed components to simplify the deployment, management, and support of IT infrastructure and to deliver unmatched performance and scalability. Oracle's x86 server family ranges from 2-socket to 8-socket systems that run your choice of operating system: Oracle Solaris, Oracle Enterprise Linux, Oracle VM, Red Hat Linux, SUSE Linux, Windows or VMware. These servers are designed to deliver peak performance while reducing energy costs and improving space efficiency with leading performance per watt and compute density. I 5 Oracle White Paper Deploying Oracle Database on x86 Systems with Oracle Solaris 6 Oracle Solaris x86 on third-party x86 hardware As of August 2010, there are over 1250 x86 systems on the Solaris Hardware Compatibility List (HCL). 1A free download of the Hardware Certification Test Suite (HCTS) is available, which enables partners and customers to test and self-certify their hardware platforms, to ensure they can be listed as certified systems on the HCL. Additionally Sun OEM partners, including Dell and HP, offer Solaris as an Operating System choice. Oracle Solaris Premier Subscription for Non-Oracle Hardware provides Oracle support and the Oracle Solaris license for new and existing customers running Oracle Solaris across multiple x86 platforms. This offer ensures successful Oracle Solaris deployments by providing immediate access to Oracle's 1 BigAdmin: Hardware Compatibility List (HCL) Overview, 7 deep product expertise and fast and accurate issue resolution while limiting risk in your IT environment. 2 Oracle Solaris 10: Optimized for the Intel Xeon Processor Oracle and Intel, as part of a broad strategic alliance, have been working together to ensure that Oracle Solaris is optimized to unleash the power and capabilities of current and future Intel Xeon processors. 3 As a result, Oracle and Intel have made significant advances to optimize Oracle Solaris for Intel Xeon processor-based systems, and are working closely to develop new capabilities that are part of the Intel Xeon processor 5600 series and the Intel Xeon processor 7500 series. Some examples of this include: Scalable performance: Oracle Solaris enhances Intel multicore processor capabilities up to 8 processor sockets, each with up to 8 cores and 2 threads per core as well as Intel Hyper- Threading Technology, Intel QuickPath Technology (Intel QPI), and Intel Turbo Boost Technology. Additional optimizations improve memory and network performance. Advanced reliability: The Oracle Solaris Fault Management Architecture (FMA) integrates with the Intel Machine Check Architecture (MCA) Recovery features, enabling systems to automatically monitor, report, and recover from hardware errors to maintain data integrity and keep mission critical applications and services online. Power efficiency and utilization: Oracle Solaris takes advantage of performance-enhanced dynamic power management capabilities of the Intel Xeon processor 5600 and 7500 series. Cost-effective virtualization: Enhancing Oracle Solaris to take advantage of the latest Intel Virtualization Technology (Intel VT) features enables the highest consolidation ratios. Storage Options for Oracle Solaris x86 Oracle offers a full range of storage solutions, including flash storage arrays, the Sun Flash Accelerator PCIe card, disk arrays, and unified storage arrays. Disk Storage Oracle Sun Storage Fibre Channel Arrays provide mission-critical, tier-1 storage that scales in every dimension. Tailor performance profiles to site and application specific needs to achieve higher application performance while reducing power, space, and cooling requirements. 2 Oracle Solaris Premier Subscription for Non-Oracle Hardware, 3 oracle-solaris-intel-xeon-bwp pdf, pdf. 8 RAID 0, 1, 3, 5, 6 (p+q), and 10 support matches performance and availability to any mix of application requirements. As indicated in the subsequent section on file system recommendations, RAID configurations provided by Oracle Sun Storage Fibre Channel Arrays are fully supported and recommended for use in conjunction with Oracle ASM and provides the best storage solution, in terms of both performance and reliability. Flash Storage Oracle provides the industry s most complete Flash-based storage portfolio, from high-performance arrays through Flash-optimized system software and databases, all with Oracle support. Using Oracle Flash-based storage can reduce I/O service times up to 15x, and accelerate applications up to 2x using Oracle's Flash storage and Flash-optimized database and systems software. Oracle provides two Flash storage options: the Sun Storage 5100 Flash Array and the Sun Flash Accelerator PCIe Card. Oracle s Sun Storage F5100 Flash Array is the world's fastest and most power-efficient flash array for accelerating databases and I/O intensive applications. It redefines database performance, cutting transaction times in half and doubling application throughput. The Sun Storage F5100 Flash Array lets you scale your performance and capacity needs efficiently without impacting data availability so you can meet your growing business needs. The Sun Flash Accelerator PCIe Card improves response times, and reduces I/O latency. Based on Oracle s Sun FlashFire technology, it delivers the I/O performance of over 300 disk drives to eliminate storage I/O bottlenecks and help your servers and applications run faster and more efficiently. In particular, the Sun Flash Accelerator PCIe card can be used in Flash Cache configurations, which are a new feature in Oracle Database 11gR2. Unified Storage Oracle Sun Unified Storage 7000 Series Systems combine an innovative storage architecture and file system with storage analytics and management technologies to deliver leadership performance and value. Oracle Sun Unified Storage Systems simultaneously provide multiple storage interconnects (Gigabit Ethernet, 10GbE, Fibre Channel and InfiniBand), thereby consolidating storage for file and block I/O driven applications onto a single high-capacity, high-performance storage system with reduced administration and the industry's most comprehensive and intuitive analytics environment. Oracle Sun Unified Storage Systems run the ZFS file system. As mentioned in the following section on file system recommendations, Oracle ZFS is recommended for Oracle Database binaries and fully certified for Oracle Database data files. Storage analytic and storage management tools are included with Oracle Sun Unified Storage Systems, which enables an integrated view from Oracle Database to Oracle Sun Storage 7000 and provides monitoring of multiple storage systems from a single pane. File System Recommendations 9 While the Oracle binaries can be installed on any supported file system, the recommended best practice for Oracle Database deployments on Oracle Solaris is to use Oracle Solaris ZFS for the Oracle Database binaries and Oracle ASM as an integrated volume manager for the Oracle Database data files. However, if you choose to use Oracle Solaris ZFS for Oracle database deployment, which is certified for Oracle Database 10g and 11g, refer to the resources section for a list of collateral on best practices for using Oracle Solaris ZFS with Oracle Database. Oracle Binaries Oracle Solaris ZFS Oracle Solaris Zettabyte File System (ZFS) technology offers a dramatic advancement in data management with a virtual storage pool design, integrated volume manager, and data services that provide an innovative approach to data integrity. Oracle Solaris ZFS software enables more efficient and optimized use of storage devices, while dramatically increasing reliability and scalability. Physical storage can be dynamically added or removed from storage pools without interrupting services, providing new levels of flexibility, availability, and performance. Oracle Solaris ZFS protects all data by 256-bit check sums, resulting in percent error detection and correction. Oracle Solaris ZFS constantly reads and checks data to help ensure it is correct, and if it detects an error in a storage pool with redundancy (protected with mirroring, Oracle Solaris ZFS RAIDZ, or Oracle Solaris ZFS RAIDZ2), Oracle Solaris ZFS automatically repairs the corrupt data. This contributes to continuous availability by helping to protect against costly and timeconsuming data loss due to hardware or software failure, and by reducing the chance of administrator error when performing file system-related tasks. Oracle Solaris ZFS software optimizes file system reliability by maintaining data redundancy on commodity hardware. It seamlessly and transparently supports new hybrid disk storage pools that include Flash technology for superior application performance. Oracle Solaris ZFS can also be used to create snapshots and clones: snapshots are read-only, while clones are read-write copies of the file system. In addition to typical disaster recovery and other business continuity purposes, Oracle Solaris ZFS snapshots are particularly useful as the Oracle Database environment is being built. In case of any configuration errors, the entire filesystem may be reverted back to its previous state. Deployments to multiple target systems can be accelerated using Oracle Solaris ZFS cloning functionality. Instead of installing multiple systems from scratch, existing instances may be cloned in a fraction of the time. Oracle Data Files ASM As mentioned above, the recommended practice for the Oracle Database data files is to use Oracle Automatic Storage Management (ASM) as an integrated volume manager. Once disk sets are configured, Oracle ASM will begin to stripe data across all available disk sets. The striping method is configurable to three levels: 10 Normal Oracle ASM will maintain two copies of all data High Availability Oracle ASM will maintain three copies of all data. External Oracle ASM will maintain only one copy of all data. In this scenario, the external storage device is expected to mirror its own data. Please note that data redundancy can be defined at a much more granular level (down to the file level). Advanced configurations such as this, are beyond the scope of this paper. For further details, please see the Storage Administrators' Guide. For storage systems that do not provide hardware RAID redundancy, it is recommended to present all storage devices to Oracle ASM individually,
Recommended
View more...
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x