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
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
Hi Raji - not sure what you mean ... do you want to test how to downgrade the database from 10.2.0.5 to 10.2.0.4 in case you encounter some issue?
Also - how are you doing the upgrade from 10.2.0.4 to 10.2.0.5 without any downtime?
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.
I have this error in AIX 64 bit 6.1 oracle 10.2.0.5. It does not happend with 10.2.0.4, is 10.2.0.5 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.
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.
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.
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
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.
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
10 Comments