AskDba.org Weblog

Writing About Our Experiences With Oracle Databases

Sunday February 5th 2012

Latest Topics

11gR2:Listener Startup Issues

In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this [Read More]

Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c

This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c [Read More]

Cluster SSH tool Utility

Many times you come across scenario’s when you wish to open multiple ssh windows and execute same commands.e.g [Read More]

11g: Multiple failed login attempt can block New Application connections

In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple [Read More]

Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins

In one of my databases, one application query suddenly started to pick Nested-Loop joins instead of Hash-Joins and took [Read More]

Archive for November, 2008

How To Change/Restore User Password in 11G

21 Nov, 2008 | Author: Amit | 9 Comments »

Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarily) and reset it back to old , you will find that password field in dba_users is empty. Prior to 11g we could use following technique to [Read More]

Tom Kyte Seminar in Bangalore, India

18 Nov, 2008 | Author: Amit | 5 Comments »

All India Oracle user Group (AIOUG) has arranged for Seminar by Tom Kyte on 18th December 2008. Venue- The Good Shepherd Auditorium Residency Road- Museum Road Junction Opp. St. Joseph’s P.U. College Bangalore – 560 025 SEMINAR TOPICS Storage Techniques [Read More]

10g RAC Tuning :Useful Link

05 Nov, 2008 | Author: Amit | No Comments »

I came across useful link which contains 10g RAC Tuning tips from Joel Goodman (Oracle). It discusses RAC Instance Recovery concepts and key things to look out for while tuning RAC (Real Application Clusters) Databases. Must watch for anyone who is learning RAC. You can [Read More]