1 Reply Latest reply: Aug 29, 2013 11:17 PM by vrluna RSS

    OGG-00204,Missing TARGET specification.

    vrluna

      Hi All,

       

      I'm having some issues on my replicat process as I'm encountering this error "OGG-00204, MIssing TARGET specification" when I'm trying to start it,

      my replicat parameter file includes "TARGET" on table mapping, am i missing something? please see below the error log and replicat parameters below.

      i tried googling it but i don't have any luck on finding a solution, please help.

       

      GG version

      Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

      Solaris, x64, 64bit (optimized), Oracle 11g on Apr 24 2012 01:48:54

       

      DB version 11.2.0.1.0

       

       

      ERROR LOG

       

      2013-08-29 21:08:38  INFOOGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start replicat RPGRPA0A.
      2013-08-29 21:08:38  INFOOGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host unknown (START REPLICAT RPGRPA0A ).
      2013-08-29 21:08:38  INFOOGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT RPGRPA0A starting.
      2013-08-29 21:08:39  INFOOGG-00995  Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm:  REPLICAT RPGRPA0A starting.
      2013-08-29 21:08:39  INFOOGG-03035  Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm:  Operating system character set identified as US-ASCII. Locale: en_US_POSIX, LC_ALL:.
      2013-08-29 21:08:39  INFOOGG-00506  Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm:  Both GETTRUNCATES and DDL replication are enabled.
      2013-08-29 21:08:39  INFOOGG-01815  Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm:  Virtual Memory Facilities for: COM
      anon alloc: mmap(MAP_ANON)  anon free: munmap
      file alloc: mmap(MAP_SHARED)  file free: munmap
      target directories:
      /ogg/ggs/dirtmp.
      2013-08-29 21:08:39  INFOOGG-00996  Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm:  REPLICAT RPGRPA0A started.

      2013-08-29 21:08:39  ERROR   OGG-00204  Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm:  Missing TARGET specification.

      2013-08-29 21:08:39  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm:  PROCESS ABENDING.

      -bash-3.00$

       

       

       

      REPLICAT PARAMETER

       

       

       

      REPLICAT RPGRPA0A

      getenv (ORACLE_SID)

      USERID ggs_owner, &

      PASSWORD AADAAAAAAAAAAAJANEMJKFJARJIFTJCHBABBCIBEQJNIGJVFIGQJAGGIHHTHTHAIGIUJPGSDTCOECFVA, &

      ENCRYPTKEY clarityogg

      ASSUMETARGETDEFS

      DBOPTIONS DEFERREFCONST

      DISCARDFILE ./dirout/dscrpgrpa0a.dsc, APPEND

      APPLYNOOPUPDATES

      GETTRUNCATES

       

      --ERROR HANDLING

      REPERROR (-1, EXCEPTION)

      REPERROR (-1403, EXCEPTION)

      DDLERROR DEFAULT IGNORE RETRYOP

       

      --OPTIMIZATION

      BATCHSQL

      GROUPTRANSOPS 2000

       

      --DDL REPLICATION

       

      DDL &

      INCLUDE OBJNAME "SCHEMA2.APRTEMP" &

      INCLUDE OBJNAME "SCHEMA2.AWAIT_TASK4" &

      INCLUDE OBJNAME "SCHEMA2.BASH_CUSTOMER_RBG" &

      INCLUDE OBJNAME "SCHEMA2.BC_CBG" &

      EXCLUDE INSTR 'AS SELECT'

       

      --TABLE REPLICATION

       

      SEQUENCE SCHEMA2.*;

      MAP SCHEMA1.APRTEMP, TARGET SCHEMA2.APRTEMP;

      MAP SCHEMA1.AWAIT_TASK4, TARGET SCHEMA2.AWAIT_TASK4;

      MAP SCHEMA1.BASH_CUSTOMER_RBG, TARGET SCHEMA2.BASH_CUSTOMER_RBG;

      MAP SCHEMA1.BC_CBG, TARGET SCHEMA2.BC_CBG;

       

       

      Thanks a lot

       

      Villy