Openfiler on Virtualbox and 12c Oracle Flex ASM

Last week Oracle released 12c database and Oracle blogosphere is bustling with lot of people posting details about new versions and setup. I too decided to take plunge and setup my own RAC cluster. I had 4 machines with me but no shared storage Long back I had done one installation using openfiler (Followed Jeff…

portmap: unrecognized service on RHEL6

Quick note for people using NFS for shared storage on RAC database. Till RHEL5 we had to ensure nfs,nfslock and portmap service has to be running. These services are required otherwise you will get following errors while mounting database ORA-00210: cannot open the specified control file ORA-00202: control file: '/u01/oradata/orcl/control01.ctl' ORA-27086: unable to lock file…

Recovering from Lost AWS EC2 Key

This article is for AWS users using EC2 instances. Summary: Please backup your AWS EC2 Key file and you will never have to go through below pain AWS allows you to create a key-pair which can be downloaded on your machine and it is used for logging into your EC2 instance. I had been using…

cursor: pin S wait on X

Few weeks back thread came up on oracle-l freelist regarding “cursor: pin S wait on X” event . Tanel Poder replied to this thread with excellent explanation. You can read full thread here   This wait happens when your session wants to examine / execute an existing child cursor – but it’s being pinned in X…

Moving WordPress Blog to Amazon Web Services

[—ATOC—] [—TAG:h3—] Why I moved? Last Month I had moved my blog hosting from Dreamhost to Amazon Web Services(AWS). I decided to change hosting provider as my blog suffered 17  outages (as per pingdom report for month of December 2012)   Uptime Outages Response time 97.33% 17 2359 ms Dreamhost mentioned that my wordpress processes were…

11.2 AQ – Messages stuck in PROCESESED,WAIT State

I had been working today on AQ issue where messages were not moving from WAIT to READY State.This was on 11.2.0.3 database running on RHEL5u6(64 bit). I thought of quickly documenting it for easy reference When you enqueue record, you can specify delay after which record should be ready for dequeue. During this time, MSG_STATE…