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 RecipeMany 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 RecipeTransparent Application Failover (TAF) is a client-side feature that allows for clients to reconnect to surviving databases in the event of a failure of a database instance. Note that this…
Read Full RecipeMany times Oracle DBA's are faced with a situation where shutting down the instance with shutdown immediate seems to take infinite time and gives a impression that the session is…
Read Full RecipeMany times we see an issue like this: SQL> conn / as sysdba ERROR: ORA-01031: insufficient privileges This is a very common and frequent error that can occur after the…
Read Full Recipe32-bit Operating systems provide 4Gb of addressable space to applications. This includes memory for the user application and also for the system. When running Oracle on 32-Bit Windows, we can…
Read Full Recipe1. For ORA-1578: There are two ways in which we can extract the data from a corrupted table: a) Using DBMS_REPAIR.SKIP_CORRUPT_BLOCKS b) Using Event 10231 a) Connect as sysdba user:…
Read Full Recipe