Dell 10g User's Guide

Dell™ PowerEdge™ SystemsDell Oracle Database 10g R2Standard Edition onMicrosoft® Windows Server®2003 R2 with SP2,Standard x64 EditionDeployment GuideV

10 Deployment GuideInstalling and Configuring the Operating System CAUTION: To ensure that the operating system is installed correctly, disconnect all

Deployment Guide 11The boot menu screen appears.6In the Select Language Screen, select English.7On the Software License Agreement page, click Accept.T

12 Deployment GuideEnter OS Information:hEnter the appropriate User Name, Organization, and Product ID.iEnter all other necessary information.jInstall

Deployment Guide 13 CAUTION: Do not leave the administrator password blank. NOTE: To configure the public network properly, the computer name and publ

14 Deployment Guide22Run install_drivers.bat NOTE: This procedure may take several minutes to complete.23Press any key to continue.24Check the logs t

Deployment Guide 15•HBA drivers.•PowerVault MD3000 Resource CD (when using the PowerVault MD3000 as backend storage)The storage must be configured wit

16 Deployment GuideFigure 1-1. Hardware Connections for a SAN-attached Fibre Channel ClusterTable 1-4. Fibre Channel Hardware InterconnectionsCluster

Deployment Guide 17Before You Begin Verify that the following tasks have been completed for your cluster:• All hardware is installed in the rack.• All

18 Deployment GuideFigure 1-2. Cabling in a Dell|EMC SAN-Attached Fibre Channel ClusterUse the following procedure to configure your Oracle cluster st

Deployment Guide 198Connect one optical cable from HBA 1 of each additional node to Fibre Channel switch 1.Setting Up Your SAS Cluster with a PowerVau

Notes and Cautions NOTE: A NOTE indicates important information that helps you make better use of your computer. CAUTION: A CAUTION indicates potenti

20 Deployment GuideFigure 1-3. Cabling the SAS Cluster and PowerVault MD3000 Table 1-5. SAS Cluster Hardware InterconnectionsCluster Component Connec

Deployment Guide 21Before You Begin Verify that the following tasks have been completed for your cluster:• All hardware is installed in the rack.• All

22 Deployment GuideFigure 1-4. Cabling in a Direct-attached SAS Cluster Configuring Networking and Storage for Oracle RAC 10g R2This section provides

Deployment Guide 23 NOTE: Oracle RAC 10g R2 is a complex database configuration that requires an ordered list of procedures. To configure networking

24 Deployment GuideConfiguring NIC Teaming For Your Private Network Adapters NOTE: TCP Offload Engine (TOE) functionality of a TOE-capable NIC is not

Deployment Guide 25kIn the Team Properties window, click OK.lIn the Intel NIC's Properties window, click OK. mClose the Computer Management windo

26 Deployment GuidemIn the Broadcom Advanced Control Suite 3 window, click File then Exit.5Repeat step 1 through step 4 on the remaining nodes.Configu

Deployment Guide 27fIn the Properties window, click Close.gRepeat step a through step f for the Private NIC team. NOTE: Private NIC team does not req

28 Deployment Guide155.16.170.201rac1-vip155.16.170.202rac2-vip NOTE: Registering the private IP addresses with the DNS server is not required as the

Deployment Guide 29Verifying the Storage Assignment to the Nodes1On the Windows desktop, right-click My Computer and select Manage.2In the Computer Ma

Contents 3ContentsTerminology Used in this Document. . . . . . . . . . . . 7Software and Hardware Requirements. . . . . . . . . . 8Minimum Software

30 Deployment Guide NOTE: For more information, see the EMC PowerPath documentation that came with your Dell|EMC storage system.2When the installatio

Deployment Guide 31To prepare the disks for Oracle Clusterware, identify the OCR, voting, data and flash recovery area disks. After you identify the a

