book.book Page 1 Tuesday, March 23, 2010 11:49 PM Dell™ PowerEdge™ Systems Oracle® Database on Microsoft® Windows Server® x64 Database Setup and Installation Guide Version 4.
book.book Page 2 Tuesday, March 23, 2010 11:49 PM Notes and Cautions NOTE: A NOTE indicates important information that helps you make better use of your computer. CAUTION: A CAUTION indicates potential damage to hardware or loss of data if instructions are not followed. ____________________ Information in this document is subject to change without notice. © 2009–2010 Dell Inc. All rights reserved. Reproduction of these materials in any manner whatsoever without the written permission of Dell Inc.
book.book Page 3 Tuesday, March 23, 2010 11:49 PM Contents 1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . Required Documentation for Installing Oracle Database 10g R2 . . . . . . . . . . . . . . . . . . . . . . 5 . . . . . . . . . . . 6 . . . . . . . . . . . . . . . . . . . . . . . . 6 Terminology Used in This Document Getting Help Dell Support . . . . . . . . . . . . . . . . . . . . . . 6 . . . . . . . . . . . . . . . . . . . . 6 Oracle Support 2 Before You Begin . . . .
book.book Page 4 Tuesday, March 23, 2010 11:49 PM Configuring the Listener . . . . . . . . . . . . . . . . . Creating the Seed Database . 4 . . . . . . . . . . . . . . Installing Oracle RAC 10g R2 Using ASM . . . . . . . . . . . . . . . . . . . . . . . . . Installing Oracle Clusterware . 21 . . . . . . . . . . . . . 21 . . . . . . . . 24 . . . . . . . . . . . . . 25 . . . . . . . . . . . . 26 Installing Oracle 10g R2 Patchset Installing Patchset 10.2.0.4 for Oracle 10g Clusterware . . . . .
book.book Page 5 Tuesday, March 23, 2010 11:49 PM Overview This document applies to: • Oracle® Database 10g R2 Enterprise Edition on Microsoft® Windows Server® 2003 R2 SP2 Enterprise or Standard x64 Edition or Windows Server 2008 SP2 Enterprise or Standard x64 Edition. • Oracle Database 10g R2 Standard Edition on Microsoft Windows Server 2003 R2 SP2 Standard x64 Edition or Windows Server 2008 SP2 Standard x64 Edition.
book.book Page 6 Tuesday, March 23, 2010 11:49 PM Terminology Used in This Document This document uses the terms logical unit number (LUN) and virtual disk. These terms are synonymous and can be used interchangeably. The term LUN is commonly used in a Dell/EMC Fibre Channel storage system environment and virtual disk is commonly used in a direct-attached SAS (Dell™ PowerVault™ MD3000/MD3000i and PowerVault MD3000/MD3000i with PowerVault MD1000 expansion) storage environment.
book.book Page 7 Tuesday, March 23, 2010 11:49 PM Before You Begin This section provides information on basic installation requirements for Oracle® Real Application Cluster (RAC) 10g R2. Choosing the Correct Oracle Installation Media To choose the correct Oracle installation media version for your Microsoft® Windows Server® operating systems, see Table 2-1. Table 2-1.
book.
book.book Page 9 Tuesday, March 23, 2010 11:49 PM Installing Oracle® RAC 10g R2 Using OCFS This section applies only to Oracle® Enterprise Edition. This section describes the procedures to install Oracle Real Application Cluster (RAC) 10g R2 using Oracle Cluster File System (OCFS). NOTE: If you want to install Oracle using Automatic Storage Management (ASM), ignore the following steps and follow the procedures given under "Installing Oracle RAC 10g R2 Using ASM" on page 21.
book.book Page 10 Tuesday, March 23, 2010 11:49 PM 5 In the Product Specification Prerequisite Checks window: • For Windows Server 2003: Ensure that the installation program completes all the checks successfully and then click Next. • For Windows Server 2008: The Product Specification Prerequisite Check fails for the OCFS and Orafence Driver’s Signature.
book.book Page 11 Tuesday, March 23, 2010 11:49 PM 10 In the Cluster Configuration Storage window, perform the following steps for the Oracle Cluster Registry (OCR) disk: a Locate the two 300 MB partitions that you created. For more information on the procedure, see Preparing the OCR and Voting Disks for Clusterware in Oracle Database on Microsoft Windows Server x64 – Storage and Network Guide available at support.dell.com/manuals. b Select the first partition and click Edit.
book.book Page 12 Tuesday, March 23, 2010 11:49 PM d Ensure that you select Use partition for data storage. e Use the drop-down menu of the Assign Drive Letter option to assign a drive letter to the partition. f Click OK. 13 In the Cluster Configuration Storage window, perform the following steps for flash recovery: a Locate the partition you created.
book.book Page 13 Tuesday, March 23, 2010 11:49 PM For more information, see the Oracle Database on Microsoft Windows Server x64 – Troubleshooting Guide available at support.dell.com/manuals. For information on how to install Oracle using ASM, see "Installing Oracle RAC 10g R2 Using ASM" on page 21. Applying Oracle Patch 7320726 for Windows Server 2008 NOTE: This section is applicable only if your Oracle 10g database installation is on Windows Server 2008.
book.book Page 14 Tuesday, March 23, 2010 11:49 PM 2 In the Oracle Database 10g - Autorun window, click Install/Deinstall Products. The OUI starts and the Welcome window is displayed. 3 Click Next. 4 In the Select Installation Type window, select Enterprise Edition and click Next. 5 In the Specify Home Details window, verify the following details under Destination: • The Name field displays the Oracle database home name as OraDb10g_home1.
book.book Page 15 Tuesday, March 23, 2010 11:49 PM 11 After the installation is complete, the End of Installation window is displayed. Complete the procedures in the End of Installation window and then click Exit. NOTE: You must complete the steps in the End of Installation window before you exit. 12 In the Exit Window, click Yes. Installing Oracle 10g R2 Patchset NOTE: This section is applicable only if you are installing Oracle 10g database on a system running Windows Server 2003.
book.book Page 16 Tuesday, March 23, 2010 11:49 PM Installing the Patchset NOTE: You must install the patchset from the node where you installed the RAC 10g R2 software. If you are not running the OUI from the same node, exit and install the patchset from the node where you installed the RAC 10g R2 software. 1 Start the OUI located in the patchset folder. For example: %SystemDrive%\Oracle_patch\setup.exe where %SystemDrive% is the drive on which you unzipped the Oracle patchset.
book.book Page 17 Tuesday, March 23, 2010 11:49 PM 1 Start the OUI located in the patchset folder. For example: %SystemDrive%\Oracle_patch\setup.exe where %SystemDrive% is the drive on which you unzipped the Oracle patchset. 2 In the Welcome window, click Next. 3 In the Specify Home Details window, select OraDB10g_home1 from the drop-down menu and click Next. 4 In the Specify Hardware Cluster Installation Mode window, click Next. 5 In the Product-Specific Prerequisite Checks window, click Next.
book.book Page 18 Tuesday, March 23, 2010 11:49 PM 3 In the Real Application Clusters, Active Nodes window, select Select all nodes and click Next. 4 In the Welcome window, select Listener Configuration and click Next. 5 In the Listener Configuration window perform the following steps: a In the Listener window, select Add and click Next. b In the Listener Name window, accept the default value in the Listener name field and click Next.
book.book Page 19 Tuesday, March 23, 2010 11:49 PM 7 In the Database Identification window, enter a name such as racdb in the Global Database Name field and click Next. 8 In the Management Options window, accept the default selections and click Next. 9 In the Database Credentials window, click Use the Same Password for All Accounts, type and confirm a new password in the appropriate fields, and click Next. NOTE: Record your new password. You require this information later during database administration.
book.book Page 20 Tuesday, March 23, 2010 11:49 PM 15 Click Edit Archive Mode Parameters. a In the Edit Archive Mode Parameters window, ensure that the path listed under the Archive Log Destinations is as follows: X:/ where X is the CFS drive letter that you created for the Flash Recovery Area. For more information, see Preparing the Database Disk and Flash Recovery Area for Database Storage With OCFS in Oracle Database on Microsoft Windows Server x64 – Storage and Network Guide available at support.dell.
book.book Page 33 Tuesday, March 23, 2010 11:49 PM Adding a New Node to an Existing Oracle 10g RAC Cluster This section describes how to add nodes and instances to Oracle® Real Application Cluster (RAC) databases on Microsoft® Windows Server® x64 operating systems. Preparing the Node to be Added to a Cluster Perform the following steps on the node(s) that you want to add to an existing cluster: 1 Install and configure the operating system using the deployment media.
book.book Page 34 Tuesday, March 23, 2010 11:49 PM Adding Nodes at the Oracle Clusterware Layer 1 On one of the existing nodes, navigate to the CRS home\oui\bin directory. Run the addNode.bat script to start the Oracle Universal Installer (OUI). 2 The OUI runs in the add node mode and displays the OUI Welcome window. 3 Click Next. The Specify Cluster Nodes for Node Addition window is displayed.
book.book Page 35 Tuesday, March 23, 2010 11:49 PM Adding Nodes at the Oracle RAC Database Layer 1 Run the addNode.bat script from the %ORACLE_HOME%\oui\bin directory. This starts the OUI in the add node mode and displays the OUI Welcome window. 2 Click Next on the Welcome window. The Specify Cluster Nodes for Node Addition window is displayed. The Specify Cluster Nodes for Node Addition window has a table that displays the existing nodes associated with the Oracle home from which you launched the OUI.
book.book Page 36 Tuesday, March 23, 2010 11:49 PM Adding Database Instances to New Nodes To add database instances to each new node, perform the following steps: 1 Choose Start→ Programs→ Oracle - HOME_NAME→ Configuration and Migration Tools→ Database Configuration Assistant. The Welcome window for RAC is displayed. 2 Click Help on any DBCA window for additional information. 3 Select Real Application Clusters database and click Next. The DBCA displays the Operations window.
book.book Page 21 Tuesday, March 23, 2010 11:49 PM Installing Oracle RAC 10g R2 Using ASM This section applies to both Oracle® Enterprise Edition and Standard Edition. This section describes the procedures to install Oracle Real Application Cluster (RAC) 10g R2 using Automatic Storage Management (ASM). NOTE: If you want to install Oracle using OCFS, ignore the following steps and follow the procedures given under "Installing Oracle® RAC 10g R2 Using OCFS" on page 9.
book.book Page 22 Tuesday, March 23, 2010 11:49 PM • For Windows Server 2003: Ensure that the installation program completes all the checks successfully and then click Next. • For Windows Server 2008: The Product Specification Prerequisite Check fails for the OCFS and Orafence Driver’s Signature. To continue with the installation, select the Checking OCFS & Orafence Driver's Signature check box when the installation performs the prerequisite checks. This changes the field label to User Verified.
book.book Page 23 Tuesday, March 23, 2010 11:49 PM 10 In the Cluster Configuration Storage window, perform the following steps for the Oracle Cluster Registry (OCR) disk: a Locate the two 300 MB partitions that you created. For more information on the procedure, see the Preparing the OCR and Voting Disks for Clusterware section in the Oracle Database on Microsoft Windows Server x64 – Storage and Network Guide available at support.dell.com/manuals. b Select the first partition and click Edit.
book.book Page 24 Tuesday, March 23, 2010 11:49 PM NOTE: If a failure occurs in the Configuration Assistant window, perform the following steps: a In the error window, click OK. b In the Configuration Assistant window, click Next. c Ignore the warning message and click OK. d Click Exit to finish the OUI session. e In the Exit window, click Yes. For more information, see the Oracle Database on Microsoft Windows Server x64 – Troubleshooting Guide available at support.dell.com/manuals.
book.book Page 25 Tuesday, March 23, 2010 11:49 PM Installing Oracle 10g Database NOTE: If you are installing Oracle using OCFS, skip these steps and go to "Installing Oracle® RAC 10g R2 Using OCFS" on page 9. 1 On node 1, insert the appropriate Oracle Clusterware installation media for your operating system as specified in Table 2-1 into your optical drive. The OUI starts and the Welcome window is displayed. If the Welcome window is not displayed: a Click Start and select Run.
book.book Page 26 Tuesday, March 23, 2010 11:49 PM 7 In the Specify Hardware Cluster Installation Mode window, click Select All and click Next. 8 In the Product-Specific Prerequisite Checks window, click Next. 9 In the Select Configuration Option window, select Install database Software only, and click Next. 10 In the Summary window, click Install. 11 After the installation is complete, the End of Installation window is displayed.
book.book Page 27 Tuesday, March 23, 2010 11:49 PM For more information on creating the home directory, see "Installing Oracle Clusterware" on page 9. 2 Select Start→ Programs→ Administrator Tools→ Services to start Programs Administrator Tools Services. 3 Locate all Oracle services and stop them on both nodes. Installing the Patchset NOTE: You must install the patchset from the node where you installed the RAC 10g R2 software.
book.book Page 28 Tuesday, March 23, 2010 11:49 PM 3 In the Specify Home Details window, select OraDB10g_home1 from the drop-down menu and click Next. 4 In the Specify Hardware Cluster Installation Mode window, click Next. 5 In the Product-Specific Prerequisite Checks window, click Next. 6 In the Oracle Configuration Manager Registration window, click Next. 7 In the Summary window, click Install. During the installation, the following error may be displayed: Error in writing to file oci.dll.
book.book Page 29 Tuesday, March 23, 2010 11:49 PM a In the Listener window, select Add and click Next. b In the Listener Name window, accept the default setting in the Listener name field and click Next. c In the Select Protocols window, select TCP in the Selected protocols field and click Next. d In the TCP/IP Protocol window, select Use the standard port number of 1521 and click Next. e In the More Listeners window, select No and click Next.
book.book Page 30 Tuesday, March 23, 2010 11:49 PM 6 In the Node Selection window, click Select All and click Next. 7 In the Database Templates window, click Custom Database and click Next. 8 In the Database Identification window, enter a name such as racdb in the Global Database Name field and click Next. 9 In the Management Options window, click Next.
book.book Page 31 Tuesday, March 23, 2010 11:49 PM f In the Generate stamps with this prefix field, keep the default settings and click Next. g In the Stamp disks window, click Next. h Click Finish to save your settings. i Select the check boxes next to the available disks and click OK. 16 In the ASM Disk Groups window, click Create New. 17 In the Create Disk Group window, enter the information for the Flash Recovery Area. a In the Disk Group Name field, type a name for the new disk group.
book.book Page 32 Tuesday, March 23, 2010 11:49 PM e Select Enable Archiving. f Click Edit Archive Mode Parameters. g In the Edit Archive Mode Parameters window, ensure that the path listed under the Archive Log Destinations is as follows: +FLASH/, where FLASH is the Flash Recovery Area disk group name that you specified in sub-step a of step 17. h Click Next. 20 In the Database Content window, click Next. 21 In the Database Services window, click Next.
