Dell™ PowerEdge™ SystemsDell Oracle Database 10g R2Enterprise Edition onMicrosoft® WindowsServer®2003 R2 with SP2,Standard or Enterprisex64 EditionDep

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

Deployment Guide 116In the Select Language screen, select English.7On the Software License Agreement page, click Accept.The Systems Build and Update U

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

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

14 Deployment Guide22Run install_drivers.bat NOTE: This procedure may take several minutes to complete.23Press any key to continue.24If your current

Deployment Guide 15%SystemDrive%\Tempwhere %SystemDrive% is the user’s local drive.4Repeat all steps in this section for all nodes in the cluster.Veri

16 Deployment GuideFigure 1-1. Hardware Connections for a SAN-attached Fibre Channel ClusterTable 1-5. 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 19Configuring Networking and Storage for Oracle RAC 10g R2This section provides the following information about network and storage c

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

20 Deployment GuideConfiguring and Teaming the Private NetworkBefore you deploy the cluster, assign a private IP address and host name to each cluster

Deployment Guide 21dRight-click the Intel NIC, which is identified for NIC teaming and select Properties.eClick the Teaming tab.fSelect Team with othe

22 Deployment GuideIncluding this adapter in a team will disrupt the system management features. Click Yes to proceed.gClick Next.hIn the Designating

Deployment Guide 232Configure the IP addresses. NOTE: You must set a default gateway for your public interface, otherwise, the Clusterware installati

24 Deployment Guide4On all nodes, add the public, private, and virtual IP addresses and host name to the %SystemRoot%\system32\drivers\etc\hosts file.

Deployment Guide 25Installing the Host-Based Software Needed for StorageTo install the EMC Naviagent software using the EMC software that came with yo

26 Deployment GuideInstalling PowerPath for Dell|EMC Systems1On node 1, install EMC® PowerPath®. NOTE: For more information, see the EMC PowerPath do

Deployment Guide 272In the Run field, enter cmd and click OK.3At the command prompt, enter diskpart.4At the DISKPART command prompt, enter automount e

28 Deployment GuideThe Welcome to the New Partition Wizard appears.bClick Next.cIn the Select Partition Type window, select Logical drive and click Ne

Deployment Guide 29Preparing the Database Disk and Flash Recovery Area for Database Storage With OCFSThis section provides information for creating lo

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

30 Deployment GuidePreparing the Database Disk and Flash Recovery Area for Database Storage With ASMThis section provides information about creating l

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

32 Deployment Guide2In the Oracle Clusterware - Autorun window, click Install/Deinstall Products. This will start the Oracle Universal Installer (OUI)

Deployment Guide 33cIn the Specify Disk Configuration window, select Place OCR (Primary) on this partition and click OK.dSelect the second partition a

34 Deployment GuideeUse the pull-down menu of the Assign Drive Letter option to assign a drive letter to the partition.fClick OK.14In the Cluster Conf

Deployment Guide 35where %CD-ROM drive% is the drive letter of your CD drive.2In the Oracle Database 10g - Autorun window, click Install/Deinstall Pro

36 Deployment Guide NOTE: You must perform the procedures as listed in the window before proceeding to the next step.12After completing the required

Deployment Guide 37%SystemDrive%\Oracle_patch\setup.exewhere %SystemDrive% is the drive on which you unzipped the Oracle patchset.2In the Welcome scre

38 Deployment Guide3In the Specify Home Details window, select the name as OraDb10g_home1 from the drop-down list and click Next.4In the Specify Hardw

Deployment Guide 395In the Listener Configuration, Listener window, select Add and click Next.6In the Listener Configuration, Listener Name window in

4 ContentsDownloading the Latest Oracle Patches . . . . . . 39Configuring the Listener . . . . . . . . . . . . . . 39Creating the Seed Database .

40 Deployment Guide9In the Database Credentials window, click Use the Same Password for All Accounts, enter a new password in the appropriate fields,

Deployment Guide 41bClick OK.16Click Next.17In the Database Content window, accept the default values and click Next.18In the Database Services window

42 Deployment GuideInstalling Oracle Clusterware Version 10.2.0.11On node 1, insert the Oracle Clusterware CD into the CD drive.The OUI starts and the

Deployment Guide 43aLocate the two 120 MB partitions that you created in the subsection "Preparing the OCR and Voting Disks for Clusterware"

44 Deployment Guide1Insert the Oracle Database 10g Release 2 CD into the CD drive. The OUI starts and the Welcome screen appears. If the Welcome scree

Deployment Guide 45 NOTE: You should perform the steps as listed in the window before proceeding with the next step. 12Click Exit. Installing Patchse

46 Deployment Guide5In the Summary window, click Install.6At the End of installation window, perform all the steps listed in the Summary window except

