GoldenGate issues solving and find out replication is going on which Source and Target of GoldenGate

  • If you try to start GoldenGate and facing below error , there is workaround for this:

Issue 1:

test13@DEV [12.2.0.1.1]$ agctl start goldengate gg_test

CRS-2673: Attempting to stop 'test-gg-vip.testinv.com' on 'test14'
CRS-2677: Stop of 'test-gg-vip.testinv.com' on 'test14' succeeded
CRS-2672: Attempting to start 'test-gg-vip.testinv.com' on 'test13'
CRS-2676: Start of 'test-gg-vip.testinv.com' on 'test13' succeeded 
CRS-2672: Attempting to start 'xag.gg_test.goldengate' on 'test13'
CRS-2674: Start of 'xag.gg_test.goldengate' on 'test13' failed
CRS-2679: Attempting to clean 'xag.gg_test.goldengate' on 'test13'
CRS-2681: Clean of 'xag.gg_test.goldengate' on 'test13' succeeded
CRS-2673: Attempting to stop 'test-gg-vip.testinv.com' on 'test13'
CRS-2677: Stop of 'test-gg-vip.testinv.com' on 'test13' succeeded
CRS-2672: Attempting to start 'test-gg-vip.testinv.com' on 'test14'
CRS-2676: Start of 'test-gg-vip.testinv.com' on 'test14' succeeded
CRS-4000: Command Start failed, or completed with errors. 

kill the Golden Gate process which are from /g01/app/ogg/12…… etc path only and be cautious while killing the process and make sure you are killing the right process.

example:

test13@PROD [12.2.0.1.1]$ ps -ef | grep g01
oracle 5646 1 0 Oct15 ? 00:00:27 mdb_lg01_-MGMTDB
oracle 16958 1 0 08:28 ? 00:00:26 ./mgr PARAMFILE /g01/app/ogg/12.2.0.1.1/dirprm/mgr.prm REPORTFILE /g01/app/ogg/12.2.0.1.1/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRS

test13@PROD [12.2.0.1.1]$
test13@PROD [12.2.0.1.1]$
test13@PROD [12.2.0.1.1]$ kill -9 16958

and now make sure whether that process is killed.

test13@PROD [12.2.0.1.1]$ ps -ef | grep g01
oracle 5646 1 0 Oct15 ? 00:00:27 mdb_lg01_-MGMTDB
oracle 18939 10316 0 09:52 pts/0 00:00:00 grep g01

From above we can say that there is not currently GG process exists..
So now you can try to start GoldenGate again.

test13@PROD [12.2.0.1.1]$
test13@PROD [12.2.0.1.1]$ agctl start goldengate gg_test

test13@PROD [12.2.0.1.1]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (test13.testinv.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      RUNNING
EXTRACT     RUNNING     EMUMDS      00:00:09      00:00:08
EXTRACT     RUNNING     PMUGSP      00:00:00      00:00:09
EXTRACT     RUNNING     PMUHIK      00:00:00      00:00:04


Issue 2:

Also there are some other issue or bug we can say while starting GG:

test2@PRD [~]$  agctl start goldengate gg_test

CRS-2672: Attempting to start 'xag.gg_test.goldengate' on 'test1'
CRS-2674: Start of 'xag.gg_test.goldengate' on 'test1' failed
CRS-2679: Attempting to clean 'xag.gg_test.goldengate' on 'test1'
CRS-2681: Clean of 'xag.gg_test.goldengate' on 'test1' succeeded
CRS-2563: Attempt to start resource 'xag.gg_test.goldengate' on 'test1' has failed. Will re-retry on 'test2' now.
CRS-2673: Attempting to stop 'test-gg-vip.testinv.com' on 'test1'
CRS-2677: Stop of 'test-gg-vip.testinv.com' on 'test1' succeeded
CRS-2672: Attempting to start 'test-gg-vip.testinv.com' on 'test2'
CRS-2676: Start of 'test-gg-vip.testinv.com' on 'test2' succeeded
CRS-2672: Attempting to start 'xag.gg_test.goldengate' on 'test2'

Sending START request to MANAGER ...
ERROR: sending message to MANAGER (Connection reset by peer).

CRS-2674: Start of 'xag.gg_test.goldengate' on 'test2' failed
CRS-2679: Attempting to clean 'xag.gg_test.goldengate' on 'test2'
CRS-2681: Clean of 'xag.gg_test.goldengate' on 'test2' succeeded
CRS-2673: Attempting to stop 'test-gg-vip.testinv.com' on 'test2'
CRS-2677: Stop of 'test-gg-vip.testinv.com' on 'test2' succeeded
CRS-2672: Attempting to start 'test-gg-vip.testinv.com' on 'test1'
CRS-2676: Start of 'test-gg-vip.testinv.com' on 'test1' succeeded
CRS-2632: There are no more servers to try to place resource 'xag.gg_test.goldengate' on that would satisfy its placement policy
CRS-4000: Command Start failed, or completed with errors.

Above error says that you have to create new DATASTORE for that goto $GG_HOME and search for “dirbdb” directory as shown:

cd $GG_HOME
$ ls -lrt ------>at End you will see file "dirbdb"

You can remove or rename this file and create new DATASTORE:

test2@PRD [~]$ mv dirbdb dirbdb_bkp
test2@PRD [~]$ ggsci
ggsci> INFO DATASTORE
ggsci>  CREATE DATASTORE
ggsci> exit

And now try to start GG again:

test2@PRD [~]$  agctl start goldengate gg_test
test2@PRD [~]$  

 

  • How to find out replication is going on which Source and Target of GoldenGate?

If anyone want to find out replication of GG is sending from which server to which server by “Group” name:

GGSCI (test3.testinv.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      RUNNING
REPLICAT    RUNNING     RURSTEST    00:00:00      00:00:01

GGSCI (test3.testinv.com) 2>

GGSCI (test3.testinv.com) 2> info RURSTEST

REPLICAT   RURSTEST  Last Started 2016-12-14 16:02   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Process ID           26719
Log Read Checkpoint  File /g01/ggdata/EAUTEST/RT000000474
                     2016-12-15 11:01:26.061737  RBA 481415066

Above which is gone Bold is the path were all info of Group RURSTEST is saved, so now you know the path then you can use below command to see Source and Target Groups:

GGSCI (test3.testinv.com) 4> sh strings /g01/ggdata/EAUTEST/RT000000474 |more

:uri:test3:testinv:com::g01:app:ogg:12.2.0.1.1:PAUTESTREPL5
/g01/ggdata/EAUTEST/RT0000004747
8653575747605
8653574545718
............................................
Linux1
test3.testinv.com2
2.6.32-573.22.1.el6.x86_643
##1 SMP Thu Mar 17 03:23:39 EDT 20164
x86_642
TESTMDD12
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
12.1.0.2.09
-04:003
EAUMDM1

Above marked in bold is the source server and target Group to which GG info is replicating, also it will show more than extra information, you can go through it and find what all things you needed.

Please share If you like..Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Yummly

Leave a Reply

Your email address will not be published. Required fields are marked *

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA
Go Back