Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Golden Gate fail to start extract and replicate process

883218Aug 18 2011 — edited Aug 18 2011
Hi,

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>
This post has been answered by stevencallan on Aug 18 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2011
Added on Aug 18 2011
4 comments
10,574 views