Oracle Golden Gate fail to start extract and replicate process
883218Aug 18 2011 — edited Aug 18 2011Hi,
I am trying to configure Golden Gate but i am running into the following errors while configuring. Any help is appreciated. Given below is the contents of the configuration.
Thanks
JT
ggssci>edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/ex, USECHECKPOINTS
ggsci>edit params ext1
–extract group–
extract ext1
–connection to database–
userid ggs_owner, password ggs_owner
–hostname and port for trail–
rmthost 192.168.2.111, mgrport 7809
–path and name for trail–
rmttrail /u01/app/oracle/ggs/dirdat/lt
–DDL support
DDL INCLUDE ALL
ddl include mapped objname SCOTT.*;
–DML
table SCOTT.*;
table SCOTT.EMP;
table SCOTT.DEPT;
table SCOTT.SALGRADE;
table SCOTT.BONUS;
GGSCI (ggsrc.localdomain) 12> view report ext1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x86, 32bit (optimized), Oracle 11g on Apr 30 2011 22:35:14
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-08-18 14:17:50
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Thu Mar 15 19:57:35 EDT 2007, Release 2.6.18-8.el5
Node: ggsrc.localdomain
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: 3408
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
–extract group–
Source Context :
SourceModule : [er.main]
SourceID : [/scratch/sganti/view_storage/sganti_core_lin32/oggc
ore/OpenSys/src/app/er/rep.c]
SourceFunction : [get_infile_params]
SourceLine : [12245]
ThreadBacktrace : [7] elements
: [/u01/app/oracle/ggs/extract(CMessageContext::AddThr
eadContext()+0x26) [0x8289366]]
: [/u01/app/oracle/ggs/extract(CMessageFactory::Create
Message(CSourceContext*, unsigned int, ...)+0x817) [0x827fae7]]
: [/u01/app/oracle/ggs/extract(_MSG_ERR_STARTUP_PARAME
RROR_ERRORTEXT(CSourceContext*, char const*, CMessageFactory::MessageDisposition
)+0x81) [0x822fc81]]
: [u01/app/oracle/ggs/extract [0x814e4c4]]
: [u01/app/oracle/ggs/extract(main+0x1dc) [0x81529cc]
]
: [lib/libc.so.6(__libc_start_main+0xdc) [0xa0adec]]
: [/u01/app/oracle/ggs/extract(__gxx_personality_v0+0x
1c5) [0x8120491]]
2011-08-18 14:17:50 ERROR OGG-00303 Unrecognized parameter (–extract).
2011-08-18 14:17:50 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (ggsrc.localdomain) 15> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:07:32
GGSCI (ggtrgt.localdomain) 2> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED REP1 00:00:00 00:10:23
GGSCI (ggtrgt.localdomain) 3> start replicat rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (ggtrgt.localdomain) 4> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED REP1 00:00:00 00:15:22
GGSCI (ggtrgt.localdomain) 5> view report rep1
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x86, 32bit (optimized), Oracle 11g on Apr 30 2011 22:40:44
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-08-18 14:22:08
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Thu Mar 15 19:57:35 EDT 2007, Release 2.6.18-8.el5
Node: ggtrgt.localdomain
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: 4095
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
–target database login –
Source Context :
SourceModule : [ggdb.ora.db]
SourceID : [/scratch/sganti/view_storage/sganti_core_lin32/oggc
ore/OpenSys/src/gglib/ggdbora/dboci.c]
SourceFunction : [odbc_param]
SourceLine : [1220]
ThreadBacktrace : [8] elements
: [/u01/app/oracle/ggs/replicat(CMessageContext::AddTh
readContext()+0x26) [0x820fa26]]
: [/u01/app/oracle/ggs/replicat(CMessageFactory::Creat
eMessage(CSourceContext*, unsigned int, ...)+0x817) [0x82061a7]]
: [/u01/app/oracle/ggs/replicat(_MSG_ERR_STARTUP_PARAM
_UNRECOGNIZED(CSourceContext*, char const*, CMessageFactory::MessageDisposition)
+0x7e) [0x81a7b6e]]
: [/u01/app/oracle/ggs/replicat(odbc_param(char*, char
*)+0xc25) [0x8182475]]
: [u01/app/oracle/ggs/replicat [0x812ec26]]
: [/u01/app/oracle/ggs/replicat(main+0x1a1) [0x8135bb1
]]
: [lib/libc.so.6(__libc_start_main+0xdc) [0x71a1dec]]
: [/u01/app/oracle/ggs/replicat(__gxx_personality_v0+0
x1b5) [0x8112991]]
2011-08-18 14:22:08 ERROR OGG-00014 Unrecognized parameter: –target. Paramet
er could be misspelled or unsupported.
2011-08-18 14:22:08 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (ggtrgt.localdomain) 6>