This discussion is archived
1 Reply Latest reply: Aug 29, 2013 9:17 PM by vrluna RSS

OGG-00204,Missing TARGET specification.

vrluna Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points