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 Tutorials now available ….. | Oracle DBA – Tips and Techniques
Perth, Australia
+ (61) 417713124


raji nagarajan
  • Jun 8 2010
Hi Gavin, i am planning to do below activities on my prod. 1. Upgrade 10 2 0 4 to 10 2 0 5 (same linux 64 bit OS) with 0 downtime. 2. application will be pointed to upgraded 10 20 5 db. then due to some issue. planning to rollback to 10 2 0 4 version. let me know if you have any material for this setup thanks raji
Gavin Soorma
  • Jun 10 2010
Hi Raji - not sure what you mean ... do you want to test how to downgrade the database from to in case you encounter some issue? Also - how are you doing the upgrade from to without any downtime?
  • Jul 13 2010
Hi Gavin, I had a doubt about the GoldenGate setup. We have seen that GG works at table/column level mapping too. Thanks for your posts. I would like to know, if the mapping can be done at schema level. I know we can create groups but this is still all tables. Please guide me. Thanks, Ramesh.
Gavin Soorma
  • Jul 14 2010
Hi Ramesh - you can use wildcards to include all the tables in a schema - for example we can say TABLES=SCOTT.* - regards, Gavin
  • Jul 15 2010
I have this error in AIX 64 bit 6.1 oracle It does not happend with, is the problem? sbl-db-dr:/gg/goldengate $ ggsci exec(): 0509-036 Cannot load program ggsci because of the following errors: 0509-150 Dependent module libclntsh.a(shr.o) could not be loaded. 0509-022 Cannot load module libclntsh.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist.
Gavin Soorma
  • Jul 15 2010
Hi Jose - can you check what the $LIBPATH is pointing to. It should be $ORACLE_HOME/lib: Also try and run ggsci like ./ggsci to make sure you picking the right executable in case you have multiple installations. Let me know if this works.
  • Sep 9 2010
Process id: 4104236 Description: *********************************************************************** ** Running with the following parameters ** *********************************************************************** --CHECKPARAMS EXTRACT etest USERID ggate_ct, PASSWORD *********** Source Context : SourceModule : [ggdb.ora.sess] SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/gglib/ggdbora/ocisess.c#1 $] SourceFunction : [OCISESS_try(int, OCISESS_context_def *, char *, ...)] SourceLine : [466] Hi , i am trying to start my extract but i am getting below ,please let me know if any one has come across this kind of error 2010-09-08 11:24:44 GGS ERROR 182 OCI Error creating temporary LOB to retrieve default LOB chunk size (status = 1116-ORA-01116: error in opening database file 201 ORA-01110: data file 201: '/d03/oradata/isacdev2/temp01.dbf' ORA-27092: size of file exceeds file size limit of the process Additional information: 131071 Additional information: 256001). 2010-09-08 11:24:44 GGS ERROR 190 PROCESS ABENDING.
  • Jan 19 2011
Hi Gavin, Wonderful Tutorial. I have two questions: 1. Before starting Initial Load do I have to create all the table structure at the Target side? 2. I have heard that Initial Load on big Database takes long time, then is there any alternative for initial Load. Thanks a lot. Niha
  • Feb 20 2011
thx. for broadcasting your knowledge with point to point manner and contents ... how it possible by you? it is amazing working to share knowledge. a lot thanks.
Amardeep Sidhu
  • Jun 6 2011
Hi Gavin, I was looking for an introductory start for GoldenGate. You have written an awesome series of posts. Perfect for getting a super start with GoldenGate. Thanks much for all the stuff. Keep up the good work. Cheers ! Regards, Amardeep Sidhu

Leave Reply

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