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 RecipeAuthor: Saurabh Sood
Worked with prestigious Financial Institutions and Product Based MNCs e.g. Swiss Bank (UBS), CitiBank, Qatar Central Bank (QCB), Societe Generale, Oracle Corporation & Dell.
An Oracle DBA who is up-skilling himself to help large enterprises move their data to cloud and get more insights into data to make it useful for them.
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
Verification of CRS Integrity Was Unsuccessful
While going through the routine checks from Grid Control, I found a critical alert stating "clusterware integrity check failed" and by clicking on this message it says that there is…
Read Full Recipe
11g New Feature: Database Replay
Database Replay: In critical production systems, before making changes to the environment( Hardware or software related), lots of testing is required in test systems to know the effect of those…
Read Full Recipe
Effect of OS Terminal Setting “STTY” on Oracle Database
Few days back, while trying to create a synonym over dblink I experienced following error: SQL> create synonym synonymn_name for dual@DBLINK9i; SP2-0042: unknown command "DBLINK9i" - rest of line ignored…
Read Full Recipe
Adding new ASM disk to RAC database fails
Many times i came across a common problem in RAC databases where trying to add an asm disk is not possible due to errors like ORA-15075 "disk(s) are not visible…
Read Full Recipe