Oracle Database 12.1.0.2
Hello Team,
can you please advise why data pump is failing?
2019-08-12T16:35:29.992+0400 WARNING OGG-01842 Oracle GoldenGate Capture for Oracle, pxdwn.prm: CACHESIZE PER DYNAMIC DETERMINATION (60.10G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 68.10G
Check swap space. Recommended swap/extract: 128G (64bit system).
2019-08-12T16:35:30.890+0400 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, pxdwn.prm: EXTRACT PXDWN started.
2019-08-12T16:35:30.891+0400 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, pxdwn.prm: TCP/IP error 146 (Connection refused), endpoint: proddb-scan:7809.
2019-08-12T16:35:30.908+0400 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pxdwn.prm: PROCESS ABENDING.
MGR:
PORT 7809
DYNAMICPORTLIST 20000-20099
PURGEOLDEXTRACTS ./dirdat/aa* , USECHECKPOINTS, MINKEEPHOURS 72
PURGEOLDEXTRACTS ./dirdat/cb*, USECHECKPOINTS, MINKEEPHOURS 72
AUTORESTART ER *, RETRIES 3, WAITMINUTES 10, RESETMINUTES 60
DOWNREPORTMINUTES 15
--DOWNCRITICAL
LAGCRITICALSECONDS 10
LAGINFOMINUTES 0
LAGREPORTMINUTES 15
EXTDWH:
EXTRACT EXTDWH
USERIDALIAS oggscb_dwh
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
--DDL INCLUDE ALL
--FETCHOPTIONS FETCHPKUPDATECOLS
TRANLOGOPTIONS MININGUSERALIAS oraggext
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
TRANLOGOPTIONS INCLUDEREGIONID
EXTTRAIL /ogg/ora12c/dirdat/aa
--CACHEMGR CACHEDIRECTORY /ogg/ora12c/dirtmp
--BR BRDIR /ogg/ora12c/BR
--TABLE CBS_CORE.CB_USERS,keycols(LOGIN_NAME_V, APPLICATION_ID_N);
TABLE CBS_CORE.CB_INSTALLMENT;
TABLE CBS_CORE.CB_INSTALLMENT_DTLS;
TABLE CBS_CORE.cb_serv_installment_dtls;
TABLE CBS_CORE.cb_subs_deposits;
TABLE CBS_CORE.cb_bill_cycle;
TABLE CBS_CORE.cb_order_request_dtls;
TABLE CBS_CORE.CB_WORK_ORDER;
TABLE CBS_CORE.WF_WRKFLWMGR;
....
Please advise.
Regards,
Joe