TCP/IP error 10060 occured - GoldenGate

I am trying to start extract, but TCP/IP error 10060 is occuring.
moreover, this error is not letting me to stop mgr process in source , whereas in target at least I can stop mgr.
Please suggest some solutions for this. 

hi,
Can you post your extract parameter file?
also, have a look at the messages in the GoldenGate eventlog on the target system.
thanks
Edited by: EricEE on 10-jan-2011 10:51 

TCP 10060 is related to a timeout error.
Can you telnet between source and target?
On source system: telnet name_of_target 7809
You should get a message about the escape character, which can be control + right square bracket "^]"
On target system, try telnet back to source:
telnet name_of_source 7809
If you are using a different port, substitute as necessary.
What does "stop manager !" do? 

Hi,
Please paste your extract report with the error.
Thanks
Sebastian 

You can kill mgr process at source in this way too
ps -ef | grep ./mgr
oracle 18106 1 0 09:19 ? 00:00:00 ./mgr PARAMFILE /home/oracle/goldengate/dirprm/mgr.prm REPORTFILE /home/oracle/goldengate/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
oracle 22762 19824 0 09:25 pts/2 00:00:00 grep ./mgr
kill -9 18106
Then restart the mgr process.
Thanks. 

Command:
ggsci> stop mgr ! stops manager without prompting for confirmation.
Regards 

I know what the command does, the question was for the OP in terms of what affect using that syntax/option has.

Related

No replication and weird port number

hi,
I have another installation in /logi/ogg2 on port 7810
no error but replication is not working
nothing in ggseerr.log
where I can look ?
Something weird, I put 7810 in mgr.prm
why I have port 7809 in the command line ????
On server1:
MANAGER     RUNNING
EXTRACT     RUNNING     EXT9        00:00:00      00:00:09
EXTRACT     RUNNING     P911        00:00:00      00:00:08
  oracle  790720 3915810   0 09:26:39  pts/1  0:00 grep ogg2
  oracle 2764988 4030702   0 09:19:28      -  0:00 /logi/ogg2/extract PARAMFILE /logi/ogg2/dirprm/ext9.prm REPORTFILE /logi/ogg2/dirrpt/EXT9.rpt PROCESSID EXT9 USESUBDIRS
  oracle 3125258       1   0 17:52:28      -  1:32 /logi/ogg2/extract PARAMFILE /logi/ogg2/dirprm/p911.prm REPORTFILE /logi/ogg2/dirrpt/P911.rpt PROCESSID P911 USESUBDIRS
  oracle 4030702       1   0 22:06:39      -  0:29 ./mgr PARAMFILE /logi/ogg2/dirprm/mgr.prm REPORTFILE /logi/ogg2/dirrpt/MGR.rpt PROCESSID MGR PORT 7809On server2:
MANAGER     RUNNING
REPLICAT    RUNNING     REP9        00:00:00      00:00:05
  root 2060536 2920484   0 09:49:39  pts/2  0:00 grep ogg2
  oracle 2506814       1   0 21:53:39      -  0:08 ./mgr PARAMFILE /logi/ogg2/dirprm/mgr.prm REPORTFILE /logi/ogg2/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
  oracle 2535678       1   0 17:52:28      -  0:17 ./server -p 7845 -k -l /logi/ogg2/ggserr.log
  oracle 2580626 2506814   0 09:32:47      -  0:03 /logi/ogg2/replicat PARAMFILE /logi/ogg2/dirprm/rep9.prm REPORTFILE /logi/ogg2/dirrpt/REP9.rpt PROCESSID REP9 USESUBDIRS 
