We are trying to replicate tables/views from Oracle 19c to SQL server 2019. Based on Configure an Oracle Publisher at https://learn.microsoft.com/en-us/sql/relational-databases/replication/non-sql/configure-an-oracle-publisher?view=sql-server-ver15, we have completed first three steps, now I am working on step four - Configure the Oracle database as a Publisher at the SQL Server Distributor. added Oracle publisher on Distributor Properties window, once click on "OK" button, getting "An error occurred applying the changes to the Distributor", here is full message:
TITLE: Distributor Properties
------------------------------
An error occurred applying the changes to the Distributor.
For help, click: https://go.microsoft.com:80/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.0.18386.0&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
SQL Server could not enable 'uat' as a Publisher. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot insert explicit value for identity column in table '#hquery' when IDENTITY_INSERT is set to OFF.
Changed database context to 'master'.
Error: 156, Sev: 15, State: 1, Msg: Incorrect syntax near the keyword 'PUBLIC'. (Microsoft SQL Server, Error: 544)
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-544-database-engine-error
------------------------------
BUTTONS:
OK
------------------------------
Screenshot with error is also attached
Please help to identify what might be wrong and how to fix this issue. Thanks for the help!