How to Install Red Hat Enterprise Linux 5
A step by step guide for installing Red Hat Enterprise Linux 5 (RHEL 5) 32-bit. I usually do this kind of installation for Oracle Server.
How to Configure ASM disks using ASMLib or Raw Disks
There are two very common ways to configure disks for ASM, using ASMLib or Raw Disks. This article covers both of them.
How to migrate Oracle datafiles to ASM storage via RMAN
This article shows how to migrate or move oracle datafiles to ASM diskgroups using RMAN after installing ASM instance with a non-asm database.
How to perform Block Media Recovery using RMAN
If you have corrupt blocks in datafile and you have RMAN backup or copies of the file, just those blocks can be recovered via RMAN Block Media Recovery feature.
Automatic Shared Memory Management in Oracle 10g
This article is a brief explanation of Oracle 10g Automatic Shared Memory Management (ASMM) and is explained with examples.
How to configure Raw Disks in RHEL 5
Red Hat Enterprise Linux 5.0 and 5.1 does not have rawdevices services. This post shows how to configure raw disks in RHEL 5.0. and 5.1 using UDEV.
Recyclebin with Flashback Table in Oracle 10g
A great feature in oracle 10g is recycle bin. Accidental table drops are now quite minimized with this feature. Just do a Flashback Table and the table is back.
How to install ASM instance on a non-asm Oracle database
This artical is a step by step demonstration of how to install ASM instance with Database Configuration Assistant to work with a non-asm Oracle Database.
Oracle 10g db_nk_cache_size Parameters
This is an article to show how to configure multiple size buffer caches in SGA and create tablespaces with different block sizes.
Handling Nulls in a Primary and Foreign key relationship
NULLS are the most mysterious element of a database, always behave different. This post shows how NULLS behave with Primary/Foreign Key relationships.