ORA_10g_R2.book Page 1 Tuesday, March 23, 2010 10:50 PM Dell™ PowerEdge™ Systems Oracle® Database on Microsoft® Windows Server® x64 Troubleshooting Guide Version 4.
ORA_10g_R2.book Page 2 Tuesday, March 23, 2010 10:50 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.
ORA_10g_R2.book Page 3 Tuesday, March 23, 2010 10:50 PM Contents 1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . Required Documentation for Deploying the Dell|Oracle Database . . . . . . . . . . . 5 Terminology Used in This Document . . . . . . . . . . . 6 . . . . . . . . . . . . . . . . . . . . . . . 6 . . . . . . . . . . . . . . . . . . . . . 6 . . . . . . . . . . . . . . . . . . . 7 . . . . . . . . . . . . . . . . . . . . 9 Getting Help .
ORA_10g_R2.book Page 4 Tuesday, March 23, 2010 10:50 PM 3 Additional Troubleshooting Issues 4 Oracle Security Patches and Recommended Patches . . . . . 5 4 Obtaining and Using Open Source Files . . Contents . . . . 17 . . . . . . . . . 27 . . . . . . . . . . . . . . . .
ORA_10g_R2.book Page 5 Tuesday, March 23, 2010 10:50 PM Overview This document applies to: • Oracle® Database 10g R2 Enterprise Edition on Microsoft® Windows Server® 2003 R2 SP2 Enterprise/Standard x64 Edition or Windows Server 2008 SP2 Enterprise/Standard x64 Edition. • Oracle Database 10g R2 Standard Edition on Windows Server 2003 R2 SP2 Standard x64 Edition or Windows Server 2008 SP2 Standard x64 Edition.
ORA_10g_R2.book Page 6 Tuesday, March 23, 2010 10:50 PM Terminology Used in This Document Throughout this document, the terms logical unit number (LUN) and virtual disk are used synonymously. The term LUN is commonly used in a Dell/EMC Fibre Channel storage system environment. The term virtual disk is commonly used in a Dell™ PowerVault™ SAS (Dell MD3000 and Dell MD3000i with MD1000 expansion) storage environment.
ORA_10g_R2.book Page 7 Tuesday, March 23, 2010 10:50 PM Oracle Support • For information about Oracle software, application clusterware training, and contacting Oracle, see oracle.com or the Oracle documentation that shipped with the system components. • For information on technical support, downloads, and, other technical information, see metalink.oracle.com.
ORA_10g_R2.
ORA_10g_R2.book Page 9 Tuesday, March 23, 2010 10:50 PM Troubleshooting This section contains information about Oracle Clusterware installation, resolutions, and workarounds with Windows Server 2008 SP2 x64 Edition on your Dell system. Oracle® Clusterware Configuration Assistant Fails The installation of Oracle Clusterware Configuration Assistant fails in the Configuration Assistants window.
ORA_10g_R2.book Page 10 Tuesday, March 23, 2010 10:50 PM VIPCA Fails If the VIPCA fails during the installation of Oracle Clusterware, the following error message is displayed: Virtual Private IP Configuration Assistant failed To work around the issue: 1 Click Start and select Run. 2 In the Run field, type the following and click OK: %SystemDrive%\Oracle\product\\crs\ bin\vipca where %SystemDrive% is your local drive and is your Oracle Database version that is either 10.2.
ORA_10g_R2.book Page 11 Tuesday, March 23, 2010 10:50 PM Running Oracle Universal Installer (OUI) 1 On node 1, open Windows Explorer and navigate to the following directory: %SystemDrive%\Oracle\product\\crs\ oui\bin\ where %SystemDrive% is your local drive and is your Oracle Database version that is either 10.2.0 for Oracle 10g or 11.1.0 for Oracle 11g. 2 Double-click setup.exe to launch the OUI. 3 In the Welcome window, click Deinstall Products.
ORA_10g_R2.book Page 12 Tuesday, March 23, 2010 10:50 PM c Type the following, and press : sc delete d Repeat step c for each additional service that you need to remove. 3 Restart node 1 and log in as the administrator. 4 Restart each of the other nodes and log in as the administrator. The Oracle services are deleted.
ORA_10g_R2.book Page 13 Tuesday, March 23, 2010 10:50 PM Use the Oracle Symbolic Link Importer (ImportSYMLinks) to import the symbolic links into the assigned storage disks (OCRCFG, OCRMIRRORCFG, Votedsk1, Votedsk2, and Votedsk3). At the command prompt, type the following and press : %SystemDrive%\Oracle\product\\crs\ bin\ImportSYMLinks where %SystemDrive% is your local drive and is your Oracle Database version that is either 10.2.0 for Oracle 10g or 11.1.
ORA_10g_R2.book Page 14 Tuesday, March 23, 2010 10:50 PM 5 Delete the symlinks for the OCR (OCRCFG and OCRMIRRORCFG) and the voting disks (Votedsk1, Votedsk2, and Votedsk3). a Select OCRCFG, OCRMIRRORCFG, Votedsk1, Votedsk2, and Votedsk3. b Click Options and select Commit. If successful, the OCRCFG, OCRMIRRORCFG, Votedsk1, Votedsk2, and Votedsk3 entries disappear. c Click Options and select Exit to close the Oracle Object Manager. 6 Launch the Computer Management Console.
ORA_10g_R2.book Page 15 Tuesday, March 23, 2010 10:50 PM Oracle 10g R2 10.2.0.4 Installation Issue on Microsoft Windows Server 2008 When installing Oracle Cluster Ready Services on Windows Server 2008 x64, the prerequisite check fails and the following message is displayed: Security certificates for OCFS and Orafence drivers on Windows Server 2008 have expired. To resolve the issue, download and install the latest drivers from patch 7320726 available at metalink.oracle.com.
ORA_10g_R2.
ORA_10g_R2.book Page 17 Tuesday, March 23, 2010 10:50 PM Additional Troubleshooting Issues Table 3-1 provides resolution for problems that you may encounter while deploying and using your Microsoft® Windows Server® 2003 or 2008 operating system and Oracle® database software. Table 3-1. Category Additional Troubleshooting Issues and Resolutions Problem/Symptom Cause EMC® Resolution PowerPath PowerPath® installation fails. installation Unknown installation error.
ORA_10g_R2.book Page 18 Tuesday, March 23, 2010 10:50 PM Table 3-1. Additional Troubleshooting Issues and Resolutions (continued) Category Problem/Symptom Cause Resolution NIC Teaming When the first NIC is still down or disabled, the second NIC in the teaming also fails or is disabled. This failure causes the private network to go down completely on this node. The private IP address on this node cannot be pinged.
ORA_10g_R2.book Page 19 Tuesday, March 23, 2010 10:50 PM Table 3-1. Category Additional Troubleshooting Issues and Resolutions (continued) Problem/Symptom Cause Resolution Installing During Oracle Clusterware Clusterware installation the following error message is displayed: The specified nodes are not clusterable. The administrative Perform the following steps: account or the 1 Right-click My Computer account used to and select Manage.
ORA_10g_R2.book Page 20 Tuesday, March 23, 2010 10:50 PM Table 3-1. Category Additional Troubleshooting Issues and Resolutions (continued) Problem/Symptom Cause Oracle The cluster Clusterware node restarts with a blue screen. 20 The cluster node cannot communicate with the storage disks. Additional Troubleshooting Issues Resolution Perform the following steps: 1 Restart the cluster node. 2 During POST, press . 3 In the Windows Advanced Options Menu window, select Safe Mode.
ORA_10g_R2.book Page 21 Tuesday, March 23, 2010 10:50 PM Table 3-1. Category Additional Troubleshooting Issues and Resolutions (continued) Problem/Symptom Cause Resolution 12 In the Startup drop-down menu, select Disabled. 13 Repeat step 10 through step 12 for all the remaining Oracle services. 14 Verify the following: • The storage system is functioning properly. • All fiber-optic cables are connected and secure. • The cluster node can access the shared storage disks.
ORA_10g_R2.book Page 22 Tuesday, March 23, 2010 10:50 PM Table 3-1. Category Additional Troubleshooting Issues and Resolutions (continued) Problem/Symptom Cause System blue The cluster screen nodes generate a blue screen. The cluster nodes cannot access the voting disk. Resolution 1 Ensure that the HBA connection mode firmware settings are configured properly for your storage configuration.
ORA_10g_R2.book Page 23 Tuesday, March 23, 2010 10:50 PM Table 3-1. Category Additional Troubleshooting Issues and Resolutions (continued) Problem/Symptom Cause Resolution c Type the following, and press : %ORA_CLUSTERWAR E_HOME%\bin where %ORA_CLUSTERWARE _HOME% is the CRS home directory that you created using procedures found in the Oracle Database on Microsoft Windows Server x64 Oracle Database Setup and Installation Guide.
ORA_10g_R2.book Page 24 Tuesday, March 23, 2010 10:50 PM Table 3-1. Additional Troubleshooting Issues and Resolutions (continued) Category Problem/Symptom Cause Storage • Disks appear as The LUNs are Ensure that the storage LUNs unreachable. not assigned to the are assigned to both cluster cluster nodes. nodes. • On the Windows desktop, when you right-click My Computer, select Computer Management, and then click Disk Management, the disks appear unreachable. 24 Improper cabling.
ORA_10g_R2.book Page 25 Tuesday, March 23, 2010 10:50 PM Table 3-1. Category Additional Troubleshooting Issues and Resolutions (continued) Problem/Symptom Cause • SCSI disk devices are not displayed. Resolution • The LUNs are not Ensure that the storage LUNs are assigned to both cluster assigned to the nodes. cluster nodes. • On the • Improper cabling. Perform the following steps.
ORA_10g_R2.book Page 26 Tuesday, March 23, 2010 10:50 PM Table 3-1. Category Additional Troubleshooting Issues and Resolutions (continued) Problem/Symptom Cause Resolution Virtual The VIPCA Private IP configuration Configurati fails. on Assistant (VIPCA) The public network adapter interface (or the network interface assigned for Virtual IP (VIP) in case 4 network interfaces) name is not identical on both cluster nodes. Uninstall Configuration Oracle assistant fails to Clusterware install repetitively.
ORA_10g_R2.book Page 27 Tuesday, March 23, 2010 10:50 PM Oracle Security Patches and Recommended Patches Oracle® releases quarterly critical patch updates (CPUs) for fixing potential security vulnerabilities for Oracle products. These CPUs are required to be applied to the production systems. Currently, the latest CPUs for the Microsoft® Windows® platform are: • Oracle 11g R1 11.1.0.7 CPU patch: 8343070 • Oracle 10g R2 10.2.0.4 patches: see Metalink note #786800.1 at metalink.oracle.com.
ORA_10g_R2.
ORA_10g_R2.book Page 29 Tuesday, March 23, 2010 10:50 PM Obtaining and Using Open Source Files The software contained on the deployment media is an aggregate of third-party programs as well as Dell programs. Use of the software is subject to designated license terms. All software that is designated as under the terms of the GNU General Public License (GPL) may be copied, distributed, and/or modified in accordance with the terms and conditions of the GNU GPL, Version 2, June 1991.
ORA_10g_R2.