Deployment Guide 47Configuring the ListenerThis section contains procedures to configure the listener, which is required to establish a remote client

48 Deployment Guide EVM appears healthy NOTE: If the output indicated above does not appear, enter crsctl start crs.cClose the cmd window by

Deployment Guide 4913In the Database Configuration Assistant window, click OK.The ASM Creation window appears, and the ASM Instance is created. NOTE:

Contents 5Obtaining and Using Open Source Files . . . . . . . . 76Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87

50 Deployment GuideeIn the Generate stamps with this prefix field, enter FLASH, and click Next.fIn the Stamp disks window, click Next.gClick Finish to

Deployment Guide 5126In the Summary window, click OK.The Database Configuration Assistant window appears, and the Oracle software creates the database

52 Deployment Guide3In the Welcome screen, click Next. 4In the Specify Home Details window, accept the default settings and click Next. NOTE: Record

Deployment Guide 5312Click Next.13Ignore the warning messages and click OK.14In the Summary window, click Install to start the installation procedure.

54 Deployment Guide•In the Path field, the complete Oracle home path is%SystemDrive%\oracle\product\10.2.0\db_1where %SystemDrive% is the user’s local

Deployment Guide 55%SystemDrive%:\%CRS_HOME%\bin> srvctl stop nodeapps -n <node_name>where %SystemDrive% is the user’s local drive.2Stop all

56 Deployment Guide3In the Specify home details window, select the name as OraDb10g_home1 from the drop down list to install the patchset to Oracle ho

Deployment Guide 577In the Listener Configuration Select Protocols window, select TCP in the Selected protocols field and click Next.8In the Listener

58 Deployment Guide9In the Database Credentials window, click Use the Same Password for All Accounts, enter a new password in the appropriate fields,

Deployment Guide 5916In the Create Disk Group window, enter the following information for the Flash Recovery Area.aIn the Disk Group Name field, enter

6 Contents

60 Deployment GuidegIn the Edit Archive Mode Parameters window, ensure that the path listed under the Archive Log Destinations is as follows: +FLASH/,

Deployment Guide 61Make sure that you can execute the following command from each of the existing nodes of your cluster where the host_name is the pub

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

Deployment Guide 636Execute the VIPCA utility from the bin subdirectory of the Oracle home using the -nodelist option with the following syntax that i

64 Deployment Guide11Review the information on the Summary dialog and click OK. The DBCA displays a progress dialog showing the DBCA performing the in

Deployment Guide 65If this occurs, perform the following steps to work around the error. These steps are detailed in Metalink Note ID 338924.1. This g

66 Deployment Guide6In the Welcome window, click Cancel.7When prompted, click Cancel, and then click Yes.Deleting Oracle Services1On node 1, launch th

Deployment Guide 67where %SystemDrive% is the user’s local drive.The Oracle Symbolic Link Exporter (ExportSYMLinks) imports the symbolic links to theS

68 Deployment Guide5Launch the Oracle GUI Object Manager.At the command prompt, enter the following:%SystemDrive%\ora_bin_utils\GUIOracleOBJManager.ex

Deployment Guide 6911Repeat the procedures "Preparing the Disks for Oracle Clusterware" on page 26 and "Removing the Assigned Drive Let

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

70 Deployment Guide• Turn off Spanning Tree on the switch.•Enable Port Fast Learning (or equivalent, which may be called something different depending

Deployment Guide 71cClean the storage devices.See "Uninstalling Oracle Clusterware" on page 65 for more information.• PROBLEM: The Configura

72 Deployment GuidenVerify the following:• The storage system is functioning properly.• All fiber-optic cables are connected and secure.• The cluster

Deployment Guide 73crsctl set css misscount n where n is a value greater than 120.dRestart node 1 and log on as administrator.eRestart each of the oth

74 Deployment GuideNext, ensure that the fiber optic cables connected to the cluster nodes and storage system are installed correctly. See "Cabli

Deployment Guide 75Getting HelpDell SupportFor detailed information about using your system, see the documentation that came with your system componen

76 Deployment Guide

Index 87IndexCclusterfibre channel, 9, 16Clusterwareinstalling, 42, 52preparing disks, 26uninstalling, 66Ddatabase disk, 29disksdatabase, 29flash reco

88 IndexNNaviagent, 25networkconfiguring, 19NICport assignments, 20OOCFS, 29creating seed database, 40installing Oracle using, 31OCRdisk, 26Oracleprep

8 Deployment Guidevirtual disk is commonly used in a Direct-attached SAS (Dell MD3000/MD3000i and Dell MD3000/MD3000i with MD1000 expansion) storage e

Deployment Guide 9Table 1-2. Minimum Hardware Requirements - Fibre Channel Cluster Configurations Hardware Component ConfigurationDell™ PowerEdge™ sys