ORA-00955: /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

While starting replicats over target database server I met with following error.

2013-07-30 16:57:23  ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, tar_rep1.prm:  Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is already used by an existing object, SQL create table GG as select * from test  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

GGSCI (target.cybage.com) 41> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     TAR_DPMP    00:00:00      00:00:07

EXTRACT     RUNNING     TAR_EXT     00:00:00      00:00:00

REPLICAT    ABENDED     TAR_REP1    00:00:00      00:02:17

REPLICAT    ABENDED     TAR_REP2    00:00:00      00:11:46

REPLICAT    RUNNING     TAR_REP3    06:12:37      00:00:32

excerpts from log file.

2013-07-30 16:57:17  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT TAR_REP3 starting.

2013-07-30 16:57:17  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, tar_rep1.prm:  REPLICAT TAR_REP1 starting.

2013-07-30 16:57:18  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, tar_rep2.prm:  REPLICAT TAR_REP2 starting.

2013-07-30 16:57:18  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, tar_rep3.prm:  REPLICAT TAR_REP3 starting.

2013-07-30 16:57:23  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, tar_rep1.prm:  REPLICAT TAR_REP1 started.

2013-07-30 16:57:23  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, tar_rep1.prm:  Setting current schema for DDL operation to [SCOTT].

2013-07-30 16:57:23  ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, tar_rep1.prm:  Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is already used by an existing object, SQL create table GG as select * from test  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

2013-07-30 16:57:23  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, tar_rep1.prm:  PROCESS ABENDING.

2013-07-30 16:57:23  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, tar_rep2.prm:  REPLICAT TAR_REP2 started.

2013-07-30 16:57:23  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, tar_rep3.prm:  REPLICAT TAR_REP3 started.

2013-07-30 16:57:23  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, tar_rep2.prm:  Setting current schema for DDL operation to [SCOTT].

2013-07-30 16:57:24  ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, tar_rep2.prm:  Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is already used by an existing object, SQL create table sal as select * from test  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

2013-07-30 16:57:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, tar_rep2.prm:  PROCESS ABENDING.

========================================================================  

GGSCI (target.cybage.com) 36> view report TAR_REP1

***********************************************************************

                 Oracle GoldenGate Delivery for Oracle

     Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100

   Linux, x86, 32bit (optimized), Oracle 11g on Oct  7 2011 15:40:15

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2013-07-30 16:57:17

***********************************************************************

Operating System Version:

Linux

Version #1 SMP Mon Mar 29 20:06:41 EDT 2010, Release 2.6.18-194.el5

Node: target.cybage.com

Machine: i686

                         soft limit   hard limit

Address Space Size   :    unlimited    unlimited

Heap Size            :    unlimited    unlimited

File Size            :    unlimited    unlimited

CPU Time             :    unlimited    unlimited

Process id: 8553

Description:

***********************************************************************

**            Running with the following parameters                  **

***********************************************************************

replicat tar_rep1

userid gger, password ****

handlecollisions

assumetargetdefs

discardfile /u01/app/GG/dirrpt/tar_rep.dsc, append

map SCOTT.BONUS, target SCOTT.BONUS;

map SCOTT.CYB, target SCOTT.CYB;

map  SCOTT.DEPT, target SCOTT.DEPT;

CACHEMGR virtual memory values (may have been adjusted)

CACHEBUFFERSIZE:                         64K

CACHESIZE:                              512M

CACHEBUFFERSIZE (soft max):               4M

CACHEPAGEOUTSIZE (normal):                4M

PROCESS VM AVAIL FROM OS (min):           1G

CACHESIZEMAX (strict force to disk):    881M

Database Version:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

PL/SQL Release 11.2.0.3.0 - Production

CORE    11.2.0.3.0      Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Database Language and Character Set:

NLS_LANG environment variable specified has invalid format, default value will be used.

NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.

NLS_LANGUAGE     = "AMERICAN"

NLS_TERRITORY    = "AMERICA"

NLS_CHARACTERSET = "WE8MSWIN1252"

Warning: your NLS_LANG setting does not match database server language setting.

Please refer to user manual for more information.

***********************************************************************

**                     Run Time Messages                             **

***********************************************************************

