Datapump error - GoldenGate

Hi,
Can any one assist me on this,
While trying to get the STATS EXTRACT pump , or trying to stop the datapump im getting the below error message
Sending STOP request to EXTRACT PUMP ...
ERROR: sending message to EXTRACT US_PUMP (Timeout waiting for message)
How to avoid this is there any parameter missing?
Thanks in Advance
Edited by: ATP on Sep 17, 2010 6:23 PM 

Hi ATP,
Sometimes the network ports may have some problems processing your request or they may be slow and you get the following error message.
ERROR: sending message to EXTRACT US_PUMP (Timeout waiting for message)
You may try to do a force stop by
ggsci> stop extract ext01 stop !
For stats extract pump you may wait for sometime and then give the command again to get your result.
Thanks. 

Hi thanks a lot,one more issue
I have tried to setup datapump in two environments,everything is fine, extract and pump replicat running status only,
i inserted 1000 rows in source but its not reflecting in target ...
Please find below my setting ..................on source and target
but in target side
Sending STATS request to REPLICAT
No active replication maps.
MGR on source
PORT 7809
on source
ADD EXTRACT pnbtest, TRANLOG, BEGIN NOW
ADD EXTTRAIL ./dirdat/tt, EXTRACT pnbtest
ADD EXTRACT tpump, EXTTRAILSOURCE ./dirdat/tt
EXTRACT pnbtest
USERID ggate, password changeme
TRANLOGOPTIONS ASMUSER sys#ASM, ASMPASSWORD dr3amw0rk5
EXTTRAIL ./dirdat/tt
TABLE ggate.my_items;
EXTRACT tpump
USERID ggate, password changeme
RMTHOST 10.6.34.36, MGRPORT 7909
RMTTRAIL ./dirdat/pt
TABLE ggate.my_items;
On target
Mgr.prm
PORT 7909
dblogin userid iii, password password
ADD CHECKPOINTTABLE
ADD REPLICAT ogg, EXTTRAIL ./dirdat/pt, checkpointtable test_check
REPLICAT ogg
USERID ggate, password changeme
ASSUMETARGETDEFS
MAP ggate.my_items, TARGET ggate.my_items;
also im geeting below warning
2010-09-17 10:57:33 GGS WARNING 150 Oracle GoldenGate Capture for Oracle,
tpump.prm: TCP/IP error 145 (Connection timed out).
2010-09-17 11:01:28 GGS WARNING 150 Oracle GoldenGate Capture for Oracle,
tpump.prm: TCP/IP error 145 (Connection timed out).
2010-09-17 11:05:09 GGS INFO 399 Oracle GoldenGate Command Interpreter
for Oracle: GGSCI command (ggate): edit params mgr.
2010-09-17 11:05:22 GGS WARNING 150 Oracle GoldenGate Capture for Oracle,
tpump.prm: TCP/IP error 145 (Connection timed out).
2010-09-17 11:09:17 GGS WARNING 150 Oracle GoldenGate Capture for Oracle,
tpump.prm: TCP/IP error 145 (Connection timed out).
can you please help to resolve this
Thanks in advance
Edited by: ATP on Sep 17, 2010 8:46 PM
Edited by: ATP on Sep 17, 2010 8:49 PM 

Hi ATP,
Did you check if the source extract process is extracting by
send extract ext01 stats
One more thing is that do you have the source and target goldengate files in the same folder?
Because you specified
in extract
EXTTRAIL ./dirdat/tt
RMTTRAIL ./dirdat/pt
in replicat
ADD REPLICAT ogg, EXTTRAIL ./dirdat/pt, checkpointtable test_check
If they are in the same goldengate installation directory, it is fine.
If they are in a different location then you need to specify the replicat as
ADD REPLICAT ogg, EXTTRAIL /destn_gg/dirdat/pt, checkpointtable test_check
Check this if it works for you.
tpump.prm: TCP/IP error 145 (Connection timed out).
Did you check to see if this is a valid port number?
Thanks.
Edited by: 786923 on Sep 17, 2010 8:37 AM 

Hi
Goldengate installed on target as per the source system,
send extract stats,
plz see below the extract stats
Start of Statistics at 2010-09-17 11:35:07.
Output to ./dirdat/tt:
Extracting from GGATE.MY_ITEMS to GGATE.MY_ITEMS:
*** Total statistics since 2010-09-17 11:31:07 ***
Total inserts 1000.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1000.00
It shows 1000 rows inserted successfully, but pump not fetching.....
its anything related to port.... i couldnt find anything
Edited by: ATP on Sep 17, 2010 9:12 PM 

