Cannot start EXTRACT - OGG-01742 is reported
vsvsJan 22 2013 — edited Jan 23 2013Hi,
I've configured, added and registered EXTRACT process, but when I try to start it i receive an error:
GGSCI (TEST-SRV1) 6> START EXTRACT extr
Sending START request to MANAGER ('GGSMGR') ...
ERROR: Cannot create process 'extract'. Child process is no longer alive
.
2013-01-22 15:56:22 WARNING OGG-01742 Command sent to MGR MGR returned with an
ERROR response.
When i try
GGSCI (TEST-SRV1) 8> view report extr
ERROR: REPORT file EXTR does not exist.
GGSCI (TEST-SRV1) 9>
The mgr report contains the following:
2013-01-22 15:53:59 INFO OGG-00983 Manager started (port 7809).
2013-01-22 15:56:17 INFO OGG-00963 Command received from GGSCI on host TEST
-SRV1 (START EXTRACT EXTR ).
2013-01-22 15:56:22 INFO OGG-00975 client_start_er_prog failed.
What could be the cause of the problem? I cannot find anything relevant both at support.oracle.com and google
The extract process was successfully added with the command
ADD EXTRACT extr , INTEGRATED TRANLOG, BEGIN NOW
Then it was successfully registered:
GGSCI (TEST-SRV1) 5> REGISTER EXTRACT extr DATABASE
2013-01-22 15:55:48 INFO OGG-02003 Extract EXTR successfully registered wit
h database at SCN 1004025.
The exttrail was also created successfully
ADD EXTTRAIL C:\Goldengate\dirdat\t*, EXTRACT extr
The parameter file for extract is:
EXTRACT extr
USERID GGEXTRACT,
PASSWORD AACAAAAAAAAAAAEANJEILEYAOIUJKDTA &
BLOWFISH, ENCRYPTKEY GGKEY
ENCRYPTTRAIL BLOWFISH, KEYNAME GGKEY
EXTTRAIL C:\Goldengate\dirdat\t*
DDL INCLUDE ALL
TABLE DEPO.*;
TABLE DEPO_ARCH.*;
TABLE DEPO_RPT.*;
TABLEEXCLUDE DEPO.TMP*;
TABLEEXCLUDE DEPO.*_D;
TABLEEXCLUDE DEPO.SQL*;
SEQUENCE DEPO.VID;
SEQUENCE DEPO.LOG_SEQ;