12 Replies Latest reply: Jan 18, 2014 9:07 PM by user296828 RSS

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

1000662 Newbie
Currently Being Moderated

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.