topic Re: Qlik Replicate Log Reader- Throwing error even if ASM not enabled at Oracle source- Cannot connect to ASM server in Qlik Replicate

Qlik Replicate Log Reader- Throwing error even if ASM not enabled at Oracle source- Cannot connect to ASM server

sanjeevbind — Wed, 04 Oct 2023 02:30:16 GMT

Hi There,

I am trying to enable CDC in my Qlik task with Oracle DB as source. I don't have ASM enabled at the source. Hence, I just selected Replicate Log reader and kept rest everything default in the advanced page of EndPoint setting. Connection test is working fine and data load working when using just full load but when we run the task with CDC enabled, it failed throwing below error: Kindly refer attached configuration, log file and error message and help me to resolve the issue.

Cannot connect to ASM server ''(user '', Redo Thread 1, OCIthread 0)
Cannot attach OCI server
OCI error 'ORA-12560: TNS:protocol adapter error'

Re: Qlik Replicate Log Reader- Throwing error even if ASM not enabled at Oracle source- Cannot connect to ASM server

Heinvandenheuvel — Wed, 04 Oct 2023 12:01:52 GMT

Is this the same site/problem as https://community.qlik.com/t5/Qlik-Replicate/How-do-we-configure-Replicate-Log-Reader-on-Qlik-Replicate-when/td-p/2124759 ???

The error looks different yet both mention ASM. Please stick to a single topic if it is the same site/problem

You blanked out the connection string in the picture. Is that really a security issue? I don't think so. It might be incorrect. In the task log we can see "Going to connect to Oracle server //xxxx:1521/yyyy". - bbut in my test I don't see the // server name introducer. is the right syntax used - we can't see but it feels wrong? Can you use SQLserver or TNSping with that connection string? EDIT: I since tried the // on my source endpoint connection string and it does not seem to make a difference.

The Task log looks really bad with the uncontrolled and uncorrectable reconnection attempts. You may want to submit a support case to address both root cause and the reaction. Version V2023.5.0.152 is about as recent as it gets (it is what I test with ... and I connect fine to my Oracle source without ASM. Now your Windows server is just 2012 - old but that shouldn't matter much.

The task JSON, and notably the source endpoint section might provide insight.

Btw... next time you <snip> the log after 5 or 10 repeats and indicate <snipped 1000+ repeats in XX minutes>

Maybe there is something odd about the source DB, do you have an other one to connect to , just an express edition if you have to?

Next time, maybe run with LOGGING SOURCE_CAPTURE VERBOSE to hopefully get relevant details. Kill after first errors.

Hein.

Re: Qlik Replicate Log Reader- Throwing error even if ASM not enabled at Oracle source- Cannot connect to ASM server

Heinvandenheuvel — Wed, 04 Oct 2023 17:42:08 GMT

Switch logging for SOURCE_READER to VERBOSE.

Maybe there is, or there was at some point, ASM usage after all.

Search the log for a string like : Going to open Redo Log with original name '+DATA_A

I suspect it is good enough to just look for '+

You'll get a couple of hits for TIMEZONE, but that should be all if ASM was not in play (at some point in time)

Hein.