topic Re: Switchover scenario with oracle data guard in Qlik Replicate

Switchover scenario with oracle data guard

FrancoHR — Tue, 25 Jul 2023 16:43:08 GMT

Over the weekend I tried a switchover scenario with Oracle Data Guard and Replicate.
When the change from the primary node to the standby node was made, connection endpoint to the standby node was updated. The connection test was successful but when resuming the replication task the following error was obtained:

Error
Failed opening ASM file '+ARC01/oraprod/archivelog/2023_07_22/thread_1_seq_1632.320.1142895477', thread id '1'
OCI error 'ORA-15056: additional error message
ORA-15173: entry 'oraprod' does not exist in directory '/'
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 201
ORA-06512: at line 1'

What is this error due to?

The dba at that time told me that both Oracle primary and standby nodes have the same service name but different SID. Both nodes have service name: oraprod but the primary node has SID: oraprod and the standby node has SID: oraprods.

Is there a way to configure this on the replicate endpoint?

Regards,

Re: Switchover scenario with oracle data guard

SushilKumar — Wed, 26 Jul 2023 01:56:34 GMT

Hello Team,

Request you to raise a Support case for further analysis. Along with DP

Regards,

Sushil Kumar

Re: Switchover scenario with oracle data guard

Dana_Baldwin — Wed, 26 Jul 2023 23:52:04 GMT

Hi @FrancoHR

Just to clarify, DP = Diagnostics package

For help on how to generate one, please refer to this link:

https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/1815056

Thanks,

Dana

Re: Switchover scenario with oracle data guard

suvbin — Fri, 10 Nov 2023 01:33:13 GMT

how does this issue resolved

Re: Switchover scenario with oracle data guard

Steve_Nguyen — Mon, 13 Nov 2023 17:54:34 GMT

@suvbin this was resolve from support case, if you have similar issue , best to open support case , so that support team can isolate the issue.