12 Replies Latest reply: Jan 18, 2014 11:07 PM by 12cdb RSS

    When i run the "@ddl_setup.sql" on one node of the 11gr2rac get errors

    1000662

      I want open DDL replicate from source node ,so i run

      SQL> @marker_setup

       

      Marker setup script

       

      You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

      NOTE: The schema must be created prior to running this script.

      NOTE: Stop all DDL replication before starting this installation.

       

      Enter Oracle GoldenGate schema name:ogg

       

       

      Marker setup table script complete, running verification script...

      Please enter the name of a schema for the GoldenGate database objects:

      Setting schema name to OGG

       

      MARKER TABLE

      -------------------------------

      OK

       

      MARKER SEQUENCE

      -------------------------------

      OK

       

      When i run the "@ddl_setup.sql" on one node of the 11gr2rac get errors

       

      SQL> @ddl_setup.sql

       

      Oracle GoldenGate DDL Replication setup script

       

      Verifying that current user has privileges to install DDL Replication...

       

      You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

      NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.

      NOTE: The schema must be created prior to running this script.

      NOTE: Stop all DDL replication before starting this installation.

       

      Enter Oracle GoldenGate schema name:ogg

       

      Working, please wait ...

      Spooling to file ddl_setup_spool.txt

       

      Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

       

      Check complete.

       

       

       

       

       

       

       

      Using OGG as a Oracle GoldenGate schema name.

       

      Working, please wait ...

       

      DDL replication setup script complete, running verification script...

      Please enter the name of a schema for the GoldenGate database objects:

      Setting schema name to OGG

       

      CLEAR_TRACE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      CREATE_TRACE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      TRACE_PUT_LINE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      INITIAL_SETUP STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      DDLVERSIONSPECIFIC PACKAGE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      DDLREPLICATION PACKAGE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      DDLREPLICATION PACKAGE BODY STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      1453/9 PL/SQL: SQL Statement ignored

      1455/23 PL/SQL: ORA-00942: table or view does not exist

      1464/9 PL/SQL: SQL Statement ignored

      1466/23 PL/SQL: ORA-00942: table or view does not exist

      1478/9 PL/SQL: SQL Statement ignored

      1480/23 PL/SQL: ORA-00942: table or view does not exist

      1485/9 PL/SQL: SQL Statement ignored

      1487/23 PL/SQL: ORA-00942: table or view does not exist

      1492/9 PL/SQL: SQL Statement ignored

      1494/23 PL/SQL: ORA-00942: table or view does not exist

      1499/9 PL/SQL: SQL Statement ignored

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      1501/23 PL/SQL: ORA-00942: table or view does not exist

      1581/4 PL/SQL: SQL Statement ignored

      1582/18 PL/SQL: ORA-00942: table or view does not exist

      1584/4 PL/SQL: SQL Statement ignored

      1585/18 PL/SQL: ORA-00942: table or view does not exist

      1600/25 PL/SQL: ORA-00942: table or view does not exist

      1600/4 PL/SQL: SQL Statement ignored

      1602/25 PL/SQL: ORA-00942: table or view does not exist

      1602/4 PL/SQL: SQL Statement ignored

       

       

      DDL IGNORE TABLE

      -----------------------------------

      FAILED: Table does not exist

       

      DDL IGNORE LOG TABLE

      -----------------------------------

      FAILED: Table does not exist

       

      DDLAUX PACKAGE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      DDLAUX PACKAGE BODY STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      0/0 PL/SQL: Compilation unit analysis terminated

      1/21 PLS-00304: cannot compile body of 'DDLAUX' without its

        specification

       

      1/21 PLS-00905: object OGG.DDLAUX is invalid

       

       

      SYS.DDLCTXINFO PACKAGE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      SYS.DDLCTXINFO PACKAGE BODY STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      No errors No errors

       

      DDL HISTORY TABLE

      -----------------------------------

      FAILED: Table does not exist

       

      DDL HISTORY TABLE(1)

      -----------------------------------

      FAILED: Table does not exist

       

      DDL DUMP TABLES

      -----------------------------------

      FAILED: Table does not exist

       

      DDL DUMP COLUMNS

      -----------------------------------

      FAILED: Table does not exist

       

      DDL DUMP LOG GROUPS

      -----------------------------------

      FAILED: Table does not exist

       

      DDL DUMP PARTITIONS

      -----------------------------------

      FAILED: Table does not exist

       

      DDL DUMP PRIMARY KEYS

      -----------------------------------

      FAILED: Table does not exist

       

      DDL SEQUENCE

      -----------------------------------

      FAILED: Sequence does not exist

       

      GGS_TEMP_COLS

      -----------------------------------

      FAILED: Table does not exist

       

      GGS_TEMP_UK

      -----------------------------------

      FAILED: Table does not exist

       

      DDL TRIGGER CODE STATUS:

       

      Line/pos Error

      -------------------- -----------------------------------------------------------------

      126/9 PL/SQL: SQL Statement ignored

      128/23 PL/SQL: ORA-00942: table or view does not exist

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

      133/5 PL/SQL: SQL Statement ignored

      657/14 PLS-00905: object OGG.DDLAUX is invalid

      657/5 PL/SQL: Statement ignored

      919/25 PL/SQL: ORA-00942: table or view does not exist

      919/4 PL/SQL: SQL Statement ignored

       

       

      DDL TRIGGER INSTALL STATUS

      -----------------------------------

      OK

       

      DDL TRIGGER RUNNING STATUS

      ----------------------------------------------------------------------

      ENABLED

      FROM "OGG" ."GGS_SETUP"

        *

      ERROR at line 2:

      ORA-00942: table or view does not exist

       

       

      FROM "OGG" ."GGS_SETUP"

        *

      ERROR at line 2:

      ORA-00942: table or view does not exist

       

       

      FROM "OGG" ."GGS_SETUP"

        *

      ERROR at line 2:

      ORA-00942: table or view does not exist

       

       

       

      LOCATION OF DDL TRACE FILE

      ------------------------------------------------------------------------------------------------------------------------

      /home/data/app/oracle/diag/rdbms/appstore/appstore2/trace/ggs_ddl_trace.log

       

      Analyzing installation status...

       

       

      STATUS OF DDL REPLICATION

      ------------------------------------------------------------------------------------------------------------------------

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

       

      Script complete.