Oracle 12c database has introduced enhancement to DBMS_REDEFINITION for specifying a a lock timeout (in seconds) which will allow FINISH_REDEF_TABLE to acquire an exclusive lock for swapping the source and interim tables.If timeout expires, then operation exits. This will help to avoid cancellation by user or indefinite wait. This does not put our session in queue…
Author: Amit Bansal
Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions.
Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python
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…
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…
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…