0 Replies Latest reply: Mar 7, 2013 1:45 AM by 993159 RSS

    replicat process abending with  ORA-00955

    993159
      Hi,

      below is the error i m receiving while doing GG replication on target by replicate process
      2013-03-07 13:01:59  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rep1.prm:  REPLICAT REP1 started.
      2013-03-07 13:01:59  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Setting current schema for DDL operation to [TESTUSER].
      2013-03-07 13:01:59  ERROR   OGG-00517  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is already used by an exist
      ing object SQL create table TESTUSER."TEST" ( name varchar2(30))  /* GOLDENGATE_DDL_REPLICATION */], because it's not included in error handling.
      2013-03-07 13:01:59  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep1.prm:  PROCESS ABENDING.
      Souce : 10.2.0.4
      -------------------------------
      GGSCI (prod.naveed.com) 6> info all
      
      Program     Status      Group       Lag at Chkpt  Time Since Chkpt
      
      MANAGER     RUNNING                                           
      EXTRACT     RUNNING     DPUMP       00:00:00      00:00:47    
      EXTRACT     RUNNING     EXT1        00:00:40      00:00:07    
      
      
      GGSCI (prod.naveed.com) 15> view params ext1
      
      EXTRACT ext1
      USERID ggs_owner, PASSWORD ggs_owner
      EXTTRAIL /u01/GG/dirdat/lt
      DDL INCLUDE ALL
      DDLOPTIONS ADDTRANDATA
      ddloptions report, ignorereplicates
      TABLE TESTUSER.*;
      
      
      GGSCI (prod.naveed.com) 16> view params dpump
      
      EXTRACT dpump
      USERID ggs_owner, PASSWORD ggs_owner
      RMTHOST 192.168.1.9, MGRPORT 7809
      RMTTRAIL /u05/GG/dirdat/rt
      PASSTHRU
      TABLE TESTUSER.*;
      Target: 11.2.0.3 DB
      ----------------------------------
      GGSCI (rhel5.4_prod) 15> info all
      
      Program     Status      Group       Lag at Chkpt  Time Since Chkpt
      
      MANAGER     RUNNING                                           
      REPLICAT    ABENDED     REP1        00:00:00      00:12:06    
      
      
      GGSCI (rhel5.4_prod) 16> view params rep1
      
      REPLICAT rep1
      USERID ggs_owner, PASSWORD ggs_owner
      ASSUMETARGETDEFS
      DISCARDFILE /u05/GG/dirrpt/rolap01.dsc, PURGE
      ddlerror 955 discard include optype DROP
      -- This starts the macro
      MACRO #exception_handler
      BEGIN
      , TARGET ggs_owner.exceptions
      , COLMAP ( rep_name = "RTARGET1"
      , table_name = @GETENV ("GGHEADER", "TABLENAME")
      , errno = @GETENV ("LASTERR", "DBERRNUM")
      , dberrmsg = @GETENV ("LASTERR", "DBERRMSG")
      , optype = @GETENV ("LASTERR", "OPTYPE")
      , errtype = @GETENV ("LASTERR", "ERRTYPE")
      , logrba = @GETENV ("GGHEADER", "LOGRBA")
      , logposition = @GETENV ("GGHEADER", "LOGPOSITION")
      , committimestamp = @GETENV ("GGHEADER", "COMMITTIMESTAMP"))
      , INSERTALLRECORDS
      , EXCEPTIONSONLY;
      END;
      -- This ends the macro
      REPERROR (DEFAULT, EXCEPTION)
      REPERROR (DEFAULT2, ABEND)
      REPERROR (-1, EXCEPTION)
      MAP TESTUSER.*, TARGET TESTUSER.*;
      MAP TESTUSER.* #exception_handler();