OGG-00529 Oracle GoldenGate Capture for Oracle, lsrcet.prm: DDL Replication is enabled but table ggs_owner.GGS_DDL_HIST is not found. Please check DDL installation in the database





OGG-00529  Oracle GoldenGate Capture for Oracle, lsrcet.prm:  DDL Replication is enabled but table ggs_owner.GGS_DDL_HIST is not found. Please check DDL installation in the database


DDL support scripts should be run in source database:


GGSCI (dbhost01.domain.com) 11> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt


MANAGER     RUNNING
EXTRACT     RUNNING     DPUMP1      00:00:00      00:00:04
EXTRACT     STOPPED     EXT1        00:00:00      00:31:08

REPLICAT    RUNNING     REP1        00:00:00      00:00:08

SQL> alter system set recyclebin=off scope=spfile;

System altered.

cd $GG_HOME
[oracle@dbhost01 oggcore_1]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 13 14:15:16 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @marker_setup.sql

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:gguser

Marker setup table script complete, running verification script…
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGUSER

MARKER TABLE
——————————-
OK

MARKER SEQUENCE
——————————-
OK

Script complete.
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:gguser

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.

WARNING: Tablespace GGUSER01 does not have AUTOEXTEND enabled.

Using GGUSER 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 GGUSER

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
———- —————————————————————–
No errors  No errors

DDL IGNORE TABLE
———————————–
OK

DDL IGNORE LOG TABLE
———————————–
OK

DDLAUX  PACKAGE STATUS:

Line/pos   Error
———- —————————————————————–
No errors  No errors

DDLAUX PACKAGE BODY STATUS:

Line/pos   Error
———- —————————————————————–
No errors  No errors

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
———————————–
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
———- —————————————————————–
No errors  No errors

DDL TRIGGER INSTALL STATUS
———————————–
OK

DDL TRIGGER RUNNING STATUS
———————————–
ENABLED

STAYMETADATA IN TRIGGER
———————————–
OFF

DDL TRIGGER SQL TRACING
———————————–
0

DDL TRIGGER TRACE LEVEL
———————————–
NONE

LOCATION OF DDL TRACE FILE
————————————————————————————————————————
/u02/app/oracle/product/12.1.0/dbhome_1/rdbms/log/ggs_ddl_trace.log

Analyzing installation status…

VERSION OF DDL REPLICATION
————————————————————————————————————————
OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

STATUS OF DDL REPLICATION
————————————————————————————————————————
SUCCESSFUL installation of DDL Replication software components

Script complete.
SQL> @role_setup.sql

GGS Role setup script

This script will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)

You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name:gguser
Wrote file role_setup_set.txt

PL/SQL procedure successfully completed.

Role setup script complete

Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:

GRANT GGS_GGSUSER_ROLE TO <loggedUser>

where <loggedUser> is the user assigned to the GoldenGate processes.
SQL> GRANT GGS_GGSUSER_ROLE TO gguser;

Grant succeeded.

SQL> @ddl_enable

Trigger altered.

GGSCI (dbhost01.domain.com) 12> start ext1


Sending START request to MANAGER …
EXTRACT EXT1 starting




GGSCI (dbhost01.domain.com) 13> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt


MANAGER     RUNNING
EXTRACT     RUNNING     DPUMP1      00:00:00      00:00:00
EXTRACT     RUNNING     EXT1        00:00:00      00:00:01
REPLICAT    RUNNING     REP1        00:00:00      00:00:05

  • July 13, 2017 | 18 views
  • Comments