Put 7810 in the parameter file when? Looks to me that the current manager process on both is using 7809. Did you stop and re-start manager? 
Hi Steven
I checked(lsof) mgr is listening on 7810, bug in the output ?
BTW nothing arrive in the destination database …
do you have any idea ?
Thanks for your help
below my extract, pump and replicat
extract ext9
userid ogg,password xxx
tracetable ogg.ggs_trace
exttrail /vld/data/ogg/9L
tableexclude siebel.s_dock_txn*
tableexclude siebel.s_dck_txn*
tableexclude siebel.S_ACCELERATOR
...
table siebel.s_*;
table siebel.cx_*;
table siebel.timelag;
table siebel.jmt_pwd;
table siebel.test;pump
extract P911
passthru
rmthost cbsu13,mgrport 7810
rmttrail /vld/data/ogg/9R
table siebel.*;replicat
replicat rep9
setenv (oracle_sid=V18)
userid ogg,password xxx
handlecollisions
sourcedefs ./dirdef/ext9.def
discardfile /vld/data/ogg/discards/resp.dsc,purge
reperror default discard
dboptions deferrefconst
MAP "SIEBEL.CX_APPL_BU", TARGET "SIEBEL.CX_APPL_BU", COLMAP (usedefaults, DB
_LAST_UPD=#DATENOW(),DB_LAST_UPD_SRC="Siebel78");
MAP "SIEBEL.CX_APPLICATION", TARGET "SIEBEL.CX_APPLICATION", COLMAP (usedefa
ults, DB_LAST_UPD=#DATENOW(),DB_LAST_UPD_SRC="Siebel78");
...
MAP "SIEBEL.S_ZIPCODE_XM", TARGET "SIEBEL.S_ZIPCODE_XM", COLMAP (usedefaults
, DB_LAST_UPD=#DATENOW(),DB_LAST_UPD_SRC="Siebel78");
map SIEBEL.*, target SIEBEL.*; 
Where is the installation path on the remote server? In one post, you refer to /logi, and in the last post, the path is under vld.
If the remote server is a different machine, why the need to use 7810? 
HI Steven,
The installation path is /logi/ogg2 on the 2 servers .
This is the second installation, this why is use 7810.
/vld/data/ogg is the data path on the two servers.
My configuration below:
server1           server2
DB1    <--->     DB2
DB3     ---->     DB4Thanks for your help
Edited by: user12045475 on 5 nov. 2011 23:01
Edited by: user12045475 on 6 nov. 2011 01:21 
Are you sure you are looking at the correct instance of GoldenGate? If you have two instances of manager running, you will see two processes from a ps output. 
yes I did a grep ogg2 
This isn't hard.
Databases 1 and 3 are on one server, 2 and 4 on another.
No-brainer approach: For DB1, use one instance of GoldenGate, use port 7809 for the manager. For DB2 on the other server, again, a separate intall/instance of GoldenGate and use the same port number.
Do the same thing for the pairing of 3 and 4, using port 7810 between them, using a separate install/instance of GoldenGate.
Start manager for DB1, 7809, start manager for DB2, 7810. Start manager for DB3, 7809, start manager for DB4, 7810.
You will see ports 7809 and 7810 in use (netstat -an) on server 1, and ports 7809 and 7810 on server 2. 
Yes correct ... 
user12045475 wrote:
Something weird, I put 7810 in mgr.prm
why I have port 7809 in the command line ????
oracle 4030702       1   0 22:06:39      -  0:29 ./mgr PARAMFILE /logi/ogg2/dirprm/mgr.prm REPORTFILE /logi/ogg2/dirrpt/MGR.rpt PROCESSID MGR PORT 7809The mgr will always say "PORT 7809" when you grep for the process ID. As per the docs, it's the default port for manager; and, that is how the default is given to manager via ggsci, when you run "start mgr". Put another way, the default port for mgr isn't hard-coded in 'mgr', rather, it's defined in ggsci, given a command-line option to mgr when manager is started. Once mgr starts, it reads its prm file, and uses the port you specify.
Long story short, mgr has a default port of 7809, but you need to specify a port regardless in mgr's prm file. You can ignore the port you see when grepping for the process ID. 
OK thanks for the input
replication is working now (DB3 -> DB4)
but I don't know why ...
Edited by: user12045475 on Nov 7, 2011 12:07 AM 
the user ogg has now the following privileges
maybe this why it works now but I don't how he got this privileges
any idea ?
GRANT EXECUTE ON SYS.DBMS_AQ_BQVIEW TO OGG;
GRANT SELECT ON SYS.QT60820_BUFFER TO OGG;

TCP/IP error 111 (Connection refused).?

Hi,
I have configured replication using Golden gate. After starting extract .. i am getting following follwing error.
How to resolve this error. please help me
Error:
GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ext1.prm: TCP/IP error 111 (Connection refused) 
user2017273 wrote:
I have configured replication using Golden gate. After starting extract .. i am getting following follwing error.
How to resolve this error. please help me
Error:
GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ext1.prm: TCP/IP error 111 (Connection refused)What is the contents of the report file?? (note that the report file also has the contents of the paramter file... a double benefit for us so that we can better guess what the issue is...)
ggsci> view report ext1
...details?The problem is, most likely, that you have your extract "ext1" writing to a remote trail (RmtHost {hostname}, mgrPort 7801), and the remote manager is either not running, or is not running on the correct/expected port (in this example, 7801). Also be sure "ext1.prm" uses the correct syntax for specifying the rmthost: it's "mgrport", not just "port".
Good luck,
-Michael 
Hi,
Now i am getting different error
Log file:
GGSCI (test1.domain.com) 28> view report ext1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 on Sep 18 2009 00:01:59
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-07-21 08:02:03
***********************************************************************
Operating System Version:
Linux
Version #1 Wed Jan 5 19:22:18 EST 2005, Release 2.6.9-5.EL
Node: test1.domain.com
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: 3601
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
extract ext1
userid ggs_owner, password *********
rmthost 192.168.0.108, mgrport 7809
rmttrail /u01/gg/dirdat/lt
ddl include mapped objname scott.*;
table scott.*;
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.92G
CACHESIZEMAX (strict force to disk): 2.68G
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.US7ASCII"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "US7ASCII"
2011-07-21 08:02:08 GGS INFO 406 Socket buffer size set to 27985 (flush size 27985).
2011-07-21 08:02:18 GGS INFO 112 No recovery is required for target file /u01/gg/dirdat/lt000000, at RBA 0 (file not opened).
2011-07-21 08:02:18 GGS INFO Z0-05M Output file /u01/gg/dirdat/lt is using format RELEASE 10.4.
Source Context :
SourceModule : [er.extrout]
SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/extrout.c#4 $]
SourceFunction : [complete_tcp_msg]
SourceLine : [1342]
ThreadBacktrace : [8] elements
: [u01/gg/extract(_ZN15CMessageContext16AddThreadContextEv+0x26) [0x825bb56]]
: [u01/gg/extract(_ZN15CMessageFactory13CreateMessageEP14CSourceContextjz+0x533) [0x824fc43]]
: [u01/gg/extract(_Z16complete_tcp_msgP11extract_def+0x7d7) [0x80c3347]]
: [u01/gg/extract [0x80ce7b1]]
: [u01/gg/extract(_Z19open_targ_ext_filess+0xa5) [0x80c2525]]
: [u01/gg/extract(main+0x6d0) [0x80ff900]]
: [lib/tls/libc.so.6(__libc_start_main+0xe3) [0xc0ee33]]
: [u01/gg/extract [0x809b5e1]]
*2011-07-21 08:02:18 GGS ERROR 112 There is a problem in network communication, a remote file problem, encryption keys for target and source do not ma*
tch (if using ENCRYPT) or an unknown error. (Remote file used is /u01/gg/dirdat/lt000000, reply received is Could not create /u01/gg/dirdat/lt000000).
*2011-07-21 08:02:18 GGS ERROR 190 PROCESS ABENDING.* 
Does your GG user have rw permissions for the directory you are using? 
Dear you have two different problems...
On your first problem you should check the target server port opend or not for sorce server. TCP/IP connection (port) must established for this communication. You can check this by using telnet to target server from source server.
Now on your second question...
If everything is working fine for port connectivity, and no issue. You check that whether already file is created for the same name. You can also check whether same name file is created over the target location. You can check the goldengate authentication on that perticular server mount. 
Hi,
Error:
GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ext1.prm: TCP/IP error 111 (Connection refused)
Explanation:
"Connection refused" indicates one of the following:
No application running on the remote system is listening to the specified port
The MGR process is not running
The "static" Server/Collector process is not running.
The "dynamic" Server/Collector process was slow to start (Extract should recover by retrying the connection).
The "dynamic" Server/Collector process failed to start.
The "dynamic" Server/Collector process terminated immediately after starting.
The application running on the remote system is listening to the specified port, but the connection request queue is full
Too many processes are opening connections to the specified port at the same time.
Extract is trying to connect to a Server/Collector port that already has an established connection.
Sometimes, firewalls refuse unauthorized connection requests.
Oracle GoldenGate Extract opens TCP/IP connections for two purposes:
To Send "START" requests to a remote MGR process.
To Send trail data to a remote Server/Collector process.
Extract may connect to a remote MGR to request that it start a "dynamic" Server/Collector process, in which case the MGR responds with the port number it assigned to the process it started, or Extract may connect directly to a "static" Server/Collector process.
In general, it is recommended using Dynamic Server/Collector processes.
Troubleshooting the MGR process on the remote system
----------------------------------------------------------------------------------------------
Ensure that MGR is running on the remote system:
GGSCI (remote_system) 1> info mgr
Manager is running (IP port sysname.7890).
If not running, start mgr:
GGSCI (remote_system) 3> start mgr
Manager started.
If running, check that MGR is responding to connection requests and commands:
GGSCI (remote_system) 4> send mgr getportinfo detail
Sending GETPORTINFO, request to MANAGER ...
Entry Port Error Process Assigned Program
----- ----- ----- ---------- ------------------- -------
0 7891 0
1 7892 0
2 7893 0
3 7894 0
4 7895 0
If the comnand times out, kill and restart MGR:
$ ps -f | grep ./mgr
gguser 782474 1171604 0 12:46:30 pts/2 0:04 ./mgr mgr PARAMFILE /home/gguser/v10.4.0.19/dirprm/mgr.prm REPORTFILE /home/gguser/v10.4.0.19dirrpt/MGR.rpt PROCESSID MGR PORT 7809 > /home/gguser/v10.4.0.19/dirout/MGR.out
$ kill -9 782474
$ ggsci
GGSCI > start mgr
Manager started.
Troubleshooting MGR connection problems from the local system
-------------------------------------------------------------------------------------------------------------------
After ensuring that MGR is running and responsive on the remote system, check whether a connection can be established.
Using the wrong port number, or when a firewall refuses a connection attempt:
$ telnet remote_system_name 7809
Trying...
telnet: connect: A remote host refused an attempted connect operation.
Using the correct port number:
$ telnet remote_system_name 7890
Trying...
Connected to axe01.
Escape character is '^]'.
^]
telnet> close
Connection closed.
Troubleshooting Server/Collector connection problems
------------------------------------------------------------------------------------------
Look for messages related to starting dynamic Server/Collector processes in ggserr.log on the remote system.
2009-05-18 13:56:43 GGS INFO 301 GoldenGate Manager for DB2, mgr.prm: Command received from EXTRACT on host 192.168.118.59 (START SERVER CPU -1 PRI -1 PARAMS -c ON).
2009-05-18 13:56:43 GGS INFO 302 GoldenGate Manager for DB2, mgr.prm: Manager started collector process (Port 7891).
2009-05-18 13:56:43 GGS INFO 373 GoldenGate Collector, port 7891: Waiting for connection (started dynamically).
If the Server/Collector process (either static or dynamic) is running, but Extract cannot establish a connection, you may attempt to connect to the Server/Collector process using the "telnet" client utility program:
$ telnet remote_server_name 7891
Trying...
telnet: connect: A remote host refused an attempted connect operation.
The above indicates that either the Server/Collector process is not listening to the specified port, or a firewall is refusing the connection request. The "Connection refused" message may be slightly different on different systems, for example:
Trying 192.168.168.192...
telnet: connect to address 192.168.168.192: Connection refused
telnet: Unable to connect to remote host
Successful connections using telnet indicate that the routing is correct and any network firewalls are allowing connections through:
$ telnet remote_system_name 7890
Trying...
Connected to system_name.
Escape character is '^]'.
^]
telnet> close
Connection closed.
Note that the Server/Collector process will terminate when the connection is closed.
Even though telnet may be able to establish a connection, there may still be problems with system software that monitors application activity and blocks connections from unauthorized applications - for example, if "telnet" is "authorized", and "extract" is not, "telnet" can establish connections, but "extract" will be unable to connect:. Whether extract gets "Connection refused" or "Connection timeout" or a different error depends on the software that blocks connections from "unauthorized" programs.
Routing problems and firewalls that drop unauthorized packets may cause a connection timeout:
$ telnet 192.168.168.192 12345
Trying...
telnet: connect: A remote host did not respond within the timeout period.
To check for routing problems, use traceroute, a program that traces the path packets take through the network by setting the "Time-To-Live" (TTL) value to cause the routers along the way to return the "expired" packets; each router that receives the packet decrements the TTL and when it hits zero, that router returns the packet; the traceroute program then displays the "hop count" (TTL value), the address(es) of the router(s) that returned the packet, and the time it took to receive responses from three packets. Timeouts are indicated by an "*" instead of the response time.
If the above didn't help identify the problem, contact your network administrator to check firewall settings.
Thanks & Regards
SK

multiple processes on unix server even stop replicat, is that block port?

I have configured on source server Oracle goldengate manager/extract on port 7809 and same configured on target server with port 7809.
Now over the weekend, I encountered two problems.
1). tcp ip timeout from extract error log and extract abend.
test : telnet linuxserver 7809
$ telnet linuxserver 7809
Trying...
Connected to linuxserver.
Escape character is '^]'.
Connection closed.
It connected, then after a second, connection closed.
2). On target server, there are multiple processes for replicat existed even I stopped replicat and stopped manager. There are nothing running.
ps -ef|grep ggs
oracle 13595 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
oracle 14031 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
oracle 14447 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
oracle 14674 1335 0 13:34 pts/0 00:00:00 grep ggs
oracle 14962 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
oracle 15529 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
oracle 28295 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
oracle 28751 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
oracle 29158 1 0 May20 ? 00:00:00 ./replicat INITIALDATALOAD -p 7819-12818 -m 7809 PARAMFILE /u01/app/oracle/product/11.2.0/ggs/dirprm/load2.prm REPORTFILE /u01/app/oracle/product/11.2.0/ggs/dirrpt/LOAD2.rpt PROCESSID LOAD2 USESUBDIRS
I have to manually kill those processes by kill -9 on server.
How to control this manner?
thanks. 
use DYNAMICPORTS and define a range of ports not just one
Please check with the reference guide for implementation 
It could have something to do with the firewall or any other kind of restrictions in your network. As suggested by NK try a range of ports using DYNAMICPORTLIST and get those ports open between two servers before starting GG services. 
SA did open those ports. And on source, we have 7809 and 7810-7820 open.
On Target, it seems replicate goes to 7840-7850. And even I stopped replicat, I still see those processes if I do a ps -ef|grep ggs.
I have network engineering and SA look into this issue, they all said firewalls are open,and everything looks fine on their end. They said it is goldengate configuration issues. 
Can you post your target manager param file ? 
9233598 wrote:
SA did open those ports. And on source, we have 7809 and 7810-7820 open.
On Target, it seems replicate goes to 7840-7850. And even I stopped replicat, I still see those processes if I do a ps -ef|grep ggs.
I have network engineering and SA look into this issue, they all said firewalls are open,and everything looks fine on their end. They said it is goldengate configuration issues.Doesn't seem like a possibility if you have mentioned the DYNAMICPORTLIST in the Source's Manager File and have mentioned a port from that range in the Target's side. As Sidhu has asked, post your target Manager's param file and let's have a look.
Aman.... 
Here is target manager parameter file. Sorry my neighborhood was out of power last night.
PORT 7809
USERID ggs_owner PASSWORD xxxx
PURGEOLDEXTRACTS /u01/app/oracle/product/11.2.0/ggs/dirdat/ex, USECHECKPOINTS
~ 
As i said above use DYNAMICPORTLIST parameter in the target manager file to define a range of ports, get those ports opened and then try. 
Great. I finally got it working now.
Thank you so much for help.
I have another quetion, in real life migration, our database have a lot clobs datatype, and logsegments, etc. What is the best practice or advices you can give to me?
Can I create multiple extracts on source and multiple replicat on source?
Let's say we have 10 application users in the prod database, do I create at least extracts for each schema? then within each schema, I create multiple extracts to based on datatype or others?
Thanks in advance. 
I have another quetion, in real life migration, our database have a lot clobs datatype, and logsegments, etc. What is the best practice or advices you can give to me?I am probably not the best guy to answer this question.
Can I create multiple extracts on source and multiple replicat on source? Yes.
Let's say we have 10 application users in the prod database, do I create at least extracts for each schema? then within each schema, I create multiple extracts to based on datatype or others?Yes. You can create one Extract/Replicat group per schema. That would help in parallelizing the things.

