Creating ASM devices on AIX
I thought of sharing few tips on creating ASM devices on AIX which I will be helpful to Oracle DBA's. Suppose SysAdmin gives you list of Serial numbers for LUN…
Read Full RecipeI thought of sharing few tips on creating ASM devices on AIX which I will be helpful to Oracle DBA's. Suppose SysAdmin gives you list of Serial numbers for LUN…
Read Full RecipeI was installing 10.2.0.1 on IBM AIX 5L and while running root.sh from first node (as part of Clusterware installation) got following messages Now formatting voting device: /dev/voting_disk01 Now formatting…
Read Full RecipeThere are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve…
Read Full RecipeI was trying to recreate database links as part of database migration activity. This involved mixture of 8i,9i and 10g database. In case of 8i/9i it is very easy to…
Read Full RecipePeople planning to appear for 10g OCA Exam will be startled to find that they need to pass additional exam to get the certificate. Starting from December 1, 2008, in…
Read Full RecipeThere is a common misconception that Index access is the best access method for query execution. This approach leads to people concentrate on removing Full Table Scans (FTS) from the…
Read Full Recipe