CRSCTL CheatSheet
You can find below various commands which can be used to administer Oracle Clusterware using crsctl. This is for purpose of easy reference. Start Oracle Clusterware #crsctl start crs Stop…
ORA-00600 [12333]
ORA-00600 with [12333] is an error that I have encountered on multiple occasions. This post is to shed some light on what this error is all about. To start with…
Allocation Unit and Extents In ASM
ASM was introduced with Oracle 10g and is used as a Volume Manager and a file system. It provides both mirroring and striping of the database files. To use ASM…
ORA-15063 – ASM Discovered Insufficient amount of Disks
Looking at the response generated by my earlier post on ASM, I thought of writing one more article. Many of us (Working on ASM) would have encountered following errors during…
10.2.0.4 on AIX5L (64-Bit) is Out
As usual Laurent has been first to locate that 10.2.0.4 on AIX5L (64-Bit) is Out. Patchset size is whopping 1.9G which I believe is the maximum size for Oracle Patchset…
Tracing Sessions with Event 10046
10046 Event is used to trace SQL statements (similar to sql_trace=true) with additional details depending on the tracing level which is specified. 10046 EVENT levels: 1 - Enable standard SQL_TRACE…