Ji's Cloud, Database, Engineer World

Ji's Cloud, Database, Engineer World

#oracle

Articles tagged with #oracle

Troubleshooting Tips for CDC for Oracle on SQL Server
Get Processing Range error Timeout Reason: It's because you have a CDC transaction not committed yet. Solution:Run DBCC OPENTRANIdentify the active sessions running the program: MSXDBCDC$OracleCDCService1$xxxxYourCDC Database End the sessionsReru...
Feb 28, 20252 min read7
Unlocking SQL Server CDC for Oracle: Essential Permissions and Roles Explained
In this article and from CDC official document, I will outline the specific permissions I’ve tested and used in my environment, as admin privileges are not allowed in Oracle. Windows User Roles Computer Administrator: Oracle CDC Service The compu...
Oct 2, 20245 min read128