I testing GG on my Laptop - GoldenGate

Hi ,
I am having Oracle 11g installed on Laptop with Windows 7.
I have installed two GG on separate directories . The Managers are running on port 7809 and 7810.
I have only one database with Two Schemas Ravi and DAMS.
My Source schema is DAMS. The Extract param file is as below :
EXTRACT extora
USERID ggs, PASSWORD ggs
DISCARDFILE D:\Downloads\GoldenGate\da_appl.dsc, PURGE
RMTHOST USER-PC, MGRPORT 7810
RMTTRAIL D:\Downloads\RemHost\dirdat\aa
TABLE DAMS.DA_APPL;
I registered the above in source GG as ADD EXTRACT EXTORA, SOURCEISTABLE
On the Target my Replicate is as below :
REPLICAT INITREP
ASSUMETARGETDEFS
DISCARDFILE D:\Downloads\RemHost\tcustmer.dsc, PURGE
USERID ggs, PASSWORD ggs
MAP DAMS.DA_APPL, TARGET RAVI.DA_APPL
WHERE (trunc(creation_date) >to_date('31-DEC-2008','DD-MON-YYYY'));
IGNOREINSERTS
MAP DAMS.DA_APPL, TARGET RAVI.DA_APPL
WHERE (trunc(creation_date) <=to_date('31-DEC-2008','DD-MON-YYYY'));
I keep getting the below error when I run the extract :
2010-10-14 16:58:00 ERROR OGG-00049 Trails cannot be used when SOURCEISTABLE/SOURCEISFILE is specified.
If i mark the rmttrail then I get the following error :
2010-10-14 17:02:49 ERROR OGG-00362 RMTTRAIL must be specified before FILE/TABLE/SEQUENCE.
I registered the replicate as :
add replicat initrep , specialrun
Thanks & Regards
Ravinder 

Hi Ravi,
If you are doing initial load then the parameters you specified work well. And you have to specify rmttask in the extora parameter file instead of rmttrail
EXTRACT extora
USERID ggs, PASSWORD ggs
DISCARDFILE D:\Downloads\GoldenGate\da_appl.dsc, PURGE
RMTHOST USER-PC, MGRPORT 7810
RMTTASK replicat, GROUP <replicat name>
--RMTTRAIL D:\Downloads\RemHost\dirdat\aa
TABLE DAMS.DA_APPL;
After initial load you have to specify
add extract extoram, tranlog, begin now
add replicat rep1, exttrail <trail location>, checkpointtable <table.checkpoint>
See if this works for you.
Thanks. 

Thanks a ton for the solution . The extract works now. But I am getting the below error message .
2010-10-15 12:04:05 ERROR OGG-00730 No minimum supplemental logging is enabl
ed. This may cause extract process to handle key update incorrectly if key colum
n is not in first row piece.
2010-10-15 12:04:05 ERROR OGG-01668 PROCESS ABENDING.
Does this mean that I need to turn on Supplemental Logging even if I am using DIRECT LOAD method for the initial load.
Thanks & Regards
Ravinder 

I ran the extract after turning on the supplemental log also and I get the below message :
2010-10-15 13:35:30 ERROR OGG-00446 Error 5 (Access is denied.) opening log
file D:\DATABASEAPPLE\APPLE\REDO03.LOG for sequence 396. Not able to establish i
nitial position for begin time 2010-10-15 10:13:24.
2010-10-15 13:35:30 ERROR OGG-01668 PROCESS ABENDING.
Am I missing something
Thanks & Regards 

Hi Ravi,
If you enabled the supplemental log at the database level then did u do this
ggsci> dblogin userid <username>, password <pwd>
ggsci> add trandata scott.*
I think you haven't done this and so the error. See is this works for you and also could you please post your extract and replicat params.
Thanks. 

