Change Data Capture for Oracle by Attunity SQL 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-2427251%22%20slang%3D%22en-US%22%3EChange%20Data%20Capture%20for%20Oracle%20by%20Attunity%20SQL%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2427251%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20configure%20CDC%20for%20Oracle%20by%20Attnity%20for%20SQL%202019%20but%20getting%20following%20error%20in%20the%20log.%20Please%20advise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etimestamp%2Ctype%2Cnode%2Cstatus%2Csub_status%2Cstatus_message%2Csource%2C%20text_data%2Cbinary_data%3CBR%20%2F%3E%226%2F8%2F2021%203%3A15%3A22%20PM%22%2C%22INFO%22%2C%22xxx%22%2C%22RUNNING%22%2C%22INIT%22%2C%22ORACDC300I%3AThe%20Oracle%20CDC%20instance%20for%20service%20OracleCDCService%20and%20database%20xxx%20started.%22%2C%22service%22%2C%22%22%2C%22%22%3CBR%20%2F%3E%226%2F8%2F2021%203%3A15%3A22%20PM%22%2C%22ERROR%22%2C%22xxx%22%2C%22ERROR%22%2C%22PASSWORD-REQUIRED%22%2C%22ORACDC423E%3AODBC%20error%3A%20RetCode%3A%20SQL_ERROR%20SqlStat%3A%2000000%20NativeError%3A%200%20Message%3A%20%22%2C%22infrastructure%22%2C%22%22%2C%22%22%3CBR%20%2F%3E%226%2F8%2F2021%203%3A15%3A22%20PM%22%2C%22INFO%22%2C%22xxx%22%2C%22RUNNING%22%2C%22INIT%22%2C%22ORACDC314I%3AAsymmetric%20key%20xdbcdc_asym_key%20was%20created%20for%20the%20database%20xxx.%20The%20Oracle%20password%20should%20be%20set%20manually%20in%20cdc.xdbcdc_config%20table.%22%2C%22infrastructure%22%2C%22%22%2C%22%22%3CBR%20%2F%3E%226%2F8%2F2021%203%3A15%3A23%20PM%22%2C%22ERROR%22%2C%22xxx%22%2C%22ERROR%22%2C%22PASSWORD-REQUIRED%22%2C%22ORACDC414E%3AThe%20Engine%20Initializer%20component%20failed%20with%20return%20code%2013.%22%2C%22engine%22%2C%22%22%2C%22%22%3CBR%20%2F%3E%226%2F8%2F2021%203%3A15%3A23%20PM%22%2C%22INFO%22%2C%22xxx%22%2C%22ERROR%22%2C%22STOP%22%2C%22ORACDC312I%3AThe%20Oracle%20CDC%20instance%20for%20service%20OracleCDCService%20and%20database%20xxx%20finished%20abnormally.%22%2C%22service%22%2C%22%22%2C%22%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2429897%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20Data%20Capture%20for%20Oracle%20by%20Attunity%20SQL%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2429897%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F762489%22%20target%3D%22_blank%22%3E%40Vicki_Rylov%3C%2FA%3E%26nbsp%3B%2C%20I%20think%20it's%20the%20best%20to%20contact%20Attunity%20support%20instead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.qlik.com%2Fus%2Fproducts%2Fdata-integration-products%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EQlik%20Data%20Integration%20%7C%20Qlik%3C%2FA%3E%26nbsp%3B%3D%26gt%3B%20Support%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2440276%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20Data%20Capture%20for%20Oracle%20by%20Attunity%20SQL%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440276%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%20I%20will%20try.%20But%20since%20Microsoft%20represents%20this%20tool%20and%20I%20was%20expecting%20to%20get%20some%20support%20from%20Microsoft.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fintegration-services%2Fchange-data-capture%2Fchange-data-capture-service-for-oracle-by-attunity%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChange%20Data%20Capture%20Service%20for%20Oracle%20by%20Attunity%20-%20SQL%20Server%20Integration%20Services%20(SSIS)%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to configure CDC for Oracle by Attnity for SQL 2019 but getting following error in the log. Please advise.

 

timestamp,type,node,status,sub_status,status_message,source, text_data,binary_data
"6/8/2021 3:15:22 PM","INFO","xxx","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service OracleCDCService and database xxx started.","service","",""
"6/8/2021 3:15:22 PM","ERROR","xxx","ERROR","PASSWORD-REQUIRED","ORACDC423E:ODBC error: RetCode: SQL_ERROR SqlStat: 00000 NativeError: 0 Message: ","infrastructure","",""
"6/8/2021 3:15:22 PM","INFO","xxx","RUNNING","INIT","ORACDC314I:Asymmetric key xdbcdc_asym_key was created for the database xxx. The Oracle password should be set manually in cdc.xdbcdc_config table.","infrastructure","",""
"6/8/2021 3:15:23 PM","ERROR","xxx","ERROR","PASSWORD-REQUIRED","ORACDC414E:The Engine Initializer component failed with return code 13.","engine","",""
"6/8/2021 3:15:23 PM","INFO","xxx","ERROR","STOP","ORACDC312I:The Oracle CDC instance for service OracleCDCService and database xxx finished abnormally.","service","",""

2 Replies

@Vicki_Rylov , I think it's the best to contact Attunity support instead.

 

Qlik Data Integration | Qlik => Support

Thank you. I will try. But since Microsoft represents this tool and I was expecting to get some support from Microsoft. Change Data Capture Service for Oracle by Attunity - SQL Server Integration Services (SSIS) | Micros...