GoldenGate DDL Replication setup error
Hi,
I am using Goldengate V11 on Windows 2003 server for Oracle 10g Source & Target. DML replication is working fine. But when I run script for DDL replication, I experience the following error please advice.
SQL> @D:\OracleGGSource\ddl_setup.sql
GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
Checking user sessions...
Check complete.
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, i
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:gg
You will be prompted for the mode of installation.
To install or reinstall DDL replication, enter INITIALSETUP
To upgrade DDL replication, enter NORMAL
Enter mode of installation:INITIALSETUP
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Using GG as a GoldenGate schema name, INITIALSETUP as a mode of installation.
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 GG
DDLORA_GETTABLESPACESIZE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
No errors No errors
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
---------- -----------------------------------------------------------------
1394/13 PL/SQL: Statement ignored
1394/23 PLS-00201: identifier 'GG.DDLVERSIONSPECIFIC' must be declared
1498/13 PL/SQL: Statement ignored
1498/23 PLS-00201: identifier 'GG.DDLVERSIONSPECIFIC' must be declared
1621/29 PL/SQL: Statement ignored
1622/85 PLS-00201: identifier 'UKC.COLNAME' must be declared
1625/33 PL/SQL: Statement ignored
1625/99 PLS-00201: identifier 'UKC.COLNAME' must be declared
2255/20 PLS-00201: identifier 'DDLORA_GETTABLESPACESIZE' must be declared
2255/9 PL/SQL: Statement ignored
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:
Line/pos Error
---------- -----------------------------------------------------------------
161/22 PLS-00201: identifier 'GG.DDLORA_GETBINOBJECTCOUNT' must be
declared
161/9 PL/SQL: Statement ignored
863/9 PL/SQL: Statement ignored
864/72 PLS-00201: identifier 'GG.DDLORA_GETERRORSTACK' must be declared
915/13 PL/SQL: Statement ignored
917/59 PLS-00201: identifier 'GG.DDLORA_GETERRORSTACK' must be declared
953/17 PL/SQL: Statement ignored
956/90 PLS-00201: identifier 'GG.DDLORA_GETERRORSTACK' must be declared
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
-----------------------------------
ENABLED
STAYMETADATA IN TRIGGER
-----------------------------------
OFF
DDL TRIGGER SQL TRACING
-----------------------------------
0
DDL TRIGGER TRACE LEVEL
-----------------------------------
0
LOCATION OF DDL TRACE FILE
--------------------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP/ggs_ddl_trace.log
Analyzing installation status...
STATUS OF DDL REPLICATION
--------------------------------------------------------------------------------
ERRORS detected in installation of DDL Replication software components (6)
Script complete.
SQL>
Thanks & Regards,
Noman.