Dell PowerEdge Systems Oracle Database on Enterprise Linux x86_64 Troubleshooting Guide Version 1.5
This Dell guide provides recommended solutions for problems encountered while deploying and using Oracle Database 11g R2 on Red Hat Enterprise Linux 5.5 AS x86_64 or Oracle Enterprise Linux 5.5 AS x86_64 on Dell PowerEdge systems. It also lists the other Dell|Oracle Database installation guides in the documentation set and explains where to get Dell and Oracle support.
The troubleshooting sections cover performance and stability, Enterprise Manager startup, Automatic Storage Management (ASM) disk creation with EMC PowerPath, clusterware verification and Grid Infrastructure installation errors, database restart with PowerVault MD3000i and EqualLogic iSCSI arrays, uninstallation, networking prerequisite checks, Fibre Channel HBA driver messages, operating system device recognition and DKMS drivers, and Oracle security patches.
| Supported database | Oracle Database 11g R2 |
|---|---|
| Supported operating systems | Red Hat Enterprise Linux 5.5 AS x86_64 or Oracle Enterprise Linux 5.5 AS x86_64 |
| Recommended SGA size | No more than 65 percent of total system RAM |
| EMC PowerPath versions affected by ASM disk creation issue | 5.0.1-5.3 |
The SGA size should not exceed 65 percent of the total system RAM. If it does, reduce the db_cache_size and shared_pool_size parameters in the Oracle parameter file.
It fails to start if the environment variable ORACLE_UNQNAME is not defined. Set it to the unique name of the database, then run emctl status dbconsole as the Oracle user to verify.
Use the /usr/sbin/asmtool command with the force=yes option instead of oracleasm createdisk, then reboot the system to correct the root:root permissions of the volume.
The required permissions are not set on the remote node. Run chmod 6751 $ORACLE_HOME as the root user on all remote nodes.