Setting up a dedicated application server for golden gate - GoldenGate

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

Related

Replicating on the same server

Hello,
What would I need to do to replicate a table from a source database to a target database on the same server. Here are my parameter files
extract load1
userid ggs_owner, password ggs_owner
rmthost <servername>.ca, mgrport 7576
rmttask replicat, group load2
table gsdba.mytesttable;
replicat load2
userid ggs_owner, password ggs_owner
assumetargetdefs
map gsdba.mytesttable, target gsdba.mytesttable;
port 7576
userid ggs_owner, password ggs_owner
purgeoldextracts /t01/software/gg/dirdat
With this configuration the data is reloaded in the source table :-(
Thank you, 
You should have two GoldenGate installations on source with two different ports.
Your configuration should be:
-------------SOURCE DB GG-------------------
GGSCI> edit params load1
extract load1
userid ggs_owner, password ggs_owner
rmthost <servername>.ca, mgrport 7576
rmttask replicat, group load2
table gsdba.mytesttable;
GGSCI> edit params mgr
port 7575
userid ggs_owner, password ggs_owner
purgeoldextracts /t01/software/gg/dirdat
-------------DESTINATION DB GG-------------------
GGSCI> edit params load2
replicat load2
userid ggs_owner, password ggs_owner
assumetargetdefs
map gsdba.mytesttable, target gsdba.mytesttable;
GGSCI> edit params mgr
port 7576
userid ggs_owner, password ggs_owner
purgeoldextracts /t01/software/gg/dirdat
Cheers 
Hi.
You guys are close but please allow me to clarify.
First, rmttask is used only for initial loads and the manger does not login to the database so you can leave both of those lines out unless you're really doing an initial load. However, unless you're going across database vendors (SQL Server to Oracle, for example) then you should use the native tools (BCP or exp/imp). Second, if you're talking about replication and not initial loads, since you're keeping everything local you only need extTrail and not rmtHost/rmtTrail. Lastly, the connection for your replicat is the same as the extract so both are connecting to the same system, and this is the key problem you're having.
Each single installation of OGG can can have many extracts and replicats which could all be talking to different databases. By default we'll pick up the environment settings but you can override that with SETENV in your parameter files. For example, before the login info put something like:
SETENV (ORACLE_HOME="/app/oracle/base/product/10.2.0/db_1")
SETENV (ORACLE_SID="sourceSID")
Good luck,
-joe

OGG PROCESS

Hi All,
This is my manager process
PORT 7808
DYNAMICPORTLIST 7813-7824
PURGEOLDEXTRACTS ‘D:\OGG\dirdat\*’, USECHECKPOINTS
USERID ogg_target#raja, PASSWORD oggtarget
This is my extract process
EXTRACT extuat
EXTTRAIL ‘D:\OGG\dirdat\rr’
USERID ogg_target#raja, PASSWORD oggtarget
TABLE scott.*;
this is my pump process
extract pmpuat
–RMTHOST MGRPORT 7809, COMPRESS
RMTTRAIL ‘D:\OGG\dirdat\rr’
USERID ogg_target#raja, PASSWORD oggtarget
–PASSTHRU
TABLE scott.*;
when i am trying to run extract process it will abending.
when i am trying to check report file it will throwugh error report file does not exist.
Can you please help me above issues.
Thanks
Raj 
Hi,
1. Remote host name not given for RMTHOST parameter,
2. Trail file assiganation is not correctly assigned to gg processes
3. Remove the single quote marks from all the path specifications,
4. Check in ggserr.log file in your GG home directory you can find the error message,
5. Also check in gg home directory there is a folder called dirrpt.
OR
use the below setup and try :
In Source
mgr prm
PORT 7809
DYNAMICPORTLIST 7813-7824
USERID ogg_target#raja, PASSWORD oggtarget
PURGEOLDEXTRACTS D:\OGG\dirdat\* , USECHECKPOINTS
ADD EXTRACT extuat1 , TRANLOG , BEGIN NOW
ADD EXTTRAIL D:\OGG\dirdat\ll, EXTRACT extuat1
ADD EXTRACT pmpuat1, EXTTRAILSOURCE D:\OGG\dirdat\ll
ADD RMTTRAIL D:\OGG\dirdat\rr EXTRACT pmpuat1
GGSCI > edit params extuat1
extract prm
EXTRACT extuat1
USERID ogg_target#raja, PASSWORD oggtarget
EXTTRAIL D:\OGG\dirdat\ll
TABLE scott.*;
GGSCI > ADD EXTRACT extuat1 , TRANLOG , BEGIN NOW
GGSCI > ADD EXTTRAIL D:\OGG\dirdat\ll, EXTRACT extuat1
GGSCI > edit params pmpuat1
Pump Prm
extract pmpuat1
USERID ogg_target#raja, PASSWORD oggtarget
RMTHOST < target server hostname> , MGRPORT 7809, COMPRESS
RMTTRAIL D:\OGG\dirdat\rr
PASSTHRU
TABLE scott.*;
GGSCI > ADD EXTRACT pmpuat1, EXTTRAILSOURCE D:\OGG\dirdat\ll
GGSCI > ADD RMTTRAIL D:\OGG\dirdat\rr EXTRACT pmpuat1 ---- this trail file (rr) path should be same from target server.
In Target
GGSCI > edit params repuat1
REPLICAT REPUAT1
USERID <username>, PASSWORD <pwd>
assumetargetdefs
MAP scott.*, TARGET scott.*;
GGSCI > ADD REPLICAT repuat1 , EXTTRAIL D:\GG\dirdat\rr , checkpointtable <checkpoint tab name>
then start the extract, pump and replicat process....
HTH
Annamalai 
Although creativity is admired in many areas, GoldenGate is not one such area. Follow the rules or it won't work, it's that simple.
You can also go through the learning library tutorial(s). For example, as pointed out in the other post, do you see quotation marks around any paths? No. So why did you include them?
http://apex.oracle.com/pls/apex/f?p=44785:2:0:FORCE_QUERY::2,CIR,RIR:P2_TAGS:Goldengate 
Hi All,
i working on windows operating system.
10g database.
in D drive i am running source
in E drive i am running target.
i dont' kow what is the value for RMTHOST < target server hostname> , MGRPORT 7809, 
What part in the tutorial was not clear? 
Hi,
As suggested by Steven once again go through the learning tutorials, you can easy to understand what is the use of RMTHOST parameter and other parameters,
In your case the RMTHOST is your same windown machine IP address/hostname. 
RMTHOST will be your system name or machine name.
If you are trying to configure source and target on the same host (your machine) go through this article by Gavin Soorma and try accordingly..
http://gavinsoorma.com/2011/08/goldengate-replication-with-source-and-target-on-the-same-physical-host/

Oracle goldengate manager process not starting

Hi, All
I am not able to start the GG manager in source node.
Below is the parameter file for manager, rep1 and global
manager
======
PORT 7809
USERID ggt_owner, PASSWORD ggt_owner
rep1
=======
userid ggt_owner, password ggt_owner
discardfile /u001/app/oracle/product/GG/discard/rep1_discard.txt, append, megabytes 10
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
MAP DANISH.*,TARGET DANISH.*;
global
=====
GGSCHEMA ggt_owner
CHECKPOINTTABLE ggt_owner.Checkpoint
NOTE: All the process is running fine in TARGET side
I tried the following thigs.
1. Changing the manager port to 7810 as i am using port in target is (7809) 
I reconfigure all the things and its working fine.....

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?

Unable to do Repliaction?No active ext Maps

hi,
All the process are running fine.but no synch. not doing replication.
when i check the stats * then it throws the follows message.
GGSCI (serv1) 62> stats *
Sending STATS request to EXTRACT EMASTR ...
No active extraction maps.
Sending STATS request to EXTRACT PMASTR ...
No active extraction maps.
Regards,
AMSII 
Parameter files? 
Source
----Process Manager
PORT 7809
PURGEOLDEXTRACTS ./dirdat/sa*, USECHECKPOINTS, MINKEEPHOURS 2
--Extract Process
extract emastr
userid orclgg, password Ogg1234
exttrail ./dirdat/em
DBOPTIONS ALLOWUNUSEDCOLUMN
table crisp.test_ogg;
--Data Pump Process param
extract pmastr
rmthost 172.100.11.48, mgrport 7809
rmttrail ./dirdat/pm
passthru
table crisp.test_ogg;
Target
--Replicat
replicat rmastr
userid orclgg, password Ogg1234
handlecollisions
assumetargetdefs
allownoopupdates
map crisp.test_ogg, target crisp.test_ogg;
Thanks 
You've added extract and replicat, started ER* after changes were made to the parameter files, configured the database, created the orclgg user with appropriate permissions? And you have a working example to compare with, the one from the tutorial?
http://apex.oracle.com/pls/apex/f?p=44785:24:8956339493459::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5340,2 
Problem resolved by myself. 
Please don't share what the problem/resolution was, and certainly, don't ever award points to the numerous people who help you here.

Categories

Resources