Initial Load issue in 12c.
-- Report error.
2018-10-28 10:08:02 ERROR OGG-01033 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is /u01/app/oracle/product/ogg/dirdat/initload.dat, reply received is Failed resolving output file /u01/app/oracle/product/ogg/dirdat/initload.dat (error: 2, No such file or directory)).
2018-10-28 10:08:02
2018-10-28 10:08:02
ERROR OGG-01668 PROCESS ABENDING.
-- Solution.
This error will come in goldengate version 12.2, as new parameter ALLOWOUTPUTDIR has been introduced , which need to be added in ./GLOBALS file on target .
syntax – ALLOWOUTPUTDIR [ path of the remote trail location]
1. stop the manager and the replicates
ggsci> stop mgr
ggsci> stop *
ggsci> edit params ./GLOBAL <-------------------- Put the parameter ALLOWOUTPUTDIR
2. edit the ./GLOBAL
ALLOWOUTPUTDIR /u01/ogg/dirdat/
3. stat mgr and replicates
ggsci> start mgr
ggsci> start *
3. stat mgr and replicates
ggsci> start mgr
ggsci> start *
-- Source
./extract <param_file> <report_file> for checking any issue before deploying automate.
1 comment:
You have done very special content
Post a Comment