ASM 11gR2 Installation & Configuration (Role Separation).

Before the database creation of an 11.2.0.X.X, 11.1.0.X.X  or 10.2.0.X.X database using ASM 11.2.0.X.X (as storage option), then you need to set the ASM GID to the oracle kernel (<10.2, 11.1 or 11.2 RDBMS Oracle Home>/bin/oracle executable), this needs to be set before you execute the DBCA.

Use Chrome plugin to make Oracle AWR reports (formattter) friendly

Blogpost of Tom Kyte Thursday, April 28, 2011

An "AWR Formatter" written by a friend of mine, Tyler Muth. It's pretty cool - works as a Chrome plugin - and it makes an AWR report a little more 'friendly' to use. It creates hot links for many of the wait events (so you know what they mean) and it summarizes up a lot of stuff - making the AWR report a lot more "interactive". Check it out and give him feedback on it if you have time.

 

Oracle Support IDs for Oracle Apps DBAs

Here are the list of Oracle Support ID's for Oracle Apps DBAs, I do refer regularly. Moreover, these are very informative. So, I thought of sharing those note ids here with you.
Note: You have to have an account in Oracle Support to access id's.

Points of Interest

1. Installation
2. Real Application Cluster (RAC)
3. AD Utility
4. Cloning
5. Patching
6. Upgrades
7. Printer
8. Performance
9. Others
10. Oracle Application DBA Field Guide