Opened trail file dirdat/l2000001 at 2013-07-30 16:57:23

2013-07-30 16:57:23  INFO    OGG-01407  Setting current schema for DDL operation to [SCOTT].

Source Context :

  SourceModule            : [ggapp.ddl]

  SourceID                : [/scratch/mmar/view_storage/mmar_111112_tier3/oggcore/OpenSys/src/gglib/ggapp/ddlrep.c]

  SourceFunction          : [DDLREP_handleDDLError]

  SourceLine              : [500]

  ThreadBacktrace         : [11] elements

                          : [/u01/app/GG/replicat(CMessageContext::AddThreadContext()+0x26) [0x8215846]]

                          : [/u01/app/GG/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x817) [0x820bf97]]

                          : [/u01/app/GG/replicat(_MSG_ERR_DDL_ABEND_NO_HANDLER(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x81) [0x8

1c6bf1]]

                          : [/u01/app/GG/replicat(DDLREP_handleDDLError(char const*, char const*, char const*, char*, int, RepConfig_t*, char const*, char co

nst*, char const*, DBString<258>&, DBString<258>&, long*)+0x8a6) [0x84466e8]]

                          : [/u01/app/GG/replicat [0x8448021]]

                          : [/u01/app/GG/replicat(DDLREP_process(char*, __std_rec_hdr*, unsigned short)+0x23e1) [0x8452597]]

                          : [/u01/app/GG/replicat [0x84f4c7a]]

                          : [/u01/app/GG/replicat [0x84f98e0]]

                          : [/u01/app/GG/replicat(main+0x826) [0x8137206]]

                          : [/lib/libc.so.6(__libc_start_main+0xdc) [0x9fde9c]]

                          : [/u01/app/GG/replicat(__gxx_personality_v0+0x1b9) [0x8113711]]

2013-07-30 16:57:23  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is already used by an existing object

, SQL create table GG as

select * from test  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

***********************************************************************

*                   ** Run Time Statistics **                         *

***********************************************************************

Reading dirdat/l2000001, current RBA 1176, 0 records

Report at 2013-07-30 16:57:23 (activity since 2013-07-30 16:57:17)

DDL replication statistics:

                    Operations:         1

             Mapped operations:         0

           Unmapped operations:         1

              Other operations:         0

           Excluded operations:         0

                        Errors:         1

                Retried errors:         0

              Discarded errors:         0

                Ignored errors:         0

No records were replicated.

Last log location read:

     FILE:      dirdat/l2000001

     SEQNO:     1

     RBA:       1176

     TIMESTAMP: 2013-07-25 18:42:34.968578

     EOF:       NO

     READERR:   0

2013-07-30 16:57:23  ERROR   OGG-01668  PROCESS ABENDING.

Solution.

I append the following parameters in my Replicat parameter and it worked for me.

GGSCI (target.cybage.com) 18> edit params TAR_REP1

replicat tar_rep1

userid gger, password gger

handlecollisions

assumetargetdefs

discardfile /u01/app/GG/dirrpt/tar_rep.dsc, append

gettruncates

ddl include mapped

map SCOTT.BONUS, target SCOTT.BONUS;

map SCOTT.CYB, target SCOTT.CYB;

map  SCOTT.DEPT, target SCOTT.DEPT;

GGSCI (target.cybage.com) 19> edit params TAR_REP2

replicat tar_rep2

userid gger, password gger

handlecollisions

assumetargetdefs

discardfile /u01/app/GG/dirrpt/tar_rep.dsc, append

gettruncates

ddl include mapped

map SCOTT.EMP, target SCOTT.EMP;

map SCOTT.EXT, target SCOTT.EXT;

map  SCOTT.GG, target SCOTT.GG;

GGSCI (target.cybage.com) 13> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     TAR_DPMP    00:00:00      00:00:03

EXTRACT     RUNNING     TAR_EXT     00:00:00      00:00:04

REPLICAT    RUNNING     TAR_REP1    00:00:00      00:00:04

REPLICAT    RUNNING     TAR_REP2    00:00:00      00:00:05

REPLICAT    RUNNING     TAR_REP3    05:56:47      00:09:51

Cheers!!!