4 Replies Latest reply: Sep 17, 2013 8:38 PM by 1000662 RSS

    DDL script

    Annamalai A
      Hi ,

      I'm trying to setup DDL replication,
      for this i have followed the below forum thread detail, Which is provided by Steven,

      Re: GoldenGate DDL Replication setup error

      while running the ddl_setup script i'm getting the below error message and i unable to use create command in my DB

      SQL> create table test (h number(5));
      create table test (h number(5))
      *
      ERROR at line 1:
      ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed
      re-validation


      Script error:


      Line/pos
      ----------------------------------------
      Error
      -----------------------------------------------------------------
      260/21
      PL/SQL: Statement ignored

      260/30
      PLS-00905: object GGREP.TRACE_PUT_LINE is invalid

      59/9
      PL/SQL: SQL Statement ignored


      Line/pos
      ----------------------------------------
      Error
      -----------------------------------------------------------------
      61/23
      PL/SQL: ORA-00942: table or view does not exist

      66/21
      PL/SQL: ORA-02289: sequence does not exist

      66/5
      PL/SQL: SQL Statement ignored


      Line/pos
      ----------------------------------------
      Error
      -----------------------------------------------------------------
      70/18
      PLS-00905: object GGREP.TRACE_PUT_LINE is invalid

      70/9
      PL/SQL: Statement ignored





      DDL TRIGGER INSTALL STATUS
      -----------------------------------
      OK

      DDL TRIGGER RUNNING STATUS
      -----------------------------------------------------------------------------

      ENABLED
      FROM "GGREP" ."GGS_SETUP"
      *
      ERROR at line 2:
      ORA-00942: table or view does not exist


      FROM "GGREP" ."GGS_SETUP"
      *
      ERROR at line 2:
      ORA-00942: table or view does not exist


      FROM "GGREP" ."GGS_SETUP"
      *
      ERROR at line 2:
      ORA-00942: table or view does not exist



      LOCATION OF DDL TRACE FILE
      -----------------------------------------------------------------------------

      F:\ORACLE\APP\ORACLE\ADMIN\XE\UDUMP/ggs_ddl_trace.log

      Analyzing installation status...


      STATUS OF DDL REPLICATION
      -----------------------------------------------------------------------------

      ERRORS detected in installation of DDL Replication software components (3)

      Script complete.



      Can you please guide me to fix this issue?

      Edited by: Atp on May 18, 2011 4:49 PM