HI
Please find my params files :
Extract Param File :
EXTRACT extora
USERID ggs, PASSWORD ggs
DISCARDFILE D:\Downloads\GoldenGate\da_appl.dsc, PURGE
RMTHOST USER-PC, MGRPORT 7809
RMTTASK replicat, GROUP initrep
TABLE DAMS.DA_MKTS_DTL;
Replicate PARAM file :
REPLICAT INITREP
ASSUMETARGETDEFS
DISCARDFILE D:\Downloads\GoldenGate\tcustmer.dsc, PURGE
USERID ggs, PASSWORD ggs
MAP DAMS.DA_MKTS_DTL, TARGET RAVI.DA_MKTS_DTL;
Thanks & Regards 

Hi,
After initial load remove those parameters RMTTASK and GROUP in extract. Instead specify RMTTRAIL
Stop the extract and replicat parameters and edit them and restart them.
add extract extora, tranlog, begin now
add rmttrail <trail location>, extract extora
Extract Param File :
EXTRACT extora
USERID ggs, PASSWORD ggs
DISCARDFILE D:\Downloads\GoldenGate\da_appl.dsc, PURGE
RMTHOST USER-PC, MGRPORT 7809
RMTTRAIL <trail location>
--RMTTASK replicat, GROUP initrep
TABLE DAMS.DA_MKTS_DTL;
add replicat initrep, exttrail <rmttrail file location>, checkpointtable ggs.checkpoint
Replicate PARAM file :
REPLICAT INITREP
ASSUMETARGETDEFS
DISCARDFILE D:\Downloads\GoldenGate\tcustmer.dsc, PURGE
USERID ggs, PASSWORD ggs
MAP DAMS.DA_MKTS_DTL, TARGET RAVI.DA_MKTS_DTL;
Hope this works for you.
Thanks. 

Hi ,
The thing is I want do the initial load using this files. But I am not able to get it to work. The extract starts and it opens another window for replicat but nothing happens.
Regards 

Hi,
Have you gone through this Metalink Doc ID 1149823.1. If not here it is. They clearly explained the solution for this error in Windows 7.
Symptoms
OS: Windows 2008 or Windows 7
DB: Oracle
Goldengate extract gets following errors:
1. fail to read Oracle online redo logs
(1) Before version 10.4.0.40_001 and 10.0.0.51_001:
2010-01-19 20:51:24 GGS ERROR 190 error (The operation completed successfully.) creating file E:\ORACLE\ORADATA\ORA1022A\REDO01.LOG for sequence 63.
(2) In version 10.4.0.40_001 and 10.0.0.51_001, or later:
2010-01-28 11:41:35 GGS ERROR 500 Error 5 (Access is denied.) opening log file E:\ORACLE\ORADATA\ORA1022A\REDO03.LOG for sequence 79. Not able to establish initial position for begin time 2010-01-28 11:38:38.
2. fail to read SQL server online log
2010-07-12 12:31:47 GGS INFO 285 VAM Client Report <OpenProcess failed to open SQL Server process. GetLastError is 5. Verify connection is to a local instance and that permissions are granted for access to sqlservr process ID 3948.>.
Cause
On windows 2008 or Windows 7, the default permission for Oracle online redo log is changed. Therefore, the other users cannot read them.
Solution
1. install GG service (e.g., "install ADDSERVICE").
The installation will require administrator privilege. After the installation, starting the manager by service (not from ggsci command line). Then, the extract may be started and able to read redo logs. This is the preferred way.
2. Start manager/extract processes as administrator.
Right click 'cmd' program (DOS), select 'run as administrator'. Then starting manager and extract will give the extract the permission to read redo logs.
3. Change online redo log files permission
Add read permission on all the redo logfiles to the user who will start up the manager and extract.
right click the file ->property->security->Edit->add
This may have side effects on database security, and is not recommended in production environment.
Thanks. 

