Archive for May, 2008
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 you need to create a Diskgroup and add disks/raw devices to the Diskgroup.Data is allocated in disks in terms of [Read More]
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 startup of ASM instance ORA-15032: not all alterations performed ORA-15063: ASM discovered an [Read More]
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 till date. Looks like 10.2.0.3 on AIX had lot of bugs or it could be that DATABASE REPLAY feature needed [Read More]
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 functionality (Default) 4 – As Level 1 PLUS trace bind values 8 [Read More]
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 information about Oracle Clusterware resource [Read More]
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 dump or ORA-07445: exception encountered: core dump [Read More]
