11G: OCR Manual Backups
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…
ORA-07445 [opidsa()+480] – Metalink Alert for 10.2.0.3
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…
Significance of LD_LIBRARY_PATH
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…
ASM Disk Discovery
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…
CPU (Critical Patch Update) and N-apply
OVERVIEW Oracle has been regularly releasing security fixes for all it's products to take care of any security vulnerability. Since 2005 Oracle formulated a policy that it will release CPU…
Understanding of Oracle 11g Automatic Diagnostic Repository – Part 1
INTRODUCTION In an endeavour to move towards self managed database and provide better support solutions, Oracle 11g introduces another new feature in 11g called the Automatic Diagnostic Repository or ADR.…