Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data pump fails

RobeenAug 12 2019 — edited Aug 13 2019

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

Comments

Post Details

Added on Aug 12 2019
10 comments
146 views