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 January, 2009

Input is too long (> 2499 characters) – line ignored

30 Jan, 2009 | Author: Amit | No Comments »

There 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 this issue. Copy the code in Text file and while in escape mode enter following command [Read More]

Recreating Database Link

18 Jan, 2009 | Author: Amit | 4 Comments »

I 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 find the old password which was used to create database link as passwords for database links are stored in [Read More]