Phenomenal video! Works like a charm. Do you by any chance have any SQL Server to Oracle database replication videos on setting it up? Also maybe, SQL Server to Autonomous Data Warehouse for warehousing?
I get the following error when i try to add the cleanup job: "Neither the SQL Server Change Data Capture job nor Replication Log Reader Agent are found in database source. Ensure that supplemental logging is enabled for database 'source' and that either the SQL Server Change Data Capture job or the Replication Log Reader Agent exists, if the database is Published for Transactional Replication, and re-run this program. Also, ensure that the SQL Server login is a member of the sysadmin server role."
Carlos, usually that is something wrong in the connection string when running the .bat program. The connection for the Cleanup creation does not use the DSN that the Extract or Replicat uses, but the actual server\instance name and the login used has to be sysadmin just for this process. I would suggest using OGG 19.1 and try again, and if you still can't get it to work, to open a support ticket with Oracle.
And if you're connection string has a port number in it, then put double quotes around the whole thing, like: ogg_cdc_cleanup_setup.bat createJob gguser ggpword dbname "server.oracle.com,1443" ggschema Also, make sure that the userid and password is correct and has sysadmin rights, just for the job creation.
OGG 19.1 for SQL Server can be installed on Windows or Linux systems, and it doesn't have to be on the database server, and can be installed on an application server or VM. You can refer to this tutorial for a sample step-by-step setup: docs.oracle.com/en/middleware/goldengate/core/19.1/obcdc/ and to this link to see which OS versions are supported: www.oracle.com/technetwork/middleware/ogg-19-1-0-0-0-cert-matrix-5491855.xls
If you are using goldengate on source and target , on both boxes you must install goldengate , even if you want to replicate data with in the server between to different databases, on both databases you must install oracle goldengate .. In short, goldengate must be installed on on boxes/server's/databases where you wish to use golden gate feature
@@kishoreplsql3913 , this is no longer true, and was never true for a target only installation. If you are using OGG 19.1, you can install on a remote Windows or Linux server and it can support both remote capture and remote delivery.
@@kishoreplsql3913 Hey Kishore, there has been some restrictions in the past, but things are changing, and with OGG 21c, even for Db2, GoldenGate can now run remotely for Extract (and has usually always been allowed for Replicat). If you look at the Cert Matrix for 21c, the last column of the GoldenGate sheet lists comments like 'Supports remote capture and delivery', etc, meaning that GoldenGate can run remotely from the database. www.oracle.com/technetwork/middleware/ogg-21-1-0-0-0-cert-matrix-7503910.xls
Phenomenal video! Works like a charm. Do you by any chance have any SQL Server to Oracle database replication videos on setting it up? Also maybe, SQL Server to Autonomous Data Warehouse for warehousing?
thank you, we'll look at adding that!
Very nice video, do you have videos about adding a database and or alerting the schema which is part of the replication?
I get the following error when i try to add the cleanup job: "Neither the SQL Server Change Data Capture job nor Replication Log Reader Agent are found in database source.
Ensure that supplemental logging is enabled for database 'source' and that either the SQL Server Change Data Capture job or the Replication Log Reader Agent exists, if the database is Published for Transactional Replication, and re-run this program.
Also, ensure that the SQL Server login is a member of the sysadmin server role."
Carlos, usually that is something wrong in the connection string when running the .bat program. The connection for the Cleanup creation does not use the DSN that the Extract or Replicat uses, but the actual server\instance name and the login used has to be sysadmin just for this process. I would suggest using OGG 19.1 and try again, and if you still can't get it to work, to open a support ticket with Oracle.
Did you find any solution for this issue @Carlos Ordoñez
And if you're connection string has a port number in it, then put double quotes around the whole thing, like: ogg_cdc_cleanup_setup.bat createJob gguser ggpword dbname "server.oracle.com,1443" ggschema
Also, make sure that the userid and password is correct and has sysadmin rights, just for the job creation.
In case, I want to add more tables, what are the steps?
Where would the Golden Gate installation be done? On the source or the target or the local desktop?
OGG 19.1 for SQL Server can be installed on Windows or Linux systems, and it doesn't have to be on the database server, and can be installed on an application server or VM. You can refer to this tutorial for a sample step-by-step setup: docs.oracle.com/en/middleware/goldengate/core/19.1/obcdc/ and to this link to see which OS versions are supported: www.oracle.com/technetwork/middleware/ogg-19-1-0-0-0-cert-matrix-5491855.xls
If you are using goldengate on source and target , on both boxes you must install goldengate , even if you want to replicate data with in the server between to different databases, on both databases you must install oracle goldengate ..
In short, goldengate must be installed on on boxes/server's/databases where you wish to use golden gate feature
@@kishoreplsql3913 , this is no longer true, and was never true for a target only installation. If you are using OGG 19.1, you can install on a remote Windows or Linux server and it can support both remote capture and remote delivery.
oh... is it same for heterogeneous replication also ?
for example. DB2 - KAFKA ?
@@kishoreplsql3913 Hey Kishore, there has been some restrictions in the past, but things are changing, and with OGG 21c, even for Db2, GoldenGate can now run remotely for Extract (and has usually always been allowed for Replicat). If you look at the Cert Matrix for 21c, the last column of the GoldenGate sheet lists comments like 'Supports remote capture and delivery', etc, meaning that GoldenGate can run remotely from the database. www.oracle.com/technetwork/middleware/ogg-21-1-0-0-0-cert-matrix-7503910.xls