dblogin sourcedb stest,userid ogg,password 1234

ogg_cdc_cleanup_setup.bat createJob ogg 1234 test (local) ogg

2025-06-04 16:11:04  WARNING OGG-05300  The Oracle GoldenGate cleanup job and the SQL Server CDC cleanup job both exist on database test. Ensure the SQL Server CDC cleanup job is disabled to allow Oracle GoldenGate to manage CDC cleanup.

EXECUTE sys.sp_cdc_drop_job 'cleanup'

MSSQL CDC : Unable To Create GoldenGate CDC Cleanup Job While Configuring SQL Server CDC Capture Replication In Goldengate (Doc ID 2484238.1)

Getting the below error while creating GoldenGate CDC Cleanup Job using the below command.
Command:
ogg_cdc_cleanup_setup.bat createJob gg_abc gg_abc Siteabc IABC ggs

Error:
The SQL Server CDC Capture or Transactional Replication Log Reader job is not found in database Siteabc.
Ensure that the database is enabled for CDC and either the SQL Server Capture job is enabled for database Siteabc or the database is Published for Transactional Replication, and re-run this program.
 

CHANGES

CAUSE

Facing issue while creating GoldenGate CDC Cleanup Job. CDC capture job was not available in the database. The OGG cleanup job checks the existence of CDC capture job. The CDC capture job is a pre-requisite for the cleanup job. Hence, Oracle Goldengate cleanup script failed to create a cleanup job.

SOLUTION

CDC capture job was deleted mistakenly. Create a capture job by using the below command: 

EXECUTE sys.sp_cdc_add_job @job_type = N'capture'

REFERENCES

BUG:27126834 - OGG-05290 THE ORACLE GOLDENGATE CDC CLEANUP JOB IS NOT ENABLED FOR DATABASE

ERROR OGG-05253 - Invalid object name 'goldengate.OracleGGCleanupJobStatus'. (Doc ID 2382734.1)

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

SYMPTOMS

GG configuration on SQL Server

Extract failing with below error 

ERROR OGG-05253 The SQL Server provider has thrown an exception. [mssqlcdcvam::MSSqlCDCCleanupMgr::Start] Invalid object nam
'goldengate.OracleGGCleanupJobStatus'. Additional Info : Error (-2147217865): Invalid object name 'goldengate.OracleGGCleanupJobStatus'.
 

CAUSE

Table goldengate.OracleGGCleanupJobStatus was not present in the DB.

Cleanup job was not created.
 

SOLUTION

Issue was solved by creating the cleanup job

Below are the steps for the same

To create the Oracle GoldenGate CDC Cleanup job and objects:

This requires a SQL Server authenticated database user who is a member of the SQL Server System Administrators (sysadmin) role. Windows authentication is not supported for the .bat binary

Manually delete the database’s SQL Server cdc.dbname_cleanup job from SQL Server Agent. Alternatively, you can drop it from the source database with the following command.

On the source system, open a command prompt and change to the Oracle GoldenGate installation folder.

EXECUTE sys.sp_cdc_drop_job 'cleanup'
Run the ogg_cdc_cleanup_setup.bat file, providing the following variable values:

ogg_cdc_cleanup_setup.bat createJob userid password databasename servername\instancename schema
In the preceding, userid password> is a valid SQL Server login and password for a sysadmin user. databasename<servername\instancename are the source database name and instance name. If only server name is listed, then the default instance will be connected to. The schema is the schema name listed in the GLOBALS file, with the GGSCHEMA parameter. This schema should be the same for all Oracle GoldenGate objects, including supplemental logging, checkpoint tables, heartbeat tables, and the Oracle GoldenGate CDC Cleanup job.

For example: ogg_cdc_cleanup_setup.bat createJob ggsuser ggspword db1 server1\inst1 ogg

The Oracle GoldenGate CDC Cleanup job when created, is scheduled to run every ten minutes, with a default retention period of seventy two hours. The job will not purge data for an Extract’s recovery checkpoint however, regardless of the retention period.

 NOTE: In the images and/or the document content above, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public
Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

REFERENCES

Preparing the Database for Oracle GoldenGate — CDC Capture

ogg sqlserver:
https://www.modb.pro/db/51617 

ogg 12.3 for sqlserver 2016 CDC模式配置 - margiex - 博客园 

ogg 12.3 for sqlserver 2016/2014 CDC模式配置 - margiex - 博客园