Hi,
Have you gone through this Metalink Doc ID 1149823.1. If not here it is. They clearly explained the solution for this error in Windows 7.
Symptoms
OS: Windows 2008 or Windows 7
DB: Oracle
Goldengate extract gets following errors:
1. fail to read Oracle online redo logs
(1) Before version 10.4.0.40_001 and 10.0.0.51_001:
2010-01-19 20:51:24 GGS ERROR 190 error (The operation completed successfully.) creating file E:\ORACLE\ORADATA\ORA1022A\REDO01.LOG for sequence 63.
(2) In version 10.4.0.40_001 and 10.0.0.51_001, or later:
2010-01-28 11:41:35 GGS ERROR 500 Error 5 (Access is denied.) opening log file E:\ORACLE\ORADATA\ORA1022A\REDO03.LOG for sequence 79. Not able to establish initial position for begin time 2010-01-28 11:38:38.
2. fail to read SQL server online log
2010-07-12 12:31:47 GGS INFO 285 VAM Client Report <OpenProcess failed to open SQL Server process. GetLastError is 5. Verify connection is to a local instance and that permissions are granted for access to sqlservr process ID 3948.>.
Cause
On windows 2008 or Windows 7, the default permission for Oracle online redo log is changed. Therefore, the other users cannot read them.
Solution
1. install GG service (e.g., "install ADDSERVICE").
The installation will require administrator privilege. After the installation, starting the manager by service (not from ggsci command line). Then, the extract may be started and able to read redo logs. This is the preferred way.
2. Start manager/extract processes as administrator.
Right click 'cmd' program (DOS), select 'run as administrator'. Then starting manager and extract will give the extract the permission to read redo logs.
3. Change online redo log files permission
Add read permission on all the redo logfiles to the user who will start up the manager and extract.
right click the file ->property->security->Edit->add
This may have side effects on database security, and is not recommended in production environment.
Thanks. 

Hi
Thanks for your feedback. However I am using the same user id to login to my desktop which I used to install and create the database on my laptop. So my guess is that the redo logs are readable by my userid. Also GG is not given any messages with respect to unable to read the redo log files. It just sit there and no messages on the manager windows.
Thanks & Regards 

Sounds like a Windows permissions problem. If it can't open the file it can't open the file. See:
http://msdn.microsoft.com/en-us/library/ms681382%28VS.85%29.aspx
Manager doesn't report on extract read errors. Extract reports on extract read errors in the report and ggserr.log files. Try installing manager as a service from the OGG installation directory using a GLOBALS file and with "install addservice".
Good luck,
-joe 

Hi
Have done as you said .
1. Added MGR as a service to windows.
2. Provided full rights on redo files to the user account.
But still no luck .. Can someone tell me if it is really possible to do an Initail Load using SourceISTABLE option during extract and replicate to TARGET into the table. So called DIRECT LOAD. 

Mind posting the newest versions of your add commands and parameter files?
RMTTASK and RMTTRAIL are mutually exclusive. While the extract process binary is the same for initial loads and real-time change data capture, you can't use the same defined (with add command) extract and replicat for both. Also, SOURCEISTABLE is only used in extract for initial loads.
Regards,
-joe

Related

PURGEOLDEXTRACTS parameter

