Коллеги, привет!
Помогите решить две проблемы:

1. На источнике не работает памп, по логам такая ошибка:

INFO ALL возвращает:
авторEXTRACT RUNNING EPROD 00:00:00 00:00:09
EXTRACT ABENDED PPROD 00:00:00 00:16:19

в логах:
автор2016-09-05 18:03:29 ERROR OGG-01224 Oracle GoldenGate Capture for DB2, pprod.prm: TCP/IP error 111 (В соединении отказано
), endpoint: 10.0.0.2:7810; retries exceeded.
2016-09-05 18:03:29 ERROR OGG-01668 Oracle GoldenGate Capture for DB, pprod.prm: PROCESS ABENDING.

настроено так:
EXTRACT PPROM
SOURCEDB db, USERID user, PASSWORD pass
RMTHOST 10.0.0.2, MGRPORT 7810
RMTTRAIL dirdat/RPROD/PR, MEGABYTES 2000
PURGEOLDEXTRACTS dirdat/PR*, USECHECKPOINTS, MINKEEPFILES 1
TABLE SCHEME.TABLE;


менеджер 10.0.0.2:
авторGGSCI (localhost.localdomain) 17> SEND MANAGER GETPORTINFI
GGSCI (localhost.localdomain) 18> SEND MANAGER GETPORTINFO
Sending GETPORTINFO request to MANAGER ...
Dynamic Port List
Starting Index 0
Entry Port Error Process Assigned Program
----- ----- ----- ---------- ------------------- -------
0 7810 0 27649 2016/08/29 17:32:16 SERVER

GGSCI (localhost.localdomain) 19> SEND MANAGER GETPORTINFO DETAIL
Sending GETPORTINFO, request to MANAGER ...
Dynamic Port List
Starting Index 0
Entry Port Error Process Assigned Program
----- ----- ----- ---------- ------------------- -------
0 7810 0 27649 2016/08/29 17:32:16 SERVER
1 7811 0
2 7812 0
3 7813 0
4 7814 0
5 7815 0
...


$ more ./PPROD.dsc
авторOracle GoldenGate Capture for DB process started, group PPROD discard file opened: 2016-09-05 17:55:39.157313
Process Abending : 2016-09-05 18:03:29


$ more ./PPROD.rpt
автор2016-09-05 17:56:09 WARNING OGG-01223 TCP/IP error 111 (В соединении отказано), endpoint: 10.0.0.2:7810.
2016-09-05 17:58:39 INFO OGG-01971 The previous message, 'WARNING OGG-01223', repeated 3 times.
2016-09-05 18:03:29 INFO OGG-01971 The previous message, 'WARNING OGG-01223', repeated 7 times.
Source Context :
SourceModule : [er.extrout]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150405/oggcore/OpenSys/src/app/er/extrout.c]
SourceFunction : [tcp_send_data]
SourceLine : [1603]
ThreadBacktrace : [13] elements
: [/data/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7ffff539dbc6]]
: [/data/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2af) [0x7ffff5395cef]]
: [/data/ogg/libgglog.so(_MSG_ERR_TCP_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x42) [0x7ffff534a5f2]]
: [/data/ogg/extract(tcp_send_data(extract_def*)+0x2b8) [0x4ee538]]
: [/data/ogg/extract(flush_tcp(extract_def*, unsigned int)+0x3ae) [0x4ef33e]]
: [/data/ogg/extract(RECOVERY_initialize()+0x411) [0x522001]]
: [/data/ogg/extract(extract_main(int, char**)+0x44f) [0x59367f]]
: [/data/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x72121f]]
: [/data/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x71f01a]]
: [/data/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x71ff88]]
: [/data/ogg/extract(main+0x4a) [0x59246a]]
: [/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7ffff1660ec5]]
: [/data/ogg/extract() [0x4bd929]]
2016-09-05 18:03:29 ERROR OGG-01224 TCP/IP error 111 (В соединении отказано), endpoint: 10.0.0.2:7810; retries exceeded.
2016-09-05 18:03:29 ERROR OGG-01668 PROCESS ABENDING.


пинги и телнет на 10.0.0.2 проходят, ранее пробовал на порт 7809 подключаться, но решил на 7810 исходя из инфы на менеджере приемника. Не могу понять почему коннекты не проходят, что можно проверить ещё?







2. На приемнике (10.0.0.2) не работает репликат, по логам такая ошибка:

авторProcess id: 5725
Description:
2016-09-05 18:07:42 WARNING OGG-02904 Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
***********************************************************************
** Running with the following parameters **
***********************************************************************
2016-09-05 18:07:42 INFO OGG-03059 Operating system character set identified as UTF-8.
2016-09-05 18:07:42 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
REPLICAT RPROD
Source Context :
SourceModule : [er.checkpoint]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150384/oggcore/OpenSys/src/app/er/checkpoint.cpp]
SourceFunction : [get_checkpoint_context]
SourceLine : [47]
ThreadBacktrace : [13] elements
: [/data/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f4d145d2dce]]
: [/data/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7f4d145cdae0]]
: [/data/ogg/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x3
1) [0x7f4d145b8991]]
: [/data/ogg/replicat(get_checkpoint_context(time_elt_def*, time_elt_def*)+0x136) [0x570256]]
: [/data/ogg/replicat(readCheckpoint()+0x6d) [0x56f80d]]
: [/data/ogg/replicat(get_infile_params(time_elt_def*, time_elt_def*, char**)+0x5777) [0x581927]]
: [/data/ogg/replicat(replicat_main(int, char**)+0x11c) [0x5bd06c]]
: [/data/ogg/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6905af]]
: [/data/ogg/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104)
[0x6908e4]]
: [/data/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6909eb]]
: [/data/ogg/replicat(main+0x3f) [0x5bc1af]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x30b561ed5d]]
: [/data/ogg/replicat() [0x50da69]]

2016-09-05 18:07:42 ERROR OGG-00446 Could not open checkpoint file /data/ogg/dirchk/RPROD.cpr, mode 1 (error 13, Permission denied).
2016-09-05 18:07:42 ERROR OGG-01668 PROCESS ABENDING.



сам репликат:
# more ./rprod.prm
авторREPLICAT RPROD
USERID user, PASSWORD pass
DISCARDFILE ./dirrpt/rprod.dsc, PURGE
SOURCEDEFS ./dirdef/db.def
PURGEOLDEXTRACTS /zfssa/trail/RPROD/PR*, USECHECKPOINTS, MINKEEPFILES 1
HANDLECOLLISIONS
INSERTMISSINGUPDATES
UPDATEDELETES
...


Большая просьба подсказать, по поводу дисконнекта и отсутствия прав на чекпоинт, спасибо!

up