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!

OGG-10144 at golden gate initial data with file to replicat method

user12996446Aug 27 2019 — edited Aug 27 2019

The extract process has generated a trail file at the target side, then I go to start replicat process

[oracle@rhel6u5x64 ogg_home]$ ls -l dirdat/initld

-rw-r----- 1 oracle oinstall 1736312 Aug 26 14:09 dirdat/initld

GGSCI (rhel6u5x64) 1> view param initrep1

REPLICAT initrep1

SPECIALRUN

SETENV (ORACLE_HOME='/u01/app/oracle/12.2.0/db_1')

SETENV (ORACLE_SID='cxy')

USERID ggadmin, password ggadmin

ASSUMETARGETDEFS        

EXTFILE ./dirdat/initld    

MAP a.*, TARGET a.*;      

END RUNTIME    

GGSCI (rhel6u5x64) 4> add replicat initrep1, specialrun

REPLICAT added.

GGSCI (rhel6u5x64) 2> start initrep1

Sending START request to MANAGER ...

REPLICAT INITREP1 starting

Then I got these error messages:

2019-08-27T13:17:38.070+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start initrep1.

2019-08-27T13:17:38.071+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [10.0.0.101]:10174 (START REPLICAT INITREP1 ).

2019-08-27T13:17:38.071+0800  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT INITREP1 starting.

2019-08-27T13:17:38.172+0800  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, initrep1.prm:  REPLICAT INITREP1 starting.

2019-08-27T13:17:38.174+0800  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle, initrep1.prm:  Operating system character set identified as UTF-8.

2019-08-27T13:17:38.174+0800  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle, initrep1.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2019-08-27T13:17:38.174+0800  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, initrep1.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/12.2.0/db_1.

2019-08-27T13:17:38.174+0800  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, initrep1.prm:  Successfully set environment variable ORACLE_SID=cxy.

2019-08-27T13:17:38.215+0800  ERROR   OGG-10144  Oracle GoldenGate Delivery for Oracle, initrep1.prm:  (initrep1.prm) line 2: Parameter [SPECIALRUN] is not valid for this configuration.

2019-08-27T13:17:38.215+0800  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, initrep1.prm:  PROCESS ABENDING.

This post has been answered by ORASCN on Aug 27 2019
Jump to Answer
Comments
Post Details
Added on Aug 27 2019
5 comments
1,879 views