Copy table or append table fails with the following message in the sync log:
"ERROR: connect() returned -1, errno = 146 Connection refused at <path>"
The following example shows the error message as it occurred when running copy but it also applies to append.
A. Copy is launched to sync a table:
sp_ctrl (irvsupu16:5438)> copy user.table1
copy started; job id 8
B. The target table did not get sync'd up. Command "copy status" shows the following:
sp_ctrl (irvsupu16:5438)> copy status
Job ID : 8
Host : irvsupu16
Started : 31-OCT-08 16:31:51
Job Type : Copy
Status : Failed - Launcher not started on target, use "start launcher"
ID Tablename Total Rows %Comp Status Status T
ime Total Time
------ ------------------------------------ ---------- ----- ---------- --------
--- ----------
1 "USER"."TABLE1" 6 Failed
N/A 0:02
C. Sync log shows the following:
Fri Oct 31/16:31:52.391:: SYNC SERVER START: pid = 12189
.
.
Fri Oct 31/16:31:59.772:: Connected to Oracle, 2 OCI connections open
Fri Oct 31/16:31:59.780:: NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
Fri Oct 31/16:31:59.783:: NLS_NCHAR_CHARACTERSET = AL16UTF16
Fri Oct 31/16:32:00.097:: ERROR: connect() returned -1, errno = 146 Connection refused at sync/sys/net/sync_tcp_client.cpp:77
Fri Oct 31/16:32:00.357:: ERROR: Connection to server failed at sync/sys/net/syn
c_tcp_client.cpp:133
Fri Oct 31/16:32:00.357:: ERROR: Cannot connect to target launcher at 10.1.0.156
:2501 at sync/svr/sync_launch_messager.cpp:62
Fri Oct 31/16:32:00.363:: ERROR: Launcher communcation failed at sync/svr/sync_s
erver.cpp:106 at sync/svr/sync_server.cpp:159
Fri Oct 31/16:32:00.468:: Logged off from Oracle, 1 OCI connections open<
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center