GG replication not performing - GoldenGate

Dear All,
Can any one help me on this
I have pasted my entire setup parametes here, kindly check and provide your valuable sollution on this issue,
ggsci > edit params mgr
PORT 7810
DYNAMICPORTLIST 7810-7820
ggsci> dblogin userid ggate, password changeme
ggsci> add trandata ggate.*
ggsci> edit params septest
extract septest
userid ggate, password changeme
TRANLOGOPTIONS ASMUSER sys#ASM, ASMPASSWORD kkkkk12
discardfile ./dirrpt/septest.dsc, purge
reportcount every 15 minutes, rate
exttrail ./dirdat/t1
table ggate.*;
ggsci> add extract xtst01, tranlog, begin now
ggsci > add exttrail ./dirdat/t1, extract xtst01, megabytes 100
for pump:
extract ptst01
passthru
rmthost 10.10.35.32, mgrport 7910
rmttrail ./dirdat/t1
table ggate.*;
ggsci> add extract ptst01, exttrailsource ./dirdat/t1
ggsci add rmttrail ./dirdat/t1, extract ptst01, megabytes 100
Target side
ggsci> dblogin userid ggate, password changeme
ggsci > add checkpoint table sep_check
gsci> edit params mgr
PORT 7910
DYNAMICPORTLIST 7910-7920
ggsci> edit params rtst01
replicat rtst01
userid ggate, password changeme
discardfile ./dirrpt/rtst01.dsc, purge
assumetargetdefs
reportcount every 15 minutes, rate
map ggate.*, target ggate.*;
add replicat rtst01, exttrail ./dirdat/t1, checkpointtable sep_check
Manager,extract,pump, target side mgr, replicat everything RUNNING.... but replication not happend,
but in source side extract stats
*** Total statistics since 2010-09-16 03:34:12 ***
Total inserts 1000.00
Total updates 0.00
Total deletes 0.00
Total truncates 0.00
Total discards 0.00
Total operations 1.00
But pump stats , im unable to get ,
Im getting timeout occur waiting for message
target side
ggsci> stats replicat rtst01
no active replication maps
replication not happend,
i think, datapump not fetching the datas, ..? :(
or whether any port related issues,:(
please guide me
Thanks in advance 

Annamalai,
What port is your target manager running on?
In your source manager param file you have listed:
DYNAMICPORTLIST 7810-7820
But in your pump you use:
rmthost 10.10.35.32, mgrport 7910
7910 is not in the range of 7810-7820. Either make your target manager listen on a port in the 7810-7820 range or change the range to include port 7910.
Regards,
-joe 

i have changed my port, now everything works fine,
Thank u so much 

.

Related

Configure

Hi All,
i have configured OGG like below but it is not replicating.
Souce:
----------
MGR PARAMETER
PORT 7809
DYNAMICPORTLIST 7810-7820
PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat
dblogin userid adm1, password adm1
SQLPLUS ORCL (SYS USER)
=========
#marker_setup.sql
#ddl_setup.sql
#role_setup.sql
grant GGS_GGSUSER_ROLE to adm1;
#ddl_enable.sql
dblogin userid adm1, password adm1
add trandata scott.*
exteimple parameter
EXTRACT extsimple
EXTTRAIL /exports/OGG10g_Home/dirdat/ut
DISCARDFILE /exports/OGG10g_Home/dirrpt/simple.dsc
SETENV (ORACLE_SID = "ORCL")
USERID adm1, PASSWORD adm1
DBOPTIONS ALLOWUNUSEDCOLUMN
TRANLOGOPTIONS EXCLUDEUSER adm1
DDL INCLUDE MAPPED OBJNAME scott.*
DDLOPTIONS ADDTRANDATA, REPORT
TABLE scott.*;
PMPSIMPLE PARAMETER
EXTRACT pmpuat
RMTHOST 183.82.143.49, MGRPORT 7809, COMPRESS
RMTTRAIL /exports/OGG10g_Home/dirdat/ut
SETENV (ORACLE_SID = "raja")
TRANLOGOPTIONS EXCLUDEUSER adm1
PASSTHRU
TABLE scott.*;
add extract extsimple, tranlog, begin now
add exttrail /exports/OGG10g_Home/dirdat/ut, extract extsimple, megabytes 50
add extract pmpsimple, exttrailsource /exports/OGG10g_Home/dirdat/ut
add rmttrail /exports/OGG10g_Home/dirdat/ut, extract pmpsimple, megabytes 50
start extract extsimple
start extract pmpsimple
add checkpointtable simple
add replicat repsimple, exttrail /exports/OGG10g_Home/dirdat/tu, CHECKPOINTTABLE simple
start replicat repsimple
Target:
-----------
MGR PARAMETER
PORT 7809
DYNAMICPORTLIST 7810-7820
PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat/*, USECHECKPOINTS
dblogin userid adm2, password adm2
RAJA AT SQLPLUS (SYS USER)
========
#marker_setup.sql
#ddl_setup.sql
#role_setup.sql
grant GGS_GGSUSER_ROLE to adm2;
#ddl_enable.sql
dblogin userid adm2, password adm2
add trandata scott.*
REPLICATION PARAMETER
REPLICAT repsimple
ASSUMETARGETDEFS
APPLYNOOPUPDATES
DISCARDFILE /exports/OGG10g_Home/dirrpt/repuat.dsc,
SETENV (ORACLE_SID = "raja")
USERID adm2 PASSWORD adm2
MAP scottt.*, TARGET scott.*;
add checkpointtable simple1
add replicat repsimple1, exttrail /exports/OGG10g_Home/dirdat/ut, CHECKPOINTTABLE simple
start replicat repuat
add extract extsimple1, tranlog, begin now
add exttrail /exports/OGG10g_Home/dirdat/tu, extract extsimple1, megabytes 50
add extract pmpsimple1, exttrailsource /exports/OGG10g_Home/dirdat/tu
add rmttrail /exports/OGG10g_Home/dirdat/tu, extract pmpsimple1, megabytes 50
start extract extsimple1
start extract pmpsimple1
Thanks
Rajasekhar 
Hi,
1. What is your requirement? are trying to configure uni directional(one way) or Bi - directional(two way) replication?
2. as per your below setup from manager parameter file ,
Source side manager prm file , the purgeoldextracts is not configured correctly , it should be with ext trail file name or '*' , like the below example
PURGEOLDEXTRACTS ./dirdat/ut*, USECHECKPOINTS, MINKEEPHOURS 2
3. the ext trail file and rmt trail file name should not be same , also the rmt trail file path must be your target environment directory path,
here you have configured the both path name and file name are same,
4. and if you are going to configure bi directional replication, better to first configure uni directional and test it then move to bi directional.
5. see the below config steps,
i. add supplemental log data on both database (if the requirment is two way)
ii. Souce:
--------------------------------------------------------------------------------
MGR PARAMETER
PORT 7809
DYNAMICPORTLIST 7810-7820
PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat/ut*, usecheckpoints
ii. execute requird DDL scripts on source database connected as sys user or sysdba privileged user,
iii, change the rmttrail path , give path name as available in target database,
for ex,
add extract extsimple, tranlog, begin now
add exttrail /exports/OGG10g_Home/dirdat/ut, extract extsimple, megabytes 50
add extract pmpsimple, exttrailsource /exports/OGG10g_Home/dirdat/ut
add rmttrail <this path should be target environment path and trail file name also different one from source exttrail >, extract pmpsimple, megabytes 50
iv, updte the pmp parameter file with new rmt trail file name,
finally recommend to go through the below link tutorial for Using Oracle GoldenGate for Oracle to Oracle Database Synchronization,
http://apex.oracle.com/pls/apex/f?p=44785:24:8343116176167:::24:P24_CONTENT_ID,P24_PREV_PAGE:5340,24
also refer the oracle goldengate admin guide,
hopefully this will help you
Annamalai 
on the source database side, can you please execute this select: SELECT supplemental_log_data_min FROM v$database; and provide the output?

Setting up a dedicated application server for golden gate

Has anyone setup a dedicated server for Golden Gate replication?
I started configuring my GG-replication server and have a couple questions that I have not figured out how to work around. Hopefully someone he has done this and can assist.
Here is what I am doing:
I have my application server - APPSRV1
I have DatabaseA (11.1.0.7) which runs on DBSERVER1
And DatabaseB (10.2.0.4) which runs on DBSERVER2
I have created my extract and replicat on APPSRV1 and have the manager for each both running on different ports.
Extract:
PORT 7809
USERID ggadm#DatabaseA, PASSWORD manager
PURGEOLDEXTRACTS /export/apps/oracle/ggate/dev/11.1/DataA/dirdat, USECHECKPOINTS
Replicat:
PORT 7810
USERID ggadm#DatabaseB, PASSWORD manager
PURGEOLDEXTRACTS /export/apps/ggate/dev/11.1/DataB/dirdat, USECHECKPOINTS
And My PARAMS for My extract and replicat
DBLOGIN USERID ggadm#DatabaseA, PASSWORD manager
DELETE EXTRACT SATMP
ADD EXTRACT SATMP, SOURCEISTABLE
EDIT PARAMS SATMP
EXTRACT SATMP
SOURCEISTABLE
SETENV (ORACLE_HOME=/app001/oracle/11107/software)
USERID ggadm#DatabaseA, PASSWORD manager
RMTHOST APPSRV1, MGRPORT 7810
RMTFILE ./dirdat/in, MAXFILES 999999, megabytes 500
TABLE SCOTT.EMP;
start ext SATMP
#################
DBLOGIN USERID ggadm#DatabaseB, PASSWORD manager
DELETE REP AWTMP
ADD REPLICAT AWTMP, EXTTRAIL ./dirdat/in, nodbcheckpoint
EDIT PARAMS AWTMP
REPLICAT AWTMP
SETENV (ORACLE_HOME=/app001/oracle/10204/software)
USERID ggadm#DatabaseB, PASSWORD manager
ASSUMETARGETDEFS
MAP SCOTT.EMP, TARGET BRENDA.EMP;
START REP AWTMP
All of this worked fine...and the data was loaded. However, when I go to start the real-time replication, it is not working so favorably for me.
DBLOGIN USERID ggadm#DatabaseA, PASSWORD manager
ADD TRANDATA SCOTT.EMP
ADD EXTRACT SAREAL TRANLOG, BEGIN NOW
ADD RMTTRAIL /export/apps/ggate/dev/11.1/DataB/dirdat/sa, EXTRACT SAREAL, MEGABYTES 20
alter ext SAREAL, begin now
edit params SAREAL
EXTRACT SAREAL
SETENV (ORACLE_HOME=/app001/oracle/11107/software)
USERID ggadm#DatabaseA, PASSWORD manager
RMTHOST APPSRV1, MGRPORT 7810
RMTTRAIL /export/apps/ggate/dev/11.1/DataB/dirdat/sa
TABLE SCOTT.EMP;
#########################
ADD REPLICAT AWREAL, EXTTRAIL /export/apps/ggate/dev/11.1/DataB/dirdat/sa
EDIT PARAMS AWREAL
REPLICAT AWREAL
SETENV (ORACLE_HOME=/app001/oracle/10204/software)
USERID ggadm#DatabaseB, PASSWORD manager
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/AWREAL.dsc, PURGE
MAP SCOTT.EMP, TARGET BRENDA.EMP;
But when I go over to start the EXTRACT, I get the following error message.
2010-12-03 12:21:36 ERROR OGG-00446 error 2 (No such file or directory) opening redo log /ora001/oradata/DataA/redo_DataA_05a.log for sequence 2711Not able to establish initial position for begin time 2010-12-03 12:20:57.
2010-12-03 12:21:36 ERROR OGG-01668 PROCESS ABENDING.
Is there not a way for me to run the GG extract and replicat processes from a remote server other than the servers where the databases reside?
Thank you 
Hi
Mount log files on platform that you have GoldenGate installed and tell GoldenGate extract where the logs are:
You need to say what platform is this logs from in extract parameter file:
TRANLOGOPTIONS LOGSOURCE <platform>
Page 370 of reference guide.
Where are they:
TRANLOGOPTIONS PATHMAP <NFS mount point> <log path>
Page 372 of reference guide.
Cheers

Problem with extract process

Hi All,
I am new to oracle golden gate , i have configured a setup for replicating data b/w MYSQL and Oracle 11g using golden gate.Below are the steps i followed
Manager on Source MYSQL:
PORT 7809
DYNAMICPORTLIST 8001, 8002, 9500-9502
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS
CHECKMINUTES 5
Extract eload for initial load on source.
EXTRACT ELOAD
RMTHOST 127.0.0.1, MGRPORT 15000
RMTTASK REPLICAT, GROUP RLOAD
SOURCEDB MYBANK USERID mygg, PASSWORD mygg
TABLE MYBANK.ACCOUNT;
TABLE MYBANK.ACCOUNT_TRANS;
TABLE MYBANK.BRANCH;
TABLE MYBANK.BRANCH_ATM;
TABLE MYBANK.TELLER;
TABLE MYBANK.TELLER_TRANS;
Manager on Target Oracle:
PORT 15000
DYNAMICPORTLIST 15010-15020
PURGEOLDEXTRACTS /u01/oraclegg/dirdat/*, USECHECKPOINTS
CHECKMINUTES 5
Rload on Target for initial load:
REPLICAT RLOAD
USERID orgg, PASSWORD orgg
ASSUMETARGETDEFS
MAP MYBANK.*, TARGET ORGG.*;
I have started managers and started initial load by starting eload , initial load went fine. Now i have configured processes for REplication through transactional logs.
extract process on source mysql:
EXTRACT EMASTR
EXTTRAIL ./dirdat/em
SOURCEDB MYBANK, USERID mygg, PASSWORD mygg
STATOPTIONS RESETREPORTSTATS
REPORT AT 00:01
REPORTROLLOVER AT 00:01
REPORTCOUNT EVERY 60 SECONDS, RATE
TABLE MYBANK.ACCOUNT;
TABLE MYBANK.ACCOUNT_TRANS;
TABLE MYBANK.BRANCH;
TABLE MYBANK.BRANCH_ATM;
TABLE MYBANK.TELLER;
TABLE MYBANK.TELLER_TRANS;
Datamump process on source:
EXTRACT PMASTR
RMTHOST 127.0.0.1, MGRPORT 15000
RMTTRAIL ./dirdat/pm
PASSTHRU
TABLE MYBANK.*;
Replicat process on target:
REPLICAT RMASTR
USERID orgg, PASSWORD orgg
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/rmastr.dsc, purge
STATOPTIONS RESETREPORTSTATS
REPORT AT 00:01
REPORTROLLOVER AT 00:01
REPORTCOUNT EVERY 60 SECONDS, RATE
MAP MYBANK.*, TARGET ORGG.*;
I have started extract and replicat processes for the first time it went fine no issues and after some time i have shut down all golden gate processes , source and target databases as well now after 3 days i have started databases and golden gate processes for replication.
All processes are running fine and info * shows no lag , but the issue is i am not able to see the transactions happened on the source and when i give "stats extract emastr" on my source it says "No active replication maps" , i got stuck here.
Pls let me know what went wrong , any help on this would be really gr8.
Thanks in advance.
Puneeth.
Edited by: Puneeth Velichala on May 12, 2011 9:59 AM 
What did you mean by
MAP MYBANK., TARGET ORGG.; ???
If you want to replicate all tables from MYBANK schema to ORGG schema - you should use
MAP MYBANK.*, TARGET ORGG.*;
You also should check trail ./dirdat/pm - is it growing? if yes then problem in replicat - otherwise in extract

GoldenGate Replication issue!

Hi,
I have configured extract, datapump and replication process and they all are running without any error.
The issue is actual replicatin is not taking place..
Infact extract process and datapump process nothing is their, if I run any DMLs in source database no info appears when I run view report ext1, datapump or replication process detail.
Kindly help urgently.
Thanks in advance.
Poorna
Edited by: 0077 on Sep 22, 2011 4:54 PM 
Post your parameter files and GGSCI ADD statements. 
ADD EXTRACT ext1, TRANLOG, BEGIN NOW                              
                                   
ADD EXTTRAIL /u01/app/gg/dirdat/lt, extract ext1                                   
extract ext1                                             
userid gg, password gg               
rmthost test01.lab.com, mgrport 7809                         
EXTTRAIL /u01/app/gg/dirdat/lt                                   
table
TO.REM,
PA.PUR;                                                                                                                             
ADD EXTRACT dp, EXTTRAILSOURCE /u01/app/ggate/dirdat/xt                                   
                                   
ADD RMTTRAIL /u01/app/gg/dirdat/xt, EXTRACT dp               
extract dpump                                             
userid gg, password gg               
discardfile /u01/app/gg/discard/ext_discard.txt, purge, megabytes 15                         rmthost test02.lab.com, mgrport 7809                    
rmttrail /u01/app/gg/dirdat/xt                                             passthru     
table TO.*;
table PA.*;                                                  
                                   
ADD REPLICAT rep1, EXTTRAIL /u01/app/gg/dirdat/xt     
REPLICAT rep2
ASSUMETARGETDEFS
USERID gg, PASSWORD gg
discardfile /u01/app/gg/discard/rep_discard.txt, purge, megabytes 15
MAP TO.*, PA.*,
Target GG.*;
Edited by: 0077 on Sep 23, 2011 8:23 AM 
If you typed in the parameter file contents, there are some errors, and if you pasted them in, there are definitely errors.
In the extract:
table owner.table_name;
table owner.table_name;
This is not a comma separated listed. It is table by table with an ending semicolon. If you wildcard, then it is:
table owner.*;
table owner.part_of_the_table_name*;
In the replicat:
You need a MAP and TABLE in one statement/line.
MAP owner.table_from_source, TABLE owner.table_in_target;
If you wildcard this:
MAP owner.[asterisk], TABLE owner.*; 
I have Changed pamareters accordingly
but still data is not replicated on Target database
stats replicat rep1
Sending STATS request to REPLICAT REP1 ...
No active replication maps.
Kindly help
Thanks
Poorna
Edited by: 0077 on Sep 25, 2011 3:32 PM 
Let's see the parameter files again (after the fixes you made). 
ADD EXTRACT ext1, TRANLOG, BEGIN NOW
ADD EXTTRAIL /u01/app/gg/dirdat/lt, extract ext1
extract ext1
userid gg, password gg
rmthost test01.lab.com, mgrport 7809
EXTTRAIL /u01/app/gg/dirdat/lt
table.TO.REM,
table.PA.PUR;
ADD EXTRACT dp, EXTTRAILSOURCE /u01/app/ggate/dirdat/xt
ADD RMTTRAIL /u01/app/gg/dirdat/xt, EXTRACT dp
extract dpump
userid gg, password gg
discardfile /u01/app/gg/discard/ext_discard.txt, purge, megabytes 15 rmthost test02.lab.com, mgrport 7809
rmttrail /u01/app/gg/dirdat/xt passthru
table TO.*;
table PA.*;
ADD REPLICAT rep1, EXTTRAIL /u01/app/gg/dirdat/xt
REPLICAT rep2
ASSUMETARGETDEFS
USERID gg, PASSWORD gg
discardfile /u01/app/gg/discard/rep_discard.txt, purge, megabytes 15
MAP TO.*, PA.*, Target GG.*; 
Okay, there are several mistakes.
Your extract should be like this:
extract ext1
userid gg, password gg
rmthost test01.lab.com, mgrport 7809
EXTTRAIL /u01/app/gg/dirdat/lt
table TO.REM;
table PA.PUR;
The data pump's trail source should be reading the trails generated by the extract. You have data pump reading xt files with the source files named using lt.
Multiple names for data pump: dpump and dp. That won't work.
Replicate rep1 versus rep2, plus extra stuff at the end of the parameter file:
Target GG.*;
Try following the Oracle to Oracle tutorial here (at least get a simple extract and replicat working, then add in a data pump, note the syntax used):
https://apex.oracle.com/pls/apex/f?p=44785:24:299584712491262::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5340,2 
Hi,
all required latest trail files are present in dirdat directory of Target database but still replication process is not processing.
Please let me know.
Thanks & Regards,
Poorna 
Parameter file? ADD command? Status/info? 
Its really big pain ???   the replicat was very unstable .. there are no message , I got simply the error no.. as  ogg 0446 .and I could see Process Abending ... ???    I tried all the options ...

replication of two database on the same host

Hello,
I installed oracle and teradata dbms on my PC.
I have two different databases on the same hostname.
Basicly I want to test a simple replication(only extract and replicat) from oracle to teradata.
I don't know if it is possible to replicate two databases on the same host??
If yes, would you please tell me what to write to the extract file on the source(oracle) site.
"rmthost db2, mgrport 7809" here in the extract params file, rmthost will be the same as my sourcehost??
For source and target, manager ports will be the same?
extract group
extract ext1
connection to database
userid ggate, password qwerty
hostname and port for trail
rmthost db2, mgrport 7809
path and name for trail
rmttrail /u01/app/oracle/product/gg/dirdat/lt
--DDL support
ddl include mapped objname sender.*;
--DML
table sender.* 
You can do two on the same host. Use a separate GoldenGate installation for each RDBMS, and use different Manager ports. 
Hello,
Just would like to add to Steve's comment. You will indeed need two managers.
However, you do not need to specify rmthost and stuff like that. Chekc out the example below
For your extract process
GGSCI> DBLOGIN USERID GGATEUSER#MYORACLEDB, PASSWORD ggatehcc
GGSCI> ADD CHECKPOINTTABLE GGATEUSER.CHKPTAB
GGSCI> ADD TRANDATA SENDER.*
GGSCI> ADD EXTRACT EXT1 , TRANLOG, BEGIN NOW
GGSCI> ADD EXTTRAIL /some_shared_directory/lt, EXTRACT EXT1, MEGABYTES 1000
GGSCI> EDIT PARAMS EXT1
EXTRACT EXT1
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8MSWIN1252")
USERID GGATEUSER#MYORACLEDB, PASSWORD
EXTTRAIL /some_shared_directory/lt
WILDCARDRESOLVE DYNAMIC
DDL &
INCLUDE MAPPED OBJNAME SENDER.*
DDLOPTIONS ADDTRANDATA RETRYOP RETRYDELAY 5 MAXRETRIES 5 REPORT
TRANLOGOPTIONS PURGEORPHANEDTRANSACTIONS
STATOPTIONS RESETREPORTSTATS
REPORT AT 00:01
REPORTROLLOVER AT 00:01
REPORTCOUNT EVERY 60 SECONDS, RATE
SEQUENCE SENDER.*;
TABLE SENDER.*;-- now for your teradata replication process
GGSCI> DBLOGIN USERID GGATEUSER, PASSWORD ggatehcc, TARGETDB MYTERADATADB
GGSCI> ADD REPLICAT REP1, EXTTRAIL /some_shared_directory/lt, CHECKPOINTTABLE GGATEUSER.CHKPTAB
GGSCI> EDIT PARAMS REP1
EXTRACT REP1
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8MSWIN1252")
-- From GG Reference Guide : On a target Teradata system, also use the TARGETDB parameter to specify the target ODBC data source.
USERID GGATEUSER, PASSWORD my passoword, TARGETDB MYTERADATADB
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/rep1.dsc, purge
STATOPTIONS RESETREPORTSTATS
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 5
REPORT AT 00:01
REPORTROLLOVER AT 00:01
REPORTCOUNT EVERY 60 SECONDS, RATE
DDLOPTIONS REPORT
MAP SENDER.*, TARGET SENDER.*;Hope this helps out.
Jan S.
Edited by: jstem1177 on Mar 7, 2012 11:00 AM

Categories

Resources