1 2 Previous Next 21 Replies Latest reply on Jun 19, 2012 2:10 PM by EmaxG

    Golden gate pump process failing

    933968
      Goldengate PUMP process is configured as given below:

      GGSCI (cbidb006) 2> edit param pmpus1

      "/goldengateUS/home/ggsus/dirprm/pmpus1.prm" 210 lines, 7217 characters
      EXTRACT PMPUS1
      RMTHOST 172.16.251.82, MGRPORT 7809
      RMTTRAIL /home/ggs/bobus/rmttrailloc/us
      PASSTHRU
      TABLE TBAADM.NAME_AND_ADD_TABLE;

      GGSCI> ADD EXTRACT PMPUS1, EXTTRAILSOURCE /goldengateUS/home/ggsus/dirdat/trailus/us

      GGSCI> ADD RMTTRAIL /home/ggs/bobus/rmttrailloc/us, EXTRACT PMPUS1, MEGABYTES 3

      While starting the PUMP process, the following error occured in source & target server.

      ON SOURCE


      2012-06-12 13:42:34 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pmpus1.prm: TCP/IP error 239 (Connection refused).
      2012-06-12 13:43:14 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pmpus1.prm: TCP/IP error 239 (Connection refused).
      2012-06-12 13:43:54 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pmpus1.prm: TCP/IP error 239 (Connection refused).
      2012-06-12 13:44:34 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, pmpus1.prm: TCP/IP error 239 (Connection refused); retries exceeded.
      2012-06-12 13:44:34 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pmpus1.prm: PROCESS ABENDING.


      ON TARGET

      2012-06-12 13:44:04 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host ::ffff:172.16.2.50 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
      2012-06-12 13:44:04 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically).
      2012-06-12 13:44:04 ERROR OGG-00303 Oracle GoldenGate Collector for Oracle: TCP/IP bind error 98 (Address already in use).
      2012-06-12 13:44:04 ERROR OGG-01668 Oracle GoldenGate Collector for Oracle: PROCESS ABENDING.


      Pls help. Thanks
        • 1. Re: Golden gate pump process failing
          Kamal.Sharma-Oracle
          Hi ,

          Please check if the PORT 7809 is already in use on the target server. Try using dynamicportlist parameter on the target manager side with a range of available ports and check if the issue persists.


          Thanks,
          Kamal.
          • 2. Re: Golden gate pump process failing
            933968
            Many number of source servers are communicating to one target server and already dynamicportlist is designed in target manager process (7840 to 7849). But only this source pump process is giving error.
            From this server no other Database is communicating to target server.
            • 3. Re: Golden gate pump process failing
              Kamal.Sharma-Oracle
              Hi,

              Then try to get the below information to see which port is free on target.

              SEND MGR GETPORTINFO

              Thanks,
              Kamal.
              • 4. Re: Golden gate pump process failing
                amardeep.sidhu
                Kamal -Oracle wrote:
                Hi ,

                Please check if the PORT 7809 is already in use on the target server. Try using dynamicportlist parameter on the target manager side with a range of available ports and check if the issue persists.
                7809 is the port on which the manager is running. Problem is with the port on which the Collector is being started. 7809 will always be bound to the manager process.
                • 5. Re: Golden gate pump process failing
                  amardeep.sidhu
                  930965 wrote:
                  Many number of source servers are communicating to one target server and already dynamicportlist is designed in target manager process (7840 to 7849).
                  Are all the ports from this range open at Firewall (if any) ?
                  But only this source pump process is giving error.
                  What is your platform on source side ? What version of GG ?

                  Can you truss/strace the pump process on source side ?
                  • 6. Re: Golden gate pump process failing
                    933968
                    How to use truss/strace the pump process? And how to know on which port collector is initiating communication to the source.
                    • 7. Re: Golden gate pump process failing
                      933968
                      Let me explain the complete setup.

                      We have 5 servers as source. Each server is having 2-5 databases. GG is used for consolidating the data from all these 20 DBs into single database.

                      Already I have implemented GG in 2 servers (ie 7 DBs). Each DBs is having one pump process. When I am configuring for the 8th DB, I am getting the error in PUMP process.

                      The following ports are opened in the firewall between source & target server.
                      server1 (5 DBs) to target - 7809, 7840-7849
                      server2 (2 DBs) to target - 7809, 7840-7843
                      server3 (4 DBs) to target - 7809, 7840-7847
                      server4 (5 DBs) to target - 7809, 7840-7849
                      server5 (4 DBs) to target - 7809, 7840-7847

                      I have used DYNAMICPORTLIST 7840-7849 on the MGR process of target server.
                      • 8. Re: Golden gate pump process failing
                        amardeep.sidhu
                        We have 5 servers as source. Each server is having 2-5 databases. GG is used for consolidating the data from all these 20 DBs into single database.

                        Already I have implemented GG in 2 servers (ie 7 DBs). Each DBs is having one pump process. When I am configuring for the 8th DB, I am getting the error in PUMP process.

                        The following ports are opened in the firewall between source & target server.
                        server1 (5 DBs) to target - 7809, 7840-7849
                        server2 (2 DBs) to target - 7809, 7840-7843
                        server3 (4 DBs) to target - 7809, 7840-7847
                        server4 (5 DBs) to target - 7809, 7840-7849
                        server5 (4 DBs) to target - 7809, 7840-7847

                        I have used DYNAMICPORTLIST 7840-7849 on the MGR process of target server.
                        1) You need to open all the ports (mentioned in the DYNAMICPORTLIST parameter of the target mgr) between all sources & the target as you don't know on which port (and for which pump ?) the collector will start. So all the ports should be open.

                        2) Given the number of pump processes you are going to use, you need to increase the range of ports. Presently they are just too few.
                        • 9. Re: Golden gate pump process failing
                          933968
                          1. Each DB will be having one PUMP process.

                          2. What I understood is, manager (target) process start the collector on port which is defined in the dynamicportlist paramter (7840-7849). For each server, it will start from 7840 or keep on incrementing one until 7849. Thats why I have opened respective ports between the source server to target server. I have taken 2 ports for each pump process.
                          ie

                          server1 (5 DBs) to target - 7809, 7840-7849 (for 5 pump process, 10 PORTS)
                          server2 (2 DBs) to target - 7809, 7840-7843 (for 2 pump process, 4 PORTS)
                          server3 (4 DBs) to target - 7809, 7840-7847 (for 4 pump process, 8 PORTS)
                          server4 (5 DBs) to target - 7809, 7840-7849 (for 5 pump process, 10 PORTS)
                          server5 (4 DBs) to target - 7809, 7840-7847 (for 4 pump process, 8 PORTS)

                          Pls clarrify the port concept for collector process.
                          • 10. Re: Golden gate pump process failing
                            amardeep.sidhu
                            930965 wrote:
                            1. Each DB will be having one PUMP process.
                            Fine !

                            >
                            2. What I understood is, manager (target) process start the collector on port which is defined in the dynamicportlist paramter (7840-7849). For each server, it will start from 7840 or keep on incrementing one until 7849. Thats why I have opened respective ports between the source server to target server. I have taken 2 ports for each pump process.
                            ie
                            >
                            server1 (5 DBs) to target - 7809, 7840-7849 (for 5 pump process, 10 PORTS)
                            server2 (2 DBs) to target - 7809, 7840-7843 (for 2 pump process, 4 PORTS)
                            server3 (4 DBs) to target - 7809, 7840-7847 (for 4 pump process, 8 PORTS)
                            server4 (5 DBs) to target - 7809, 7840-7849 (for 5 pump process, 10 PORTS)
                            server5 (4 DBs) to target - 7809, 7840-7847 (for 4 pump process, 8 PORTS)

                            Pls clarrify the port concept for collector process.
                            You have only one manager running on target side. Right ?
                            • 11. Re: Golden gate pump process failing
                              933968
                              One mgr at target.

                              multipls mgr (one mgr for each DB) on source. Because all DBs are working in different cluster service.

                              On 5 source servers, totally 20 mgr process running. each having one extract process & one pump process.
                              • 12. Re: Golden gate pump process failing
                                amardeep.sidhu
                                2. What I understood is, manager (target) process start the collector on port which is defined in the dynamicportlist paramter (7840-7849). For each server, it will start from 7840 or keep on incrementing one until 7849. Thats why I have opened respective ports between the source server to target server. I have taken 2 ports for each pump process.
                                ie

                                server1 (5 DBs) to target - 7809, 7840-7849 (for 5 pump process, 10 PORTS)
                                server2 (2 DBs) to target - 7809, 7840-7843 (for 2 pump process, 4 PORTS)
                                server3 (4 DBs) to target - 7809, 7840-7847 (for 4 pump process, 8 PORTS)
                                server4 (5 DBs) to target - 7809, 7840-7849 (for 5 pump process, 10 PORTS)
                                server5 (4 DBs) to target - 7809, 7840-7847 (for 4 pump process, 8 PORTS)

                                Pls clarrify the port concept for collector process.
                                What i mean to say is that the way you are reserving the ports; how do you know that say for Server5 the collector will use the port from 7840-7849 only and not 7849 ?

                                The port for the collector is decided by the range defined on the target mgr and it may use any port from that range for accepting the requests from any of the extract pumps.

                                Edited by: amardeep.sidhu on Jun 13, 2012 3:25 PM
                                • 13. Re: Golden gate pump process failing
                                  933968
                                  DYNAMICPORTLIST 7840-7849

                                  Due to this parameter mgr (target) will start collector process on source server from 7840 / keep on increase the port no by 1 until getting a connection (may upto 7849).

                                  It the above is wrong, pls let me know the different source server's pump process can communicate to single target server on same port (7840) or not.
                                  • 14. Re: Golden gate pump process failing
                                    amardeep.sidhu
                                    Let me try to rephrase it:

                                    Here is what you have

                                    Server1----------->A
                                    Server2----------->A
                                    Server3----------->A
                                    Server4----------->A
                                    Server5----------->A

                                    Now on A's mgr params file you use DYNAMICPORTLIST and define a range of ports as 7840-7849.

                                    When it (A) receives request from any of the extract pumps (from server1, 2, 3, 4 or 5) it will use one port to start a collector port. Now any port from this range may get used for any of the Extract pumps. So you need to open this complete range of ports between each combination. ie Server1 and A, Server2 and B and so on.

                                    Hope it helps.
                                    1 2 Previous Next