ERROR  OGG-01201  Error reported by MGR : No available dynamic port entries

Dear All,
I have configured Golden Gate for MySQL on Linux machine.
All my extracts and replicats were running fine but suddenly the initial load extract have started trowing this error:
*2013-02-25 14:30:08 ERROR OGG-01201 Error reported by MGR : No available dynamic port entries.*
*2013-02-25 14:30:08 ERROR OGG-01668 PROCESS ABENDING.*
This is the same configuration that was working fine for many days:
GGSCI>ADD EXTRACT exp1, SOURCEISTABLE
GGSCI>INFO EXTRACT *, TASKS
GGSCI>edit params exp1
EXTRACT exp1
SOURCEDB db#localhost:3306, USERID "******", PASSWORD "******"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTASK REPLICAT, GROUP imp1
TABLE netfors.edr;
--on 31
GGSCI>ADD REPLICAT imp1, SPECIALRUN
GGSCI>edit params imp1
replicat imp1
USERID user, PASSWORD password
SOURCEDEFS /u01/app/oracle/oradata/GG/dirdef/edr.def
DISCARDFILE /u01/app/oracle/oradata/GG/dirrpt/imp1.dsc, PURGE
HANDLECOLLISIONS
MAP "db.edr", TARGET db.SDR_TBLICPRAWEDR, COLMAP (usedefaults,
ICPRE_RAWEDRID=seqno,
ICPRE_SENDER=sender,
ICPRE_RECEIVER=receiver,
ICPRE_ICCARRIERID=incoming,
ICPRE_OGCARRIERID=outgoing,
ICPRE_QUEUE=queue,
NE_ELEMENTID=18,
ICPRE_CREATETIME=createtime,
ICPRE_TIMEOFDAYBEGIN=timeofdaybegin,
ICPRE_TIMEOFDAYEND=timeofdayend,
ICPRE_UPDATETIME=updatetime,
ICPRE_STATE=state,
ICPRE_MODE=mode,
ICPRE_BATCHID=batchid,
ICPRE_REFERENCE=reference,
ICPRE_MSG_REFERENCE=msg_reference,
ICPRE_SEGMENT=segment,
ICPRE_CSMSID=csmsid,
ICPRE_GMSC=gmsc,
ICPRE_IMSI=imsi,
ICPRE_SMPP_MESSAGE_ID=smpp_message_id,
ICPRE_RETRIES=retries,
ICPRE_ELOCATION=elocation,
ICPRE_ECODE1=ecode1,
ICPRE_ECODE2=ecode2,
ICPRE_FLAGS=flags);
Kindly help to resolve this issue.
Thanks, Imran 
Try checking
OGG GGS Error 150: No Dynamic Ports Available [ID 965356.1] 
I can find the help for * No Dynamic Ports Available* but not for No available dynamic port entries
And moreover I don't have access to Meta link :(
I cant find help for the exact Error Code on Google.
Kindly Help, Imran 
Hi Imran,
Are you using DYNAMICPORTLIST parameter in your manager parameter file. Post your manager parameter file and output of below query from target.
send mgr getportinfo detail
Thanks,
Kamal. 
Thanks for your reply and time Kamal.
When i run :
GGSCI (smsc.etisalcom.net) 1> send mgr getportinfo detail
returns
Sending GETPORTINFO, request to MANAGER ...
No Dynamic Ports In Use or Configured
But I have tried with
DYNAMICPORTLIST 7809,7810,7811 7812-7850
But error message was the same.
Current settings for the mgr
GGSCI>edit params mgr
PORT 7813
Regards, Imran 
HI Imran,
In your extract param file i can see manager port is defined as 7809 but in you last mail you mentioned that you are using manager port 7813. Please share exact settings that you are using.
Thanks
Avinash Dubey

Autorestart doubts in OGG

I just had a doubt on Autorestart.
Autorestart
view param mgrport 8813
AUTOSTART EXTRACT L*
AUTOSTART EXTRACT P*
AUTORESTART ER *, RETRIES 5, WAITMINUTES 1, RESETMINUTES 1
When i provide the kill command from OS shell prompt, it got restarted
GGSCI > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING LGG11GG1 00:00:07 00:00:11
EXTRACT RUNNING PGG11GG1 00:00:00 00:00:04
GGSCI () 65> sh cat LGG11GG1.pce
PROGRAM EXTRACT PROCESSID LGG11GG1 PORT PID *5919*
GGSCI () 66> sh kill -9 5919
It got restarted automatically
when i provide the kill command from gg prompt, it wont restart(autorestart) the process (is that due to the manual intervention logged in the ggserr.log file)
GGSCI () 66> kill LGG11GG1
Please throw some light on this one. 
http://linux.about.com/od/commands/l/blcmdl1_kill.htm, that's why.

Categories

Resources