OGG replication failing with “ORA-12899: value too large for column“

Recently while working on Oracle GoldenGate, when i started the replicat it failed with "ORA-12899: value too large for column" 2011-09-25 22:19:52 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep3.prm: SQL error 12899 mapping anand.tab1 to andy.tab2 OCI Error ORA-12899: value too large for column "ANDY"."TAB2"."CITY" (actual: 68, maximum: 50) (status = 12899), SQL <UPDATE … Continue reading OGG replication failing with “ORA-12899: value too large for column“

Duplicating Database without connecting to Target – 11gR2

From 11gR2, you can duplicate the database without connecting to the target database or recovery catalog which is termed as "Backup-Based Duplication Without a Target and a Recovery Catalog Connection". http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#BRADV435 OS - Windows Duplicate Database - ORCL Target Database - MATRIX 1. Backup the target database D:\scripts>rman target / Recovery Manager: Release 11.2.0.2.0 - … Continue reading Duplicating Database without connecting to Target – 11gR2

single-task message and Cursor:pin S wait on X

Recently we had faced an issue where the CPU utilization on 3-node RAC (10.2.0.5) servers were high. The load testing team had reported for the same as they were doing loading testing on the machine and wanted us to have a look. I was asked to check and find the reason for the same, so … Continue reading single-task message and Cursor:pin S wait on X

ORA-04021: timeout occurred while waiting to lock object – Library Cache Pin

Few of the times during deployment users complain of their session almost hanged and that is when is start digging. Recently i was pinged by a user where she was trying to run .sql script which was doing create or replace procedure and she got the error "ORA-04021: timeout occurred while waiting to lock object".I … Continue reading ORA-04021: timeout occurred while waiting to lock object – Library Cache Pin

AIOUG Sangam11 – Registration Opens

Just a quick post.Registration for All India Oracle Users Group (AIOUG) conference to be held in Bangalore on 9th and 10th Dec 2011 is now open.The key Presenter for the 2 day event is Arup Nanda, who needs no introduction.So,come lets meet, share and learn at Sangam11,AIOUG. For further details and registration visit http://www.aioug.org/sangam11.php Hope … Continue reading AIOUG Sangam11 – Registration Opens