32 Deployment Guide9Create a logical drive for the OCR disk.aOn the partition area of the disk identified for OCR and voting disk (1 GB LUN/virtual di

Deployment Guide 33 NOTE: If you are using Redundant Voting Disk and OCR, repeat the steps outlined in step 9 and step 10 for the redundant Voting Di

34 Deployment Guide3If you find any drive letters assigned to the drives that you created in "Preparing the OCR and Voting Disks for Clusterware&

Deployment Guide 354In the Specify Home Details window, accept the default settings and click Next. NOTE: Record the OraCR10g_home (CRS Home) path f

36 Deployment Guide11In the Cluster Configure Storage screen, perform the following steps for the Voting disk:aLocate the three 50 MB partitions that

Deployment Guide 37The OUI starts and the Welcome window appears.3Click Next.4In the Select Installation Type window, click Standard Edition and click

38 Deployment Guide1Download the patchset 10.2.0.4 from the Oracle Metalink website located at metalink.oracle.com. 2Unzip the patchset to the followi

Deployment Guide 39 NOTE: You must install the patchset software from the node where the Oracle RAC 10g R2 software was installed. If this is not the

4 ContentsInstalling Oracle RAC 10g R2 Using ASM . . . . . . . . 33Installing Oracle Clusterware Version 10.2.0.1. . . 33Installing Oracle10g Data

40 Deployment Guide3In the Real Application Clusters Configuration window, select Cluster configuration and click Next.4In the Real Application Cluste

Deployment Guide 413In the Run field, enter dbca and click OK. The Database Configuration Assistant starts. 4In the Welcome window, select Oracle Real

42 Deployment GuidebIn the Redundancy box, select External.cClick Stamp Disks.dSelect Add or change label and click Next.eIn the Select disks screen,

Deployment Guide 4319In the Database File Locations window, select Use Oracle-Managed Files and Multiplex Redo Logs and Control Files and click Next.2

44 Deployment GuideConfiguring and Deploying Oracle Database 10g (Single Node)This section provides information about installing the Oracle 10g R2 sof

Deployment Guide 457Click Next. The Specify Network Interface Usage window appears, displaying a list of cluster-wide network interfaces. 8In the Inte

46 Deployment Guide15Click Exit to finish the OUI session.16In the Exit window, click Yes.Installing Oracle10g Database With Real Application Clusters

Deployment Guide 478 In the Product-Specific Prerequisite Checks window, click Next.9In the Select Configuration Option window, select Install Databas

48 Deployment GuideInstalling the Patchset NOTE: You must install the patchset software from the node where the Oracle RAC 10g R2 software was install

Deployment Guide 495In the Summary window, click Install.During the installation, the following error message may appear: Error in writing to file oci

Contents 5Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69

50 Deployment Guide9In the Listener Configuration More Listeners window, select No and click Next.10In the Listener Configuration Done window, click N

Deployment Guide 5110In the Storage Options window, select Automatic Storage Management (ASM) and click Next.11In the Create ASM Instance window, perf

52 Deployment GuideFor example, FLASH.bIn the Redundancy box, select External.cClick Stamp disks.dIn the Select disks screen, select the disk which yo

Deployment Guide 53hClick Next.20In the Database Content window, click Next.21In the Database Services window, click Next.22In the Initialization Para

54 Deployment GuideNET USE \\host_name\C$You have the required administrative privileges on each node if the operating system responds with:Command co

Deployment Guide 557Execute the following command to identify the node names and node numbers that are currently in use:CRS home\bin\olsnodes -n8Execu

56 Deployment Guidevipca -nodelist Node1,Node2,Node3,...NodeN6Add a listener to the new node only by running the Net Configuration Assistant (NetCA).A

Deployment Guide 5711Review the information on the Summary dialog and click OK. The DBCA displays a progress dialog showing the DBCA performing the in

58 Deployment Guide%SystemDrive%\Oracle\product\10.2.0\crs\bin\vipcawhere %SystemDrive% is the user’s local drive.3Follow the steps in VIPCA by select

Deployment Guide 59aClick Start→Run.bIn the Run field, enter the following and click OK:services.mscThe Services window appears.2Identify and delete a

6 Contents

60 Deployment GuideIf OCRCFG, OCRMIRRORCFG, Votedsk1, Votedsk2, and Votedsk3 do not appear in the file, assign OCRCFG, OCRMIRRORCFG, Votedsk1, Votedsk

Deployment Guide 616Delete the symlinks for the OCR (OCRCFG and OCRMIRRORCFG) and the voting disks (Votedsk1, Votedsk2, and Votedsk3).aSelect OCRCFG,

62 Deployment GuidePowerPath Installation• PROBLEM: PowerPath installation fails.–CAUSE: Unknown installation error. – RESOLUTION: Reboot the system o

Deployment Guide 63 NOTE: Though the suggested solutions may fix the above mentioned issue, be aware of the implications or issues that may arise fro

64 Deployment GuideaUninstall Oracle Clusterware using OUI.bUninstall any remaining Oracle services.cClean the storage devices.See "Uninstalling

Deployment Guide 65See "Installing the Host-Based Software Needed for Storage" on page 27 and "Verifying Multi-Path Driver Functionalit

66 Deployment GuideStorage• PROBLEM: Disks appear as unreachable.–CAUSE: On the Windows desktop, when you right-click My Computer, select Computer Man

Deployment Guide 67– CAUSE: The public network adapter interface (or the network interface assigned for VIP in case 4 network interfaces) name is not

68 Deployment GuideOracle SupportFor information about Oracle software and application clusterware training and contacting Oracle, see the Oracle webs

Index 69IndexCcablingSAS storage, 20clusterfibre channel, 9, 15Clusterwareinstalling, 33, 43preparing disks, 29uninstalling, 56Ddisksflash recovery, 3

Deployment Guide 7This document provides information about installing, configuring, reinstalling, and using your Oracle Database 10g R2 software follo

70 IndexNNaviagent, 27networkconfiguring, 21NICport assignments, 22OOCRdisk, 29Oraclepreparing disks for Clusterware, 29Oracle Database 10gconfiguring

8 Deployment Guideenvironment and virtual disk is commonly used in a Direct-attached SAS (Dell MD3000/MD3000i and Dell MD3000/MD3000i with MD1000 expa

Deployment Guide 9Table 1-2. Minimum Hardware Requirements - Direct-Attached SAS or Fibre Channel Cluster Configurations Hardware Component Configura