Hi,
I need
As it's indicated in GG documentation I put the PURGEOLDEXTRACTS parameter in an Extract parameter file to delete old trail files whenever Oracle GoldenGate starts processing from a new one.
But it seeams for me that I keep all the trail files in my server!!
How I can know the unused trail files to delete them manually till now I accumulate more than 500 trail files.
here is my Extract parameter file:
extract E_DPRD
userid ogg#OSI1, password system
exttrail /oracle/product/goldengate/data/PD
PURGEOLDEXTRACTS
DBOPTIONS ALLOWUNUSEDCOLUMN
TRANLOGOPTIONS ASMUSER sys#ASM_OSI, ASMPASSWORD XXXX
wildcardresolve dynamic
TABLE OSI.;*
Regards, 
I think info <PROCESS>, showch should give you the idea. Have a look at the Startup Checkpoint & Checkpoint lag. 
vittel wrote:
As it's indicated in GG documentation I put the PURGEOLDEXTRACTS parameter in an Extract parameter file to delete old trail files whenever Oracle GoldenGate starts processing from a new one.
But it seeams for me that I keep all the trail files in my server!!
How I can know the unused trail files to delete them manually till now I accumulate more than 500 trail files.
...
here is my Extract parameter file:
extract E_DPRD
userid ogg#OSI1, password system
exttrail /oracle/product/goldengate/data/PD
PURGEOLDEXTRACTSPut the parameter in mgr parameter file instead of extract. Specify the option to "use checkpoints" to delete old trails, optionally with other "minimum" values to keep the files around just a little longer, just in case.
PURGEOLDEXTRACTS dirdat/xy, USECHECKPOINTS, MINKEEPHOURS 1 MINKEEPFILES 5Also, from the admin guide,
When using PURGEOLDEXTRACTS, do not permit trail files to be deleted by any user or program other than Oracle GoldenGate. It will cause PURGEOLDEXTRACTS to function improperlySee also the Oracle GoldenGate Best Practice - sample parameter files (Doc ID 1321696.1). 
hi, May I ask how your tranlogoptions asmusre, asmpassword worked?
Mine keep giving me ora-12514 error. 
HI
I hoppe this help you, this is my configuration and its working fine to purge old trails:
GGSCI (ISIS) 3> EDIT PARAMS MGR
PORT 7809
USERID goldengate, PASSWORD oracle1
PURGEOLDEXTRACTS /u02/app/goldenGate/dirdat/ex, USECHECKPOINTS
PURGEOLDEXTRACTS /u02/app/goldenGate/dirdat/nm, USECHECKPOINTS
GGSCI (ISIS) 4> edit params exnomina
EXTRACT exnomina
USERID goldengate, PASSWORD oracle1
SETENV (ORACLE_HOME = "/u01/app/oracle/product/10.2.0/db_1")
SETENV (ORACLE_SID = "ISISDB")
EXTTRAIL /u02/app/goldenGate/dirdat/nm
DISCARDFILE discardNomina.log, APPEND
TABLE nomina.*;
Edited by: J.A. on 24/05/2012 07:00 AM 
Hi,
Thank you very much about your response
It's possible to add the parameter PURGEOLDEXTRACTS without restarting the process?
Regards, 
Hi
Im not sure, but I think you have to restart, if you can not restart tell me and I will try it on my enviroment
J.A. 
#vittel, bounce is required for any process to take any new parameters into affect. Overhere, bouncing the manager would not effect the already running process in OGG environment.

Goldengate replication not working

