Sunday, September 25, 2016

Extract process abended

Error:

GGSCI (test.domain.com) 4> start EXTRACT EXT1

Sending START request to MANAGER ...

ERROR: Cannot create process '/home/oracle/gg11g/extract'. Child process is no longer alive
.

2016-09-25 12:09:00  WARNING OGG-01742  Command sent to MGR MGR returned with an ERROR response.



Solution:

SYS@oem> select FORCE_LOGGING,
  2  SUPPLEMENTAL_LOG_DATA_MIN from v$database;

FOR SUPPLEME
--- --------
NO  NO

SYS@oem> alter database force logging;

Database altered.

SYS@oem> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Database altered.

SYS@oem>  select FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN from v$database;

FOR SUPPLEME
--- --------
YES YES