OCR is a file that manages cluster and Oracle Real Application Clusters (Oracle RAC) database configuration information. The OCR contains information about the cluster node list, instance-to-node mapping information, and…
Read Full Recipe
Oracle has reported a new Alert for user's who have upgraded their databases to 10.2.0.3 patchset on windows. User processes dumps core dumps with following errors ORA-07445: exception encountered: core…
Read Full Recipe
Few days back, I wanted to remove a instance semaphore as they were not cleared automatically due to abnormal shutdown. As there were few other databases running on the server…
Read Full Recipe
While creating ASM diskgroup or adding new disk to a existing diskgroup, Disk should be visible in V$ASM_DISK. ASM discovers and examines the contents of all of the disks that…
Read Full Recipe
Much has been written on designing good application (which uses bind variables) so as to have better performance and avoid shared pool memory issues. Tom Kyte explains this on one…
Read Full Recipe
Many times we observe following error which corresponds to low setting of processes parameter. $ oerr ora 20 00020, 00000, "maximum number of processes (%s) exceeded" // *Cause: All process…
Read Full Recipe