I have configured goldengate on Linux machine , below are the environment details.Oracle DB version : 11gr2 , 11.2.0.4.0 with ASM storageGoldengate version: Version 11.2.1.0.1OS : Redhat Linux I am trying to replicat  from source to target but its just not replicating , at the same time I donot see any errors with extract and replicat.I recreated the ASM password file too.Below are the extract and replicat configurations. ============On Source ============---------- view params mgrPORT 15000PurgeOldExtracts ./dirdat/*, UseCheckpoints ---------- view params extdmEXTRACT extdmuserid ggs_admin, password qwertyEXTTRAIL ./dirdat/saTRANLOGOPTIONS ASMUSER sys#+ASM, ASMPASSWORD Public123ddl include mapped;table sender.t1; ---------- view params extdpmpEXTRACT extdpmpPASSTHRURMTHOST <remotemachineip>, MGRPORT 15005RMTTRAIL /home/goldengate/dirdat/ltTABLE sender.*;  ----------view params ./GLOBALGGSCHEMA ggs_adminCHECKPOINTTABLE ggs_admin.chkpt  =========== On Target ============== ---------------view params mgrPORT 15005PurgeOldExtracts ./dirdat/*, UseCheckpoints -----------view params rep1replicat rep1ASSUMETARGETDEFSuserid ggs_admin, password qwertyhandlecollisionsdiscardfile /home/goldengate/discard.txt, append, megabytes 10ddl include mappedmap sender.*, target receiver.*; -------- view params ./GLOBALGGSCHEMA ggs_adminCHECKPOINTTABLE ggs_admin.chkpt The target database is reachable from source.Could you please advise what should be investigated further? Is the configuration not proper? Thanks,MKS
Hi, 1.  You may want to take off the ASM credentails in the extract parameter file and use 'TRANLOGOPTIONS DBLOGREADER' which uses the new API to read the logs on the ASM instance and restart the extract which is significantly faster in reading the logs. 2. When you say "I am trying to replicat  from source to target but its just not replicating".  Are you stating that the transactions are not captured on the source i.e., by the extract process here? Try checking the stats on the extract process to see if it ever captured any dml's/ddl's:ggsci> stats extdmggsci> stats extdpmpggsci> info extdmggsci> info extdpmpggsci> send extdm status -->> get this output 3-4 timesggsci> send extdpmp status -->> get this output 3-4 times 3.  You may also want to see if the replicat is configured correctly to process the transactions in the trails on the target server. 4.  Get the below from source:- How th extract and pump is added.- shell> ls -lrt ./dirdat/sa* Get the below from target:- ggsci> sh ls -lrt /home/goldengate/dirdat/lt*- ggsci> info rep1 ThanksVivek
My issue is resolved after I deleted and reconfigured the replicat.I might have missed below step or did not follow it properly.add replicat rep1, exttrail /home/goldengate/dirdat/lt,checkpointtable ggs_admin.chkpt,begin now Now the replication works.Thanks for your help.

Goldengate Installation issue

Hi There,
I am configuring Oracle GG(unzip V22228-01) on below test servers.
SOURCE : 11gR2, RHEL 4, Schema : sender.*
TARGET : 10gR2, RHEL 4: Schema : reciever.*
See my workaround below.
SOURCE :
mgr process--
PORT 7809
USERID ggate,password ****
PURGEOLDEXTRACTS /gg/dirdat/ex, USECHECKPOINTS
My extract process --
extract ext1
userid ggate,password ggate
rmhost <IP>, mgrport 7809
rmttrail /gg/dirdat/lt
ddl include mapped objname sender.*
table sender.*;
start extract ext1
TARGET -----------
mgr process same as source
default chekpointtable using ./GLOBALS file
replicat process..
gg>add replicat rep1, exttrail /gg/dirdat/lt, checkpointtable ggate.checkpoint
gg>edit params rep1
--------
replicat rep1
ASSUMETARGETDEFS
userid ggate,password ****
discardfile /gg/discard/repsh_discard.txt, append, megabytes 10
DDL include all
DDLOPTIONS REPORT
map sender.*.target reciever.*;
start replicat rep1
But replication is not working properly. But mgr,extract and replicat are successfully without showing any errors in view report...
Find my some of the queries below..
1) In which case do we need do Initial load??
2) How GG transfer data to RMHOST server? It uses any TCP/IP connection?
3) In EXTRACT and REPLICAT process I used below statement to connect..
dblogin userid#source,password ***
In replicat, dblogin usreid#target,password ***
How data is transfered between Source and destination?
Here, How gg will comes to know that it will connect RMTHOST without any tnsalias to TARGET from SOURCE and SOURCE To TARGET.
We are connecting the same server using tns aliases.
Please help on configuring GG. Guide me on this.
Thanks,
Harry
Edited by: Harry on Aug 3, 2011 4:22 PM 
Try the tutorial and that will give you a good working example.
There are typos in what you posted. I don't know if that is from you actually typing what is posted, or from cut and paste (RMHOST, for example, should be RMTHOST).
GoldenGate for Oracle needs access to at least the full client (the XDK libraries therein). From the setup guide:
"Make certain that the ORACLE_HOME and ORACLE_SID system environment variables are set
to the correct Oracle instance. The Oracle GoldenGate processes refer to them when
connecting to the database."
Like any other client trying to access an Oracle database using Oracle client software, your client configuration will include an entry in the tnsnames.ora file. If you are on the same server, but using two different databases, then you can specify the correct SID by using the SETENV parameter in your parameter file.
"If there are multiple Oracle instances on the system with Extract and Replicat
processes connecting to them, you will need to use a SETENV statement in the parameter
file of each process group and point it to the correct instance."
Data is transferred between source and target via TCP/IP, which makes the transfer of data using GoldenGate separate from Oracle Net Services. 
Dear
After unzip the GG version, on goldengate command prompt, have you created subfolders of the GoldenGate?
Command is created subdirs. 
You mean create subdirs, not created subdirs. 
Yes,I have created all the subdirs and followd all the necessary steps, but no luck yet.
I will post all of work here, jst wanted you to go through and guide me.
Thanks,
Harry 
Ya dear, Thanks I wrote Created by mistakes. Please post your errors and detail so we can help you acordingly.
Edited by: samir on Aug 10, 2011 12:40 PM 
Samir,
I have posted all of my workaround and steps as another thread "goldentgate installation failed -urgent"
Plz go through that steps and help me out..
Harry

MYSQL 55 to Oracle 11gr1 replication(oneway) - can not replicate

I have setup golden gate replication between mysql 55 and oracle 11gr1. While trying to setup the initial load, I do'nt see any data push to oracle from mysql.
What could be wrong in my setup.? has anyone tried this kind of setup? i see the the report for replicat and it says data is not replicated. while extract shows that 4 rows from table are taken for insert. 
Can you post your extract and replicat parameter files? And confirm both processes are running. 
Hi Stev
I am trying to do the initial load process
On source (MYSQL 55)
database (ggtest and table test)
table test has
TEST(COL1 INT)
manager is running on default port 7809
manager parameter file is defined with (PORT 7809)
There is initial load extract (EINI01) -->
ADD EXTRACT EINI01
param file
EXTRACT EINI01
SOURCEDB ggtest#192.168.75.115, USERID ggsdev, PASSWORD ggsdev
RMTHOST 192.168.75.116, MGRPORT 7809
RMPTTASK REPLICAT, GROUP RINI01
TABLE ggtest.TEST
On target oracle 11gr1 (11.1.0.6)
Database in archive log mode, with minimum supplemental logging.
replicat process
ADD REPLICAT RINI01
Parameter file for replicat
REPLICAT RINI01
USERID ggs_owner, PASSWORD ggs_owner ( added in target database)
ASSUMTARGETDEFS
SETENV (NLS_LANG="AMERICAN_AMERICA.WE8MSWIN1252")
MAP ggtest.TEST , TARGET GGTEST.TEST;
-- to start the initial load ( mysql side has 4 rows, oracle has no row )
on source, i ran the command
ggsci> start extract eini01
I can see on report, extract has picked 4 rows for insert, but on replicat side no replication done. No error reported in gserr.log and there was a communication between source side of extract with traget side manager and sunsequently repliacat on target was started by manager and stopped normally. but no rows replicated.
Between oracle-to-oracle there is no problem. But my actual project is to setup from mysql to oracle (one way replication).
let me know if you need any other info.
Thanks
rafey 
One change I would make is to not use assumetargetdefs. A MySQL table is not identical to an Oracle table.
Also, try using the tutorial for MySQL to Oracle:
http://apex.oracle.com/pls/apex/f?p=44785:24:171764612587781::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5495,2
Another change (as a good practice) is to not use the GoldenGate database user as the schema you are trying replicate. Use the GoldenGate user to manage/run/operate GoldenGate and do the replication. Extract and Replicat should be based on other schemas, not the GoldenGate schema. 
Steve
Thank you so much for the suggestion and pointing me to the right direction.
This document is very helpful.
After reading through document, I have one question arises as why ODBC connector is used although (my thought) mysql client is there to connect to mysql server. I installed both GG and MYSQL under oracle user in the same group and I can launch mysql client from any place as long as I am connected through os user (oracle).
I will give a try based on the document. 
Hi Steve
Following the Document, I was able to complete the initial load. However, I avoided the ODBC connector part and directly used it with mysql native user.
DEFGEN made the difference and did help in translation and initial load. I hope now change capture and replication will be not be an issue now. I will post you detail of my testing and finding.
Thanks again for your quick reply and helping me.
Rafey 
I have been getting the below error while starting EXTRACT process for change capture on source mysql db
2011-12-28 08:34:06 ERROR OGG-00146 VAM function VAMInitialize returned unexpected result: error 600 - VAM C
lient Report <CAUSE OF FAILURE : Failed to connect to mysql database
WHEN FAILED : While initializing mysql context
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.
2011-12-28 08:34:06 ERROR OGG-01668 PROCESS ABENDING.
I have extract EMSQ01 setup as follow
GGSCI (ogg-mysql-src.localdomain) 18> view params emsq01
EXTRACT EMSQ01
DBOPTIONS HOST 192.168.75.116, CONNECTIONPORT 3306
SOURCEDB ggtest#192.168.75.115, USERID ggsdev, PASSWORD ggsdev
RMTHOST 192.168.75.116, MGRPORT 7809
RMTTRAIL ./dirdat/td
TRANLOGOPTIONS ALTLOGDEST /u01/app/oracle/mysql/data/mysql-bin.index
TABLE ggtest.TCUSTMER;
TABLE ggtest.TCUSTORD;
I will greatly appreciate if anyone can help on this. 
can anybody reply in case they have any insight about this issue.
I will greatly appreciate it. 
Failed to connect to mysql database
Can you login the MYSQL instance with dblogin? 
Yes, I can login.
Working with Oraclesupport has identified a bug. mysql was trying to login through local host. Once I changed that one it worked.

GoldenGate Running with no error but no replication.How to Troubleshoot?

Hi,
I am using 2 servers
OS DB
Server 1 - IBM AIX ORACLE 11g - Source Machine.
Server 2 - Oracle Linux 5 ORACLE 11g - Target Machine.
I am trying to apply goldengate to replicate data as well as DDL modifications from Server 1 to Server 2.
Details of Server 1 :-
Manager is running.
Parameter file for Extract IUT01
EXTRACT IUT01
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST OFSMUG-VM-87.i-flex.com, MGRPORT 7809
RMTTRAIL /oracle/GoldenGate/Setup/dirdat/rt
TABLE NGPIUT01.*;
Parameter file for Extract IUT01DP - Data pump Extract
EXTRACT IUT01DP
USERID ggs_owner, PASSWORD ggs_owner
EXTTRAIL /data01/oradata/GoldenGate/dirdat/dpump/lt
TABLE IUT01.*;
GGSCI (FIFLX595) 56> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING IUT01 00:00:00 00:00:05
EXTRACT RUNNING IUT01DP 00:00:00 00:00:09
Details of Server 2 :-
Manager is running.
Parameter file for Replicat NGPIUT01
REPLICAT NGPIUT01
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ggs_owner
MAP NGPIUT01.*, TARGET IUT01.*;
GGSCI (OFSMUG-VM-87.i-flex.com) 42> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING NGPIUT01 00:00:00 00:00:08
But I can't see the changes happening in the Source db getting reflected in the Target db .
Please guide me how should i troubleshoot here???? I am not getting any error but no effect of replication as well.
Thanks in advance! 
Let's say you want to use a data pump in your replication. A data pump is a secondary extract process. The primary extract will get SQL out of the redo logs and put it into local files, called trails. From there, the data pump will send those files to the target server.
On the target server, the replicat process will read through the trails and create the SQL to be applied to the target database.
In your parameters, what you have so far, is one extract sending directly to the target, altogether bypassing a data pump. Then you have a data pump that does nothing (where is it sending the trails to?). And your replicat, which is okay by itself.
I would suggest going through the tutorial at Oracle Learning Library. There are several other steps you missed (or at least, did not mention in your post).
Here is the link to OLL:
http://apex.oracle.com/pls/apex/f?p=44785:2:2156313463925258:FORCE_QUERY::2,CIR,RIR:P2_TAGS:Goldengate
Plus, look at the admin guide and the diagrams. Those will help explain the architecture. 
Thanks for your reply.
I am facing a error now.
ERROR   OGG-01031  There is a problem in network communication, a remote file problem, encryption keys
for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/oracle/G
oldenGate/Setup/dirdat/rt000004" (error 11, Resource temporarily unavailable)).I tried the solution given in some post on this forum which says that rename the rt0001 file to some other name like rt0001_backup and then restart the extract dpump process and then it will work. I did this it started working but after sometime I get again the same error for some different file.
Please guide me what to do in such situations? 
Anyone any update ? 
Hi
you can use logdump utility to find out the number of transactons in source trail file and target trail file. The count should match. in Golden Gate home directory you can execute "logdump" command and
(1) open "trail file location"
(2) detail data on
(3) count

Categories

Resources