Golden gate

[Arsalan]

Hi Arsalan,

SOURCE ORACLE 11.2.0.1.0 - 64bit Production
OS WINDOW 7

TARGET ORACLE 12C  12.1.0.2.0
OS WINDOW 2008R



i configure 2  server to practice oracle golden gate for bidirectional replication of data

when i start EXTRACT give will not work give below type of error,,

2017-11-20 15:53:09  WARNING OGG-01742  Command sent to MGR MGR returned with an
 ERROR response.

kindly guide me thanks

Note i followed golden gate by below link

http://www.vinayagaconsultancyltd.co.uk/blogs/oracle-golden-gate/golden-gate-bi-directional-replication

[ErmanArslansOracleBlog]

That link is not an Oracle support or docs.oracle.com link.

Anyways, we need to see the full error.

Check this first; Goldengate Extract Wont Start: OGG-02021 (Doc ID 1497480.1) and then send me the necessary logs.

[Arsalan]

Hi Arsalan,

I  mad another  tow vm machines  and installed on both oracle 12c for golden gate like below

SOURCE ORACLE 12C  12.1.0.2.0 - 64bit Production
OS WINDOW 7

TARGET ORACLE 12C  12.1.0.2.0
OS WINDOW 2008R

So when ever i start

START EXTRACT GGPROD it does not open

i attached some configuration files of source db with this message

ggprod.prm

mgr.prm

pump.prm


if u needs any logs etc inform me

Thanks Arsalan

[ErmanArslansOracleBlog]

Send me the log file of the failing process.

[Arsalan]

Sir,

I uploaded some error logs file with this message pls find it.

it file i took from source Db.

if you want a specefic error log tell me i will send you.

thanks

ggprod.prm

mgr.prm


pump.prm

[ErmanArslansOracleBlog]

let's check ggserr.log file within the root Oracle GoldenGate directory.

[Arsalan]

Hi Arslan

below are some log-file of  golden gate



INFO_EXTRACT_GGPROD.txt

mgr.prm

pump.prm

ggprod.prm

MGR.pcm


gglog-PUMP.dmp

gglog-GGPROD.dmp



GGPROD.cpe


PUMP.cpe

[ErmanArslansOracleBlog]

where is the ggserr.log file?

[Arsalan]

Sorry i fogot log file..


ggserr.log

[ErmanArslansOracleBlog]

I think your GGPRD10.prm file is problematic. There is parse error as you see;

"GGPRD10.prm:  (GGPRD10.prm) line 4: Parsing error, parameter [exttrail] has unrecognized keyword or extra"


Check the GGPRD10.prm and update it accordingly and properly.

[Arsalan]

Hi arslan

new error when i start ext1


Could not find archived log for sequence 28 thread 1 under default destinations

[ErmanArslansOracleBlog]

Your platform is Windows right?
I think you have arch 28 already in place?

Anyways first see this note and update me ->

Classic Extract Abends with OGG-00446 Error on Windows System (Doc ID 1670624.1)

[Arsalan]

Hi Arslan,

I configured oracle golden gate in my both machin

Source db oracle 11g

Target oracle 12c

from source mean oracle 11g uni directional are working normal but bidirectional of replication give some

error  see logs

here is logs of rep2

ggserr.log

[ErmanArslansOracleBlog]

You have several errors encountered in different times.
stop your goldengate services . empty this log file and start the goldengate services again.
Send me the log file afterwards... I want to see only the last start logs.

Note : You have errors like 2017-12-10 10:06:04  ERROR   OGG-01091  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Unable to open file -> for discard file

[Arsalan]

Hi brother

This error ( ERROR   OGG-01091) solved by below command

alter REP2, extseqno  154 , extrba 0

Now on both machine bi-directional working fine.

DML operation is normal working on both machine.


Thanks for your support..

BUT HAVE ONE PROBLEM AS WELL


I CREATED ONE TABLE ON SOURCE DB and SAME TABLE I ALSO CREATED IN TARGET

BUT WHILE I INSERT RECORD ON TEST TABLE IS NOT REPLICATE ON TARGET

WHY KINDLY GUIDE ME


create table test
(id number,
name varchar2(23));

[ErmanArslansOracleBlog]

Did you configured to environment to replicate this new table?

Take a look at this -> https://blog.dbi-services.com/adding-new-tables-to-an-existing-oracle-goldengate-replication/

[Arsalan]

Hello Arslan,

As you know that i started practice on oracle golden gate bi-directional

in different database version like oracle 11g oracle 12c

sometime it work bi-directional sometime it give error kindly check the error logs

LOG ERROR
------------------------------------------------

    C:\app\arsala\product\11.2.0\golden\dirtmp.
2017-12-20 11:31:49  ERROR   OGG-00446  Oracle GoldenGate Delivery for Oracle, REP2.prm:  No data selecting position from checkpoint table ggs_admin.Checkpoint for group 'REP2', key 2089802348 (0x7c8fda6c), SQL <>.
2017-12-20 11:31:49  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, REP2.prm:  PROCESS ABENDING.
2017-12-20 11:31:52  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (arsala): INFO ALL.


=========================================================



Below Configure Replicate on target database mean oracle 12c

it work normal

dblogin userid c##ogguser@pdborcl,password oracle

ADD CHECKPOINTTABLE ggs_admin.Checkpoint

---give path or location of local trail like below

edit param rep2

replicat rep2
userid ggs_admin@pdborcl, password ggs_admin
handlecollisions
assumetargetdefs
discardfile C:\app\GG\dirrpt\repl1.dsc, append
discardrollover at 5:00 on sunday
map SCOTT.*, target SCOTT.*;

--give path of local machine

add replicat rep2, exttrail C:\app\GG\dirdat\rt, checkpointtable ggs_admin.Checkpoint
---------------------------------------------------------------------------------------------------------------------

But on Oracle 11g replicat not working below script is

ON TARGET DATABASE WE CONFIGURE REPLICATION


ADD TRANDATA HR.*

ADD CHECKPOINTTABLE ggs_admin.Checkpoint


ADD REPLICAT REP2 EXTTRAIL C:\app\arsala\product\11.2.0\golden\dirdat\rt,checkpointtable ggs_admin.Checkpoint


EDIT PARAMS REP2

REPLICAT REP2
USERID ggs_admin, PASSWORD ggs_admin
ASSUMETARGETDEFS
discardfile C:\app\arsala\product\11.2.0\golden\dirrpt\repl2.dsc, append
MAP scott.*, TARGET scott.*;

[ErmanArslansOracleBlog]

Check this note:

My Checkpoint Table Is Corrupted. What Do I Do? (Doc ID 965703.1)