Page 2 - Introduction; Executive Overview
Introduction Migrating traditional Oracle databases to Oracle Real Application Clusters has become an emerging trend in the IT field. The reasons are clear: Oracle RAC offers a way to obtain high availability and high performance benefits at a relatively low cost. Dell PowerEdge servers are one of t...
Page 3 - Installing Microsoft Windows Server OS; Oracle Enterprise Manager; Data Guard
Of course, any solution with this much cutting-edge technology is going to have a fair amount of inherent complexity. This can be discouraging to someone attempting a new Oracle RAC deployment. However, this paper focuses on the areas where IT staff needs the most help: configuring the cluster hardw...
Page 4 - Preparing Windows Server for Oracle Installation
Oracle Data Provider for .NET (ODP.NET) – .NET data provider designed exclusively by and for Oracle for optimal data access from .NET to Oracle 9i Database and Oracle Database 10g. Can be used from any .NET language, including C# and Visual Basic .NET. Microsoft Windows Server offers a powerful plat...
Page 6 - Configuring the Cluster Hardware
The order that the server’s NIC cards (and IP addresses) are defined to Windows is important. Windows must recognize the public IP address as the first address. Otherwise, any Oracle utility that uses “gethostbyname” (such as Oracle Enterprise Manager) might identify the wrong host. In Windows 2000,...
Page 7 - Dell Minimum Hardware List and System Requirements
Dell Minimum Hardware List and System Requirements Oracle provides some general guidelines for minimum hardware and software requirements. These include: • External shared storage • At least 256 MB of RAM on each node (512 MB preferred) • Oracle supported clusterware. In Oracle9i, Oracle supports a ...
Page 8 - Cluster Hardware Considerations for Oracle RAC; RAID Systems
Cluster Hardware Considerations for Oracle RAC This section covers some of the issues that you should consider when choosing hardware for your Oracle RAC system. Two of the key issues are how to choose the right RAID level for your shared storage, and how to choose the right amount of memory for you...
Page 9 - RAID Comparison
RAID 5 RAID 5 uses parity for fault tolerance. The advantage of using parity is that instead of having to double the number of disk drives in the system, you only have to add one disk drive to store the parity. RAID 5 uses parity, but distributes the parity among all of the disk drives in the RAID v...
Page 10 - Recommendations for Oracle Component Placement; Configuring Server Memory; Large Memory Implementation
Recommendations for Oracle Component Placement Oracle is sensitive to read performance and sensitive to write performance on the redo log files and on the archive log files. Thus, the following recommendations are given. OS Volume - The OS should be installed on a RAID 1 disk volume. It is important...
Page 11 - Changes in Memory Requirements for RAC
Another technique is available to address memory above 4 GB. The Address Windowing Extensions interface (AWE) allows access to RAM up to 64 GB. AWE is implemented through Physical Address Extensions, which are enabled by setting the /PAE flag in the boot. ini file. In addition, the account that runs...
Page 12 - Features of the Dell PowerEdge 6850 Server; Performance Enhancements
But in general, please take into consideration that memory requirements per instance are reduced when the same user population is distributed over multiple nodes. In this case: Assuming the same user population N number of nodes M buffer cache for a single system then (M / N) + ((M / N )*0.10) [ + e...
Page 14 - Impact of the Dell PowerEdge 6850 on RAC Implementations
The Dell PowerEdge 6850 server is capable of running in several different modes, due to the EM64T processor. There two major modes: IA32e mode and Legacy mode. IA32e mode is automatically invoked when a 64-bit OS is booted. Legacy mode is automatically invoked when either a 32-bit OS or 16-bit OS is...
Page 15 - Dell | EMC Fibre Channel Storage Installation Steps
Installing and Configuring the Dell | EMC SAN or PowerVault Shared Disk Array Installing and configuring a Dell | EMC SAN is a discipline unto itself. It requires training and specific storage domain knowledge. For- tunately, most of the “heavy lifting” is usually performed by Dell Professional Serv...
Page 16 - Best Practice LUNs -
For a two-node cluster, you may directly attach to a CXx00 storage array with fiber cables rather than using a switch. This requires at least two HBAs and associated cables per server. In addition, PowerPath software is required for these implementations. Dell PowerVault Installation Steps A more co...
Page 17 - Oracle10g and ASM; Setting Up Networking
Oracle10g and ASM All of the recommendations listed above apply to Oracle9i or Oracle10g utilizing the Oracle Cluster File System. However, if the Automatic Storage Management option is used for Oracle10g, the rules may need to be modified. With ASM, Oracle software can take on the responsibility fo...
Page 19 - Verifying that the SAN is Ready for Oracle
If you choose to utilize Intel NICs for teaming, perform the following configuration steps: 1. Install Intel PROSet II (if necessary) 2. Start Intel PROSet II as described in Using PROSet II 3. Run the Teaming Wizard to add adapters to each team. 4. See the PROSet II Help for additional information....
Page 22 - Shared Disk Configuration; Install Cluster Software; Installing Oracle9i Clusterware
Shared Disk Configuration On windows 2003 (32 and 64 bit versions), the user must enable the automatic mounting of new volumes on each node in the cluster. • The default value for auto mounting was changed from enabled in Windows 2000 to disabled in Windows 2003, so this additional step is required....
Page 23 - Staging Oracle Patches
Note: As of October 2004, the 9.2.0.6 patchset is available for Windows. However, the 9.2.0.6 clusterware patch is not yet available as of this publication. In the interest of offering a fully tested RAC configuration, this paper will cover a consistent upgrade to all 9.2.0.5 components. Those wishi...
Page 26 - Install the 2.2.0.18 Version of the Oracle Universal Installer
The Cluster Wizard will create only one OCFS drive for data files. If you would like to create additional OCFS drives from the logical partitions you created earlier, do the following: 1. Use Windows Disk Management tool to assign the unformatted logical partition a driver letter. • Start disk Manag...
Page 27 - Installing Oracle10g Cluster Ready Services; Pre-installation Steps
Installing Oracle10g Cluster Ready Services In Oracle10g, the Clusterware has been placed on a separate CD which installs Cluster Ready Services. You must install from this disk before installing from the Oracle10g Database installation CD. In addition, you must complete some pre-installation steps ...
Page 29 - Install Oracle Database Software; Installing Oracle9i Database Software
Cluster Ready Services are now installed, and you are ready to install Oracle10g software. Install Oracle Database Software Whether you are installing Oracle9i or Oracle10g, completion of the Cluster Software installation step makes it possible to perform an Oracle database software installation tha...
Page 30 - Oracle10g OUI Installation Steps
11. Software installation may take an hour or more. To successfully complete the software installation, perform the following additional steps: a. Installation progress may appear to be hung while operations are occurring on remote nodes. To check progress, check for I/O activity on each node, or ch...
Page 32 - Remaining Clusterware Patch Steps
Oracle 9.2.0.5 Patch Installation Steps To install the Oracle 9.2.0.5 patchset, re-launch the OUI: 1. Open a command prompt window. 2. Navigate to the E:\oracle_stage\9205\Disk 1 directory. 3. Run setup.exe. 4. In the “OUI Welcome screen”, click “Next”. 5. In the next screen, check that the “Source ...
Page 33 - Fix the CM Service Priority
4. Patch the OLM files by copying all of the following files from the E:\oracle_stage\ocfs9205\3575688\Disk1\preinstall_rac\olm directory to both of the following directories: a. Directories: %ORACLE_HOME%\bin C:\WINNT\System32\osd9i\olm b. Files: crlogdr.exe DeleteDisk.exe ExportSYMLinks.exe GUIOra...
Page 34 - Installing Oracle10g Database Software; Creating an Oracle Database
Installing Oracle10g Database Software While installing Oracle10g database software, you have the option of creating a Starter Database. In this example, creation of the Starter Database will be delayed, in order to explain the technique of creating a database at any time outside of the software ins...
Page 35 - Configuring the Oracle Listener; Creating an Oracle9i Seed Database; Pre-Database Creation Tasks
Configuring the Oracle Listener Before creating a database, it is necessary to first create the Listener service for Oracle Net. To create a database in Cluster Mode, both local and remote entries in the listener.ora and tnsnames.ora file must be pre-created. The remote listener must be named LISTEN...
Page 36 - Database Creation Tasks
Under Oracle9i RAC, several issues have been noted with DBCA. If you follow the instructions below, you should finish database cre- ation without any problems. Nevertheless, it may prove helpful to create a trace file for the DBCA installation. In case of a problem, the trace file will help you dete...
Page 37 - Post-Database Creation Tasks; Creating an Oracle10g Seed Database
11. In the “Creation Options” page, choose at least the “Create Database” option. You may also choose the “Create Template” and “Save as a Script” options. Click “Finish”. 12. The “DBCA Summary” page is displayed. Review the information, and then click “OK”. Database creation progress is displayed. ...
Page 40 - Post-Installation Tasks
Post-Installation Tasks There are some post-installation tasks that are common to Oracle9i and Oracle10g installations. These tasks are covered below. First, verify that all services start properly after booting the servers. Use the following steps: 1. Reboot each node. 2. Select Start -> Setting...
Page 41 - Summary
Summary Many companies are currently interested in deploying Oracle Real Application Clusters on the Microsoft Windows Server platform. Microsoft Windows Server offers a powerful platform for corporate databases that may also be managed with skill sets readily available within most IT departments. O...
Page 42 - References
References “Configuring Disks in Windows 2000”; Oracle MetaLink Note 109711.1; Oracle Corporation, November, 2002; http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=109711.1 “CRS and10g Real Application Clusters”; Oracle MetaLink Note 259301.1; Orac...