extract ext1 can't start - GoldenGate

help me this list of ext1.prm
extract ext1
userid ggs_owner, password ggs_owner
rmthost orcl3, mgrport 7809
rmttrail D:\oracle\product\10.2.0\db_1\BIN\dirdat\lt
ddl include mapped objname pengirim.*;
table pengirim.*;
this is the word show when i start extract ext1
Sending START Request to MANAGER .......
EXTRACT EXT1 starting
but when i type info all
EXTRACT STOP
give me solution about this 

hi
better to get and paste the error message wich you are getting in ggserr.log file 

Actually, I think it we need info from your report file. But one thing I immediately notice is that you have an extract semi-colon: So this:
ddl include mapped objname pengirim.*;
Should be this:
ddl include mapped objname pengirim.*
Regards,
-joe

Related

Golden Gate DDL Replication

Hi Can anyone tell me how to do DDL replication
I am using these params but its not working
EXTRACT ext04
USERID ggs, PASSWORD ggs
RMTHOST localhost, MGRPORT 7809
RMTTRAIL /u01/oracle/goldengate/dirdat/dd, purge
DDL INCLUDE MAPPED
TABLE SCOTT.*;
REPLICAT rep04
ASSUMETARGETDEFS
USERID gg, PASSWORD welcome
DISCARDFILE ./dirrpt/rep3.txt, purge
--RESTARTCOLLISIONS
HANDLECOLLISIONS
APPLYNOOPUPDATES
DDL
MAP SCOTT.*, TARGET SCOTT.*; 
Hi 786923,
At a first glance you are missing "*" in the replicats MAP statement. It should be:
MAP SCOTT.\*, TARGET SCOTT.*;
You could also change "DDL" into "DDL include all" to make sure all DDL operations which are in the trail are applied to the target db by the replicat.
P.S. Have you created database objects which are required for GoldenGate to replicate DDL? 
Thanks Dominik.
Actually that was a typo mistake while pasting the syntax here.
I specified the '*' and also created the database objects which are required for GoldenGate on both source and target. Will this be a mistake?
Shall I create them only on source itself?
I also tried using "DDL include all" but couldn't replicat DDL. 
GoldenGate DDL objects are only required on the source database, but you do not need to drop them from the target, but I would recommend executing ddl_disable.sql script (should be located in GoldenGate installation directory) on the target.
I would check if GG DDL objects are properly installed on the source by executing following scripts (also from GG installation directory):
-marker_status.sql
It should display:
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
- ddl_status.sql
It should display:
SUCCESSFUL installation of DDL Replication software components
If db objects appears to be ok, you can add DDLOPTIONS REPORT parameter to both extract and replicat parameter files. It will cause detailed messages to be written to ggserr.log file so you could see if extract is "catching" any DDL operations. 
Hi Dominik
I have done what you said. It worked.
Thanks a lot... 
Hi:
If you ever come across this reply then please let me have the EXTRACT and REPLICAT param files and if possible a little about the process. If they are available in any bolg of yours let me have the link. I am learning GG.
Thanks Caesar 
Hi caesar,
Here are the param files.
Manager:
PORT 7840
USERID gg_target, PASSWORD welcome
PURGEOLDEXTRACTS /orahome/oracle/goldengate/dirdat/*
add trandata scott.*
add extract ext1, tranlog, begin now
add rmttrail ./dirdat/dd, extract ext1
EXTRACT ext04
USERID ggs, PASSWORD ggs_source
RMTHOST localhost, MGRPORT 7840
RMTTRAIL ./dirdat/dd, purge
TABLE scott.*;
dblogin ...
add checkpointtable gg11g.checkpoint
add replicat rep1, exttrail ./dirdat/dd, checkpointtable gg11g.checkpoint
REPLICAT rep04
ASSUMETARGETDEFS
USERID gg_target, PASSWORD welcome
DISCARDFILE ./dirrpt/rep3.txt, purge
--RESTARTCOLLISIONS
HANDLECOLLISIONS
APPLYNOOPUPDATES
MAP scott.*, TARGET scott.*;
Here are the websites
http://gavinsoorma.com/oracle-goldengate-veridata-web/
http://www.oracle11ggotchas.com/articles/CreatingaGoldenGateExceptionHandlertotrapandlogOracleErrors.htm
http://itkunn.wordpress.com/2010/01/29/setting-up-oracle-golden-gate-between-2-oracle-instances-asynchronous/
Thanks.

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 ...

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/

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.

dml only replic one way in a bi direct setup

Hi Everyone, I am trying to set up a demo for two way replication using golden gate.  I hope someone out there can see where I am going wrong.  What has happened was that I was able to get dml replication working both ways and then separately  I added ddl replication that worked both ways.  Now when I tried my first dml replication going from target to source it works but from source to target it now does not want to replicate even though when it was set up alone it worked ok. Would some please look at these param files over to see if there is something blocking something or too that affect?  It would be much appreciated.  Right now I am at a loss. Thanks for your help in advance. al SOURCE SERVER: Lance. PARAMETER FILES: Mgr Port 7809 Ext1 EXTRACT ext1 USERID ggs_owner, PASSWORD ggs_owner EXTTRAIL /opt/u01/app/product/11.2.0/dbhome_1/ggs/dirdat/lt DDL INCLUDE ALL TABLE scott.*; Dpump EXTRACT dpump USERID ggs_owner, PASSWORD ggs_owner RMHOST 192.168.1.4,    MGRPORT      7809 RMTTRAIL /opt/u01/oracle/ggs/dirdat/rt TABLE scott.*; REP2 USERID  ggs_owner,  PASSWORD ggs_owner ASSUMETARGETDEFS DDL  INCLUDE ALL DDLERROR DEFAULT IGNORE MAP scott.*,      TARGET  scott.*; TARGET SERVER:  Pearl. Mgr: PORT 7809 Rep1 USERID ggs_owner, PASSWORD ggs_owner ASSUMETARGETDEFS DDLERROR DEFAULT IGNORE MAP scott.*,      TARGET  scott.*; EXT2 EXTRACT ext2 USERID ggs_owner,      PASSWORD      ggs_owner EXTTRAIL /opt/u01/oracle/ggs/dirdat/pl DDL INCLUDE  ALL TABLE scott.*; DP2 EXTRACT  dp2 USERID ggs_owner,    PASSWORD    ggs_owner RMTHOST 192.168.1.3, MGRPORT    7809 RMTTRAIL /opt/u01/app/product/11.2.0/dbhome_1/ggs/dirdat/pr DDL INCLUDE  ALL TABLE scott.*;
I found the error.  In the ext1 and 2 parameters the line DDL INCLUDE ALL   should readDDL INCLUDE  MAPPED. Now the ddl works in both directions. al

Categories

Resources