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

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

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

Upgrade to WordPress 2.7.1

WordPress 2.7.1 is out..While using upgrade button, it will be stuck at downloading files and will not proceed further. This issue will be faced by people using “Automatic Upgrade” plugin available in prior release. You need to disable the plugin and then re-try [Read More]

Scheduling Job through Cron??

In case you came across this link searching for Cron syntax, then you can refer to following link http://www.adminschoice.com/docs/crontab.htm Other’s can continue reading the article …. This was a problem which I faced yesterday. We had a mview refresh which [Read More]

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 instead of device Name pcmpath query device DEV#: 33 DEVICE NAME: hdisk33 TYPE: 2107900 ALGORITHM: Load [Read More]

CRS Fails to Start – 10.2.0.1 RAC Install on AIX

I 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 voting device: /dev/voting_disk02 Now formatting voting device: [Read More]

Recent Comments

Saurabh Sood had this to say

Hi Pawan, We cannot force the writes to a specific disk. At least I am not aware of any such thing. Oracle will Read the post

Amit had this to say

hi Pawan, ASM_PREFERRED_READ_FAILURE_GROUPS is mainly used for RAC instances and that too stretch clusters i.e when Read the post

PAWAN had this to say

HI, i am newbie.... please guide me! My manager asked me to configure ASM in 11g with single instance Read the post

PAWAN had this to say

HI, i am newbie.... please guide me! My manager asked me to configure ASM in 11g with single instance Read the post

Saurabh Sood had this to say

@Ganesh: The global stats were up-to-date for both the databases, though I did not check the col stats. But the Read the post