Hi ATP,
You forgot to specify PASSTHRU parameter in the pump extract params
Here is the syntax
EXTRACT tpump
USERID ggate, password changeme
RMTHOST 10.6.34.36, MGRPORT 7909
RMTTRAIL ./dirdat/pt
PASSTHRU
TABLE ggate.my_items;
Hope this should solve your problem.
Thanks. 

Hi
Passthru parameter just used to increase the performance right? its not mandatory one ?
reg Passthru
Consider using this parameter if there is no filtering, conversion or mapping required and you’re using DATAPUMP.
In pass-through mode, the Extract process does not look up table definitions, either from the database or from a data definitions file. Pass-through mode increases the throughput of the data pump, because all of the functionality that looks up object definitions is bypassed.
This saves database fetches to improve performance. 

hi any update on this plz 

Try changing the MGR param in the replicat side to 7810 and try if changing the port number makes the replicat to work good. As well change the pump parameter MGRPORT to 7810 and give it a try.
Hey did you add rmttrail for the extract pump parameter
GGSCI> ADD RMTTRAIL <ggs_install_path>/dirdat/rt, EXTRACT EXTPUMP
Edited by: 786923 on Sep 17, 2010 11:04 AM 

.
Edited by: ATP on Sep 19, 2010 6:54 PM

Related

WARNING OGG-01223  TCP/IP error 111 (Connection refused).

