Having completed the database user creation, we can now move on to define a GoldenGate Manager process, which is vital for a variety of tasks like reporting.
10) It is also very important to setup a GoldenGate Manager process which is used for a variety of purposes like reporting and so on. At this stage, if I execute the "info manager" command in GGSCI, I get the following output
 Oracle GoldenGate Command Interpreter for Oracle Version 10.4.0.19 Build 002 Windows (optimized), Oracle 10 on Sep 18 2009 15:54:55 Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved. GGSCI (Home) 1> info manager Manager is DOWN! GGSCI (Home) 2> |
We will now setup the manager in Windows. Issue the command "EDIT PARAMS MGR". If this is the first time you are doing this, you may get the following prompt from Windows
| Cannot find the C:\GoldenGate\dirprm\mgr.prm file. Do you want to create a new file? |
Respond with Yes. You have to specify the USERID, port and login information in the manager parameter file. This is provided below [ save the file after this ]
| PORT 9500 USERID ggate,PASSWORD ggate PURGEOLDEXTRACTS C:\purge,USECHECKPOINTS |
10) Now, issue the START MANAGER command from GGSCI, a new window will open up [ If windows firewall is enabled, it will request for a unblock to allow communication on the defined port. Grant the required access in this case ]. A log of the manager process is given below
| *********************************************************************** Oracle GoldenGate Manager for Oracle Version 10.4.0.19 Build 002 Windows (optimized), Oracle 10 on Sep 18 2009 15:53:58 Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved. Starting at <date time> ***********************************************************************  Microsoft Windows Vista Home Premium Edition, on x86 Version 6.0 (Build 6002: Service Pack 2) Process id: 5912 Parameters... PORT 9500 USERID ggate,PASSWORD ggate PURGEOLDEXTRACTS C:\purge,USECHECKPOINTS *********************************************************************** ** Run Time Messages ** *********************************************************************** <datetime> GGS INFO 330 Manager started (port 9500). |
GGSCI would respond to the START MANAGER command with the following information
C:\GoldenGate>GGSCI Oracle GoldenGate Command Interpreter for Oracle Version 10.4.0.19 Build 002 Windows (optimized), Oracle 10 on Sep 18 2009 15:54:55 Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved. GGSCI (Home) 1> info manager Manager is DOWN! GGSCI (Home) 2> start manager Manager started. GGSCI (Home) 3> |
When you issue 'info manager' at this stage, you would get the following response
'Manager is running. (IP Port Home:9500)', You can use the STOP MANAGER command to stop the manager at any time. When you issue STOP MANAGER, you will get the following prompt
GGSCI (Home) 4> stop manager Manager process is required by other GGS processes. Are you sure you want to stop it (y/n)? y=> response to be provided by the user Sending STOP request to MANAGER ... Request processed. Manager stopped. |
That completes the guide of GoldenGate installation.We are now ready to move on with the next step in GoldenGate. Extracting data from logs and tables.
thanks for your excellent post on goldengate installation on windows machine.
ReplyDeleteCan you please post or share how to Extract/replicate data from one oracle database to another with sample example. Alos looking to replicate partial table data. It will be great if you can share this.
Hello,
ReplyDeletewe meet a problem in our first golden gate installation. The Extract data pump Process (named ODIT1P) Abends after starting, with the following error message on log file:
2010-05-12 15:26:42 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-12 15:26:44 GGS ERROR 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l’hôte distant.); retries exceeded.
2010-05-12 15:26:44 GGS ERROR 190 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: PROCESS ABENDING.
what do we do to bypass this issue please
@Abdelhamid
ReplyDeleteCan you post your extract code and the contents inside the log file?
@yellowRose
ReplyDeleteI built my configuration in a localhost (source, staging, and target)
My primary extract groupe's code is:
extract ODISC
userid system, password system
exttrail C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc
TABLE GG_TEST_SRC.CUSTOMERS;
My data pump extract's code is:
extract ODIT1P
userid system, password system
rmthost localhost, mgrport 7910
rmttrail C:\GoldenGate\GoldenGate_Stg/dirdat/ODIT1op/op
TABLE GG_TEST_SRC.CUSTOMERS;
My replicat groupe's code is:
replicat ODIT1A1
userid system, password system
discardfile C:\GoldenGate\GoldenGate_Stg/dirrpt/ODIT1.dsc, purge
sourcedefs C:\GoldenGate\GoldenGate_Stg/dirdef/ODISC.def
map GG_TEST_SRC.CUSTOMERS, TARGET GG_TEST_STG.CUSTOMERS, KEYCOLS (ID);
map GG_TEST_SRC.CUSTOMERS, target GG_TEST_STG.J$CUSTOMERS, KEYCOLS (ID, WINDOW_ID), INSERTALLRECORDS, OVERRIDEDUPS,
COLMAP (
ID = ID,
WINDOW_ID = @STRCAT(@GETENV("RECORD", "FILESEQNO"), @STRNUM(@GETENV("RECORD", "FILERBA"), RIGHTZERO, 10))
);
@YellowRose
ReplyDeleteA contents inside a log file part 1 are:
Sourc log is:
2010-05-14 10:21:44 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start mgr.
2010-05-14 10:22:01 GGS INFO 330 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7909).
2010-05-14 10:24:05 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start ODISC.
2010-05-14 10:24:05 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.27.68 (START EXTRACT ODISC ).
2010-05-14 10:24:05 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT ODISC starting.
2010-05-14 10:24:23 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODISC.prm: EXTRACT ODISC starting.
2010-05-14 10:24:24 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start ODIT1P.
2010-05-14 10:24:25 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.27.68 (START EXTRACT ODIT1P ).
2010-05-14 10:24:25 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT ODIT1P starting.
2010-05-14 10:24:44 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: EXTRACT ODIT1P starting.
2010-05-14 10:24:44 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: EXTRACT ODIT1P started.
2010-05-14 10:24:46 GGS WARNING Z1-078 Oracle GoldenGate Capture for Oracle, ODISC.prm: No valid default archive log destination directory found for thread 1.
2010-05-14 10:24:49 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODISC.prm: EXTRACT ODISC started.
2010-05-14 10:24:49 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ODISC.prm: Recovery initialization completed for target file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc000007, at RBA 1035.
2010-05-14 10:24:49 GGS INFO Z0-05M Oracle GoldenGate Capture for Oracle, ODISC.prm: Output file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc is using format RELEASE 10.4.
2010-05-14 10:24:49 GGS INFO 224 Oracle GoldenGate Capture for Oracle, ODISC.prm: Rolling over remote file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc000007.
2010-05-14 10:24:49 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ODISC.prm: Recovery completed for target file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc000008, at RBA 1035.
2010-05-14 10:24:49 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ODISC.prm: Recovery completed for all targets.
2010-05-14 10:24:50 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:24:51 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:24:52 GGS INFO 220 Oracle GoldenGate Capture for Oracle, ODISC.prm: Found crash recovery marker from thread #1 on sequence 7 at RBA 1040. Aborting uncommitted transactions.
2010-05-14 10:24:56 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
@Yellow rose
ReplyDeleteMy replicat logfile :
2010-05-14 10:22:42 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start mgr.
2010-05-14 10:22:59 GGS INFO 330 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7910).
2010-05-14 10:24:45 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
2010-05-14 10:24:45 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7842).
2010-05-14 10:25:03 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
2010-05-14 10:25:03 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7843).
2010-05-14 10:25:22 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
2010-05-14 10:25:22 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7844).
2010-05-14 10:25:40 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
2010-05-14 10:25:40 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7845).
2010-05-14 10:25:58 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
2010-05-14 10:25:58 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7846).
A contents inside a log file part 2 are:
ReplyDelete2010-05-14 10:24:57 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:25:08 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:25:09 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:25:14 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:25:15 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:25:27 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:25:28 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:25:33 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:25:34 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:25:45 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:25:46 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:25:52 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:25:53 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:26:03 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:26:04 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
2010-05-14 10:26:09 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
2010-05-14 10:26:10 GGS ERROR 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.); retries exceeded.
2010-05-14 10:26:10 GGS ERROR 190 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: PROCESS ABENDING.
Hello
ReplyDeleteI followed all the previous steps, the enviroment variables, the conection to the database, the creattion of directories using gssci, all seams ok.
But I am trying to make the manager start and still with the same problem
When I execute
ggsci> start manager
manager started
ggscia> info manager
Manager is DOWN!
Can anyone help me to find the problem? I will appreciate.
Thanks
Great site. A lot of useful information here. I’m sending it to some friends!
ReplyDeleteI have a question about Flashback Data Archive tables in Goldengate replication. Are these tables usually excluded in an extract like "TABLEEXCLUDE .SYS_FBA_*"?
ReplyDeleteWhat is the approach for replicating and initial load of Flash Back Data Archive tables?
Here is my problem. I exported a user schema using Oracle DataPump, imported into destination database. GoldenGate abended saying some tables dont exist on dest. I checked tables and there were about 200 tables that were not exported because they are FBDA tables and DataPump just ignores them. So, I recreated them on source with scripts.
So, how is this done? Source and destination have their own FBDA and these tables should not be neither recreated with scripts on dest or replicated? Or they have to be replicated with contents?