Performance Tuning Corporation has successfully implemented more than 300 Oracle Real Application Cluster (RAC) systems on UNIX, Linux and Windows. Below are some important things to consider before engaging your critical resources.
- Server, Storage and Network (SAN) Implementation Knowledge. Without these skills, it is impossible to properly configure and tune Oracle RAC due to the various server, network and application interdependencies.
- Operating System and Application Skills. We have implemented RAC systems on UNIX, Linux and Microsoft Windows platforms with leading applications such as Oracle eBusiness Suite, PeopleSoft and J.D. Edwards.
- Oracle Skills and Oracle RAC Experience. Database layout and design is important to scale and optimize the performance of Oracle RAC. Without previous experience with RAC, your installation may not be successful or perform as expected. We understand how to implement and optimize Oracle, Oracle RAC and your SAN (network) environment.
Let us make your job easier and be more productive, leverage our experience in the design and implementation of your Oracle RAC system.
Below is an example engagement that can be tailored to your specific environment. Variable components include OS, hardware, storage, file system, virtualization, database version, number of nodes.
BASE ORACLE 2-NODE RAC Service Package
This service is designed as a base package to deploy a 2-node RAC and can be built upon to design a package that fits your needs. Our specialized RAC Implementation service consists of the following Phases.
Phase 1 – System Installation and Configuration Planning
This phase is to assist Client in understanding requirements, making configuration decisions and providing recommendations for system setup for Oracle 11gR2 RAC and the chosen OS, including discussions on the following areas (not limited to).
- OS and Version
- Oracle Validated RPM for the OS (if appropriate)
- OS packages
- Groups and users
- Packages to support gnome desktop and VNC Server (if appropriate)
- NIC and bonding recommendations
- Required IP Addresses
- SCAN (Single Client Access Name) IPs
- Cluster Name
- Filesystem layout
- Shared Storage
- Shared storage access – Fibre Attached, NFS, iSCSI, etc.
- Cluster Configuration files
- OCR and Voting Disk – RAID method
- LUN configuration recommendations
- Database storage
- ASM or clustered filesystem
- Multipath software to be used (i.e. PowerPath, Device Mapper, etc)
- Local storage – each node
- Filesystem space for Grid Infrastructure home (Clusterware), Database Home, EM Agent Home (optional) – recommend space for /tmp directory, GRID HOME, ORACLE HOME
- Cluster Name
- Database Name
Phase 2 – 2-Node RAC Implementation
Implementation of a 2-node Oracle RAC. All hardware, storage, shared storage volumes, network and FC cabling will be setup, configured and verified operational by Client before implementation begins, as appropriate. RAC implementation will consist of the following high-level steps:
- Validate hardware and storage setup, gather software and license information
- Install OS and patches to current release level
- Validate configuration of OS for an Oracle installation
- Verify all networking functionality
- Validate network interface configuration
- Validate accessibility to external shared storage from each server node
- Configure shared storage for use by Oracle (multipath configuration)
- Install and configure Oracle 11gR2 RAC for 2-node cluster
- Patch the Oracle software to the current release level (if desired)
- Create a Seed Database on the RAC cluster
- Verify Oracle RAC functionality and failover capabilities
- A written summary documenting the final configuration of the implemented 2-node system.
“Performance Tuning was able to quickly troubleshoot and resolve many technical issues that often eluded other consulting companies we’ve worked with. I was most impressed by their quick response in emergency situations. They’ ve been instrumental in the delivery of Oracle technologies such as Oracle RAC, Grid Control and Data Guard.”
“Performance Tuning was able to offer unique insights to database design and performance tuning optimization on a world class level. They did a superb job of load testing, which was cited by Microsoft (a team member) as, the best we’ve seen in three years and 50 customers to come through our SQL Server Performance Tuning Lab. This statement came from the SQL Server Product Group in Redmond – a tough crowd to please. In addition, they accelerated several products including our flagship Thomson ONE Analytics and were a key part of a project whose success has lead to case studies by Intel, Microsoft, and Unisys.”
“The Instructor was able to customize the course slightly to meet the needs and levels of experience in the class. It was great to get some real hands on to cement in what was reviewed and explained.”
“We recently had a problem with SQL Server performance after introducing virtualization and a SAN in our server environment. After working with two different consulting companies without success, we contacted Performance Tuning Corporation. PTC rapidly set up a remote engagement with us, and within one week was able to identify a problem with a virtual device driver. We are very satisfied with the work PFC performed, and feel it is some of the best consulting money that we have spent in several years.”
PTC has been phenomenal. It’s a scary time when your most critical data is being moved while users are in the system working. Especially on the heals of our previous vendor’s failed attempt. I can only describe it as a calming effect when true professionals are running the show.
“We are very pleased with the work that PTC performed. They were able to extract information from SQL Server and use that information to identify the exact causes of our performance bottlenecks. They provided us with information, tools, and instructions on how we can locate the cause of our performance problems. The final report contained good information and gives us a benchmark for doing future performance reviews.”
“This is a well balanced course (Optimizing Oracle RAC on Linux) covering all major topics from System Administration to Database Administration unlike most of the courses”