1GR2TG.book Page 1 Wednesday, August 4, 2010 12:31 PM Dell PowerEdge Systems Oracle Database on Enterprise Linux x86_64 Troubleshooting Guide Version 1.
11GR2TG.book Page 2 Wednesday, August 4, 2010 12:31 PM Notes, Cautions, and Warnings 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. WARNING: A WARNING indicates a potential for property damage, personal injury, or death. ____________________ Information in this publication is subject to change without notice. © 2009–2010 Dell Inc. All rights reserved.
11GR2TG.book Page 3 Wednesday, August 4, 2010 12:31 PM Contents 1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . Required Documentation for Deploying the Dell|Oracle 11g R2 Database . . . . . . . . . . . . . . . 5 . . . . . . . . . . . 6 . . . . . . . . . . . . . . . . . . . . . . . . 6 Terminology Used in This Document Getting Help Dell Support . 2 5 . . . . . . . . . . . . . . . . . . . . . 6 Oracle Support . . . . . . . . . . . . . . . . . . . . 6 Troubleshooting . . .
11GR2TG.book Page 4 Wednesday, August 4, 2010 12:31 PM Linux Error 13 and ORA01034 Error Messages are Displayed While Connecting to the Oracle Database . . . . . . . . . . . . . . . Grid Infrastructure Installation Fails and Error PRCR-1079 is Displayed . . . . . . . . . . . . . . . 10 Database Restart While Pulling one of the Storage Paths on Dell PowerVault MD3000i and Equallogic iSCSI Array . . . . . . . . . . . . . . . 11 . . . . . . . . . . . . . . . . . . . . . . 11 . . . . . . . . . . . . .
11GR2TG.book Page 5 Wednesday, August 4, 2010 12:31 PM 1 Overview This document applies to Oracle Database 11g R2 running on Red Hat Enterprise Linux 5.5 AS x86_64 or Oracle Enterprise Linux 5.5 AS x86_64.
11GR2TG.book Page 6 Wednesday, August 4, 2010 12:31 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 Dell PowerVault SAS and iSCSI (Dell PowerVault MD3000 and Dell PowerVault MD3000i with Dell PowerVault MD1000 expansion) storage environment.
11GR2TG.book Page 7 Wednesday, August 4, 2010 12:31 PM 2 Troubleshooting This section provides recommended solutions for issues that you may encounter while deploying and using your Enterprise Linux and Oracle software. Performance and Stability Enterprise Linux Exhibits Poor Performance and Instability Poor performance and instability occurs when the size of the Oracle System Global Area (SGA) exceeds the recommended size.
11GR2TG.book Page 8 Wednesday, August 4, 2010 12:31 PM 3 Enter the following lines at the SQL> prompt: alter system set cluster_interconnects=’ scope=spfile sid=’’ alter system set cluster_interconnects = ’’ scope=spfile sid= ’’ 4 Repeat step 3 for each cluster node.
11GR2TG.book Page 9 Wednesday, August 4, 2010 12:31 PM To resolve the issue, perform the following steps: 1 Perform the /etc/init.d/oracleasm createdisk operation using the following command: /usr/sbin/asmtool -C -l /dev/oracleasm -n -s /dev/ -a force=yes The following message is displayed: asmtool: Device "/dev/" is not a partitionasmtool: Continue anyway. 2 The permissions of the volume under /dev/oracleasm/disks/ will be root: root. Reboot the system to correct it.
11GR2TG.book Page 10 Wednesday, August 4, 2010 12:31 PM ERROR INS-32026 is Displayed While Specifying Grid Home Location Error INS-32026 is displayed when the Grid software location is specified under Oracle base directory. grid infrastructure for cluster installation assigns root ownership to all the parent directories of the clusterware software location. Consequently, all the named directories in the Grid software location path acquires root ownership.
GR2TG.book Page 11 Wednesday, August 4, 2010 12:31 PM Database Restart While Pulling one of the Storage Paths on Dell PowerVault MD3000i and Equallogic iSCSI Array Change the following syntax: /etc/iscsi/iscsid.conf node.session.timeo.replacement_timeout = 144 to node.session.timeo.replacement_timeout = 30 Log out from the existing iscsi sessions and rediscover and re-login to make the above timeout setting effective.
11GR2TG.
11GR2TG.book Page 13 Wednesday, August 4, 2010 12:31 PM OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid" # Set to 'yes' to sync hw clock after successful ntpdate SYNC_HWCLOCK=no # Additional options for ntpdate NTPDATE_OPTIONS="" [root@node1]# After making the above changes at both the nodes, run the cluvfy script and verify if the output related to NTP has passed.
11GR2TG.book Page 14 Wednesday, August 4, 2010 12:31 PM • If the module version in the updated kernel is lesser than the DKMS driver version, then use the DKMS driver. Create a file in /etc/depmod.d with the file name dkms_module_name.conf and the following entry: override module_name kernel_version modules_directory For example, for the bnx2 driver, create a file bnx2.conf in /etc/depmod.d/ with the below contents: override bnx2 2.6.18-x.
11GR2TG.
11GR2TG.