Dear All,
On my 11gR2 database after configuring golden gate when i start my extract procedure, it gets ABENDED after couple of minutes.
The reason I m getting is: WARNING OGG-01223  TCP/IP error 111 (Connection refused)
10.168.20.244 is my target where i want data to be replicated from source 10.168.20.182
I can ping 10.168.20.244, I have set ORACLE_HOME and ORACLE_SID as i read in one forums. But I am not getting rid of this error. Tried a lot but all in vain.
Kindly help
Here is the report for more information.
GGSCI (orabackup.etisalcom.com) 176> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED EXT1 00:00:00 01:28:44
GGSCI (orabackup.etisalcom.com) 177> view report ext1
Operating System Version:
Linux
Version #1 SMP Tue Mar 16 21:52:39 EDT 2010, Release 2.6.18-194.el5
Node: orabackup.etisalcom.com
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 11689
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
extract ext1
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1/")
Set environment variable (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/)
SETENV (ORACLE_SID = "GGBKP")
Set environment variable (ORACLE_SID=GGBKP)
userid ggs_owner, password ******
rmthost 10.168.20.244, mgrport 7810
rmttrail /u01/app/oracle/oradata/GG/dirdat/lt
DDL INCLUDE ALL
table RADIUS_DSL.*;
table RADIUS_DSL.RADACCT;
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u01/app/oracle/oradata/GG
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 8G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 16G
CACHESIZEMAX (strict force to disk): 13.99G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
2012-01-25 11:59:15 INFO OGG-01513 Positioning to Sequence 3173, RBA 19020800.
2012-01-25 11:59:15 INFO OGG-01516 Positioned to Sequence 3173, RBA 19020800, Jan 25, 2012 10:32:29 AM.
2012-01-25 11:59:15 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 11:59:25 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 11:59:35 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 11:59:45 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 11:59:55 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 12:00:05 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 12:00:15 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 12:00:25 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 12:00:35 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 12:00:45 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
2012-01-25 12:00:55 WARNING OGG-01223 TCP/IP error 111 (Connection refused).
Source Context :
SourceModule : [er.extrout]
SourceID : [scratch/pradshar/view_storage/pradshar_bugdbrh40_12927937/oggcore/OpenSys/src/app/er/extrout.c]
SourceFunction : [tcp_send_data]
SourceLine : [1261]
ThreadBacktrace : [9] elements
: [u01/app/oracle/oradata/GG/extract(CMessageContext::AddThreadContext()+0x26) [0x6705e6]]
: [u01/app/oracle/oradata/GG/extract(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x667082]]
: [/u01/app/oracle/oradata/GG/extract(_MSG_ERR_TCP_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x92) [0x64
1182]]
: [u01/app/oracle/oradata/GG/extract(tcp_send_data(extract_def*)+0x1e6) [0x8806d6]]
: [u01/app/oracle/oradata/GG/extract(flush_tcp(extract_def*, int)+0x155) [0x8811dd]]
: [u01/app/oracle/oradata/GG/extract(RECOVERY_initialize()+0xb36) [0x5116b6]]
: [u01/app/oracle/oradata/GG/extract(main+0x7dc) [0x52787c]]
: [lib64/libc.so.6(__libc_start_main+0xf4) [0x3c9ce1d994]]
: [u01/app/oracle/oradata/GG/extract(__gxx_personality_v0+0x1ea) [0x4f3aba]]
2012-01-25 12:01:05 ERROR OGG-01224 TCP/IP error 111 (Connection refused); retries exceeded.
2012-01-25 12:01:05 ERROR OGG-01668 PROCESS ABENDING.
Thanks, Imran 
Please post output from: VIEW PARAM MGR
Also stats the O/S you are using.
Edited by: drbiloukos on 25 Ιαν 2012 12:02 μμ 
Thanks drbiloukos,
My OS is Linux 64-Bit.
This problem was somehow resolved when I changed port to 1521 :) dont know if this was the proper solution of this problem.
But now I am getting another error and here it is:
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
*2012-01-25 13:28:27 INFO OGG-01513 Positioning to Sequence 3173, RBA 19020800.*
*2012-01-25 13:28:28 INFO OGG-01516 Positioned to Sequence 3173, RBA 19020800, Jan 25, 2012 10:32:29 AM.*
Now please help me to get resolve this error.
Regards,
Imran 
Kindly help this is my configuration:
On Source:
edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD xxxxxx
PURGEOLDEXTRACTS /u01/app/oracle/oradata/GG/dirdat/ex, USECHECKPOINTS
edit params ext1
extract ext1
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1/")
SETENV (ORACLE_SID = "GGBKP")
userid ggs_owner, password xxxxxx
rmthost 10.168.20.244, mgrport 1521
rmttrail /u01/app/oracle/oradata/GG/dirdat/lt
DDL INCLUDE ALL
table RADIUS_DSL.*;
table RADIUS_DSL.RADACCT;
info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED EXT1 00:00:00 06:12:28
On Target Database
edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ******
PURGEOLDEXTRACTS /u01/app/oracle/oradata/GG/dirdat/ex, USECHECKPOINTS
edit params rep1
REPLICAT rep1
ASSUMETARGETDEFS
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "RACBKP")
userid ggs_owner, password ******
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
MAP RADIUS_DSL.*, TARGET RADIUS_DSL.*;
MAP RADIUS_DSL.RADACCT, TARGET RADIUS_DSL.RADACCT;
info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:04
This is the error:
view report ext1
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
*2012-01-25 15:31:32 INFO OGG-01513 Positioning to Sequence 3173, RBA 19020800.*
*2012-01-25 15:31:32 INFO OGG-01516 Positioned to Sequence 3173, RBA 19020800, Jan 25, 2012 10:32:29 AM.*
Regards,
Imran 
First, add
DYNAMICPORTLIST 9001-9010 (port listed is juat an example)
DYNAMICPORTREASSIGNDELAY 5
Also, from extract ext1
rmthost 10.168.20.244, mgrport 1521
Your mgrport is not 1521, it's PORT 7809 according to your configuration.
http://mdinh.wordpress.com/
Edited by: dinhmt on 25-Jan-2012 20:39 
Thanks for the help.
I have changed the port, and now the port thing is not giving any error.
I think after adding the parameters I have moved a step ahead.
Now the problem is:
2012-01-26 09:44:09 INFO OGG-01513 Positioning to Sequence 3173, RBA 19020800.
Source Context :
SourceModule : [er.main]
SourceID : [scratch/pradshar/view_storage/pradshar_bugdbrh40_12927937/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [extract_start_point]
SourceLine : [13026]
ThreadBacktrace : [6] elements
: [u01/app/oracle/oradata/GG/extract(CMessageContext::AddThreadContext()+0x26) [0x6705e6]]
: [u01/app/oracle/oradata/GG/extract(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x667082]]
: [/u01/app/oracle/oradata/GG/extract(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x92) [0x612
0b2]]
: [u01/app/oracle/oradata/GG/extract(main+0x125b) [0x5282fb]]
: [lib64/libc.so.6(__libc_start_main+0xf4) [0x3c9ce1d994]]
: [u01/app/oracle/oradata/GG/extract(__gxx_personality_v0+0x1ea) [0x4f3aba]]
2012-01-26 09:45:28 ERROR OGG-00446 Could not find archived log for sequence 3173 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE
sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'NO>, error retrie
ving redo file name for sequence 3173, archived = 1, use_alternate = 0Not able to establish initial position for sequence 3173, rba 19020800.
2012-01-26 09:45:28 ERROR OGG-01668 PROCESS ABENDING.
I am looking how to resolve this issue now. Your help will be highly appreciated.
I tried to expdp from source and impdp on target just to refresh data at target and then alter extract ext1 begin now but no luck, error remains the same :(
But later on I tried adding these lines in extract ext1
TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY /u01/app/oracle/archive
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT %t_%s_%r.dbf
now the extract process is running continuously and so is the replicat. There are no errors but still no replication :(
How to check what is the problem, there is nothing in view report.
And these are the last lines from ggserr.log
From Source
2012-01-26 10:20:03 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2012-01-26 10:20:08 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, ext1.prm: Socket buffer size set to 27985 (flush size 27985).2012-01-26 10:20:08 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file /u01/app/oracle/oradata/GG/dirdat/lt000000, at RBA 0 (file not opened).
2012-01-26 10:20:08 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /u01/app/oracle/oradata/GG/dirdat/lt is using format RELEASE 10.4/11.1.2012-01-26 10:20:08 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed Sequence 3241, RBA 14606864, SCN 0.1163015311, Jan 26, 2012 10:09:26 AM.2012-01-26 10:20:23 WARNING OGG-00869 Oracle GoldenGate Capture for Oracle, ext1.prm: No unique key is defined for table RADTRAFFICMONITOR. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.2012-01-26 10:27:42 WARNING OGG-00869 Oracle GoldenGate Capture for Oracle, ext1.prm: No unique key is defined for table TEST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-01-26 10:46:44 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2012-01-26 10:49:48 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
From Target
2012-01-26 10:18:54 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 10.168.20.182 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2012-01-26 10:18:54 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7841).
2012-01-26 10:18:54 INFO OGG-01677 Oracle GoldenGate Collector: Waiting for connection (started dynamically).
2012-01-26 10:18:54 INFO OGG-01228 Oracle GoldenGate Collector: Timeout in 300 seconds.
2012-01-26 10:18:59 INFO OGG-01229 Oracle GoldenGate Collector: Connected to 10.168.20.182:42419.
2012-01-26 10:18:59 INFO OGG-01669 Oracle GoldenGate Collector: Opening /u01/app/oracle/oradata/GG/dirdat/lt000000 (byte -1, current EOF 0).
Regards,
Imran
Edited by: misterimran on Jan 26, 2012 12:04 PM
Edited by: misterimran on Jan 26, 2012 12:09 PM
Edited by: misterimran on Jan 26, 2012 12:45 PM
Edited by: misterimran on Jan 26, 2012 1:07 PM 
Based on all the other errors you've had so far, I would venture to say that other elements are incorrect as well.
Have you tried using the tutorial at Oracle Learning Library?
Have you read the admin guide? Where did using the listener port (1521) come from?
Firewall - have you checked ports on the target?
Extract and replicat - why would you wildcard all tables of a schema, and then turn around and list another table in that schema, given that it is already covered by the wildcard?
What about other setup steps? Did you set supplemental logging? Did you add trandata?
What is the point of the purge old extracts that have a trail ID of ex, when your extract is producing trails with an ID of lt?
Your rmttrail setting of /u01/app/oracle/oradata/GG/dirdat/lt - on the target, did you add that trail to replicat?
Go through the tutorial, get a good working setup, and emulate the steps for your system instead of trying to wing it. 
Thanks for your reply Steven.
Here are the answers of your questions.
I have read a quite good document and following it.
I had to do some hit and try's because as per documents few things were not working properly.
Port and the target thing is working fine now... port is 7809 and working
just tried one table, I have removed that line now. and using only radius_dsl.*
supplement logging and trandata is added.
alter database add supplemental log data;
add trandata RADIUS_DSL.*
Now the extract and replicat are showing no errors. There is just no replication. This is what i am trying to investigate now. 
What command did you use to tie the lt trails sent by the source to the replicat being run on the target? Since you have a reference to "ex" trail IDs in the manager parameter file, makes me question what replicat is looking for. Do you see the trails being shipped to the target?
What do detailed reports for extract and replicat show? (You're looking for the output showing the current trail being used by each). If you see that extract is on seqno 26 and replicat is on seqno 0, it's a good bet replicat is looking for the wrong trail ID. 
Dear Steve,
This is the the confusing thing for me.
From your reply, got few things and tried to correct them
On Source I did:
edit params mgr
DYNAMICPORTLIST 7000-9000
DYNAMICPORTREASSIGNDELAY 5
PORT 7809
USERID ggs_owner, PASSWORD warsaw
PURGEOLDEXTRACTS /u01/app/oracle/oradata/GG/dirdat/lt, USECHECKPOINTS
extract ext1
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1/")
SETENV (ORACLE_SID = "GGBKP")
userid ggs_owner, password warsaw
rmthost 10.168.20.244, mgrport 7809
rmttrail /u01/app/oracle/oradata/GG/dirdat/lt
TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY /u01/app/oracle/archive
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT %t_%s_%r.dbf
DDL INCLUDE ALL
table RADIUS_DSL.*;
I also did
ADD EXTTRAIL /u01/app/oracle/oradata/GG/dirdat/lt, EXTRACT ext1
on Target
edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD warsaw
PURGEOLDEXTRACTS /u01/app/oracle/oradata/GG/dirdat/lt, USECHECKPOINTS
edit params ./GLOBAL
GGSCHEMA ggs_owner
CHECKPOINTTABLE ggs_owner. Checkpoint
Also did
add checkpointtable ggs_owner.checkpoint
D*add replicat rep1, exttrail /u01/app/oracle/oradata/GG/dirdat/lt,checkpointtable ggs_owner.checkpoint*
edit params rep1
REPLICAT rep1
ASSUMETARGETDEFS
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "RACBKP")
userid ggs_owner, password warsaw
discardfile /u01/app/oracle/oradata/GG/discard/rep1_discard.txt, append, megabytes 10
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
MAP RADIUS_DSL.*, TARGET RADIUS_DSL.*;
Now I started the extract and replicat process again. The extract started without error, while replicat is giving some constarints
errors like this: and the process is stopped.
OCI Error ORA-00001: unique constraint (RADIUS_DSL.SYS_C0014601) violated
Now I will try resync the DBs. But after this I have to replicate a huge database that takes around 2 hours to export and 3 hours to import.
I doubt there will be constraints and sequence errors. How to properly perform this import and export. Is there any sppecial way?
After refreshing the schema, replication finally started :)
But how to deal multiple schema and huge DBs like 100GB, your advice will help to build a safe production environment.
Thanks for all your help.
Regards, Imran
Edited by: misterimran on Jan 26, 2012 5:00 PM 
This:
ERROR OGG-00446 Could not find archived log for sequence 3173 thread 1 under default destinations SQL <SELECT name FROM> v$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'NO>, error retrieving redo file name for sequence 3173, archived = 1, use_alternate = 0Not able to establish initial position for sequence 3173, rba 19020800.Means it couldn't find your archive log file. It probably got deleted or archived. So you either need to restore it or if this is a test system just skip it (you'll have a hole in replication) "alter extract <name> begin now". Don't ever do this on production unless you're 100% sure what you're doing.
When you set the alternative location it kicks in logic that says, "hey, the file may not be here immediately so I'm going to wait and not abend." The ALTARCHIVEDLOGDEST is typically used for when the system has archived the redo log file and the fastest way to get it back is to mount a remote file system or restore it to some readable location with adequate disc space which is not the archived log directory as indicated in the system tables.
You're probably capturing data but not applying it to the target. That's because this line:
MAP RADIUS_DSL., TARGET RADIUS_DSL.;
Needs to be like this:
MAP RADIUS_DSL.*, TARGET RADIUS_DSL.*;
You're missing your wildcards. This Oracle site has some great - and free - GoldenGate tutorials:
http://apex.oracle.com/pls/apex/f?p=44785:24:1279381555174319::::P24_CONTENT_ID,P24_PREV_PAGE:5153,24
Good luck,
-joe

Replicat doesn't start

Hi,
I can't start my replicat with the error below
any idea ?
Thanks for your help
2011-10-08 17:15:38 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep9.prm: REPLICAT REP9 started.
2011-10-08 17:15:38 ERROR OGG-00204 Oracle GoldenGate Delivery for Oracle, rep9.prm: Missing TARGET specification.
2011-10-08 17:15:38 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep9.prm: PROCESS ABENDING.
my replicat parameters
replicat rep9
setenv (oracle_sid=T4F)
userid ogg,password ogg_pwd
handlecollisions
assumetargetdefs
discardfile /tst/data/ogg/discards/resp.dsc,purge
reperror default discard
table SIEBEL.S_*;
table siebel.timelag;
table siebel.jmt_pwd;
tableexclude siebel.s_dock_txn*;
tableexclude siebel.s_dck_txn*; 
Replicat maps the source table to a target table.
The parameter is like:
MAP SRC.TNAME, TARGET TGT.TNAME;
MAP HR.DEPT, TARGET HR.DEPARTMENTS;
The TABLEEXCLUDE parameter is for extract only.
Your parameter file would more like this:
replicat rep9setenv (oracle_sid=T4F)
userid ogg, password ogg_pwd
handlecollisions
assumetargetdefs
discardfile /tst/data/ogg/discards/resp.dsc, purge
reperror default discard
--just one * here, screwy Jive forum thing
MAP SIEBEL.S_**, TARGET SIEBEL.S_**;
MAP siebel.timelag, TARGET siebel.timelag;
MAP siebel.jmt_pwd, TARGET sieble.jmt_pwd;>
Your extract would have the tableexclude lines, but listed before tables:
extract exxxsetenv ...
userid ..., password ...
--other options
tableexclude siebel.s_dock_txn*;
tableexclude siebel.s_dck_txn*;
TABLE SIEBEL.S_*;
TABLE siebel.timelag;
TABLE sieble.jmt_pwd;>
Edited by: stevencallan on Mar 12, 2012 8:41 AM
Corrected syntax 
Shouldn't it be?:
MAP <tablename>, TARGET <tablename>
rather than
MAP <tablename>, TABLE <tablename> 
Hello,
Refer to the GG Reference Guide http://docs.oracle.com/cd/E22355_01/doc.11111/e21512.pdf to see what parameters can be included in which process Type, (MGR, EXTRACT, REPLICAT).
Here is also a good set of tutorials to go through : http://gavinsoorma.com/2010/02/17/oracle-goldengate-tutorial-5-configuring-online-change-synchronization/
Jan 
Oops, that should be TARGET. Thanks.

goldengate overwrite primary key on the target

why when i replicate data with same primary key to database target is not reject instead overwritten record.
note : application SAP running on the target and source
thanks,
Riyas
Edited by: 899639 on Dec 18, 2011 8:37 PM
Edited by: 899639 on Dec 18, 2011 8:43 PM 
Please give parameter file from both the side. 
Are you using HANDLECOLLISIONS?
From the Reference guide:
*How HANDLECOLLISIONS works*The following example explains how HANDLECOLLISIONS works:
When Replicat encounters a duplicate-record error, the record applied by the initial load is
overwritten by the change record. Overlaying the change is safer from an operational
standpoint than ignoring the duplicate-record error. 
--checkparams
EXTRACT EXTG1A
SETENV (ORACLE_HOME ="/oracle/GG1/102_64")
SETENV (ORACLE_SID = "GG1")
USERID gg, PASSWORD gg
EXTTRAIL ./dirdat/ta
GETINSERTS
DYNAMICRESOLUTION
GETAPPLOPS
IGNOREREPLICATES
TRACETABLE GG.GGS_TRACE
--DDL INCLUDE ALL
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA, REPORT
TABLE SAPR3.*;
--checkparams
replicat REPG2A
userid gg, password gg
assumetargetdefs
DDL INCLUDE ALL
ddloptions report
discardfile ./dirrpt/REPG2A.dsc, purge, MEGABYTES 100
REPERROR 1403 DISCARD
REPERROR (1, DISCARD)
MAP SAPR3.*, TARGET SAPR3.*; 
Dear stave,
No HANDLECOLLISIONS on my replicat..
Help me,
Riyas

Extract and Replicat Runnng, yet no Syncronization

Dear All,
I am trying replication between MySQL and Oracle.
Version of my MySQL is Server version: 5.5.19 MySQL Enterprise Server - Advanced Edition
Version of Oracle is : Oracle 11gR2
Both extract and replicat process on source and target respectively are RUNNING with no errors.
But there is no synchronization among the databases.
When i run send extract netfors, stats on source it says:
Sending STATS request to EXTRACT NETFORS ...
No active extraction maps.
Same is the case with replicate.
The trail files that are being transferred to target are just *1KB* in size
This is my Golden Gate Configuration:
-----
-----
-----
# User specific environment and startup programs
MYSQL_HOME=/usr/src/5.5.19/bin
export MYSQL_HOME
LD_LIBRARY_PATH=/root/sandboxes/GG
export LD_LIBRARY_PATH
PATH=$PATH:$HOME/bin:/root/sandboxes/GG
export PATH
unset USERNAME
#yum install mysql-connector-odbc
Edit my.cnf file
[client]
user = msandbox
password = ******
port = 6629
socket = /tmp/mysql.sock
[mysqld]
server-id=33
log-bin=mysql-bin
log-error=msandbox.err
binlog_format = row
max_binlog_size = 4096
socket =      /tmp/mysql.sock
vi /etc/odbc.ini
[netfors]
Driver = /usr/lib/libmyodbc3.so
Description = Connector/ODBC 3.51 Driver DSN
Server = 10.168.20.226
Port = 6629
User = "replication"
Password = "********"
Database = "netfors"
Option = 3
Socket = /tmp/mysql.sock
10. Configure change capture on source
GGSCI>ADD EXTRACT NETFORS, TRANLOG, BEGIN NOW
GGSCI>INFO EXTRACT NETFORS
GGSCI>EDIT PARAMS NETFORS
EXTRACT NETFORS
DBOPTIONS HOST 10.168.20.226, CONNECTIONPORT 6629
SOURCEDB netfors#10.168.20.226:6629, USERID "replication", PASSWORD "******"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/n2
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/msb_5_5_19/data/mysql-bin.index
TABLE netfors.edr;
11. Define golden gate trail
GGSCI>ADD RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/n2, EXTRACT NETFORS, MEGABYTES 5
GGSCI>INFO RMTTRAIL *
GGSCI>START EXTRACT NETFORS
GGSCI>INFO EXTRACT NETFORS
GGSCI>VIEW REPORT NETFORS
GGSCI>ALTER RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/n2, EXTRACT NETFORS, MEGABYTES 5
Configration on target (Oracle) server
1)
GGSCI>edit params ./GLOBAL
GGSCHEMA ggs_owner
CHECKPOINTTABLE ggs_owner.checkpoint
2) Add replicat
GGSCI>ADD REPLICAT NETFORS, EXTTRAIL /u01/app/oracle/oradata/GG/dirdat/n2, checkpointtable ggs_owner.checkpoint
3) edit params NETFORS
REPLICAT NETFORS
USERID ggs_owner, PASSWORD ******
HANDLECOLLISIONS
SOURCEDEFS /u01/app/oracle/oradata/GG/dirdef/mysql.def
DISCARDFILE /u01/app/oracle/oradata/GG/dirrpt/netfors.dsc, PURGE
MAP "netfors.edr",TARGET etislbilling.sdr_tblicprawedr;
GGSCI>START EXTRACT NETFORS
GGSCI>START REPLICAT NETFORS
Kindly help on this.
Regards, Imran 
The message "No active extraction maps" means that there is no "table" statement in your extract prm file matching the activity in the database. Check the prm file, note the case & quotes, make any necessary changes & restart extract. Compare to your defgen (source def's) file. Try from ggsci "dblogin" followed by "list tables sch.*" and verify that it is why you expect. (Note: on the target, it should be ./GLOBALS, I believe; rename & restart ggsci & replicat. But it is unrelated to the problem at hand.) 
Dear Mike,
Thank you for your reply. I have checked the case and quotes and also the spelling of the table, they are correct. list table command also shows the table I want to replicat.
Still, I am unable to find the actual problem. Both extract and replicat are running. No errors in report and log files.
The trail files shifted on the target are just 1.1 kb, I don't think they have data in them. Though I have set TRANLOGOPTIONS ALTLOGDEST to the log-bin parameter in my.cnf file.
Regards, Imran 
What does your extract parameter file show? (you posted the repicat, why not the extract?)
10. Configure change capture on source
GGSCI>ADD EXTRACT NETFORS, TRANLOG, BEGIN NOW 
It is there:
10. Configure change capture on source
GGSCI>ADD EXTRACT NETFORS, TRANLOG, BEGIN NOW
GGSCI>INFO EXTRACT NETFORS
GGSCI>EDIT PARAMS NETFORS
EXTRACT NETFORS
DBOPTIONS HOST 10.168.20.226, CONNECTIONPORT 6629
SOURCEDB netfors#10.168.20.226:6629, USERID "replication", PASSWORD "******"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/n2
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/msb_5_5_19/data/mysql-bin.index
TABLE netfors.edr;
11. Define golden gate trail
GGSCI>ADD RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/n2, EXTRACT NETFORS, MEGABYTES 5
GGSCI>INFO RMTTRAIL *
GGSCI>START EXTRACT NETFORS
GGSCI>INFO EXTRACT NETFORS
GGSCI>VIEW REPORT NETFORS
Thanks 
Few small suggestions:
1. Check that you're connecting to the right database:
GGSCI> dblogin sourcedb <dbname>#<hostname>:<portNo>, userid <userName>, password <password>
GGSCI> capture tabledef netfors.edr
2. Check if anything is in your trail file on the target (from OGG Home):
$ echo "count detail /u01/app/oracle/oradata/GG/dirdat/n2*"| $OGG_HOME/logdump
3. Be explicit. Is netfors.edr really lowercase? Then put it in "double quotes".
Good luck,
-joe 
Thanks Joe,
When i run:
GGSCI>dblogin sourcedb "", userid "", password ""
it returns
Successfully logged into database.
GGSCI (mysql-multi-node-replica.etisalcom.private) 52>
GGSCI (mysql-multi-node-replica.etisalcom.private) 52> capture tabledef netfors.edr
Table definitions for netfors.edr:
seqno NUMBER NOT NULL
createtime DATETIME
timeofdaybegin DATETIME NOT NULL
Trail files are being shifted to the target but they are very few and less than 1 KB, it means data is not being shifted.
I have checked the case, also have added double quotes but no difference.
Still the same :( both extract and replicat running but no synchronization.
Regards, Imran 
This is the view report of my extract:
GGSCI (mysql-multi-node-replica.etisalcom.private) 26> view report netfors
***********************************************************************
Oracle GoldenGate Capture for MySQL
Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700
Linux, x86, 32bit (optimized), MySQL Enterprise on Jul 29 2011 22:59:29
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-01-14 16:33:11
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Apr 2 14:58:35 EDT 2010, Release 2.6.18-194.el5
Node: mysql-multi-node-replica.etisalcom.private
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 21580
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
EXTRACT NETFORS
DBOPTIONS HOST 10.168.20.226, CONNECTIONPORT 6629
SOURCEDB "*********", USERID "*********", PASSWORD "*********"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/n2
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/msb_5_5_19/data/mysql-bin.index
TABLE "netfors"."edr";
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.89G
CACHESIZEMAX (strict force to disk): 2.66G
Database Version:
MySQL
Server Version: 5.5.19-enterprise-commercial-advanced-log
Client Version: 6.0.0
Host Connection: Localhost via UNIX socket
Protocol Version: 10
2013-01-14 16:33:16 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).
2013-01-14 16:33:21 INFO OGG-01055 Recovery initialization completed for target file /u01/app/oracle/oradata/GG/dirdat/n2000004, at RBA 1057.
2013-01-14 16:33:21 INFO OGG-01478 Output file /u01/app/oracle/oradata/GG/dirdat/n2 is using format RELEASE 10.4/11.1.
2013-01-14 16:33:21 INFO OGG-01026 Rolling over remote file /u01/app/oracle/oradata/GG/dirdat/n2000005.
2013-01-14 16:33:21 INFO OGG-01053 Recovery completed for target file /u01/app/oracle/oradata/GG/dirdat/n2000005, at RBA 995.
2013-01-14 16:33:21 INFO OGG-01057 Recovery completed for all targets.
2013-01-14 16:33:21 INFO OGG-00182 VAM API running in single-threaded mode.
2013-01-14 16:33:21 INFO OGG-01513 Positioning to Log Number: 130
Record Offset: 4176.
2013-01-14 16:33:21 INFO OGG-01516 Positioned to LogNum - 130
Record Offset - 4176, Jan 14, 2013 3:56:30 PM.
***********************************************************************
** Run Time Messages **
***********************************************************************
2013-01-15 03:11:03 INFO OGG-01517 Position of first record processed Log Number: 131
Record Offset: 186, Jan 15, 2013 3:11:02 AM.
GGSCI (mysql-multi-node-replica.etisalcom.private) 27> stats netfors
Sending STATS request to EXTRACT NETFORS ...
No active extraction maps.
GGSCI (mysql-multi-node-replica.etisalcom.private) 10> lag netfors
Sending GETLAG request to EXTRACT NETFORS ...
No records yet processed.
At EOF, no more records to process.
Edited by: misterimran on Jan 15, 2013 3:06 PM 
Silly question, but you did actually perform some DML for this table after adding the EXTRACT with the BEGIN NOW clause didn't you?

All the process are running but not perform replication.?

hi
i have problem that all the prcoess on both side(source & target are running) but not performing the replication. but when i enter the data in to source table then the table on target table is not replicated.I have already chechked that any error in log but there are no errors. Need of your assistance.
thanks
Global Parameter
checkpointtable ggs_checkpoint
Source
Manager Process
PORT 7809
PURGEOLDEXTRACTS ./dirdat/sa*, USECHECKPOINTS, MINKEEPHOURS 2
Extract Process PARAM
***********
extract emastr
exttrail ./dirdat/em
userid orclgg, password Ogg1234
DBOPTIONS ALLOWUNUSEDCOLUMN
table hr.emp;
*********************************************
for Datapump
extract pmastr
rmthost 192.168.1.181, mgrport 7809
rmttrail ./dirdat/pm
passthru
table hr.emp;
****************************************************************
On Target
--Replicat Process is
replicat rmastr
userid orclgg, password Ogg1234
handlecollisions
assumetargetdefs
allownoopupdates
map hr.emp, target hr.emp;
Regards.
AMSII
Edited by: AMSI on Jan 27, 2013 6:50 AM 
Is your rmttrail, using "./" a path on the remote server (i.e., are you using two separate servers)?
Why is the exttrail before the database login information?
-- Identify the Extract group:
EXTRACT <ext>
-- Specify database login information as needed for the database:
[SOURCEDB <dsn_1>][,USERID <user>][, PASSWORD <pw>
[<encryption options>]]
-- Specify the local trail that this Extract writes to and
-- optional encryption:
ENCRYPTTRAIL <encryption options>
EXTTRAIL <local_trail>
-- Specify tables to be captured:
TABLE <owner>.<table>;What does the extract log report show? Not in terms of errors, but for at least recording the transaction.
Have you tried the tutorial(s) at Oracle Learning Library?
http://apex.oracle.com/pls/apex/f?p=44785:2:0::NO:2,RIR,CIR:P2_GROUP_ID,P2_PRODUCT_ID:1001,2023 
i think its not issue.???
we can do this.
issue has been solved.
Regards,
AMSII 
Yes i have solved the issue myself.

Categories

Resources