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 INFO | OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start replicat RPGRPA0A. |
| 2013-08-29 21:08:38 INFO | OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host unknown (START REPLICAT RPGRPA0A ). |
| 2013-08-29 21:08:38 INFO | OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RPGRPA0A starting. |
| 2013-08-29 21:08:39 INFO | OGG-00995 Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm: REPLICAT RPGRPA0A starting. |
| 2013-08-29 21:08:39 INFO | OGG-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 INFO | OGG-00506 Oracle GoldenGate Delivery for Oracle, rpgrpa0a.prm: Both GETTRUNCATES and DDL replication are enabled. |
| 2013-08-29 21:08:39 INFO | OGG-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 INFO | OGG-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