How To Recover From Corrupted OCR Disk
It is very common where a DBA is left with corrupted OCR disk without having any good backup. The same situation was experienced by me few days back. One node…
Read Full Recipe
Issues with CLUSTER_DATABASE parameter
Yesterday, I faced an interesting scenario while upgrading 2 Node RAC Database. I tried setting up CLUSTER_DATABASE=FALSE in spfile from Node 1,but it displayed value as TRUE after restarting database.Same was…
Read Full Recipe
10,000 Hits – First Milestone
Hi All. Yesterday we crossed 10,000 Blog Visits on our 2.5 month old blog . Actually this blog was started 5 months back on blogger and after some time we…
Read Full Recipe
UNKNOWN State Of RAC Resources
While Checking the status of database resources, ASM was shown as UNKNOWN on one node of a two node RAC. $ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.orcl.db…
Read Full Recipe
Using RDA As RDBMS Pre-Install Check Tool
Many of us would have come across RDA (Remote Diagnostic Agent) while working on a ticket with Oracle support. In case you have not heard about it, I would recommend…
Read Full Recipe
Checking Database Feature Usage Stats
Today I came across view DBA_FEATURE_USAGE_STATISTICS (10g) which let's us know whether particular Database Feature has been used till now or not. If yes, then it also let's us know…
Read Full Recipe