Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Oracle GoldenGate – how to connect to a particular database if there are multiple databases on the source or target server | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

2 Comments

Abbas
  • Mar 9 2011
I am trying the Oracle GG tutorial posted on this site. It is a very lucid explanation of how to get GG going. Thank you very much for this wonderful tutorial!. The set up has been pretty smooth. However, when I run the extract process for the initial load, the process abends. The ggerr.log reports the following error: 2011-03-07 17:41:56 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, LOAD1.prm: EXTRACT LOAD1 started. 2011-03-07 17:42:02 WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, LOAD1.prm: EXTRACT task LOAD2 abended : OCI Error during OCIServerAttach (status = 12557-Error while trying to retrieve text for error ORA-12557). 2011-03-07 17:42:02 ERROR OGG-01203 Oracle GoldenGate Capture for Oracle, LOAD1.prm: EXTRACT abending. 2011-03-07 17:42:02 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, LOAD1.prm: PROCESS ABENDING. GGSCI reports the following: GGSCI (MY-XP) 1> ADD EXTRACT load1, SOURCEISTABLE EXTRACT added. GGSCI (MY-XP) 2> edit PARAMS load1 GGSCI (MY-XP) 3> START EXTRACT load1 Sending START request to MANAGER ('EAST') ... EXTRACT LOAD1 starting GGSCI (MY-XP) 4> info extract load1 EXTRACT LOAD1 Initialized 2011-03-07 17:14 Status STOPPED Checkpoint Lag Not Available Log Read Checkpoint Not Available First Record Record 0 Task SOURCEISTABLE I have the source as: Windows XP as VMWare instance in Mac Oracle 10g Express Edition target as: Windows XP Oracle 10g Express Edition On both source and target, I can login as ggs_owner with ggsci tool. That would, I assume, indicate it is not an issue with ORACLE_HOME or ORACLE_SID. Any help appreciated. Thanks!
E.Hatt-Swank
  • Aug 10 2011
I just wanted to say thank you so much for your GoldenGate tutorials. I'm working on setting up a GoldenGate environment for the first time, and while the official documentation has lots of detailed information, I have found it to be poorly organized and inconsistent. I've been relying heavily on your tutorials for clear step-by-step instructions. And just now, I needed an answer to this very question of multiple databases replicating on the same system: your site was the first place I looked. Thank you!

Leave Reply

Your email address will not be published. Required fields are marked *