Home » Server Options » Replication » Dump Process Abend with "Unable to open file" (GoldenGate 12, oracle )
Dump Process Abend with "Unable to open file" [message #669688] Tue, 08 May 2018 02:21 Go to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi All,

I am testing oracle golden gate configuration for replicating data from Source to Target below is my parameter files for source extract and dpump process.

Problem is :


  1. When Starting in order Extract ext1 first and then Dpump process, then Dpump process got abend with the below error message for Dpump.prm file.

  2. When starting in order Dpump first and then extract ext1 process, Extract ext1 process got abend with the below error message for ext1.prm file.


SOURCE PARAMETER AND PROCESSES

GGSCI (HRMSDBSERVER as ggate@HRMSDB) 197> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     ABENDED     DPUMP       00:00:00      00:36:49
EXTRACT     RUNNING     EXT1        00:00:00      00:00:08

---Manager Process parameter file
PORT 7809
USERID ggate,PASSWORD ggate
PURGEOLDEXTRACTS /u01/app/oracle/product/ggs/dirdat/ex, USECHECKPOINTS
DYNAMICPORTLIST 9101-9111
ACCESSRULE, PROG *, IPADDR 192.168.48.227, ALLOW


- EXT1 Parameter files

EXTRACT ext1
USERID ggate, PASSWORD ggate
--TRANLOGOPIONS INTEGRATEPARAMS(MAX_SGA_SIZE 100)
RMTHOST 192.168.48.227, MGRPORT 7809
EXTTRAIL /u01/app/oracle/product/ggs/dirdat/lt
RMTTRAIL /u01/app/oracle/product/ggs/dirdat/rt
--GETTRUNCATES
--DDL INCLUDE MAPPED
--GETDELETES -IGNOREDELETES
TABLE HRMSADMIN.EMP_CANTEEN_ENTRY;
TABLE HRMSADMIN.LEAVE_REQUEST;

--Dpump Parameter file

EXTRACT DPUMP
USERID ggate, PASSWORD ggate
PASSTHRU
RMTHOST 192.168.48.227, MGRPORT 7809
RMTTRAIL /u01/app/oracle/product/ggs/dirdat/rt

TABLE HRMSADMIN.EMP_CANTEEN_ENTRY;
TABLE HRMSADMIN.LEAVE_REQUEST;

TARGET Parameter and process as following


GGSCI (SERVER) 52> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    STOPPED     REP1        00:00:00      00:59:47



GGSCI (SERVER) 51> view param mgr

PORT 7809
USERID ggate,PASSWORD ggate
ACCESSRULE, PROG *, IPADDR 192.168.48.226, ALLOW


GGSCI (SERVER) 53> view param rep1

REPLICAT rep1
ASSUMETARGETDEFS
USERID ggate, PASSWORD ggate
HANDLECOLLISIONS
--IGNOREDELETES
--IGNOREUPDATES
MAP hrmsadmin.EMP_CANTEEN_ENTRY, TARGET ggadmin.EMP_CANTEEN_ENTRY;
MAP hrmsadmin.LEAVE_REQUEST, TARGET ggadmin.LEAVE_REQUEST;


When I am starting only Extract ext1 process it was running fine, but when I am starting process Dpump on source it's going to Abend with below error.

2018-05-08T12:41:54.353+0530  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, ext1.prm:  Recovery initialization completed for target file /u01/app/oracle/product/ggs/dirdat/lt000000006, at RBA 1512.
2018-05-08T12:41:54.355+0530  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, ext1.prm:  Recovery initialization completed for target file /u01/app/oracle/product/ggs/dirdat/rt000000006, at RBA 1512.
2018-05-08T12:41:54.355+0530  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, ext1.prm:  Output file /u01/app/oracle/product/ggs/dirdat/lt is using format RELEASE 12.3.
2018-05-08T12:41:54.355+0530  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, ext1.prm:  Output file /u01/app/oracle/product/ggs/dirdat/rt is using format RELEASE 12.3.
2018-05-08T12:41:54.438+0530  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, ext1.prm:  Rolling over remote file /u01/app/oracle/product/ggs/dirdat/lt000000006.
2018-05-08T12:41:54.504+0530  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, ext1.prm:  Recovery completed for target file /u01/app/oracle/product/ggs/dirdat/lt000000007, at RBA 1512.
2018-05-08T12:41:54.586+0530  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, ext1.prm:  Rolling over remote file /u01/app/oracle/product/ggs/dirdat/rt000000007.
2018-05-08T12:41:54.975+0530  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, ext1.prm:  Recovery completed for target file /u01/app/oracle/product/ggs/dirdat/rt000000007, at RBA 1512.
2018-05-08T12:41:54.975+0530  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, ext1.prm:  Recovery completed for all targets.
2018-05-08T12:41:55.137+0530  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, ext1.prm:  Position of first record processed Sequence 1442, RBA 54310416, SCN 0.24925867 (24925867), 2018 M05 8 12:41:22.
2018-05-08T12:41:55.554+0530  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2018-05-08T12:41:59.195+0530  INFO    OGG-01888  Oracle GoldenGate Capture for Oracle, dpump.prm:  TCP network is configured as

                                                OS DEFAULT          SPECIFIED           ACTUAL VALUE
                                       IP_DSCP    0                   N/A                 0
                                        IP_TOS    0                   N/A                 0
                                   TCP_NODELAY    0                   N/A                 0
                                  TCP_QUICKACK    1                   N/A                 1
                                      TCP_CORK    0                   N/A                 0
                                     SO_SNDBUF    8192                N/A                 8192
                                     SO_RCVBUF    43690               N/A                 43690.
2018-05-08T12:42:09.207+0530  WARNING OGG-06591  Oracle GoldenGate Capture for Oracle, dpump.prm:  Reading the output trail file /u01/app/oracle/product/ggs/dirdat/rt000000004 encounters an error from position 1,690, rescan from the file header to recover.
2018-05-08T12:42:19.210+0530  ERROR   OGG-01031  Oracle GoldenGate Capture for Oracle, dpump.prm:  There is a problem in the communication with the Collector/Receiver Server. (Reply received is 'Unable to open file "/u01/app/oracle/product/ggs/dirdat/rt000000007" (error 11, Resource temporarily unavailable)').
2018-05-08T12:42:19.210+0530  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, dpump.prm:  PROCESS ABENDING.



can someone please tell me where is the issue in configuration. what should be rectify.

Thanks.
Re: Dump Process Abend with "Unable to open file" [message #669699 is a reply to message #669688] Tue, 08 May 2018 08:31 Go to previous message
pwisman
Messages: 4
Registered: September 2014
Junior Member
You can use either the local extract or the data pump to replicate the data but not both. So if you want to use the data pump then remove the remote references from the local extent parameter files. You will need to delete and recreated all of your processes after you have removed any remote clauses from your creation scripts in the local extent. OR You can just delete the data pump altogether and let the local extent send the data as you have it setup now.

Hope this helps.
Previous Topic: Oracle Golden Gate replication
Next Topic: Replication using Oracle GoldenGate.
Goto Forum:
  


Current Time: Wed Dec 11 00:32:59 CST 2019